Readmeout Oracle DBA Blog Specifically Focusing on database administration, RMAN Backup and recovery, restore, cloning, performance tuning and sharing best practices.
AutoPatch error the worker should not have status Running or Restarted | ADOP Patch Session got terminated abnormally due to network issue or patch hung or lost connectivity after that we are facing the error when restart adop patch. AutoPatch error the worker should not have status Running or Restarted at this point. Error: … Read more
Drop XLA_GLT temporary Tables| As an Oracle DBA we need to reclaim space in database. For this we need to clear all temporary tables in our instance, which is no longer required. Temporary tables used in the GL Transfer process are no longer cleared down once the transfer is complete. using program ‘Purge Temporary Journal … Read more
adoacorectl.sh adformsctl.sh adoafmctl.sh exiting with status 150| Sometimes application services not brought down gracefully and don’t delete the .lock file. Later we bring up the application then these .lock file causing an issue for OC4J instance. How to fix adoacorectl.sh adformsctl.sh adoafmctl.sh exiting with status 150? To fix this error adoacorectl.sh exiting with status … Read more
Here we going to discuss ‘How to register custom top in oracle apps r12‘. Rename izuprod.txt to <CUSTOM MODULE>prod.txt. In this example, we will use “xxcustomzprod.txt”. How to register custom top in oracle apps r12. We will follow below steps to register/create custom top in r12.2. Step 1: – Creating Custom TOP/Application using AD Splice … Read more
ALECDC Program was terminated by signal 11 for all oracle alerts. | Due to this issue all oracle alerts terminated with signal 11. Signal 11 is a generic error, the likely cause of this issue is lack of OS resources. How to fix ALECDC Program was terminated by signal 11 We are also showing error … Read more
Mount Windows share filesystem on linux using CISF|Common Internet File System(CISF) is file sharing network protocol mainly used to provide shared access to files, printers, serial ports, and miscellaneous communications between nodes on a network. You can easily access CIFS share from Linux and mount them as a regular filesystem. Examples:- #mount … Read more
Manually Compile pll fmb | Sometimes we need to Manually Compile .pll .fmb .rdf file, if we are facing issue with forms, reports and libraries etc. using frmcmp_batch module=XXXX.fmb userid=apps, we can compile fmb. Steps to Manually Compile pll fmb .In R12 Compiling .pll (library):- Manually Compile .pll .fmb cd $AU_TOP/resourcefrmcmp_batch module=JAAUUCOM.pll userid=apps/***** output_file=JAAUUCOM.plx module_type=library batch=yes … Read more
Fixed REP-0756 Warning Unable to find PL SQL library ‘inv’ in oracle apps R12 | Discrete Job Shortage Report Completes with Error (REP-0252, REP-0756, REP-0736, REP-1247, REP-0069, REP-57054, REP-1247) in oracle apps R12. How to fix REP-0756 Warning Unable to find PL SQL library. ERROR———————–REP-0756: Warning: Unable to find PL/SQL library ‘inv’.REP-0736: There exist uncompiled program … Read more
ORA-00257 archiver error Connect internal only until freed | The archiver process received an error while trying to archive the redo logfile. Due to this issue oracle database will stop executing the transaction. So, we have to check the archive destination because most likely cause of this error is the destination device is out of … Read more
Facing error GST Form JAINNSTL.fmb is having error during applying GST July RUP 11 patches in R12.2.xx. Fixing GST Form JAINNSTL.fmb is having error. Issue:- —————— Form JAINNSTL.fmb is having error during compilation. As per Oracle support Development team form JAINNSTL.fmb is obsoleted and this error is due to … Read more