ORACLE DBA

steps to Recover APPS password in R12.2.X If we forget/ lost the apps password for r12.2.X instance. please follow below steps to recover the APPS password Step A : Login to DB server sqlplus / as sysdba STEP B : we have to Create Function for to decrypt the encrypted password 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'; / Function created STEP C : Query for encrypted password SQL> select ENCRYPTED_FOUNDATION_PASSWORD from apps.fnd_user where USER_NAME='GUEST'; Output ENCRYPTED_FOUNDATION_PASSWORD -------------------------------------------------------------------------------- ZASDFSDDS98DFGDUIFGKJDFGKJDF45343J5K345464LJKDFG09RGURIGJFGLKFJH04JOK048YURJTOKGRG04ROIJRT0IOUYJ STEP D: Query for decrypt the password SELECT apps.decrypt_pin_func('GUEST/ORACLE...

EBS R12.2 Cloning Steps. My Database version 11.2.0.3     A. Preclone db tier and application Tier     B. Copy the apps Tier  and db home only to target server     C. Take Rman full backup and copy the backup to target server             cd [RDBMS ORACLE_HOME]/appsutil/clone/bin              $ perl adcfgclone.pl dbTechStack                         Run adcfgclone dbTechStack This files are to be restored to a different location: db_file_name_convert=('/oracle/PROD/db/data' , '/oracle/CLONE/db/data') log_file_name_convert=('/oracle/PROD/db/data' , '/oracle/CLONE/db/data') $ sqlplus '/as sysdba' SQL> startup nomount pfile='/<path>/initCLONE.ora'; This will nomount  the instance using the initCLONE.ora created. Prepare for duplicat...

👉 When this issue happens. 👉 When last it ran successfully. 👉 What exactly issue is. 👉 Any patching / upgrade happen in application side. 👉 Any data Volume change or Any change in job Index Creation (Part-1): Use the following guidelines for determining when to create an index: 👉 Create an index if you frequently want to retrieve less than 15% of the rows in a large table. 👉 Index columns used for joins to improve performance on joins of mulTric for Better Performancele tables. 👉 Primary and unique keys automatically have indexes,but you might want to create an index on a foreign key.   Index Creation (Part-2): 👉Small tables do not require indexes 👉If a qurey is taking too long, then the table might have grown from small to large. Some columns are storng candidates for indexing. Column with one or more of the following characteristics are candidates for indexing: 👉 Values are relatively unique in the column. 👉 There is a wide range of values (good for regular indexes) ?...

 Oracle E-Business Suite R12.2.X : Adop Online Patching Phases Explanation All patches starting from Release R12.2.X are online patches and is applied using AD online Patching utility (ADOP) Imporatnat Points: 1. If patch does not contains new updates to files or database to the objects in system then is does not take any action . 2. If is detects a previously failed session.it will attempts to recover previously failed session. 3. Adop patching is applied in same way  there is no change in RAC enabled Oracle E-Business Suite. ==> Online Patching is classified into five main phases and three additional phases. <== A) Prepare B) Apply C) Finalize D) Cutover E) Cleanup Additional phases:- F) abort G) fs_clone H) Actualize_all 1.. Online Patching Cycle – Prepare :- syntax:- adop phase=prepare 3 1.1 :- Prepares the environment for patching by synchronizing the patch edition and the run edition on the file system. 2.1.. Creates a new patch edition in the database. 3.1.. Check...