| no listner [message #269674] |
Mon, 24 September 2007 01:33  |
axiom
Messages: 26
Registered: August 2007
|
Junior Member |
|
|
we have a database named as axiom.database is working fine & also access from other m/c.But because of power off during database not working.
it gives message as no listner .
can any one tell me the solution
|
|
|
|
|
|
| Re: no listner [message #269681 is a reply to message #269678] |
Mon, 24 September 2007 01:42  |
axiom
Messages: 26
Registered: August 2007
|
Junior Member |
|
|
listner already started.in lsnrctl start it gives erros as
TNS-12560: TNS:protocl adapter error
TNS-00530: protocol adapter error
and in 'lsnrctl status ' it gives message
listner supports no services
command completed successfully
|
|
|
|
|
|
|
|
|
|
|
|
| Re: no listner [message #270584 is a reply to message #269826] |
Thu, 27 September 2007 11:00 |
smunir362
Messages: 310
Registered: September 2007
|
Senior Member |
|
|
Dear,
Check listenere port on which it is listening.
And then test the correct port in tnsnames.ora file.
This problem occure exactly when listener is configure for the port while tnsnames.ora calling it on different port. Thats why listener say no Listener. Because it is not listening for that port........
[mod-edit] illiterate IM speak removed.
[Updated on: Thu, 27 September 2007 12:59] by Moderator Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
