Re: Designer/2000 proble.

On Thu, 15 Oct 1998 10:02:50 -0400, "Italo Bozzi Feuereisen" <ibozzi_at_cochrane.cl> wrote:

>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
> 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

I don't know if this is the same problem as I was having but you must have an entry for the remote database in the [Quoted] $ORACLE_HOME/network/admin/tnsnames.ora of the repository machine. Having the TNSNAME in you local client machine doesn't work because the repository machine is the one connecting to the remote database not your client.

When you add the entry in tnsnames.ora on the repository machine, make sure it works by running sqlplus either at the repository machine or via a telnet session running on the repository machine to make sure it can connect.

When you go to reverse engineer the database, you enter the username and password in the remote database and the connect string that you added to tnsnames.ora in the repository.

Regards,
Ken Colerick
colerick_at_borg.com Received on Thu Oct 15 1998 - 17:14:41 CEST