Connection from Oracle Developer Suite 10g 9.0.4.0.1 to Oracle DB 10g Release 10.1.0.2.0

From: <asdi2k_at_gmail.com>
Date: 29 Jun 2005 08:29:53 -0700
Message-ID: <1120058993.267547.258060_at_g47g2000cwa.googlegroups.com>



Hi,
[Quoted] I have installed Oracle DB 10g Release 10.1.0.2.0 on Windows XP. START->ALL PROGS->oracle-OraDb10g_home3
Location of TNSNAMES FILE:
C:\oracle\product\10.1.0\db_3\NETWORK\ADMIN\TNSNAMES.ORA with two alias:
1)ORCL3
2) EXTPROC_CONNECTION_DATA I can logon to database via SQL*PLUS and I can log on to EM on the web as well using ORCL3.

After that I installed Oracle Developer Suite 10g 9.0.4.0.1 to my the same computer.
During installation it was not allowing me to install this suite to the same ORACLE home.
I installed this in the following home:
START->ALL PROGS->oracle Developer Suite-DEFAULT_HOME_1 Location of TNSNAMES FILE:
C:\oracle\product\10.1.0\db_1\NETWORK\ADMIN\TNSNAMES.ORA with two alias:
1) EXTPROC_CONNECTION_DATA
2) ORCL3 Here is the problem whenever I try to logon to ORCL3 via SQL*PLUS 9.0.1.4.0( DEVELOPER SUIT):
START->ALL PROGS->oracle Developer Suite-DEFAULT_HOME_1->Application Development-> SQL Plus

OR to
START->ALL PROGS->oracle Developer Suite-DEFAULT_HOME_1->Designer-> oracle Desiger

I get following error:

ORA-12154 TNS:Could not resolve Service name

I used user
Scott/*******_at_ORCL3
and I tried this as well:
Scott/*******_at_EXTPROC_CONNECTION_DATA

I appreciate any help in this matter.

Regards, Received on Wed Jun 29 2005 - 17:29:53 CEST

Original text of this message