Re: ERROR: ORA-12505: TNS:listener could not resolve SID given in connect descriptor

From: Jim Yoshii <yoshii_at_planet.net>
Date: 1997/06/03
Message-ID: <3394C9D3.3A8C@planet.net>#1/1

R.Schierbeek wrote:
>
> Ava Chun <voyager_at_inetnow.net> wrote in artikel
> <5mldfk$ka0_at_news.inetnow.net>...
> > When i use SQLPlus to connect to the database
> > using User Name: SYSTEM Password: MANAGER Host String: ava3,
> > i get the error, as follows:
> > "ERROR: ORA-12505: TNS:listener could not resolve SID given in connect
> > descriptor"
>
> Hello Ava,
> Your TNSNAMES.ORA has:
>
> ava3.world =
> > (DESCRIPTION =
> > (ADDRESS_LIST =
> >.........
>
> so try as connect string "ava3.world"
>
> SQLNET can be very fussy about this.
>
>
> R. Schierbeek, DBA
> email: bytelife_at_worldonline.nl
> check out: www.worldonline.nl~/~bytelife

uh, I think the problem is probably in the LISTENER.ORA file on the target server. Make sure the SID for the database she's trying to connect to is listed in the SID_LIST_LISTENER section of this file

• Jim Yoshii

  ---

NOTICE TO BULK EMAILERS: Pursuant to US Code, Title 47, Chapter 5, Subchapter II, 227, any and all nonsolicited commercial e-mail sent to this address is subject to a download and archival fee in the amount of $500 US.

E-Mailing denotes acceptance of these terms.

---

Received on Tue Jun 03 1997 - 00:00:00 CDT