I have a problem. I created a password file for my database by using oradim -new -sid db7 -intpwd db7. I have four users. When I grant sysdba to one of them (say user1), I'm getting the error "ORA-1994: grant failed: cannot add user to public password file." Why is this error given? Thanks.

    Requires Free Membership to View

    Login

Simply creating the password file is not enough. You'll have to instruct Oracle to use the password file as well. This is done by setting the REMOTE_LOGIN_PASSWORDFILE initialization parameter to EXCLUSIVE in your parameter file. You will have to restart your instance for this setting to take affect.

This was first published in July 2006

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top