dbTalk Databases Forums  

TNSPING works SQLPLUS fails whsn connecting to remote server

comp.databases.oracle comp.databases.oracle


Discuss TNSPING works SQLPLUS fails whsn connecting to remote server in the comp.databases.oracle forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
91YJ_Renegade
 
Posts: n/a

Default TNSPING works SQLPLUS fails whsn connecting to remote server - 08-18-2004 , 10:33 AM






why can I TNSPING but I can not connect using SQLPLUS?

Oracle 10g
Slackware 10 install 2.6.6 kernel

exports
ORACLE_BASE=/home/oracle
ORACLE_HOME=/home/oracle/product/10g
ORACLE_SID=ora9i
ORACLE_TERM=xterm


error in sqlplus:
bash-2.05b$ sqlplus wells/blah@test

SQL*Plus: Release 10.1.0.2.0 - Production on Wed Aug 18 11:30:06 2004

Copyright (c) 1982, 2004, Oracle. All rights reserved.

ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified




TNSPING:
bash-2.05b$ tnsping test

TNS Ping Utility for Linux: Version 10.1.0.2.0 - Production on 18-AUG-2004 11:31:28

Copyright (c) 1997, 2003, Oracle. All rights reserved.

Used parameter files:
/home/oracle/product/10g/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
)SERVICE_NAME = test.clt.fisonline.com).5.30)(PORT = 1521))
OK (40 msec)


Reply With Quote
  #2  
Old   
91YJ_Renegade
 
Posts: n/a

Default Re: TNSPING works SQLPLUS fails whsn connecting to remote server - 08-18-2004 , 12:04 PM






The windows file tnsnames.ora had contrl characters
that messed up SQLPLUS!!

On Wed, 18 Aug 2004 11:33:15 -0400, 91YJ_Renegade wrote:

Quote:
why can I TNSPING but I can not connect using SQLPLUS?

Oracle 10g
Slackware 10 install 2.6.6 kernel

exports
ORACLE_BASE=/home/oracle
ORACLE_HOME=/home/oracle/product/10g
ORACLE_SID=ora9i
ORACLE_TERM=xterm


error in sqlplus:
bash-2.05b$ sqlplus wells/blah@test

SQL*Plus: Release 10.1.0.2.0 - Production on Wed Aug 18 11:30:06 2004

Copyright (c) 1982, 2004, Oracle. All rights reserved.

ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified




TNSPING:
bash-2.05b$ tnsping test

TNS Ping Utility for Linux: Version 10.1.0.2.0 - Production on 18-AUG-2004 11:31:28

Copyright (c) 1997, 2003, Oracle. All rights reserved.

Used parameter files:
/home/oracle/product/10g/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
)SERVICE_NAME = test.clt.fisonline.com).5.30)(PORT = 1521))
OK (40 msec)


Reply With Quote
  #3  
Old   
Sheela
 
Posts: n/a

Default Re: TNSPING works SQLPLUS fails whsn connecting to remote server - 08-19-2004 , 04:21 PM



91YJ_Renegade <spamcop (AT) waxhaw (DOT) net> wrote

Quote:
The windows file tnsnames.ora had contrl characters
that messed up SQLPLUS!!

On Wed, 18 Aug 2004 11:33:15 -0400, 91YJ_Renegade wrote:

why can I TNSPING but I can not connect using SQLPLUS?

Oracle 10g
Slackware 10 install 2.6.6 kernel

exports
ORACLE_BASE=/home/oracle
ORACLE_HOME=/home/oracle/product/10g
ORACLE_SID=ora9i
ORACLE_TERM=xterm


error in sqlplus:
bash-2.05b$ sqlplus wells/blah@test

SQL*Plus: Release 10.1.0.2.0 - Production on Wed Aug 18 11:30:06 2004

Copyright (c) 1982, 2004, Oracle. All rights reserved.

ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified




TNSPING:
bash-2.05b$ tnsping test

TNS Ping Utility for Linux: Version 10.1.0.2.0 - Production on 18-AUG-2004 11:31:28

Copyright (c) 1997, 2003, Oracle. All rights reserved.

Used parameter files:
/home/oracle/product/10g/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
)SERVICE_NAME = test.clt.fisonline.com).5.30)(PORT = 1521))
OK (40 msec


Thnak you. It is working.


Reply With Quote
  #4  
Old   
Sheela
 
Posts: n/a

Default Re: TNSPING works SQLPLUS fails whsn connecting to remote server - 08-19-2004 , 04:22 PM



91YJ_Renegade <spamcop (AT) waxhaw (DOT) net> wrote

Quote:
The windows file tnsnames.ora had contrl characters
that messed up SQLPLUS!!

On Wed, 18 Aug 2004 11:33:15 -0400, 91YJ_Renegade wrote:

why can I TNSPING but I can not connect using SQLPLUS?

Oracle 10g
Slackware 10 install 2.6.6 kernel

exports
ORACLE_BASE=/home/oracle
ORACLE_HOME=/home/oracle/product/10g
ORACLE_SID=ora9i
ORACLE_TERM=xterm


error in sqlplus:
bash-2.05b$ sqlplus wells/blah@test

SQL*Plus: Release 10.1.0.2.0 - Production on Wed Aug 18 11:30:06 2004

Copyright (c) 1982, 2004, Oracle. All rights reserved.

ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified




TNSPING:
bash-2.05b$ tnsping test

TNS Ping Utility for Linux: Version 10.1.0.2.0 - Production on 18-AUG-2004 11:31:28

Copyright (c) 1997, 2003, Oracle. All rights reserved.

Used parameter files:
/home/oracle/product/10g/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
)SERVICE_NAME = test.clt.fisonline.com).5.30)(PORT = 1521))
OK (40 msec)

Thank you. It is working


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.