Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle instant client - missing but undesired tnsnames.ora

637337May 2 2008 — edited May 5 2008

Hi,
I'm trying connect to a database using sqlplus instant client and for some reason the easy connection string is not working the same as in any other server I tried. Someway it is looking the entry on a tnsnames.ora file which is not defined and I don't won't/need to use either.

Is there anyone who has any idea how to resolve this or that can help me? Read below for the details.

OS = MSWin server 2003
TNS_ADMIN is not defined

c:\oracle_instant_client>sqlplus user/pass@//IP:PORT/service

SQL*Plus: Release 10.1.0.3.0 - Production on Fri May 2 13:54:05 2008

Copyright (c) 1982, 2004, Oracle. All rights reserved.

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

Enter user-name:

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 2 2008

Added on May 2 2008

#general-database-discussions

9 comments

1,936 views