Database Blog

Changing EBS user password failed with error “APP-FND-01564: ORACLE error 3113”

Changing EBS user password failed with error “APP-FND-01564: ORACLE error 3113” Introduction: Recently while changing password for application user in Oracle EBS version 12.2.6 I faced below issue. Tried multiple…

Read More

Lesser Known yet effective software for DBA’s

Introduction: There are numerous tools on the market that can boost productivity and make our jobs easier. Screen is a full-screen window manager that multiplexes a physical terminal between several…

Read More

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 More

DATABASE 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 More

COLLECTING 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 More

AUTOCONFIG 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 More

BACKUP 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 More

How 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 More

How 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 More

MRP 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 More