This should be an easy "TSN: could not resolve service name" problem:

Hi,

I have Oracle9iEMS and Orace9iDS installed on my windows XP machine.

If I run sqlplus from \oracle\ora92\bin, I connect with no problems:

C:\oracle\ora92\bin>sqlplus ****************************

SQL*Plus: Release 9.2.0.1.0 - Production on Sun Jan 19 22:48:48 2003

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0 - Production

SQL> However, if I connect using the same string in the developer directory, the local sqlplus does not connect (nor do any of the other applications).

C:\oracle\developer\bin>sqlplus *******************************************

SQL*Plus: Release 9.0.1.3.0 - Production on Sun Jan 19 22:52:52 2003

(c) Copyright 2001 Oracle Corporation. All rights reserved.

ERROR:
ORA-12154: TNS:could not resolve service name

I have tried monkeying with OracleHome selector, but this had lead nowhere yet.

Thanks for any advise!
T. Received on Sun Jan 19 2003 - 22:00:19 CST