Home » RDBMS Server » Server Administration » ORA-01031
ORA-01031 [message #63297] Fri, 24 September 2004 11:39 Go to next message
Jamuna
Messages: 2
Registered: September 2004
Junior Member
One of my development Db (ver 9.2.0.3.0) is down and I am trying to connect as sysdba. The following is the error:

SQL> conn /as sysdba
ERROR:
ORA-01031: insufficient privileges

I have checked that oracle OS user is included in dba group in /etc/passwd file. I was able to connect to the same DB earlier and execute sqls. It is not clear how the oracle user can lose any privileges.

Can anyone help me if I am missing on something very trivial here ?

Thanks.

 

 

 

 

 
Re: ORA-01031 [message #63299 is a reply to message #63297] Fri, 24 September 2004 18:06 Go to previous messageGo to next message
VISHNU
Messages: 14
Registered: November 2001
Junior Member
Check your env variables and ensure you are using correct ORACLE_HOME
Re: ORA-01031 [message #63326 is a reply to message #63299] Mon, 27 September 2004 11:55 Go to previous message
croK
Messages: 170
Registered: April 2002
Senior Member
also check ORACLE_SID en edit your init.ora file
to see if remote_os_authent parameter has been changed or orapwd file was created in ORACLE_HOME/dbs.

Best regards.
Oracle Consultant and remote DBA for hire.
Previous Topic: Few Basic Questions
Next Topic: Corrupted File-Rollback segment
Goto Forum:
  


Current Time: Fri Sep 27 08:26:48 CDT 2024