Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

ORA-01031: insufficient privileges

GeorgeLee
Occasional Visitor

ORA-01031: insufficient privileges

Hello,
Could anyone please help me to figure out this problem.
Oracle Dabase: 10.1.0.5.0
OS: Windows 2000

I have created the password file and tried to logon to the database as SYSDBA. But I got the following error.
The OS account is in ORA_DBA group. I think that it does not really matter if I want to use Password File Authentication to logon to the database.

Thanks in advance!!!


C:\>set oracle_sid=ora101
C:\>sqlplus /nolog
SQL> connect sys/password as sysdba
ERROR:
ORA-01031: insufficient privileges

SQL> connect system/password
Connected.
SQL> select name,value from v$parameter where name = 'remote_login_passwordfile';
NAME
--------------------------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
remote_login_passwordfile
EXCLUSIVE

SQL> select * from v$pwfile_users;
USERNAME SYSDB SYSOP
------------------------------ ----- -----
SYS TRUE TRUE

SQL> connect sys/password as sysdba
ERROR:
ORA-01031: insufficient privileges

Warning: You are no longer connected to ORACLE.
4 REPLIES
Frank de Vries
Respected Contributor

Re: ORA-01031: insufficient privileges

Check that $ORACLE_SID is set to the correct SID, (including capitalization),
and does not have any typos:

% echo %ORACLE_SID%

e.g. set ORACLE_SID=ORA101

check your service on windows:
net start | find "Ora"

OR

On Windows NT, if you are able to connect internally but then startup fails
for some reason, successive connect internal attempts might prompt for a
password. You may also receive errors such as:

ORA-12705: invalid or unknown NLS parameter value specified
ORA-01012: not logged on
LCC-00161: Oracle error (possible syntax error)
ORA-01031: insufficient privileges

Then do:
net stop OracleHome
and net start
and check the log if it has started properly


Good luck
Look before you leap
Yogeeraj_1
Honored Contributor

Re: ORA-01031: insufficient privileges

hi,

can you please try to run the following:

SQL> connect / as sysdba

kind regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Volker Borowski
Honored Contributor

Re: ORA-01031: insufficient privileges

Could it be,

that you are using a Local Server Login and the group membership in ORA_DBA is a domain/AD-account or vice versa ?

Did you set a password using orapwd ?

Volker

Frank de Vries
Respected Contributor

Re: ORA-01031: insufficient privileges

As you assign points, please keep in mind the scale that applies:

N/A: The answer was simply a point of clarification to my original question

1-3: The answer didn't really help answer my question but thanks for your assistance!

4-7: The answer helped with a portion of my question, but I still need some additional help.

8-10: The answer has solved my problem completely! Now I'm a happy camper!

If you have questions about the Points System, please look for more information in the Support Forums FAQs.

Look before you leap