Database Blog

Import fails with ORA-39126,ORA-06512,ORA-01403

WE ARE GOING TO SEE THE IMPORT FAILURE with ORA-39126,ORA-06512,ORA-01403 . Cause: The issue happen when we migrate using export from 11gR2 windows and import it in 12cR2 Linux server.…

Read More

Useful Information Regarding Oracle Cloud Marketplace

Introduction Information about Oracle Cloud Marketplace Posted by Narasimha Rao.K Some of you might be aware of the Oracle Cloud Market place. But there are certain useful Applications services available for…

Read More

How to deploy Oracle EBS Cloud Manager from Market Place?

Introduction Steps to deploy oracle EBS cloud manager from market place. Posted by Narasimha Rao.K The Main agenda for this post is to demonstrate basic steps to deploy Oracle EBS Cloud…

Read More

WF Mailer Not able to start with the following error : FRAMEWORK_USER=Unable to make a connection with the user and responsibility

Introduction Solution to fix if the WF Mailer Not able to start with the  error : FRAMEWORK_USER=Unable to make a connection with the user and responsibility Posted by Saravanan Scenario: I…

Read More

Shareplex Installation for Oracle Replication

Introduction: Steps to install shareplux for oracle replication Posted by Hemanth Sathavalli Installation on Source Server : oracle@src_01:~ $ . ./SOURCEDB_12c.env oracle@src_01:/u03/db $ ls -lrt -rwxr-xr-x 1 oracle oinstall 151278802 Sep…

Read More

Shareplex Setup/Configuration for Oracle Replication

Introduction Steps to configure Shareplex for Oracle Replication. Posted by Hemanth Sathavalli Prerequisites for Shareplex Setup on Oracle database : Create tablespace splex with 2GB space with autoextend-on in both source &…

Read More

Recreation / Rebuild of Reporting database (for the EBS customers using Shareplex replication)

Introduction Steps for Recreation / Rebuild of Reporting database Posted by Hemanth Sathavalli If you have Reporting database configured for your UAT or Pre-Prod instance , you may have to recreate/re-configure…

Read More

OPatch Conflict Checker

Introduction: This is to check if there is a conflict in the patches with the existing patches in our database. Posted by Hemanth Sathavalli When applying OPatches to our Oracle database,…

Read More

DBA Tip : RMAN restore when backup file are spread across 2 different mount points

Introduction This is to perform rman restore of backup files when the backup files are in two different mount points Posted by Hemanth Sathavalli Customers whose databases are of huge size…

Read More

ORA-38824: A CREATE OR REPLACE command may not change the EDITIONABLE property during Apex install in 12.2

Introduction Solution to fix ORA-38824: A CREATE OR REPLACE command may not change the EDITIONABLE property during Apex install in 12.2 Posted by Sathiyaseelan Issue: Fresh apex install failed with the…

Read More