debugMinor
Error ORA-12541: TNS:no listener
Viewed 0 times
errortnslistenerora12541
Problem
Whenever I try to start the listener (I just have only one Oracle database) I get the following:
tnsnames.ora
listerner.ora
I really don't know what the problem is. My tnsnames.ora and listener.ora file
LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=admin-41f89f35d)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
32-bit Windows Error: 61: Unknown errortnsnames.ora
# TNSNAMES.ORA Network Configuration File: F:\Oracle\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
PROJECT =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = admin-xxxxxx)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = PROJECT)
)
)
INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = admin-xxxxxx)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)listerner.ora
# LISTENER.ORA Network Configuration File: F:\Oracle\network\admin\listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = admin-xxxxxx)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = F:\Oracle)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = PROJECT)
(ORACLE_HOME = F:\Oracle)
(SID_NAME = PROJECT)
)
)I really don't know what the problem is. My tnsnames.ora and listener.ora file
Solution
As a quick fix, you can just remove the entries (with respect to your database)from both the tnsnames.ora and listerner.ora.
In your scenario, remove this from tnsnames.ora
and this from listerner.ora
and then you can try to open up the database.
These entries would be created automatically.
And we hope the listener listens to us this time.
In your scenario, remove this from tnsnames.ora
PROJECT =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = admin-xxxxxx)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = PROJECT)
)
)and this from listerner.ora
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = F:\Oracle)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = PROJECT)
(ORACLE_HOME = F:\Oracle)
(SID_NAME = PROJECT)
)
)and then you can try to open up the database.
These entries would be created automatically.
And we hope the listener listens to us this time.
Code Snippets
PROJECT =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = admin-xxxxxx)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = PROJECT)
)
)SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = F:\Oracle)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = PROJECT)
(ORACLE_HOME = F:\Oracle)
(SID_NAME = PROJECT)
)
)Context
StackExchange Database Administrators Q#12384, answer score: 2
Revisions (0)
No revisions yet.