ora-01031 - insuffcient previleges with sys as sysdba
I am using oracle 9i release 2 , with windows 2003 server.
while connecting with database user "sys" at sql prompt,
sql> conn sys as sysdba
it is showing ora-01031 insufficient previleges.
I am trying this on the server system itself i.e where database installed.
plz suggest the solution.
I am able to connect using "system" user.
Does the account belongs to ORA_DBA Windows group?
Pablo (Paul) Berzukov
Author of Understanding Database Administration
available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Click Here to Expand Forum to Full Width