Re: SQL PLUS connect problem

From: Howard J. Rogers <howardjr_at_www.com>
Date: Sun, 2 Sep 2001 10:23:30 +1000
Message-ID: <3b917aee@news.iprimus.com.au>

Because sys AS SYSDBA is a Privileged User, and Privileged Users can always connect, even in the middle of a shutdown.

Sys without the AS SYSDBA keywords is just an ordinary user (though very powerful), and no ordinary Users are allowed to connect during a shutdown.

In other words, it's the difference between ordinary user authentication (via the data dictionary), and Privileged User authentication (via the password file or operating system).

Regards
HJR "frank" <frankw_at_qd.lucent.com> wrote in message news:9meon0$5sb_at_nntpb.cb.lucent.com...
> Hi,
>
> I am using Oracle8.1.6. when I try to connect Oracle with SQL Plus with
> "sys/myPassword", I got "Oracle Initialization or Shut down in progress",
> but if I connect with "sys/myPassword as sysdba" then no problem.
> Please tell me the reason?
>
> Thanks
> Frank
>
>
Received on Sat Sep 01 2001 - 19:23:30 CDT