Hello ,
I am working on oracle 11.2.0.1 on windows 7 , 64 bit.
I have created a database using dbca and trying to access through listener.
But I am not able to register it with listener.
I tried with alter system register and while setting local listener I am getting following error.
SQL> ALTER SYSTEM set LOCAL_LISTENER=LISTENER ;
ALTER SYSTEM set LOCAL_LISTENER=LISTENER
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name 'LISTENER'
SQL>
Let me know how I can register this.
C:\Users\mathurro>tnsping orcl
TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 09-SEP-2014 10:43:39
Copyright (c) 1997, 2010, Oracle. All rights reserved.
Used parameter files:
C:\app\mathurro\product\11.2.0\dbhome_1\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = abc1.as
hpqcorp.net)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = orcl)))
OK (21110 msec)
C:\Users\mathurro>lsnrctl status
LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 09-SEP-2014 10:44:07
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=abc1.asiapacific.hpqcorp.net)(PORT=1521
TNS-12535: TNS:operation timed out
TNS-12560: TNS:protocol adapter error
TNS-00505: Operation timed out
64-bit Windows Error: 60: Unknown error
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Production
Start Date 08-SEP-2014 17:35:36
Uptime 0 days 17 hr. 8 min. 56 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File C:\app\abc\product\11.2.0\dbhome_1\network\admin\listener.ora
Listener Log File c:\app\abc\diag\tnslsnr\abc1\listener\alert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=abc1.asiapacific.hpqcorp.net)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
tnsnames.ora
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)))
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
orcl =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host=abc1.asiapacific.hpqcorp.net)(Port =1521)) ) (CONNECT_DATA = (SERVICE_NAME = orcl) ) )
listener.ora
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:\app\abc\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:C:\app\abc\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = C:\app\abc\product\11.2.0\dbhome_1)
(SID_NAME = orcl)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = abc1.asiapacific.hpqcorp.net)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
ADR_BASE_LISTENER = C:\app\abc