TNS error [message #55840] |
Wed, 19 February 2003 14:23 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Carlos Olmeda
Messages: 22 Registered: January 2003
|
Junior Member |
|
|
Good Afternoon,
I have created three sepearte databases in oracle 7.3 running on NT Server. However I cannot connect to any of them. I go to the lsnrctl command type "start" and I continue to recieve these error messages:
NL-00462: error loading paramater file D:orantnetworkadminlistener.ora
NL-00405: cannot open parameter file
SNL-00821:nlfncons: file does not exist
No such file or directory. I already checked, and the folder is there with the listener.ora file.
When I check the status I recieve the error:
Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=PNPKEY)
I have looked at my listener and tnsnames for this key and I cannot find it)
TNS-12224:TNS no listener
TNS-12560: TNS protocol adapter error
TNS-0051: No Listener
No such file or directory.
Where do the listener and tnsnames.ora file go?
The help would be greatly appeciated.
|
|
|
Re: TNS error [message #55879 is a reply to message #55840] |
Fri, 21 February 2003 08:17 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
ctg
Messages: 146 Registered: July 2002
|
Senior Member |
|
|
this probably is not it, but who knows:
a problem i have had in the past, make sure the listener.ora file is not really named listener.ora.txt. So change your NT properties to NOT hide extensions of known files.
|
|
|
Re: TNS error [message #55882 is a reply to message #55840] |
Fri, 21 February 2003 08:39 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
ctg
Messages: 146 Registered: July 2002
|
Senior Member |
|
|
this probably is not it, but who knows:
a problem i have had in the past, make sure the listener.ora file is not really named listener.ora.txt. So change your NT properties to NOT hide extensions of known files.
|
|
|