By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,652 Members | 1,335 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,652 IT Pros & Developers. It's quick & easy.

TNSPING works SQLPLUS fails whsn connecting to remote server

P: n/a
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)

Jul 19 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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)


Jul 19 '05 #2

P: n/a
91YJ_Renegade <sp*****@waxhaw.net> wrote in message news:<pa****************************@waxhaw.net>.. .
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.
Jul 19 '05 #3

P: n/a
91YJ_Renegade <sp*****@waxhaw.net> wrote in message news:<pa****************************@waxhaw.net>.. .
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 :)
Jul 19 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.