Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> ORA-01031: insufficient privileges

ORA-01031: insufficient privileges

From: Manfred Sturm <Manfred.Sturm_at_itServe.ch>
Date: Thu, 16 Dec 1999 18:08:48 +0100
Message-ID: <38591CA0.6FABA2E8@itServe.ch>


Hi

I'm not able to dbshut/dbstart my 3 successfully instances of my Oracle8i (8.1.5.0.0 for Solaris7) installation anymore. Trying to connect using svrmgrl with my Oracle installation user (named: oracle8i, member of groups: dba,oinstall,oper) using   SVRMGR> connect internal
  Password:
  ORA-01031: insufficient privileges
a password, I never have been prompted for. Neither 'manager' nor 'change_on_install' works.
  SVRMGR> connect / as sysdba
  ORA-01031: insufficient privileges
pretty much the same result here.

Note: I expect to be able to log in internally to the currently set ORACLE_SID database instance. I intent to use OS authentication with remote_login_passwordfile set to none and a removed $ORACLE_HOME/dbs/orapw<ORACLE_SID> file (I did this modification while the particular db instance was shut down).

I try to find a way to use OS authentication with no password for the internal user, so dbstart/dbshut work unchanged for a UNIX user being member of the dba or oper group (as described in the administration manual).

But for now it seems I have locked myself out of the system for startup/shutdown or database manipulation operations.

P.S.: user sys/change_on_install and system/manager still work fine :-|

Who can help me out?

Cheers

Manfred


Received on Thu Dec 16 1999 - 11:08:48 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US