Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> tnsping works, but cannot connect using sqlplus
tnsping works:
[oracle_at_roughneck oracle]$ netping dev
bash: netping: command not found
[oracle_at_roughneck oracle]$ tnsping dev
TNS Ping Utility for Linux: Version 8.1.5.0.0 - Production on 24-AUG-00 09:34:23
(c) Copyright 1997 Oracle Corporation. All rights reserved.
Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=dev)(PORT=1521)) OK (90 msec)
here is the blurb from tnsnames:
ODEV.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = appserver01)(PORT = 1521))
(CONNECT_DATA = (SID = dev))
)
when I try using sqlplus:
[oracle_at_roughneck oracle]$ sqlplus name/password_at_dev
SQL*Plus: Release 8.1.5.0.0 - Production on Thu Aug 24 09:38:48 2000
(c) Copyright 1999 Oracle Corporation. All rights reserved.
ERROR:
ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect
descriptor
This command works from a different machine with the identical tnsnames.ora file.
Any ideas what the problem is? Received on Thu Aug 24 2000 - 11:45:53 CDT
![]() |
![]() |