| ORA-12541: TNS:no listener [message #334926] |
Fri, 18 July 2008 12:40  |
reemasen
Messages: 2
Registered: July 2008
|
Junior Member |
|
|
Dear All,
Listener stop immediately after some time.
And when I try to connect to sqlplus when the listener is running by give the username, password and host in sql plus it get connected. And immediacy the listener get disconnected. When again try to connect throw sqlplus it give error ORA-12541: TNS:no listener.
I tried to search in forum and also in Google for above mention problem but not succeed to solve the problem.
tnsnames.ora file
ORSID =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orsid)
)
)
INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC2))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
Listner.ora file.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC2))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\ora92)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = orsid)
(ORACLE_HOME = C:\oracle\ora92)
(SID_NAME = orsid)
)
)
Thanks in advance
Reema
|
|
|
|
|
|
| Re: ORA-12541: TNS:no listener [message #334968 is a reply to message #334927] |
Fri, 18 July 2008 23:53  |
reemasen
Messages: 2
Registered: July 2008
|
Junior Member |
|
|
Dear All,
My host name is reema instead of localhost.
why i asked listner to be up becouse i am connecting middleware application with oracle. and detail problem i have mention in below mail.
reema
|
|
|
|
| Re: ORA-12541: TNS:no listener [message #334972 is a reply to message #334968] |
Sat, 19 July 2008 00:21 |
 |
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
|
Senior Member |
|
|
| reemasen wrote on Fri, 18 July 2008 21:53 | Dear All,
My host name is reema instead of localhost.
why i asked listner to be up becouse i am connecting middleware application with oracle. and detail problem i have mention in below mail.
reema
|
>detail problem i have mention in below mail.
it must be below horizon which I can not see.
Use absolute hostname because localhost is always realtive.
On which host does said middleware run?
Has this configuration ever worked?
If so, what changed?
If not, why am I not surprised?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
