Database Blog

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

CRS-2632: There are no more servers to try to place resource ‘ora.racdb.db’ on that would satisfy its placement policy

Introduction Solution to fix when there are no more servers to try to place resource ‘ora.racdb.db’ Posted by Sunilkumar ERROR: PRCR-1079 : Failed to start resource ora.racdb.db CRS-5017: The resource…

Read More