-
Although the Listener is running, when I try to connect to it, I get error 12541 tns no listener. The connect descriptor appears to be in sync. with the listener.
-
12541, 00000, "TNS:no listener"
// *Cause: The connection request could not be completed because the listener
// is not running.
// *Action: Ensure that the supplied destination address matches one of
// the addresses used by the listener - compare the TNSNAMES.ORA entry with
// the appropriate LISTENER.ORA file (or TNSNAV.ORA if the connection is to
// go by way of an Interchange). Start the listener on the remote machine.
Check your listener and tnsnames.ora configurations again.
Confirm it through
lsnrctl status
lsnrctl service
Sam
Thanx
Sam
Life is a journey, not a destination!
-
If your listener is started it's a tnsnames.ora problem.
-
I have seen one additional factor, if the listener was started for a prior start of the database.
ie
start database
start listener
stop database
start database
On some platforms and/or when your tongue is in the wrong cheek, the listener looses contact with the database. Stopping and restarting the listener clears it up.
Joseph R.P. Maloney, CSP,CDP,CCP
'The answer is 42'
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
|