Home / APPS DBA / How to Get Apps Password From Backend

How to Get Apps Password From Backend

How to Get Apps Password From Backend

 

STEP 1.  First login to Database through Command Prompt

sqlplus / as sysdba

 

STEP 2 : Create Function From Below Script to decrypt the encrypted password

create FUNCTION apps.decrypt_pin_func(in_chr_key IN VARCHAR2,
in_chr_encrypted_pin IN VARCHAR2)  
RETURN VARCHAR2 AS
LANGUAGE JAVA NAME ‘oracle.apps.fnd.security.WebSessionManagerProc.decrypt(java.lang.String,java.lang.String) return java.lang.String’;

 

STEP 3 : Run the Below Query for Retrieving AppsPassword

SQL> select ENCRYPTED_FOUNDATION_PASSWORD from apps.fnd_user where USER_NAME=’GUEST’;

ENCRYPTED_FOUNDATION_PASSWORD
——————————————————————————–
ZHA49B7AB1BB637F7A4347721229CF2F31A95DEC86B3CCFAEF9B40D4EB9AA8F0030EDDFC2324D873
AB2FFFA3B302AEE6EBD1

 

 

STEP 4:  Run the Below Query to get the Password

SELECT apps.decrypt_pin_func(‘GUEST/ORACLE123′,’ZHA49B7AB1BB637F7A4347721229CF2F31A95DEC86B3CCFAEF9B40D4EB9AA8F0030EDDFC2324D873AB2FFFA3B302AEE6EBD1’) from dual;

APPS.DECRYPT_PIN_FUNC(‘GUEST/ORACLE’,’ZHA49B7AB1BB637F7A4347721229CF2F31A95DEC86B3CCFAEF9B40D4EB9AA8F0030EDDFC2324D873AB2FFFA3B302AEE6EBD1′)
——————————————————————————–
APPS

 

STEP 5:  Now Login With the Password Retrieved.

SQL> conn apps/APPS;
Connected.

 

About Syed Saad Ali

With 13 years of experience as a certified and skilled Oracle Database Administrator, I possess the expertise to handle various levels of database maintenance tasks and proficiently perform Oracle updates. Throughout my career, I have honed my analytical abilities, enabling me to swiftly diagnose and resolve issues as they arise. I excel in planning and executing special projects within time-sensitive environments, showcasing exceptional organizational and time management skills. My extensive knowledge encompasses directing, coordinating, and exercising authoritative control over all aspects of planning, organization, and successful project completions. Additionally, I have a strong aptitude for resolving customer relations matters by prioritizing understanding and effective communication. I am adept at interacting with customers, vendors, and management, ensuring seamless communication and fostering positive relationships.

Check Also

OracleDBconfig

Updating OS in Oracle RAC

Updating OS in Oracle RAC running on Azure using Flashgrid Software In this blog post …

Leave a Reply