On a freshly installed 11gR2 Oracle Database, I set the following environment variables:
ORACLE_BASE
ORACLE_HOME
ORACLE_SID
TNS_ADMIN
TWO_TASK
LD_LIBRARY_PATH
However when I tried to connect to it:
sqlplus /nolog
conn / as sysdba
ORA-1031 Insufficient Privileges
A search on My Oracle Support showed this:
Error: ORA 1031
Text: 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
UPDATE a table with only SELECT privileges, if attempting to CONNECT
INTERNAL, or if attempting to install a database without the necessary
operating system privileges.
Action: Ask the database administrator to perform the operation or grant the
required privileges.
However I got my answer from this article:
UNIX: Checklist for Resolving Connect AS SYSDBA Issues [ID 69642.1]
It turned out that unsetting the environment variable TWO_TASK resolved the issue:
unset TWO_TASK
sqlplus /nolog
conn / as sysdba
Connected.
Subscribe to:
Post Comments (Atom)
Posts
7 comments:
Hi Vikram,
How did you find the "environment variable TWO_TASK" causes the
ORA-1031 Insufficient Privileges
Thanks in advance.
Superb...
Such a simple solution.
But I do not understand why this TWO_TASK creates this problem.
Ridhi
Hi Vikram,
Simply superb! This resolved my issue wherein Sharplex was not able to connect to DB as the sysdba. Both ORACLE_SID and TWO_TASK were set.
Thanks,
Mrinal
How otm is installed what is the actuall process
what is meant by integration & orderbase management system
Hello Vukram,
I typed the unset TWO_TASK
at the prompt console in both of my units:
C:\> unset TWO_TASK
"unset" no se reconoce como un comando interno o externo,
programa o archivo por lotes ejecutable.
C:\>sqlplus/nolog
SQL*Plus: Release 11.1.0.6.0 - Production on Vie Abr 20 15:56:56 2012
Copyright (c) 1982, 2007, Oracle. All rights reserved.
SQL> unset TWO_TASK
SP2-0734: inicio "unset TWO_..." de comando desconocido - resto de la lÝnea
rado.
SQL> unset TWO_TASK
SP2-0734: inicio "unset TWO_..." de comando desconocido - resto de la lÝnea
rado.
SQL> exit
C:\>d:
D:\>unset TWO_TASK
"unset" no se reconoce como un comando interno o externo,
programa o archivo por lotes ejecutable.
D:\>sqlplus/nolog
SQL*Plus: Release 11.1.0.6.0 - Production on Vie Abr 20 15:58:24 2012
Copyright (c) 1982, 2007, Oracle. All rights reserved.
SQL> conn/as sysdba
ERROR:
ORA-01031: insufficient privileges
SQL>
I still have the ora-0131 error. Any help is more than appreciated!
Sandra, the unset is for linux/unix environment. For window you can do following.
1. Make sure pfile has *.remote_login_passwordfile='EXCLUSIVE'
2. sqlnet.ora file has following.
SQLNET.AUTHENTICATION_SERVICES= (NTS)
#NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
make note that names.directory_path is commented out.
Hope it helps.
Thanks
-Vijay Parmar
Post a Comment