| no listener [message #67773] |
Thu, 07 March 2002 00:39  |
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 #67780 is a reply to message #67773] |
Mon, 11 March 2002 11:43  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
krishna!.
since ur db is in your local machine, no need to enter the host string.
it allows as such.
IF u want to enter a host string it should be a valid one. USE the net8 configuration assistant( or manually editing the tnsnames.ora) to create a hostring or a userfriedly service_name.
u need the following information.
ip/hostname of the server (your case, local)
databaseName
portno(default is 1521)
using these u create a host_string..
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
