ORA-01031 trying to list archive log status

From: Brendan Conner <brendan.conner_at_ibm.net>
Date: Fri, 22 Jan 1999 12:50:52 -0600
Message-ID: <36a8c879.0@news1.ibm.net>

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 Fri Jan 22 1999 - 12:50:52 CST