-
ORA-12541: TNS:no listener
Hi,
I need to connect to the database on the UNIX server from my laptop. So I updated TNSNAMES.ORA and LISTENER.ORA on my machine as follows:
TNSNAMES.ORA
----------------------------------------------------
ICT =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = unix4.ict.prod)(PORT = 1523))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = ict)
)
)
LISTENER.ORA
-------------------------------------------------------
ICT =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = unix4.ict.prod)(PORT = 1523))
)
--------------------------------------------------------------
but I still get the error message :
ERROR:
ORA-12541: TNS:no listener
any idea why it can't see the new listener?
Alf
-
go to the database server machine, type lsnrctl status
to see if the listerner is up. If it is up, which port
it is litenering on.
You do not need listener.ora on the client side.
-
Originally posted by sysdba
go to the database server machine, type lsnrctl status
to see if the listerner is up. If it is up, which port
it is litenering on.
Some other troubleshooting steps you can take before taking a walk to the server:
Do a ping hostname to determine basic network connectivity between your client and the server. A lot of places don't junk up the server name (unix4 versus unix4.ict.prod - what is "ict.prod" supposed to be, a domain?).
Then do a tnsping hostname from your client to determine Oracle-related network connectivity.
If ping works, but tnsping returns the 12541 error, it is more than likely no listener as sysdba pointed out.
C:\Documents and Settings\stecal>tnsping kguest
TNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Production on 20-NOV-20
03 16:30:22
Copyright (c) 1997 Oracle Corporation. All rights reserved.
Used parameter files:
D:\Oracle\network\admin\sqlnet.ora
Used HOSTNAME adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SID=*)(SERVICE_NAME=kguest))(A
DDRESS=(PROTOCOL=TCP)(HOST=kguest)(PORT=1521)))
TNS-12541: TNS:no listener
Last edited by stecal; 11-20-2003 at 07:34 PM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|