Re: HELP: SERVER MANAGER CANNOT CONNECT
From: Michael Serbanescu <ms_at_cmprime.cis.att.com>
Date: 1996/09/30
Message-ID: <324FE22E.23F9_at_cmprime.cis.att.com>#1/1
> We're running Oracle Server Manager version 2.0.4.0.0
> for Windows 3.1, and it's having problems connecting to
> a database.
>
> When I specify a service name in the Connect dialogue
> box, it responds with the following:
>
> MGR-02073: an error occurred while
> connecting to a database
> ORA-12154: TNS:could not resolve service
> name
>
> If I *don't* supply the service name, it successfully
> connects to the default database (prod).
>
> This is weird, because I'm sure our TNSNAMES.ORA file
> is correct, because Browser can successfully connect to
> both service names.
>
> Has anyone else encountered this problem? Or more to the
> point, anyone know how to fix it???
>
> Thanks in advance,
>
> Steve Chell
> slc_at_stevensons.co.nz
Received on Mon Sep 30 1996 - 00:00:00 CEST
Date: 1996/09/30
Message-ID: <324FE22E.23F9_at_cmprime.cis.att.com>#1/1
Steve Chell wrote:
>
Your best bet is to make sure and use the IP address for the host server
(rather than an alias/host name) in both the LISTENER.ORA (on the host)
and the TNSNAMES.ORA (on the client).
I hope this helps.
Michael Serbanescu
Sr. ORACLE DBA, TRECOM Business Systems, Edison, NJ
ms_at_cmprime.cis.att.com
(908)576-3894
> We're running Oracle Server Manager version 2.0.4.0.0
> for Windows 3.1, and it's having problems connecting to
> a database.
>
> When I specify a service name in the Connect dialogue
> box, it responds with the following:
>
> MGR-02073: an error occurred while
> connecting to a database
> ORA-12154: TNS:could not resolve service
> name
>
> If I *don't* supply the service name, it successfully
> connects to the default database (prod).
>
> This is weird, because I'm sure our TNSNAMES.ORA file
> is correct, because Browser can successfully connect to
> both service names.
>
> Has anyone else encountered this problem? Or more to the
> point, anyone know how to fix it???
>
> Thanks in advance,
>
> Steve Chell
> slc_at_stevensons.co.nz
Received on Mon Sep 30 1996 - 00:00:00 CEST