-
AT SQL+
========
ERROR:
ORA-12541: TNS:no listener
----------------------------
Got the following details from the document
TNS-12541 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.
------------------
But Our TNSNAME.ORA address match with LISTENER.ORA.
------------------
At Listener Control
===================
LSNRCTL> test
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
32-bit Windows Error: 61: Unknown error
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
32-bit Windows Error: 2: No such file or directory
------------------
LSNRCTL> show current_listener
Current Listener is LISTENER
------------------
tnsping krishna
TNS-12541 TNS:no listener
------------------
We think Listener auto is also not woking in this case.
------------------
The error that has been in Listener log file is
TNS-12560: TNS:protocol adapter error
TNS-00530: Protocol adapter error
32-bit Windows Error: 38: Filename too long
Is it windows error.
Our db file name is 8chr long.
Is there any rules to have a db file name with in 4chr.
-
Is your Lisyener running ?
Did you try --
LSNRCTL> STATUS
If it is not running the nSTART is bu --
LSNRCTL> START LISTENER
- Rajeev
-
Thanks for you reply
I started the listener. But it is not started.
I think this is OS problem.
I uninstalled all oracle things and going to reinstall.
-
-
could you post the exact error message ?
- Rajeev
-
I mean the error message when you run --
LSNRCTL> START LISTENER
