Tech Lover

ADOP – Applications DBA Online Patching Tool  Oracle introduced ADOP in Oracle E-Business R12.2 . This is a new patching mechanism (online patching) that allow the application of patches while your environment is up and running.You don't need to stop the application or put it on maintains mode as we use to do before.  ADOP phases: 1) Prepare  – This will prepare the instance for patch application. 2) Apply  – This will apply patches . 3) Finalize  – This will get ready the instance for cutover. 4) Cutover  – This will make the patch edition the new run edition (fs1 to fs2). 5) Cleanup  – This will drop obsolete objects and data from old editions. Steps to apply patch on R12.2 using ADOP: 1)  Download and unzip the patch 2)  Read the readme carefully 3)  run the environment as below in new cmd prompt. $ source <run APPL_TOP path>/APPS<CONTEXT_NAME>.env 4)  confirm the staus of adop by below command. $ adop -status 5) ...

 ORA-04030: out of process memory when trying to allocate  bytes (,) In logs, We you see below error >Instance terminated by CKPT, pid = 6172 with below errors in alert log . Other errors are found in log files are also listed below 1)  ORA-04030: out of process memory when trying to allocate 4096 bytes (PLS non-lib hp,pdzdM80_Allocate_Block) 2)  ORA-04030: out of process memory when trying to allocate 8148 bytes (kxs-heap-w,qesaQBInit:buffer) 3)  ORA-04030: out of process memory when trying to allocate 16408 bytes (session heap,kxsFrame16kPage) 4)  ORA-27300: OS system dependent operation:CreateThread failed with status: 8 5)  ORA-27301: OS failure message: Not enough storage is available to process this command. 6)  ORA-04030: out of process memory when trying to allocate  bytes (,) Cause :- This may occurs if system is not having the enough memory to handle new jobs. In our case, system lacked the necessary resources to create another p...