Re: Oracle designer
From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Thu, 25 Oct 2007 20:47:19 +0200
Message-ID: <ffqobk$a20$3_at_news1.zwoll1.ov.home.nl>
>
> I've found this in my tnsname.ora:
>
> XE =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = TCP)(HOST = demon)(PORT = 1521))
> (CONNECT_DATA =
> (SERVER = DEDICATED)
> (SERVICE_NAME = XE)
> )
> )
>
> It looks like my service name is "XE" but when I try to use it in login
> process I get the same error: ORA-12154 :/
>
> Any ideas?
>
> Regards
> Kuba
you have two oracle homes:
one with XE (where you found this tnsnames.ora), and one for Designer. The Designer OH also has a network\admin directory - copy the XE home\network\admin\*.ora files over to Designer_Home\network\admin.
Date: Thu, 25 Oct 2007 20:47:19 +0200
Message-ID: <ffqobk$a20$3_at_news1.zwoll1.ov.home.nl>
qpon wrote:
> Proet pisze:
>> Try with service name "XE".
>
> I've found this in my tnsname.ora:
>
> XE =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = TCP)(HOST = demon)(PORT = 1521))
> (CONNECT_DATA =
> (SERVER = DEDICATED)
> (SERVICE_NAME = XE)
> )
> )
>
> It looks like my service name is "XE" but when I try to use it in login
> process I get the same error: ORA-12154 :/
>
> Any ideas?
>
> Regards
> Kuba
you have two oracle homes:
one with XE (where you found this tnsnames.ora), and one for Designer. The Designer OH also has a network\admin directory - copy the XE home\network\admin\*.ora files over to Designer_Home\network\admin.
Or set tns_admin; more on
http://vanbortel.blogspot.com/2006/03/network-blues.html
-- Regards, Frank van Bortel Top-posting is one way to shut me up...Received on Thu Oct 25 2007 - 20:47:19 CEST