Re: ORA-01031 trying to list archive log status

You need SYSDBA privilege. In a standard install only the internal account has sysdba privilege. If you change the init<sid>.ora paramete remote_login_password_file to shared, sys and internal will have sysdba privilege. If you change the same parameter to exclusive, any user explicity granted sysdba privilege will be allowed to do this.

Hth,

Sybrand Bakker, Oracle DBA

Brendan Conner wrote:

> I get the error "ORA-01031: insufficient privleges" when I try to perform
> the following command from within svrmgrl:
>
> archive log list
>
> From reading the ORACLE8 DBA Handbook, this command is supposed to display
> the current ARCHIVELOG status of the database. The description from oerr is
> as follows:
>
> 01031, 00000, "insufficient privileges"
> // *Cause: An attempt was made to change the current username or password
> // without the appropriate privilege. This error also occurs if
> // attempting to install a database without the necessary operating
> // system privileges.
> // When Trusted Oracle is configure in DBMS MAC, this error may
> occur
> // if the user was granted the necessary privilege at a higher label
> // than the current login.
> // *Action: Ask the database administrator to perform the operation or grant
> // the required privileges.
> // For Trusted Oracle users getting this error although granted the
> // the appropriate privilege at a higher label, ask the database
> // administrator to regrant the privilege at the appropriate label.
>
> I connected to svrmgrl using an ID with the DBA role. Why can't I access
> this command?
>
> Thanks,
>
> - Brendan

Received on Mon Jan 25 1999 - 00:42:39 CST