![]() | |
![]() |
| | Thread Tools | Display Modes |
#1
| |||
| |||
|
#2
| |||
| |||
|
|
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) |
#3
| |||
| |||
|
|
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 |
#4
| |||
| |||
|
|
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) |

![]() |
| Thread Tools | |
| Display Modes | |
| |