Re: Can't shutdown database

Oracle user INTERNAL is the only user that can be connected to an idle database, a database that is not up and running. All the dba-priviliges that system and sys have are priviliges for a running database.

Dalex <dalex_at_owt.com> wrote in message news:8q3v45$gat$2_at_news.owt.com...
> System:
> Win2000
> Oracle 8.1.5
>
>
> I've set up a test installation of Oracle 8.1.5. This was a full
 installation
> of the product.
>
> When attempting to shutdown the default database [via the SHUTDOWN
 command]
> using the sys or system account I receive an ORA-01031 error (insufficient
> privileges). However, if I log on as internal, the SHUTDOWN command
 works.
>
> I was under the impression that dba role was assigned to the sys and
 system
> accounts by default, and therefore should be able to invoke the SHUTDOWN
> command to kill the database.
>
> Just curious what I'm missing here...
>
> Dalex
> dalex_at_owt.com
>
Received on Mon Sep 18 2000 - 01:27:24 CDT