Home » RDBMS Server » Networking and Gateways » ERROR:ORA-12541: TNS:no listener
ERROR:ORA-12541: TNS:no listener [message #171259] Tue, 09 May 2006 03:53 Go to next message
dharnidhar
Messages: 4
Registered: May 2006
Junior Member

Hi,

I have a very strange problem, could be because I am relatively new to the oracle as such. I am able to log into the SQLPlus onthe machine where oracle is installed. When I try to log into SQLPlus from other machine, I get this error

ERROR:ORA-12541: TNS:no listener

I tried to see if the listener was working fine using the steps mentioned below on the oracle server machine

Logged into SQLPlus window and gave qatest1/qatest1 @GOLDENGA, I am able to log into it. It means that the listener is up and running. I checked it below using lsnrctl as well.

C:\oracle\product\10.2.0\db_1\BIN>lsnrctl

LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 09-MAY-2006 14:11
:31

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Produ
ction
Start Date 09-MAY-2006 11:33:22
Uptime 0 days 2 hr. 38 min. 11 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File C:\oracle\product\10.2.0\db_1\network\admin\listener.o
ra
Listener Log File C:\oracle\product\10.2.0\db_1\network\log\listener.log

Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=arsin-018f12f74.arsin.com)(PORT=1521
)))
Services Summary...
Service "GOLDENGA" has 2 instance(s).
Instance "GOLDENGA", status UNKNOWN, has 1 handler(s) for this service...
Instance "goldenga", status READY, has 1 handler(s) for this service...
Service "GOLDENGAXDB" has 1 instance(s).
Instance "goldenga", status READY, has 1 handler(s) for this service...
Service "GOLDENGA_XPT" has 1 instance(s).
Instance "goldenga", status READY, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL>

TNSPing also works fine on the server machine

C:\oracle\product\10.2.0\db_1\BIN>tnsping GOLDENGA

TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 09-MAY-2
006 14:15:36

Copyright (c) 1997, 2005, Oracle. All rights reserved.

Used parameter files:
C:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = arsin-018f12f74)(PORT = 1521))) (CONNECT_DATA = (SERVER = DEDICATED) (SE
RVICE_NAME = GOLDENGA)))
OK (30 msec)



Now, when I run from the client machine, I get the following error message

C:\win_Oracle10g_v8040_020>sqlplus qatest1/qatest1

SQL*Plus: Release 10.2.0.1.0 - Production on Tue May 9 14:01:28 2006

Copyright (c) 1982, 2005, Oracle. All rights reserved.

ERROR:
ORA-12541: TNS:no listener

Enter user-name:

I also tried tnsping from the client machine

C:\win_Oracle10g_v8040_020>tnsping GOLDENGA

TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 09-MAY-2
006 14:06:46

Copyright (c) 1997, 2005, Oracle. All rights reserved.

Used parameter files:
\\192.168.253.120\c$\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = arsin-018f12f74)(PORT = 1521))) (CONNECT_DATA = (SERVER = DEDICATED) (SE
RVICE_NAME = GOLDENGA)))
TNS-12541: TNS:no listener


Please find the ora files for your perusal.

tnsnames.ora
-----------------------------------------------
# TNSNAMES.ORA Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

EXTPROC_CONNECTION_DATA.ARSIN.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

GOLDENGA.ARSIN.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = arsin-018f12f74)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = GOLDENGA)
)
)

listener.ora
-------------------------------------------

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

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = arsin-018f12f74)(PORT = 1521))
)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = GOLDENGA)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(SID_NAME = GOLDENGA)
)
)

sqlnet.ora
---------------------------------------

# SQLNET.ORA Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.

NAMES.DEFAULT_DOMAIN = arsin.com

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)



Can someone help me in this regard. I can be reached on dharnidhar@yahoo.com also.

Thanks and Regards,
Dharnidhar

