no listener [message #50246] |
Thu, 07 March 2002 00:38 |
krishna
Messages: 141 Registered: October 1998
|
Senior Member |
|
|
hi
when i try to connect to my database from my machine(server is on my machine itself) thru sql plus, i get the error
ora-12541: TNS no listener
when i enter all fields(ie username, password and hoststring). But it is letting me enter if i leave out the host string.
What is the problem?
|
|
|
Re: no listener [message #50251 is a reply to message #50246] |
Thu, 07 March 2002 07:53 |
Grant
Messages: 578 Registered: January 2002
|
Senior Member |
|
|
When you use the host string it is getting it from your tnsnames.ora file. Make sure you have enterred the alias correctly. Make sure the port and host is correct. The port in the tnsnames file must be the same as the port your listener.ora file is listeneing on. You may need to tack on your domain.com to the end of the host string.
The reason you are able to connect on the server without a host string (tnsnames alias) is because you have your Oracle environment variables set and the user connecting is in the dba group. It doesn't use tnsnames.
|
|
|
|