Steps to clear Production credential in cloned EBS instance

Invalidating all the passwords in the database (1) Start the database clone for the first time startup restrict (2) Clear all production credentials from the cloned database( This step is not mandatory, we can avoid it also) update SYS.user$ setpassword = translate(password,’0123456789ABCDEF’,’0000000000000000′)where type#=1 and length(password) = 16/update APPLSYS.FND_ORACLE_USERID setENCRYPTED_ORACLE_PASSWORD=’INVALID’/update APPLSYS.FND_USER setENCRYPTED_FOUNDATION_PASSWORD=’INVALID’,ENCRYPTED_USER_PASSWORD=’INVALID’/commit; (3)Shutdown the database shutdown …

Steps to clear Production credential in cloned EBS instance Read More »