clicksor ad

Friday, October 13, 2006

ORA-01994: GRANT failed: cannot add users to public password file

ORA-01994: GRANT failed: cannot add users to public password file

This error occurs on granting sysoper permission to a user

In the initialization parameter file of your database.initSID.ora add this line and then restart the database.
REMOTE_LOGIN_PASSWORDFILE = EXCLUSIVE
Posted by Ramesh at 5:57 AM

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)
Disclaimer:This blog was created as a service to those looking for oracle Database Administration related expert material and might not have resources . It is not the purpose of this site to infringe on any author's rights. If you are an author, and a article of yours is listed here, and it is not your intention to make it freely available, please contact me it.infotech@gmail.com and the article will be removed.I do not have control over what is posted on the numerous oracle groups and forums , I am merely listing those articles that I have found from numerous searches.