Re: tnsping working; sqlplus not




<phraje@xxxxxxxxx> a écrit dans le message de news: 1142356195.618312.53800@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
|I am trying to connect to a client's Oracle DB. I have installed the
| client on my PC, and copied their supplied tnsnames.ora file into
| ($ORACLE_HOME)\network\admin. The sanitized results of my attempts to
| connect are below.
|
| Tnsping is working:
| C:\oracle\product\10.2.0\client_2\BIN>tnsping instance
| TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on
| 14-MAR-2006 10:33:19
|
| Copyright (c) 1997, 2005, Oracle. All rights reserved.
| Used parameter files:
| C:\oracle\product\10.2.0\client_2\network\admin\sqlnet.ora
| Used TNSNAMES adapter to resolve the alias
|
| Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS =
| (PROTOCOL = TCP) (HOST = hostname) (PORT = 1523))) (CONNECT_DATA = (SID
| = instance) (SDU=8192) (TDU=32767)))
| OK (570 msec)
|
| SQLPlus is not working:
| C:\oracle\product\10.2.0\client_2\BIN>sqlplus
| username/password@instance
| SQL*Plus: Release 10.2.0.1.0 - Production on Tue Mar 14 10:34:26 2006
| Copyright (c) 1982, 2005, Oracle. All rights reserved.
|
| ERROR:
| ORA-12154: TNS:could not resolve the connect identifier specified
|
| Enter user-name: username
| Enter password:
| ERROR:
| ORA-12560: TNS:protocol adapter error
|
| Same name, same computer, same command prompt, different results. If
| anyone has any suggestions, I'd really appreciate them. The DBA is
| just telling me that "it's your PC, if tnsping works, sqlplus should
| work".
|
| Thanks,
| Bob
|

The main error is:

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

Check your tnsnames.ora file (tnsping doesn't check connect_data).

Regards
Michel Cadot


.



Relevant Pages

  • Re: OracleXE and Designer connection problem
    ... Used TNSNAMES adapter to resolve the alias ... OK, my output for "tnsping XE" matches exactly this one, except that in my ...
    (comp.databases.oracle.tools)
  • tnsping working; sqlplus not
    ... I am trying to connect to a client's Oracle DB. ... Used TNSNAMES adapter to resolve the alias ... SQLPlus is not working: ... ORA-12154: TNS:could not resolve the connect identifier specified ...
    (comp.databases.oracle.tools)
  • Re: ERROR ORA-12154 TNS: could not resolve the connect identifier specified
    ... The error message (ORA-12154: TNS:could not resolve the connect ... identifier specified) like the environment is not correct setup for a ... Here is tnsping output ... TNS Ping Utility for Linux: Version 11.1.0.6.0 - Production on 16- ...
    (comp.databases.oracle.misc)
  • Re: Problem with with exp
    ... I installed the Oracle Client 10.2.0.1.0 on a new machine with Windows ... sqlplus and tnsping would fail) ... check how many tnsnames.ora files there actually are on the machine; make sure exp uses the right one. ...
    (comp.databases.oracle.server)
  • Re: ERROR ORA-12154 TNS: could not resolve the connect identifier specified
    ... The error message (ORA-12154: TNS:could not resolve the connect ... Here is tnsping output ... INSTALLATION OR BETTER NUKE YOU TO RESOLVE YOUR PROBLEM? ... Senior Oracle DBA ...
    (comp.databases.oracle.misc)