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 18.104.22.168.0 - Production on 20-NOV-20
Copyright (c) 1997 Oracle Corporation. All rights reserved.
Used parameter files:
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