Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Starting a specific listener?

rg2Jan 3 2008 — edited Jan 3 2008
How do I start a specific listener on a Windows Server 2k? I am trying to start a listener called LISTENER10GR2 on port 1522 and every time I try to do a lsnrctl start it keeps starting some other listener. I don't know why this is happeneing. Below you can see all the info for this issue.

Output:
Microsoft Windows [Version 5.2.3790]
(C) Copyright 1985-2003 Microsoft Corp.

C:\Documents and Settings\oracle>set ORACLE_HOME=c:\oracle\ora102

C:\Documents and Settings\oracle>lsnrctl status

LSNRCTL for 32-bit Windows: Version 10.2.0.3.0 - Production on 03-JAN-2008 11:53
:40

Copyright (c) 1991, 2006, Oracle. All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
32-bit Windows Error: 61: Unknown error

C:\Documents and Settings\oracle>lsnrctl start

LSNRCTL for 32-bit Windows: Version 10.2.0.3.0 - Production on 03-JAN-2008 11:53
:44

Copyright (c) 1991, 2006, Oracle. All rights reserved.

Starting tnslsnr: please wait...

Failed to start service, error 1058.
TNS-12560: TNS:protocol adapter error
TNS-00530: Protocol adapter error

Listener File:
LISTENER10GR2 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.70.22)(PORT = 1522))
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = c:\oracle\ora102)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = CONVSTAG)
(ORACLE_HOME = c:\oracle\ora102)
(SID_NAME = CONVSTAG)
)
(SID_DESC =
(GLOBAL_DBNAME = LIFEDEV)
(ORACLE_HOME = c:\oracle\ora102)
(SID_NAME = LIFEDEV)
)
(SID_DESC =
(GLOBAL_DBNAME = RSLSTAG)
(ORACLE_HOME = c:\oracle\ora102)
(SID_NAME = RSLSTAG)
)
)

TNSNames File:
CONVSTAG =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.70.22)(PORT = 1522))
)
(CONNECT_DATA =
(SERVICE_NAME = CONVSTAG)
)
)

LIFEDEV =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.70.22)(PORT = 1522))
)
(CONNECT_DATA =
(SERVICE_NAME = LIFEDEV)
)
)

RSLSTAG =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.70.22)(PORT = 1522))
)
(CONNECT_DATA =
(SERVICE_NAME = RSLSTAG)
)
)

This has caused the whole server not to allow any connections to any DB's cause our listener is down. Any help please.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 31 2008
Added on Jan 3 2008
20 comments
3,041 views