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!

TNS-01151: Missing listener name, lsnrctl, in LISTENER.ORA

586983Nov 7 2007 — edited Nov 7 2007
hi,
listener failed and the databasea had to be restarted.it is a production database so cant afford to restart it.
my listener.ora is as follows:

# listener.ora Network Configuration File: E:\oracle\product\10.2.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

ALPSDBTEST =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = alpsdb.affinityexpress.co.in)(PORT = 1521))
)
)

LISTENER1 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = alpsdb.affinityexpress.co.in)(PORT = 1521))
)
)

ALPSDB =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = alpsdb.affinityexpress.co.in)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)

ONLINETEST =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = alpsdb.affinityexpress.co.in)(PORT = 1521))
)
)

ONLINE =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = alpsdb.affinityexpress.co.in)(PORT = 1521))
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = alpsdb.affinityexpress.co.in)(PORT = 1521))
)
)

SID_LIST_ALPSDB =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = E:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)
CONNECT_TIMEOUT=10


now from this i am not able to find out the problem..

please help me in solving this..

thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 5 2007
Added on Nov 7 2007
4 comments
2,197 views