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

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 Received on Mon Jun 02 1997 - 00:00:00 CDT