Yes, you are right.
sys has sysdba as default, SYSTEM dosn't.
"Ganesh Raja" <ganesh_at_gtfs-gulf.com> wrote in message
news:a5i4ve$704_at_news-dxb.emirates.net.ae...
> If i am not wrong the sysdba prvis is already given to SYS...
>
> Check V$PWFILE_USERS.
>
> Did u check u'r remote login password file it should be set to exclusive.
> Then only connections from remote client are entertained.
>
> hth
> --
> [Additions and Corrections Welcome.]
> Regards,
> Ganesh R
> "Tiger Woods" <clintonn_at_meb.co.za> wrote in message
> news:3c7b8828$0$234_at_hades.is.co.za...
> > Logon to svrmgrl and grant sysdba to sys and system...
> > Then retry, it will work!!!
> >
> > Good luck.
> >
> > Clint
> >
> >
> >
> >
> >
> > "Tao Zhao" <zhaotao_at_mediaone.net> wrote in message
> > news:qhBe8.25658$jj4.1834985_at_typhoon.ne.ipsvc.net...
> > > I am using OEM which connects to Oracle9i, in the OEM console even I
> > > specified 'as sysdba', I still get error:'ORA-01031, Insufficient
> > > privileges', I am sure the password are correct.Anybody know the
reason?
> > >
> > > Besides, if I want remote connect with 'sys' without specify 'AS
> SYSDBA',
> > > can I still login?
> > > This is the case when I install 9iAS on another computer(NT/2000).
> > >
> > >
> >
> >
>
>
Received on Wed Feb 27 2002 - 07:07:41 CST
