| ERROR:ORA-12541: TNS:no listener [message #171259] |
Tue, 09 May 2006 03:53  |
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 #171324 is a reply to message #171316] |
Tue, 09 May 2006 07:20  |
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.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
