Re: Designer/2000 proble.

>Hi folks!
>
>I have a proble with the Designer/2000 v. 1.3.2
>
>The Designer Repository is under a SunOS 4.1.4 with the next configuration:
>
> Oracle7 Server Release 7.3.2.1.0 - Production Release
> PL/SQL Release 2.3.2.0.0 - Production
> CORE Version 3.5.2.0.0 - Production
> TNS for SunOS: Version 2.3.2.1.0 - Production
> NLSRTL Version 3.2.2.0.0 - Production
>
>The problem that I have is the next:
>
> When I try to make a Reverse Engineer Database from a remote database
>with:
>
> Oracle7 Server Release 7.1.5.2.3 - Production Release
> PL/SQL Release 2.1.5.2.0 - Production
> CORE Version 2.3.5.1.0 - Production (LSF Alpha)
> TNS for VMS: Version 2.1.5.1.0 - Production
> NLSRTL Version 2.3.5.6.1 - Production
>
> I receive the next error: ORA-12154
>
>Could you help me?
>
>Thanks in advance,
>
>
>Italo Bozzi Feuereisen
>
I had problems doing reverse engineering until I found out that one of the steps that happens is that a DATABASE LINK is created between the repository and the the db begin reverse-engineered. Obviously, a DBLINK does not know anything about TNS names on the client. Find the *real* name of the database (the instance name, or maybe the listener process) and use that as the connect string, not an alias in the database,

Good luck
Dan Hekimian-Williams Received on Fri Oct 16 1998 - 05:30:47 CEST