DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: SYSDBA

  1. #1
    Join Date
    Oct 2000
    Posts
    24
    Hi All

    I am trying to grant a user admin sysdba rights. I use the command grant sysdba to admin and get theerror below
    ORA-01994: GRANT failed: cannot add users to public password file

    I have checked my for the error code ORA-01994 and it says
    ORA-01994: GRANT failed: cannot add users to public password file
    Cause: A grant failed because a user could not be added to the password file. This is because the value of the REMOTE_LOGIN_PASSWORDFILE initialization parameter is set to PUBLIC.

    Action: To add a user to the password file, shutdown the database, change the REMOTE_LOGIN_PASSWORDFILE initialization parameter to PRIVATE, and restart the database.

    My question is how do I change the remote_login_passwordfile initialization parameter to PRIVATE

    Thanks in advance


  2. #2
    Join Date
    Jan 2000
    Location
    *
    Posts
    37
    Change it in your init.ora file

  3. #3
    Join Date
    Oct 2000
    Posts
    24
    I changed remote_login_passwordfile = shared in init.ora to remote_login_passwordfile = PRIVATE but no one could connect to the database. Once I changed it back to shared everyone could connect. Any ideas

    Vinay

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    well leave it shared and create a password file with orapwd utility, by creating this file you can give sysdba to users which will be added to this password file. It's a DOS utility if you are in NT, UNIX executable if you are in UNIX, if you are using Oracle 8 then it's orapwd80 otherwise orapwd

  5. #5
    Join Date
    Jun 2005
    Location
    India
    Posts
    14
    change your remote_login_passwordfile=none restart the machine and then it should work.

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