-
Hi Guys,
I am trying to start the listener. Its giving the problem like:
LSNRCTL> reload
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
The command completed successfully
LSNRCTL> stop
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
The command completed successfully
LSNRCTL> start
Starting tnslsnr: please wait...
TNSLSNR for 32-bit Windows: Version 8.1.7.0.0 - Production
System parameter file is C:\programfiles\Ora81\network\admin\listener.ora
Log messages written to C:\programfiles\Ora81\network\log\listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc
)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=msft-man)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=msft-man)(PORT=1521))(PR
OTOCOL_STACK=(PRESENTATION=GIOP)(SESSION=RAW)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
TNS-12597: TNS:connect descriptor already in use
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=msft-man)(PORT=1521)))
TNS-12597: TNS:connect descriptor already in use
LSNRCTL>
Can you please give me any solution ASAP.
Thanks
Ravi
ravi
-
Check listener.ora file in $ORACLE_HOME/network/admin, may be you have double lines in this file.
-
This is my Listener.ora. Please correct me if i am wrong.
# LISTENER.ORA Network Configuration File: C:\programfiles\Ora81\network\admin\listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = msft-man)(PORT = 1521))
)
)
(DESCRIPTION =
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
(ADDRESS = (PROTOCOL = TCP)(HOST = msft-man)(PORT = 1521))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\programfiles\Ora81)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = test.domain)
(ORACLE_HOME = C:\programfiles\Ora81)
(SID_NAME = test)
)
)
Thanks
Ravi
ravi
-
Have you checked whether the listener is already running ?
svk
-
Check (on my mind you have double ADDRESS declaration)
# LISTENER.ORA Network Configuration File: C:\programfiles\Ora81\network\admin\listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
# (ADDRESS = (PROTOCOL = TCP)(HOST = msft-man)(PORT = 1521))
)
)
(DESCRIPTION =
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
(ADDRESS = (PROTOCOL = TCP)(HOST = msft-man)(PORT = 1521))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\programfiles\Ora81)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = test.domain)
(ORACLE_HOME = C:\programfiles\Ora81)
(SID_NAME = test)
)
)
PS: I thing you use NetConfig for setup listener parameters.
This program add ADDRESS_LIST each time, when you use it.
This is little bit not correct.
[Edited by Shestakov on 10-19-2001 at 02:12 PM]
-
Hi,
1)I tried to stop and start the listener then only i am getting the above mentioned problem.
2) Yes. I used netconfig to setup my listener. The actual Listener.ora was also posted for ur verification.
Any solution please.
Thanks
ravi
-
I see, that is Win NT(2000) box.
Check NT services, is OraListener running as service.
Try to stop it thru control panel and start it again.
-
I am sorry. I didn't mentioned my environment. It is oracle 817 on windows 2000. But i already checked that ora listener is running.
Thanks
Ravi
ravi
-
If it running, then in DOS session exec :
lsnrctl status
If you may, then show result.
-
Make a backup of the listener.ora file and Change it to this.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
)
(DESCRIPTION =
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
(ADDRESS = (PROTOCOL = TCP)(HOST = msft-man)(PORT = 1521))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\programfiles\Ora81)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = test.domain)
(ORACLE_HOME = C:\programfiles\Ora81)
(SID_NAME = test)
)
)
Doug
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|