ora-01031
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: ora-01031

  1. #1
    Join Date
    Aug 2003
    Posts
    5

    ora-01031

    Hi guys,



    Oracle 9i
    Windows 2000
    SQL*Plus


    I issued the command:

    Connect / as sysdba

    and I keep getting this message: ORA-01031 insufficient privileges

    I figured it's the facted that my Remote_login_passwordfile is set wrong so I go to my Oracle file through my OS and find my init.ora file. I find the parameter and erase "None" and type in "Exclusive" figuring that would solve the problem.

    I issued the same command and still receive the ORA-01031 insufficient privileges error so I type in "Show parameters remote" to see if the passwordfile has changed and it still registers as "none" even though in the init.ora file it says "exclusive".

    I'm I changing the Remote_login_passwordfile wrong in the init.ora and if I am how do I change this particular parameter correctly.

    Or is there another problem all together that I don't even realize.


    Thank guys.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    do you actually have the required priveleges to connect as sysdba using OS authentication?

  3. #3
    Join Date
    Oct 2002
    Posts
    182
    I just had this problem.
    Very frustrating.

    I noticed in similar threads they say to add (NTS) into your sqlnet.ora file. Well, I actually REMOVED that line and now everything works fine!

    I only wasted 4 hours attempting to solve this problem.
    At least it is solved. Now all I need to know is why.

    I was connecting remotely to the host.
    - Cookies

Posting Permissions

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



Click Here to Expand Forum to Full Width