Re: ERROR:ORA-12541: TNS:no listener [message #171265 is a reply to message #171259] Tue, 09 May 2006 04:12 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
comment all entries in sqlnet.ora and try again.
Please search the forum before asking.
Re: ERROR:ORA-12541: TNS:no listener [message #171285 is a reply to message #171265] Tue, 09 May 2006 05:09 Go to previous messageGo to next message
dharnidhar
Messages: 4
Registered: May 2006
Junior Member

Hi,

I have looked at the forums for the same information. It could be that I have missed this. I am sorry about that. After I comment all the things in the sqlnet.ora, I get the following error message

C:\win_Oracle10g_v8040_020>sqlplus qatest1/qatest1

SQL*Plus: Release 10.2.0.1.0 - Production on Tue May 9 15:29:17 2006

Copyright (c) 1982, 2005, Oracle. All rights reserved.

ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified


Enter user-name:

Re: ERROR:ORA-12541: TNS:no listener [message #171305 is a reply to message #171285] Tue, 09 May 2006 06:28 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
for a connect like this
$sqlplus username/password 

You no need listener/tnsnames.ora entries at all. Because you are not using it. And above will work only if the database is locally available. All you need is a proper entry for ORACLE_SID
For a connection like this
$sqlplus username/password@tnsentry 

You need listener running and proper tnsentries and the database may be locally or remotely hosted.
Based on your tnsentries, you are supposed to use
C:\win_Oracle10g_v8040_020>sqlplus qatest1/qatest1@GOLDENGA.ARSIN.COM
OR
C:\win_Oracle10g_v8040_020>sqlplus qatest1/qatest1@GOLDENGA 


Regards
Re: ERROR:ORA-12541: TNS:no listener [message #171309 is a reply to message #171305] Tue, 09 May 2006 06:47 Go to previous messageGo to next message
dharnidhar
Messages: 4
Registered: May 2006
Junior Member

Hi Mahesh,

Thanks for this quick response. I tried to run as mentioned by you.
C:\win_Oracle10g_v8040_020>sqlplus qatest1/qatest1@GOLDENGA

It still fails with the same error on oracle 10g. Do you think I could have done wrong somewhere else?




I have another machine with the same setup but with oracle 9.2. On the client machine I did not use tnsentry and it worked fine.

C:\>cd win_Oracle9i_v8040_020

C:\win_Oracle9i_v8040_020>startOracle9i.bat

C:\win_Oracle9i_v8040_020>set ORACLE_HOME=\\192.168.253.68\d$\oracle\ora92

C:\win_Oracle9i_v8040_020>set LOCAL=GOLDENGA

C:\win_Oracle9i_v8040_020>sqlplus qatest1/qatest1

SQL*Plus: Release 9.2.0.1.0 - Production on Tue May 9 17:05:33 2006

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production

SQL>

Is there any difference between the way client behaves between oracle 9i and oracle 10g?

Regards
Dharni
Re: ERROR:ORA-12541: TNS:no listener [message #171315 is a reply to message #171309] Tue, 09 May 2006 06:59 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Your tnsentry says GOLDENGA.ARSIN.COM.
So you are supposed to use
sqlplus qatest1/qatest1@GOLDENGA.ARSIN.COM

Is there a firewall involved here?
In your second case, you are talking to a local database. So it should work fine.
Re: ERROR:ORA-12541: TNS:no listener [message #171316 is a reply to message #171315] Tue, 09 May 2006 07:00 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
And Please post the complete error message
Re: ERROR:ORA-12541: TNS:no listener [message #171324 is a reply to message #171316] Tue, 09 May 2006 07:20 Go to previous messageGo to next message
dharnidhar
Messages: 4
Registered: May 2006
Junior Member

Hi,

I tried with sqlplus qatest1/qatest1@GOLDENGA.ARSIN.COM as well. I get the same error as mentioned below.

C:\win_Oracle10g_v8040_020>sqlplus qatest1/qatest1

SQL*Plus: Release 10.2.0.1.0 - Production on Tue May 9 15:29:17 2006
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
Enter user-name:

Since this did not work, I tried to change the ora files as follows. These were the original configurations files that got created when oracle was installed on this machine.

SQLNET.ORA
----------------------------------------------------------------
# sqlnet.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.

# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

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

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = arsin-018f12f74.arsin.com)(PORT = 1521))
)
)

TNSNAMES.ORA
--------------------------------------------------------------

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

GOLDENGA =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = arsin-018f12f74.arsin.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = GOLDENGA)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

On the machine where oracle server is installed, things work fine. I am able to log into SQLPlus.

Now when I try to connect to SQLPlus on the client machine I get this error

C:\win_Oracle10g_v8040_020>startOracle10g.bat

C:\win_Oracle10g_v8040_020>set ORACLE_HOME=\\192.168.253.120\c$\oracle\product\10.2.0\db_1

C:\win_Oracle10g_v8040_020>set LOCAL=GOLDENGA

C:\win_Oracle10g_v8040_020>sqlplus qatest1/qatest

SQL*Plus: Release 10.2.0.1.0 - Production on Tue May 9 17:34:17 2006

Copyright (c) 1982, 2005, Oracle. All rights reserved.

ERROR:
ORA-12541: TNS:no listener

Enter user-name:

I tried even with tnsentry as follows:

C:\win_Oracle10g_v8040_020>sqlplus qatest1/qatest@GOLDENGA

SQL*Plus: Release 10.2.0.1.0 - Production on Tue May 9 17:41:31 2006

Copyright (c) 1982, 2005, Oracle. All rights reserved.

ERROR:
ORA-12541: TNS:no listener
Enter user-name:


I doubt if this is the issue with sqlnet.ora. The firewalls on both the server and the client have been disabled.

In the second case in my earlier message, i was still talking to the remote database and not the local database.








Re: ERROR:ORA-12541: TNS:no listener [message #345316 is a reply to message #171324] Tue, 02 September 2008 23:52 Go to previous messageGo to next message
shivkant.pawan
Messages: 1
Registered: September 2008
Junior Member
Hi,

Check your listener services whether it's running or not.

Go to start->run(type 'services.msc')
start the services of oracle<datbase version>TNSListener
e.g. oracleOra10gTNSListener

regards,
Pawan Gautam Smile
Re: ERROR:ORA-12541: TNS:no listener [message #345319 is a reply to message #171259] Tue, 02 September 2008 23:59 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
shivkant.pawan,
Responding to a post 2+ years old may be an exercise in futility.
Previous Topic: Heterogeneous Sources Link issue in Oracle
Next Topic: TNS-12519 (merged)
Goto Forum:
  


Current Time: Fri Mar 29 07:39:31 CDT 2024