Results 1 to 3 of 3

Thread: ora-01031

  1. #1
    Join Date
    Jul 2003
    Posts
    5

    Unanswered: 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 2003
    Location
    The Netherlands
    Posts
    311
    hi,

    did you shut down and restart the database ?
    Changes in the inti.ora will only take effect after a restart of the database.

    Hope this helps
    Edwin van Hattem
    OCP DBA / System analyst

  3. #3
    Join Date
    Sep 2003
    Posts
    6

    Re: ora-01031

    Originally posted by du365
    Hi guys,
    too many connections are existing for your db...kill some connections and try


    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.

Posting Permissions

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