I installed Oracle Database 11gR2 and created the orcl database,then installed Grid Infrastructure on a standalone windwos 2008 R2 server.
I have always been able to connect to my database and asm instance using SQL*Plus. But I'm facing an issue when typing the command lsnrctl status,it reports
'The listener supports no services'
My grid's listener.ora file:
# listener.ora Network Configuration File: C:\app\Administrator\product\11.2.0\grid\network\admin\listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1522))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.78)(PORT = 1522))
)
)
ADR_BASE_LISTENER = C:\app\Administrator
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent
My grid's tnsnames.ora file:
# tnsnames.ora Network Configuration File: C:\app\Administrator\product\11.2.0\grid\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
LISTENER_+ASM =
(ADDRESS = (PROTOCOL = TCP)(HOST = WIN-G48DNRS1396)(PORT = 1522))
When typing lsnrctl status,I get the following:
C:\Users\Administrator>lsnrctl status
LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 30-OCT-2017 15:56:32
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1522)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Production
Start Date 30-OCT-2017 14:41:43
Uptime 0 days 1 hr. 14 min. 52 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File C:\app\Administrator\product\11.2.0\grid\network\admin\listener.ora
Listener Log File c:\app\administrator\diag\tnslsnr\WIN-G48DNRS1396\listener\alert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1522ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.2.78)(PORT=1522)))
The listener supports no services
The command completed successfully
I can connect the asm instance:
C:\Users\Administrator>set oracle_sid=+asm
C:\Users\Administrator>set tns_admin=C:\app\Administrator\product\11.2.0\grid\NETWORK\ADMIN
C:\Users\Administrator>sqlplus
SQL*Plus: Release 11.2.0.1.0 Production on Mon Oct 30 15:49:05 2017
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Enter user-name: sys as sysasm
Enter password:
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Automatic Storage Management option
SQL> select path,os_mb from v$asm_disk;
PATH OS_MB
------------------------------- -----------------
\\.\ORCLDISKDATA0 10240
\\.\ORCLDISKDATA1 10240
\\.\ORCLDISKDATA2 10240
\\.\ORCLDISKDATA3 10240
And i tried to use 'srvctl add listener -l listener_+asm -o C:\app\Administrator\product\11.2.0\grid -p 1522',i got the following:
PRCR-1070 : Failed to check if ora.LISTENER_+ASM.lsnr is registered
Invalid resource name
How can i solve this issue?