OraFAQ Forum: Networking and Gateways » TNS:listener not found

Home » RDBMS Server » Networking and Gateways » TNS:listener not found

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

TNS:listener not found [message #67054]

Wed, 16 July 2003 02:56

kareka
Messages: 18
Registered: January 2003

Junior Member

i have recently upgraded a 7.3 client machine to 9i client but since then i am not able to connect a remote database with 9i client...even though i can still connect using 9i. i can ping the server machine and tnsping the database but cannot connect wiht any sqlplus tool..etc.it says listener not found.....

please let me know if there is a known solution to this problem

thanks

Report message to a moderator

Re: TNS:listener not found [message #67055 is a reply to message #67054]

Wed, 16 July 2003 05:49

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

so, your cleint and database version is 9i?
make sure your tnsnames.ora is having SERVICE_NAME instead of SID.
and post the exact message.
and edit your sqlnet.ora and comment all the entries

Report message to a moderator

Re: TNS:listener not found [message #67056 is a reply to message #67055]

Tue, 22 July 2003 05:34

karekaa
Messages: 1
Registered: July 2003

Junior Member

can there be some issue at the server that we are trying to connect with the new 9i client.

we have tried connecting with a machine which was earlier connecting the server but it is now not connecting...

thanks

Report message to a moderator

listener not Running on SCO UNIX Operating System with ORACLE 7.1.6.2 [message #67100 is a reply to message #67054]

Sat, 27 September 2003 06:32

Arvind Bhandari
Messages: 50
Registered: May 2003

Member

Here we have a Two Server with different operating system and different versions of ORACLE

1 server contains SCO UNIX 5.0 with ORACLE 7.1.6.2 and
2 server Contains WINDOWS 2000 with ORACLE 9i.

We have a problem related with listner Services is not running on UNIX Machine and when i connect from 9i Server/ or any windows Client Machine by giving host Name(Through TNSNAMES.ORA we have already Defined host String by giving Host Name/ IP Address and SID Name) it gives a error "NO Listner"
so we tried to Start Listner Service on UNIX Machine it gives Error : I am writing the Following Procedure
to start listner Services on UNIX Machine

$ lsnrctl

LSNRCTL for AT&T System V/386: Version 2.1.6.0.0 - Production on 27-SEP-03 15:32
:49

Copyright (c) Oracle Corporation 1994. All rights reserved.

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> start
Starting /u1/oracle/bin/tnslsnr: please wait...

TNSLSNR for AT&T System V/386: Version 2.1.6.0.0 - Production
NL-00462: error loading parameter file /etc/listener.ora
NL-00405: cannot open parameter file
SNL-00016: snlfohd: error opening file
AT&T System V/386 Error: 13: Permission denied

is any Guys makes solution for that

Arvind

Report message to a moderator

Previous Topic:	how to automatically connect as sysdba
Next Topic:	ORA-12571: TNS:packet writer failure

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Apr 27 21:02:58 CDT 2024