How to configure patch file system in R12.2
To re-create or configure the patch file system in ebs. Follow the below step’s to configure the patch file system in R12.2. 1. Run adpreclone.pl on run file system Source…
Read MoreFind Database Query From the Linux PID
Find Database Query From the Linux PID PID=32370 select t.sql_id,t.sql_text from gv$process p , gv$session s , gv$sqlarea t where p.addr=s.paddr and s.sql_address=t.address and s.sql_hash_value=t.hash_value and p.spid = 32370;
Read MoreCalculate Actual Size of All Tables in a Schema in Oracle
SELECT owner, table_name, TRUNC(sum(bytes)/1024/1024) MB FROM (SELECT segment_name table_name, owner, bytes FROM dba_segments WHERE segment_type in (‘TABLE’,’TABLE SUBPARTITION’,’TABLE PARTITION’) UNION ALL SELECT i.table_name, i.owner, s.bytes FROM dba_indexes i, dba_segments s…
Read MoreADOP Cutover failed while running txkADOPCutOverPhaseCtrlScript.pl
Issue: During an adop online patching cycle, cutover phase failed while running the script txkADOPCutOverPhaseCtrlScript.pl [PROCEDURE] Starting Middle Tier Services [UNEXPECTED]Error occurred running “perl /u01/app/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPCutOverPhaseCtrlScript.pl -contextfile=/u01/app/fs1/inst/apps/EBSTEST_testebsmt111/appl/admin/EBSTEST_testebsmt111.xml -patchcontextfile=/u01/app/fs1/2/inst/apps/EBSTEST_testebsmt111/appl/admin/EBSTEST_testebsmt111.xml -promptmsg=hide -console=off -sessionid=14…
Read MoreAdop Cutover Failed while starting Admin Server on Run File System
You can see the following error in an adop log file. [UNEXPECTED]Error occurred running “sh $INST_TOP/apps/TEST_tst/admin/scripts/adadminsrvctl.sh start -nopromptmsg -silent forcepatchfs” [UNEXPECTED]Error running adadminsrvctl command [UNEXPECTED]Error occurred starting Admin Server [UNEXPECTED]Cutover…
Read MorePRCT-1011 : Failed to run “osdbagrp”. Detailed error
Trying to register the database manually, it fails with: $ srvctl add database -d <dbname> -o <ORACLE_HOME> PRCR-1006 : Failed to add resource ora.<dbname>.db for uat PRCT-1011 : Failed to…
Read MoretxkADOPValidations.error while Running fs_clone
Fs_clone fails with the following error: Validating configuration on node: [tst-ebs021]. Log: /u01/app/ebstst/fs_ne/EBSapps/log/adop/129/20210205_003039/fs_clone/validate/tst-ebs021 [UNEXPECTED]Error occurred running “perl /u01/app/ebstst/fs2/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPValidations.pl -contextfile=/u01/app/ebstst/fs2/inst/apps/TEST_tst-ebs021/appl/admin/TEST_tst-ebs021.xml -patchctxfile=/u01/app/ebstst/fs1/inst/apps/TEST_tst-ebs021/appl/admin/TEST_tst-ebs021.xml -phase=fs_clone -logloc=/u01/app/ebstst/fs_ne/EBSapps/log/adop/129/20210205_003039/fs_clone/validate/tst-ebs021 -promptmsg=hide” [UNEXPECTED]Error 1 occurred while Executing txkADOPValidation script…
Read MoreMRP process stopped with ORA-01111,ORA-01110,ORA-01157 error
PROBLEM: After adding a datafile in primary database, recovery process in standby stopped with below error. — Error in alert log of standby database Fri Jan 15 09:56:46 2021 Errors…
Read MoreHow to Restart a Crashed ADOP session
If an adop session is running and system crashes then it fails to update the status in the internal repository If we try to run it adop again it will…
Read MorePrepare phase failed due to GET_ACTIVE_CP_REQ_ID(c_req_id) error
Prepare phase failed due to GET_ACTIVE_CP_REQ_ID(c_req_id) error While running adop=prepare phase recieved error LOG FILE ———————– Filename =adop_20200822_140410.log See the following error: [EVENT] Submitting ADZDPATCH concurrent program. [PROCEDURE] [START 2020/08/22…
Read More