Home » RDBMS Server » Networking and Gateways » ora-12541: TNS:no listener
ora-12541: TNS:no listener [message #152984] Wed, 28 December 2005 05:16 Go to next message
omprakash
Messages: 11
Registered: January 2005
Junior Member
Hi all,

I have oracle 8.1.7 installed on my PC. My Pc is in the network.
My database name is APL
TNSName is APL

Listener is working,
Database is working.

Scenario 1
==========
PC is not in network
sqlplus scott/tiger
SQL>

Sqlplus scott/tiger@apl
SQL>

Scenario 2
=========
PC is nowt in the network
sqlplus scott/tiger
SQL>

Sqlplus scott/tiger@apl
ora-12541: TNS:no listener

Can any one tell me when i m putting my pc in the network it is giving me listener error, though my listener is working. I tested it by TNSPING. I change the port, created a new listener, uninstalled oracle and installed again but still getting the same problems. I checked 1521 port thru telnet, i m getting it..

Thanx and regards,
omprakash

Report message to a moderator

Re: ora-12541: TNS:no listener [message #153021 is a reply to message #152984] Wed, 28 December 2005 07:44 Go to previous messageGo to next message
gscen_dba
Messages: 7
Registered: December 2005
Junior Member
Hello,

Did you declare your db in the listener ?
Like :
SID_LIST_LISTENER =
(SID_LIST =(SID_DESC=(SID_NAME=DB)(ORACLE_HOME=C:\oracle\ora92))
(SID_DESC =
(GLOBAL_DBNAME = DB)
(SID_NAME = DB)
)

Use net manager o add a new service to the listener.

Regards

Report message to a moderator

Re: ora-12541: TNS:no listener [message #153910 is a reply to message #152984] Wed, 04 January 2006 16:54 Go to previous message
saritha_says
Messages: 12
Registered: October 2005
Location: Hydrabad
Junior Member

Hi,

Even i have the same problem. Here i have two different homes.
1) for oracle database - orahome92
2) for forms,reports - oracle_home

when i connect to network both 1) and 2) will work.

but when i am out of the newtwork
1) for oracle database - orahome92 DB which i install 8i does not work.

I tried coping the Listener and the TNS from orahome92 to another home oracle_home. When ever i restart the computer and try to login to my 8i DB it will not connect.
3 to 4 trys i get ORA-12541: TNS: no Listener then i get an error
ORA - 01033 Oracle initialization or shutdown in process
then when i connct again... i will be able to connct to my personal DB. Can you please help me.

Thanks,
Saritha

Report message to a moderator

Previous Topic: User cannot enter Enterprise manager console
Next Topic: Need to call SQL server Proc from Oracle.
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Nov 25 16:13:49 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.