Search This Blog

Sunday, December 25, 2011

unable to login as ops user

User was unable to login to the database using the ops user ops$abc so I had to change the parameter remote_os_authent parameter from false to true.

sql>alter system set remote_os_authent=true scope=spfile
/

Blackout the database in OEM grid control
bounce the database as remote_os_authent parameter is a static parameter
Remove the blackout for the database
Then the user was able to login to the database

No comments:

Post a Comment