Modern Oracle DBA

 Adop Phase=fs_clone What is the fs_clone Phase? The fs_clone phase in Oracle EBS refers to the process of cloning the patch edition file system from the run edition.  It is used for file system cloning, and the usual cloning (adcfgclone.pl) script cannot be used to synchronize the run and patch file systems. Normally, fs_clone deletes the patch file system and restores the run system. When to Use  fs_clone Consider using the  fs_clone  phase in the following scenarios: After Aborting an Online Patching Cycle If a previous online patching cycle is aborted, the file system must be synchronized. If Technology Stack Patch is Applied in the Run Edition If any manual changes are made in the run file system, such as applying a technology stack patch, the file system must be synchronized. After Applying a RUP Patch Using  fs_clone  will synchronization between run and patch file and its help complete the prepare phase quickly. How to Execute fs_clone? adop Ph...

What is the ADOP Finalize Phase? After applying the patches in the patch edition, it will create lots of invalid objects. The finalize phase will compile the invalid objects, and it will prepare the environment for the cutover phase. The finalize phase is the optional phase in the patching cycle. After applying the patch, if we missed it, run Finalize and directorally run the cutover. The cutover phase will check if the if the finalize phase is completed or not. If not completed, the finalize phase cutover phase will start. Key Actions during the Finalize Phase Mode Selection : ADOP offers two modes for finalization - "quick" and "full": Quick Mode : This mode prioritizes speed by skipping non-essential tasks, making it ideal for scenarios where minimal downtime is critical. Full Mode : In contrast, full mode executes additional actions such as gathering statistics to the DML statment and enhance system performance after the patch is applied. This mode is beneficial...

adop phase=prepare Understanding ADOP Prepare Parameters Before diving into the prepare phase, let's go over the key parameters: skipsyncerror : This parameter specifies whether to ignore errors that may occur during incremental file system synchronization. Options :  yes  or  no  (default:  no ) Usage : Set to  yes  if you encountered errors in a previous patching cycle but decided to continue with the cutover. This will ignore apply errors during the next synchronization. sync_mode : This parameter determines the method used to synchronize the patch file system with the run file system. Options :  delta  or  patch  (default:  patch ) Usage : delta : Uses the file system synchronization command specified in  $AD_TOP/patch/115/etc/delta_sync_drv.txt . patch : Reapplies patches applied on the run file system. Example Command adop phase=prepare skipsyncerror= yes sync_mode=delta Understanding the “Online Patching In Progr...

Listener: Listener process running the database node that listen for incoming the connection on database. The name of the listener listener.ora file Listener file default location “$ORACLE_HOME/network/admin Listener process listen for more than one database. listener.ora file: The default settings for the listener.ora file contains the below parameters Listener name Port number Protocols SID name Host name Listener commands: lsnrctl start <listener_name> Starting the listener lsnrctl stop <listener_name> Stops the listener lsnrctl status <listener_name> Display the status information about the listener. lsnrctl reload We can use add/change without stopping the listener. lsnrctl help Display the list of all listener commands lsnrctl version Display the current listener version lsnrctl services Display the detailed information about services and instance registred and service h...

1) How to restore the datafile asm to non-asm? 2) What happened alter database begin backup mode? 3) Why need to enable maintenance mode in adpatch? 4)Why we are using appsutil directory in under database home? 5)What is TWO_TASK parameter? 6)What is difference in adop prepare phase and fs_clone? 7)What is US directory in $AD_TOP? 8)How to troubleshoot long running concurrent program and sql query? 9)How to apply pre-request patch when patch running? 10)Explain weblogic patching steps? 11)Explain RMAN block change tracking?   12) Different btw fnd_ststs & dbms_ststus? 13) Different btw apps &applsys user? 14) Different btw rman validate & crosscheck?  15) What is high watermark in db? 16) How many user will connect particular oacore ? 17) How to troubleshoot long running queries ? 18) What is check point ? 19) If reado log file delete how will recover? 20) Different btw AWR,ASH,ADDM reports ? 21) After clone application URL i...

Find the invalid objects: 1. Find the number of invalid objects Select count(*) from dba_objects where status=’INVALID’; 2. Find the object name /type Select owner,object_type,status from dba_objects where status ='INVALID'; How to compile invalid objects 1 Compile the invalid objects in apps schema: Application Side: Login the application services In application side use ADadmin utlity and give below options adadminà option3 Compile/Reload Applications Database Entities menuà1: Compile APPS schema Compile entire schema SQL> EXEC UTL_RECOMP.recomp_serial('APPS'); PL/SQL procedure successfully completed. SQL> 2 Database Side: Login Database server Goto $ORACLE_HOME/rdbms/admin and run utlrp.sql SQL> @utlrp.sql 3 Manual Method : Alter package <owner>,<package_name> compile; Alter package <owner>,<package_name> compile body; Alter view <owner>,<view_name> compile; Alter materialized ...

What is apps listener and why it used? Apps listener is combination of FNDFS&FNDSM it’s running all apps node with listener alias name. It’s mainly used for listening the request for services like FNDFS&FNDSM What is difference between Socket & Servlet Mode in Apps Forms? When forms run SOCKET Mode these are dedicated connection between Client Machine & Form Server (Started by adfrmctl.sh). When Forms run in servlet mode the forms requests are fulfilled by Jserv in Apache . There will be additional JVM for Forms Request in that case and you won't start form via adfrmctl.sh. What is batch size in adpatch? Batch size is how many table performed same time. If example I give batch size 1000 means 1000 tables will perform same time in patching activity . What is (.lgi) file ? Lgi files are created with patching along with patch log file (.log) it’s contain information related to patch Patch will create two tables what are the conten...