Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Posts
    39

    Unanswered: ora-01031 on windows-xp 9.2.0.6 upgrade

    Hello
    I applied patch 9.2.0.6 and when I goto command prompt and try to login
    > sqlplus "/as sysdba"
    It says insufficient privileges 01031
    but it works with password.

    What happened after applying patch? it used to work just before applying patch.

    The windows user is unchanged and is on ORA_DBA, Administrator group

    Thanks
    Ydj

  2. #2
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    - ensure that you set the ORACLE_HOME and ORACLE_SID correctly
    before lauching the sqlplus.
    - make sure you are a member of the OSDBA or OSOPER group
    - Ensure that the global login can execute without error and don't have
    termout turned off ..

    HTH
    Gregg

Posting Permissions

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