Re: Database assistant problem

From: Trifon Anguelov <trifona_at_pacbell.net>
Date: Thu, 21 Mar 2002 07:42:32 GMT
Message-ID: <I9gm8.12044$9A5.562846823@newssvr21.news.prodigy.com>

Tom,

Try connecting in svrmgrl as internal and then: GRANT SYSDBA TO <USER>;

Then the user should be able to connect AS SYSDBA.

Hope that helps.

Trifon Anguelov
Senior Oracle DBA

visit the latest Oracle DBA forums:
http://www.dbaclick.com/cgi-bin/ib3/ikonboard.cgi

---

---

"Tom Brown" <tom_at_eazyriders.com> wrote in message news:X77m8.4887$bm6.35259602_at_news-text.cableinet.net...
> Hi,
>
> When i run the database assistant on 8.1.7 and NT and try and connect to a
> database as SYS/**PASSWORD** it fails with a invalid username and/or
> password when i connect as SYSDBA BUT when i connect with sqlplus using
the
> same info it works fine... eg
>
> sqlplus SYS/**PASSWORD**@SID i can get in and have full access?
>
> does anyone know why this might be?
>
> thanks
>
> Tom
>
>
>
Received on Thu Mar 21 2002 - 01:42:32 CST