Posts by Sakthi Sethuperumal S

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

ORA-15040: diskgroup is incomplete

Introduction Solution to fix ORA-15040: diskgroup is incomplete Posted by Karthick ASM is running but diskgroup is not mounted and its in incomplete state. [oracle@primary bin]$ps -ef|grep asm oracle    4222…

Read More

how to increase connection timeout in weblogic

Introduction Steps to increase connection timeout in weblogic Posted by Marimuthu Pandu We need to follow below steps to set this option : -Dsun.net.client.defaultConnectTimeout=5000) through Weblogic Admin Console. To set this…

Read More