Home » RDBMS Server » Networking and Gateways » ORA-12541: TNS:no listener (9.2.0.1.0)
ORA-12541: TNS:no listener [message #334926] Fri, 18 July 2008 12:40 Go to next message
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 #334927 is a reply to message #334926] Fri, 18 July 2008 12:45 Go to previous messageGo to next message
BlackSwan
Messages: 22477
Registered: January 2009
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow posting guidelines as stated in URL above

If you are logged directly onto the system which is running Oracle RDBMS, then SQL*Net is NOT required to connect to the database.

Why, Oh WHY are you using "localhost" as the hostname?
Re: ORA-12541: TNS:no listener [message #334968 is a reply to message #334927] Fri, 18 July 2008 23:53 Go to previous messageGo to next message
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 Go to previous message
BlackSwan
Messages: 22477
Registered: January 2009
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?
Previous Topic: TNS frame types in SQLNetv2
Next Topic: Not able to connect to 8i database from 10g Client
Goto Forum:
  


Current Time: Tue Jul 22 18:55:51 CDT 2014

Total time taken to generate the page: 0.13136 seconds