| ORA-12224: TNS:no listener [message #141948] |
Wed, 12 October 2005 19:52  |
chewy_fruiti
Messages: 2
Registered: October 2005
|
Junior Member |
|
|
May I please know what is this error? I'm using Win2000.
I had put the listener.ora file and the tnsnames.ora files and the sqlnet.ora files in the C:\orant\net80\admin already.
|
|
|
|
|
|
| Re: ORA-12224: TNS:no listener [message #142030 is a reply to message #141996] |
Thu, 13 October 2005 04:09  |
sunil_v_mishra
Messages: 506
Registered: March 2005
|
Senior Member |
|
|
hi
When trying to connect to Oracle the following error is generated:
ORA-12224: TNS: no listener
Cause:
The connection request could not be completed because the listener is not running. This can be confirmed using the command:
lsnrctl status
on the database server.
Remedy:
Start the listener on the remote machine. (Use ‘lsnrctl start’).
If the server name has recently been changed then try running ‘Net 8 Configuration Assistant’ and select ‘Listener Configuration’. Work through the dialogs without changing anything and it will automatically update the server name. The listener can then be started. (Oracle 8 - but may apply to earlier versions.)
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.
I hope above information will help you lot
Regards
Always Friend Sunilkumar
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
