Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: I can't login to OEM now--"SID given in connect descriptor could not be resolved"

Re: I can't login to OEM now--"SID given in connect descriptor could not be resolved"

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 27 Jul 2002 07:17:40 +0200
Message-ID: <uk4bero0at1227@corp.supernews.com>

"fish" <zuohong.f.yu_at_bigfoot.com> wrote in message news:aht0g1$2dm1$1_at_mail.cn99.com...
> Hi all,
>
> I installed Oracle 8i on my RedHat 7.2 box some days ago. It used to run
> very well. But yesterday when I wanted to login to OEM, an error message
> jumped out to say "SID given in connect descriptor could not be resolved".
> No error code, not like before. I don't what happened. Maybe I changed
some
> important settings? My INSTANCE and LISTENER can start or stop without any
> problem. I can also run SQLPLUS to show my tables.
> Any suggestion will be appreciated.
>
> fish
>
>

vi your tnsnames.ora. Look at the sid = clause in the service definiton for the service you are using. The error message is saying this sid doesn't occur in listener.ora.
Correct either file and possibly bounce the listener.

Hth

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address
Received on Sat Jul 27 2002 - 00:17:40 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US