Saturday 20 July 2013

How to find apps password in oracle apps r12 (or) retrive apps password in r12?




[oratest@ctssd ~]$ sqlplus "/as sysdba"

SQL*Plus: Release 11.2.0.3.0 Production on Sat Jul 20 10:35:09 2013

Copyright (c) 1982, 2011, Oracle. All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SQL> show user
USER is "SYS"


SQL> 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'; 2 3 4
5 /

Function created.

SQL> SELECT ENCRYPTED_FOUNDATION_PASSWORD from APPS.fnd_user where USER_NAME='GUEST';

ENCRYPTED_FOUNDATION_PASSWORD
--------------------------------------------------------------------------------
ZG2555C11618FBE5085594E7F69F0901785384BA78D95F98F252E44B9D043D0CD95DB2285AAA9B6A5A9F973D0B23859E0442


SQL> select apps.decrypt_pin_func('GUEST/ORACLE','ZG2555C11618FBE5085594E7F69F0901785384BA78D95F98F252E44B9D043D0CD95DB2285AAA9B6A5A9F973D0B23859E0442') from dual;

APPS.DECRYPT_PIN_FUNC2('GUEST/ORACLE','ZG2555C11618FBE5085594E7F69F0901785384BA7
--------------------------------------------------------------------------------
bo11yw00d

SQL> show user
USER is "SYS"
SQL> conn apps/bo11yw00d
Connected.
SQL> select name from v$database;

NAME
---------
ebstest

SQL>

Happy learning!!!!!!!

No comments:

Post a Comment