Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
General
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