Re: Not able to access Oracle on SCO box with Golden32
Date: Tue, 31 Jul 2001 18:59:13 +0200
Message-ID: <996598756.8918.0.pluto.d4ee154e_at_news.demon.nl>
"Beantown" <christopher.mendes_at_walgreens.com> wrote in message
news:195e2098.0107310603.2874c23c_at_posting.google.com...
> when trying to access Oracle on my SCO server with Benthic's Golden32
> (which resides on a Windows2000 workstation) I get the following
> message :
>
> "ORA-12505: TNS:listener could not resolve SID given in connect
> descriptor"
>
> I am positive that my TNSNAMES.ora file is correct because I copied it
> from an Windows NT workstation that can access the same SCO server.
> Also, the Windows2000 workstation is able to access Oracle on other
> servers with other OS's (e.g. Dynix).
>
> Did I overlook a setting in Golden32? Any help would be appreciated.
>
> Thanks!
> Beantown
Your problem is the SID in your tnsnames.ora doesn't show up in listener.ora: your files don't match.
Hth,
Sybrand Bakker, Senior Oracle DBA Received on Tue Jul 31 2001 - 18:59:13 CEST