Home > IT Answers > Oracle > oar-01033
Help

Question

  Asked: Apr 21 2008   8:21 AM GMT
  Asked by: Maitreya

oar-01033


ORA-01031, Oracle error messages, SQLPlus, ORA-01033

ORA-01033 and from I understand from reading posts..i'm to log in as sys/password as sysdba.

When I do this, sqlplus is returning the error message:
ORA -01031 Insufficient privileges. I've tried several different usernames...but SYS should work as i've used this many many times in the past "as sysdba".

Does anyone know what to do in this case?

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window
Help

Answer Wiki (Improve, edit or add to this answer)

IMPROVE THIS ANSWER
View History
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
Last Answered: Apr 21 2008  2:11 PM GMT  by Dwaltr




My first thought without looking anything up is that your password file is corrupt. Can you get to the server and log in as "sqlplus / as sysdba"? If so, then you need to recreate your password file or change the parameter <b>remote_login_passwordfile</b> to be "NONE".
  • AddThis Social Bookmark Button

Browse more Questions and Answers on Oracle and Development.

Looking for relevant Oracle Whitepapers? Visit the SearchOracle.com Research Library.


RSS - Discussions Help

Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register