I just got 11gR2 running and was able to conn as sysdba. I shutdown and started up the database to mount a new pfile. Now, I cannot login as sysdba. My parameter for password file is:


I am using sqlplus within the server. This is not a remote connection.

[oracle@oel56 ~]$ sqlplus /nolog

SQL*Plus: Release Production on Tue Feb 5 22:50:46 2013

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

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

Here's some more information:

[oracle@oel56 ~]$ grep -E "ine SS_DBA|ine SS_OPER" $ORACLE_HOME/rdbms/lib/config.c
#define SS_DBA_GRP "oracle"
#define SS_OPER_GRP "oracle"
[oracle@oel56 ~]$ id oracle
uid=500(oracle) gid=500(oracle) groups=500(oracle),54321(oinstall),54322(dba),54323(oper) context=user_u:system_r:unconfined_t
  • Do you have multiple oracle home? Feb 6, 2013 at 8:47
  • 1
    Can you edit your question with the output of: grep -E "ine SS_DBA|ine SS_OPER" $ORACLE_HOME/rdbms/lib/config.c and also id oracle Thanks
    – Philᵀᴹ
    Feb 6, 2013 at 9:35
  • Also, if the pw file has been created properly you should still be able to login with sqlplus sys/pass as sysdba - give that a go and let me know if it works.
    – Philᵀᴹ
    Feb 6, 2013 at 9:38
  • Hi Phil. Thanks for your reply. I added the output in my question. I tried the sqlplus string as you shown, but it does not work. I am able to login doing "sqlplus system/pass" but again I have no privileges as sysdba.
    – noober
    Feb 6, 2013 at 15:03
  • @VincentMalgrat - no, only 1 oracle home: [oracle@oel56 ~]$ echo $ORACLE_HOME /u01/app/oracle/product/11.2.0/db_1
    – noober
    Feb 6, 2013 at 15:04

1 Answer 1


The problem was I was using the variable TWO_TASK. Once I unset the variable, I nolonger had issues logging in a sysdba.

$ unset TWO_TASK
$ sqlplus /nolog

SQL*Plus: Release Production on Wed Feb 6 02:51:55 2013

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup;
ORACLE instance started.

Total System Global Area 1707446272 bytes
Fixed Size          1336988 bytes
Variable Size         989858148 bytes
Database Buffers      704643072 bytes
Redo Buffers           11608064 bytes
Database mounted.
Database opened.
SQL> exit

I found the answer here.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.