To obtain the current patchset levels for each specific E-Business Suite functional product test the following steps: 1. Log into OAM. (Responsibility System Administrator,”Oracle Applications Manager”, menu “OAM Support Cart”)…
Read MoreTo find retention guarantee for undo tablespace select tablespace_name,status,contents,retention from dba_tablespaces where tablespace_name like ‘%UNDO%’; To find Undo Space Availability select a.tablespace_name, SIZEMB, USAGEMB, (SIZEMB – USAGEMB) FREEMB from (select…
Read MoreLocking and Disabling User Accounts in Linux 1. Locking the user account To lock a user account use the command usermod -L or passwd -l. Both the commands adds…
Read MoreWe can use ssh to connect between servers, but many times it is required to setup a password less connectivity between the servers. We can follow below steps to…
Read MoreRMAN Issues and Solutions – (ORA-00020) and (ORA-00245) Error-1: RMAN failed to connect target database with ORA-00020: maximum number of processes (150) exceeded Solution: Here, we can see…
Read MoreError in `FNDLIBR’: double free or corruption (out) In some concurrent programs, I was seeing the error as FNDLIBR corrupted. Other programs were working fine. This was observed in EBS…
Read MorePROBLEM: 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 MoreIf 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 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 Morefs_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