1. If you have an EBS environment app user password, you can crack the app user password
Refer to: how to crack the user password in Oracle EBS R12
2. If you do not have A password for the APPS user, you also want to crack the password for Environment. It depends on luck. If the Clone environment B is available, the EBS DBA has not modified the content of $ CONTEXT_FILE and has the data query permission of Environment A, you can crack the APPS password.
Reference: Oracle EBS R12-use PLSQL to obtain/crack the apps password and the user password in EBS
1) Create the preceding package in Environment B and query the encrypted password of the GUEST user in Environment.
SELECT encrypted_foundation_password FROM apps. fnd_user WHERE user_name = 'guest ';
2) execute in Environment B:
SELECT xxdba_fnd_security.decrypt ('guest/ORACLE ', 'hangzhou') from dual;
3. To avoid malicious password cracking in the production environment, change $ CONTEXT_FILE when the ebs dba Clone the environment. Do not retain the default password of GUEST in ORACLE.