Way to analyze ADOP logs
DBA’s find ADOP is little is bit tricky when compare to adpatch. In this blog we are going to cover to best ways to scan adop logs. To debug Online…
Read MoreAfter 19c upgrade in EBS 12.1.3 running autoconfig errors on application tier
Autoconfig errors after 19c upgrade on application tier while read UTL_FILE_DIR parameters. Error Message: PROGRAM : (/d01/dev/appl/apps/fnd/12.0.0/patch/115/bin/txkCfgUtlfileDir.pl) TIME : FUNCTION: main::getUtlFileDirParam [ Level 1 ] ERRORMSG: Unable to read UTL_FILE_DIR…
Read MoreGetting ORA-600 error while running Generate Asset Trace program
When running the concurrent program ” Generate Asset Trace” report and the initial request for this fails, subsequent spawns of “FATRACE – SLA Sub request” continuously initiate and start to…
Read MoreScript to find total no of database startup in the year or month
Description : This script is used to find total number of database startup in the year or month. You can schedule the script in crontab for every month. Script :…
Read MoreScript to find total number of database shutdown within the year or month
Description: This Shell script is very useful to calculate and review total no of database shutdown in the year or month. We can schedule the script to crontab for every…
Read MoreHow to Identify If a Disk/Partition Is Still Used by ASM
How to Identify If a Disk/Partition Is Still Used by ASM Introduction: To find whether an ASM disk is still used by ASM, or has Been used by ASM or…
Read MoreOracle Clusterware (CRS/GI) – ASM – Database Version Compatibility
Oracle Clusterware (CRS/GI) – ASM – Database Version Compatibility Introduction: You can have different release combinations of Oracle Clusterware, ASM and database software running on your cluster. However all cluster…
Read MoreWhat is ocssd.bin, how To Stop-Start This Process To Apply A Patch in non-RAC
What is ocssd.bin ? How To Stop/Start This Process To Apply A Patch in non-RAC Introduction: You have installed Oracle Database 10g Products into the Oracle Home. Now you’re trying…
Read MoreTroubleshooting ASMLIB on Linux
Troubleshooting ASMLIB on Linux ASMLIB Disk Discovery troubleshooting checklist ———————————————— In Oracle10g, storage management and provisioning for Oracle databases is more simplified with a new feature called Automatic…
Read MoreASM is Unable to Detect ASMLIB Disks-Devices
ASM is Unable to Detect ASMLIB Disks/Devices Introduction: We can detect ASMLIB devices/disks thru the ASM instance using the below steps. How to detect ASM devices/disks: 1) First of…
Read More