Connection from Oracle Developer Suite 10g 9.0.4.0.1 to Oracle DB 10g Release 10.1.0.2.0
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