Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Can't shutdown database
You need SYSDBA privilege, not DBA privilege for this. Apparently your init<sid>.ora parameter remote_login_password_file has been set to none, which means internal is the only user with SYSDBA privilege. It needs to be set to shared to make sure SYS is receiving SYSDBA privilege, and exclusive when you want to be able to grant any user SYSDBA privilege.
Hth,
Sybrand Bakker, Oracle DBA
"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 - 00:10:07 CDT