Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

unable to grant sysdba to user

808602Nov 1 2010 — edited Nov 1 2010
Hi,
On my PC i am using Redhat 5. when I grant sysdba privilege to user hr it gives an error.

SQL> grant sysdba to hr;
grant sysdba to hr
*
ERROR at line 1:
ORA-01994: GRANT failed: password file missing or disabled

I check the password file is in place in the folder HOME/dbs. what can be the problem.

Plz help

Thanx
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 29 2010
Added on Nov 1 2010
9 comments
4,597 views