Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004
    Posts
    58

    Exclamation Unanswered: ORA-01031: insufficient privileges when logging in as "/ as sysdba"

    Hi,

    I installed Oracle9i Enterprise Edition yesterday. The installation was successful and a starter database was created. It is running fine. However, when I tried to do sqlplus '/ as sysdba' while logging in as Oracle user in UNIX, I got 'insufficient privilege'. I know my sys and system passwords but how can I log in as sysdba successfully. I need that to startup and shutdown the database. Please help...

    Thanks in advance!

  2. #2
    Join Date
    Apr 2004
    Posts
    58
    Never mind... I got it. The Oracle user was not set up with the right dba group. Once it is corrected. I was able to log as without any problems.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •