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…
Read MoreAs root user in Target Node: Step 1 : /usr/local/avamar/bin/avtar –backups –flagfile=/var/avamar/scripts/my-avtar-flags.txt Make a note of recent Seq in our case it is 124980 . Step 2 : /usr/local/avamar/bin/avtar –list –sequencenumber=124980 –flagfile=/var/avamar/scripts/my-avtar-flags.txt Get the control file name using above command. In our case “11g/PROD/CONTROLFILE.PROD.c-193295451-20170128-00” As Oracle user in Target Node: Step 3 : Step 4 : Create a pfile with db_name=PROD. Step 5 : Start the database in nomount. SQL> startup nomount pfile=’initPROD.ora’; Step 6 : Connect Rman and execute below command RMAN > set DBID=193295451; run{ allocate channel c0 type sbt PARMS=”SBT_LIBRARY=/usr/local/avamar/lib/libobk_avamar64.so” format ‘%d_%U’; send ‘”–prefix=11g/PROD/” “–flagfile=/var/avamar/scripts/my-avtar-flags.txt” “–bindir=/usr/local/avamar/bin” “–sysdir=/usr/local/avamar/etc”‘; restore controlfile from ‘CONTROLFILE.PROD.c-193295451-20170128-00’; } #### Control file taken from step 2. Step 7 : SQL> alter database mount; Step 8: RMAN> list backup; Take recent LOW SCN number. 181267677438…
Read MoreHow to activate Periodic Alert Scheduler in Oracle EBS Application Step 1:Login to ORACLE EBS Application HOME PAGE with Alert Manager Responsibility We need to Login the Oracle EBS Application…
Read MoreERROR: FORM session is not opening after the clone SOLUTION: Go to FORMS node if it is multi node. cd $ORACLE_HOME/lib32 ls -lrt ldflags unlink ldflags ln -s /devweb/oracle/TEST/apps/tech_st/10.1.2/lib32/ldflags ldflags…
Read MoreERROR: RC-50204: Error: – Web Listener Port in use: Port Value = 8009 CAUSE: When cloning we have faced this error. This is due to some other process is using…
Read MoreMonitoring Progress of a SQL Execution Plan / sql query is really hanged or not How to check the progress of a query is making from within the execution plan…
Read MoreError: Re-link fails on target “client_sharedlib”. Re-link fails on target “client_sharedlib”. Re-link fails on target “ldapmoddn”. Re-link fails on target “ldapmodifymt”. Re-link fails on target “ldapaddmt”. Re-link fails on target…
Read MoreERROR: ORA-19909: datafile 1 belongs to an orphan incarnation When I tried to Flashback on in standby database then suddenly below message found in alert log and standby database not…
Read MoreProblem Scheduled Request Goes Inactive/On Hold Status Automatically by Concurrent Manager User Cause: It is an oracle bug Solution 1.Apply the Patch -22549247 2.It will give you a newer file…
Read MoreFollow the below steps to resolve program stuck in OPP issues, 1.You will need to check and fix the Invalid FND Objects : select owner, object_name,object_type,status from dba_objects where status =’INVALID’ and object_name like ‘FND%’; 2.AQ$_FND_CP_GSM_OPP_AQTBL tables has a lot of rows and purge is needed select count(*) from applsys.FND_CP_GSM_OPP_AQTBL ; select count(*) from APPLSYS.AQ$_FND_CP_GSM_OPP_AQTBL_T; select count(*) from APPLSYS.AQ$_FND_CP_GSM_OPP_AQTBL_G; select count(*) from APPLSYS.AQ$_FND_CP_GSM_OPP_AQTBL_H; select count(*) from APPLSYS.AQ$_FND_CP_GSM_OPP_AQTBL_I;…
Read More