Ora-01994 grant failed cannot add users to public password file

FILE Name to assign to the password file, which will hold the password information. You must supply complete path. If you supply only filename, the file is written to the current directory.

The contents are encrypted and are unreadable. This argument is mandatory. The filenames allowed for the password file are OS specific. Some operating systems require the password file to adhere to a specific format and be located in a specific directory. Other operating systems allow the use of environment variables to specify the name and location of the password file.

If you are running multiple instances of Oracle Database using Oracle Real Application Clusters RAC , the environment variable for each instance should point to the same password file. This argument specifies the number of entries that you require the password file to accept.

The actual number of allowable entries can be higher than the number of users, because the orapwd utility continues to assign password entries until an OS block is filled. For example, if your OS block size is bytes, it holds four password entries. Join Us Close. Join Tek-Tips Forums! Join Us! By joining you are opting in to receive e-mail. Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here. Error: ORA Text: GRANT failed: cannot add users to public password file Cause: A grant failed because a user could not be added to the password file. Edit the init. STEP 3. STEP 4. Confirm that the user is listed in the orapwd password file.

STEP 5. Test the connectivity. Burleson is the American Team Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.

How to check free space in tablespaces How to monitor the amount of redo generated per hour How to check free space in tablespaces How to monitor the amount of redo generated per hour How to select hidden initialization parameters How to select hidden initialization parameters What is the difference between SYS and SYSTEM data What is the difference between a schema and a user?

How to check any deadlock and other locking issues How to check any deadlock and other locking issues What a Oracle DBA can be? What a Oracle DBA can be? Oracle 10gR2 : Oracle Patching