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

asdi2k_at_gmail.com wrote:
> Hi,
> 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,
>
copy
C:\oracle\product\10.1.0\db_1\NETWORK\ADMIN\TNSNAMES.ORA to the Developer Suite-DEFAULT_HOME_1\network\admin direcory. Or lookup tns_admin on google

-- 
Regards,
Frank van Bortel