Have you ever forgot or lost apps password in R12. In Oracle Applications 11i, It is easy to recover apps password as it is stored in application files appsweb.cfg and wdbsvr.app.
Apps password is not available in the application files in R12. We can still recover the lost password by creating a decrypt function.
Steps to retreive apps password in R12:
1.Create function Using below syntax
SQL> create or replace 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’;
4
5 /
Function created.
2. Find the encrypted password using below query
SQL> select ENCRYPTED_FOUNDATION_PASSWORD from apps.fnd_user where USER_NAME=’GUEST’;
ENCRYPTED_FOUNDATION_PASSWORD
——————————————————————————–
JH89E045BEA551FD01A8D71029ACA879F209U8BD898F451EBDB987C818E7608CE0CC0167BDCAF9D1D04D9C9CEE418CFE615A
3.Run the below query to decrypt the password
SQL> SELECT apps.decrypt_pin_func(‘GUEST/ORACLE’,’JH89E045BEA551FD01A8D71029ACA879F209U8BD898F451EBDB987C818E7608CE0CC0167BDCAF9D1D04D9C9CEE418CFE615A') from dual;
APPS.DECRYPT_PIN_FUNC(‘GUEST/ORACLE’,’ZG761B2FB6A2C49BC802F57E55AC26637388B4EA99
——————————————————————————–
PASSWORD
4. Verify Database Connection using the password retreived
SQL> conn apps/PASSWORD
Connected.
I feel happiness to read the content that you are posting. free password manager
ReplyDeleteIt is an informative post.
ReplyDeleteAnyone have gotten so clever with making up passwords that even they can't remember them all. Writing them down in one place is counterproductive in keeping secrecy and sitting there trying to remember what it is takes up way too much time. Try the Secure Random Password. It is a great option for the every internet user.
ReplyDeletePrivacy and security is a very important factor when dealing with sensitive documents. reset windows 10 password
ReplyDeleteThis is such a great resource that you are providing and you give it away for free. blackmart apk just black screen _ APKForAll.Com
ReplyDeleteI have read all the comments and suggestions posted by the visitors for this article are very fine,We will wait for your next article so only.Thanks! apps
ReplyDeleteAs a seller of legal steroids, you can buy Crazy Bulk products, explore stacks and finally get the body you’ve always wanted yabo
ReplyDelete