Posts by Rahmathullah Ilyas

fs_clone failed while running txkADOPPreparePhaseSynchronize.pl

fs_clone failed :[UNEXPECTED]Error occurred running”perl/oradata/applmgr/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl When attempting to run FSclone, the following error occurs. Error can be seen in adop_<TIME_STAMP>.log:   [UNEXPECTED]Error occurred running “perl <DIR>/<SID>/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl -contextfile=<DIR>/<SID>/fs1/inst/apps/<CONTEXT_NAME>/appl/admin/<CONTEXT_NAME>.xml -patchcontextfile=<DIR>/<SID>/fs2/inst/apps/<CONTEXT_NAME>/appl/admin/<CONTEXT_NAME>.xml -promptmsg=hide -console=off…

Read More

How to reorganize table using alter table method

We have to check the below details before reorganize the table TABLE DETAILS   SELECT OWNER, SEGMENT_NAME, SEGMENT_TYPE, TABLESPACE_NAME, BYTES/1024/1024/1024 FROM DBA_SEGMENTS WHERE SEGMENT_NAME IN (‘WF_ITEM_ACTIVITY_STATUSES_H’);   OWNER     …

Read More

Prepare phase failed:[ERROR]: The value of s_patch_service_name is not set correctly in atleast one of the context files.

Update Database Tier to Latest Code   Call env from APPS NOde   Execute the admkappsutil.pl utility to create the appsutil.zip file in <INST_TOP>/admin/out.   $ perl <AD_TOP>/bin/admkappsutil.pl   mv…

Read More

How to apply Middleware 11.1.1.9 webtier patches in 12.2

adop patch process cycle steps: 1) Run FSCLONE 2) PREPARE 3) APPLY 4) FINALIZE 5) CUTOVER 6) CLEANUP Before start to apply the patches we have to run fsclone to…

Read More

How to monitor adop patching cycle from backend

As a new feature of EBS 12.2.5 , we have adopmon(adop monitor, Online Patching Monitoring utility) utility for monitoring the online patching cycles. It provides a readable output, letting us…

Read More

Prepare phase failed With Error “ETCC Not Run In The Database Node”

We might some time get into below issue after clone or after installing AD and TXK patches.     Error:   ETCC not run in the database node [Node Name]…

Read More

Script To Find the Versions of all the Oracle E Business Suite R12.2 technology stack components utility

On Application Tier:   Source the Applications environment file as the owner of the application tier file system and run:     $ADPERLPRG $FND_TOP/patch/115/bin/TXKScript.pl \  -script=$FND_TOP/patch/115/bin/txkInventory.pl \  -txktop=$APPLTMP \  -contextfile=$CONTEXT_FILE…

Read More

Find Concurrent Manager status from Backend

select decode(CONCURRENT_QUEUE_NAME, ‘FNDICM’,’Internal Manager’, ‘FNDCRM’,’Conflict Resolution Manager’, ‘AMSDMIN’,’Marketing Data Mining Manager’, ‘C_AQCT_SVC’,’C AQCART Service’, ‘FFTM’,’FastFormula Transaction Manager’, ‘FNDCPOPP’,’Output Post Processor’, ‘FNDSCH’,’Scheduler/Prereleaser Manager’, ‘FNDSM_AQHERP’,’Service Manager: AQHERP’, ‘FTE_TXN_MANAGER’,’Transportation Manager’, ‘IEU_SH_CS’,’Session History Cleanup’,…

Read More

To check scheduled concurrent request in R12

SELECT cr.request_id, DECODE (cp.user_concurrent_program_name, ‘Report Set’, ‘Report Set:’ || cr.description, cp.user_concurrent_program_name ) NAME, argument_text, cr.resubmit_interval, NVL2 (cr.resubmit_interval, ‘PERIODICALLY’, NVL2 (cr.release_class_id, ‘ON SPECIFIC DAYS’, ‘ONCE’) ) schedule_type, DECODE (NVL2 (cr.resubmit_interval, ‘PERIODICALLY’,…

Read More

ADOP – Applications DBA Online Patching Tool

ADOP: Oracle E-Business R12.2 introduced new patching mechanism that allow the application of patches while your environment is up and running which is called as Online patch. The online patching cycle…

Read More