EBS File system Diagnostic Program
Effective troubleshooting of critical issues in the Oracle E-business Suite can be achieved through various means. We’d like to share information on recent issues in the Oracle E-business Suite that…
Read MoreDATABASE PATCHING
BEFORE WE HAVE CHECK THE OPATCH VERISON AND LAST UPDATE CHECK OPATCH VERSION [oracle@kaamesh OPatch]$ pwd /u01/app/oracle/product/19.0.0/dbhome_1/OPatch [oracle@kaamesh OPatch]$ [oracle@kaamesh OPatch]$ opatch version OPatch Version: 12.2.0.1.33 OPatch succeeded. CHECK LAST…
Read MoreCOLLECTING INFORMATION TO TROUBLESHOOT EBS WORKFLOW NOTIFICATION MAILER
COLLECTING INFORMATION TO TROUBLESHOOT EBS WORKFLOW NOTIFICATION MAILER ============================================================================= The following steps is to collect information for troubleshooting EBS WORKFLOW NOTIFICATION MAILER DO NOT use SYSADMIN to send a test…
Read MoreAUTOCONFIG ERROR’S OUT WITH “S_SHARED_FILE_SYSTEM” CONTEXT VARIABLE ISSUE
AUTOCONFIG ERROR’S OUT WITH “S_SHARED_FILE_SYSTEM” CONTEXT VARIABLE ISSUE. Error ===== [ERROR]: Either the value of context variable s_shared_file_system is not consistent across RUN file system and da tabase OR APPL_TOP…
Read MoreBACKUP BASED DATABASE CLONING
Before cloning we have to take full database backup using RMAN Target / COMMAND: RMAN> BACKUP DATABASE PLUS ARCHIVELOG; Once completed,move the backup file to target server USING SCP BACKUP…
Read MoreHow RECOVERY SPACE AREA will impact RMAN BACKUP
Introduction: This blog is intended for DBA’s who have issues in completing rman backup, we tried to take a rman full backup, but it failed with the below error message.…
Read MoreHow to overcome ORA-39126 in Oracle export pump?
Introduction: I get to work in export and import of particular schema, but ended up with some fatal error. While EXPDP the schema (EXPDP fails with ORA-39126 Worker unexpected fatal…
Read MoreMRP process getting terminated with error ORA-10567
This blog is intended for DBA’s who have issues in Oracle standby MRP (Managed Recovery Process) and MRP process stops with below ORA error. ” ORA-00600: internal error code, arguments:…
Read MoreHow to trace oracle database session
The purpose of this blog is to assist DBAs encountering performance issues in locating the problematic query by taking a trace of the session. The steps shared here will help…
Read MoreQuery to get CPU and Memory usage from OEM database
Please use the below query for a period. SELECT to_char(rollup_timestamp,’DD-MON-YY HH24′) “Date”, average “CPU Usage %” FROM sysman.MGMT\$METRIC_HOURLY WHERE target_name like ‘%servername%’ AND metric_name = ‘Load’ AND metric_column =…
Read More