Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> tnsping works, but cannot connect using sqlplus

tnsping works, but cannot connect using sqlplus

From: Peter Bismuti <bismuti_at_cs.fsu.edu>
Date: 24 Aug 2000 16:45:53 GMT
Message-ID: <8o3jg1$2bj$1@news.fsu.edu>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US