Readmeout Oracle DBA Blog Specifically Focusing on database administration, RMAN Backup and recovery, restore, cloning, performance tuning and sharing best practices.
How do you switch and create spfile from pfile| In this article we will discuss ‘how to create pfile from spfile’. Spfile is a binary file. By default, a new Oracle database will be working on a pfile, so the spfile must be created from the pfile using SQL command. URL:- https://youtu.be/G5eE79poQzU How do you … Read more
Below is useful configuration files and directories in Linux. Every DBA must be aware for daily operation. File Name Description /etc/passwd /etc/passwd file is used to keep track of every registered user that has access to a system. File that contains the following information: Username. Encrypted password. User ID number (UID) /etc/hosts hosts … Read more
Difference between hot backup and cold backup | I n Oracle database we are doing either hot (inconsistent) or cold (consistent) backup. Suppose we have requirement to do the backup in working hours. In this situation we have to plan hot backup. For cold or consistent backup, we have to plan it in night because … Read more
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