ORA-12541: TNS:no listener

[ALF]

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

[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.

You do not need listener.ora on the client side.

[stecal]

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