Database Blog

Oracle Database Diagnostic and Tuning Pack Usage

Introduction: Oracle database always comes up with additional licensing for extra features and most prominent feature is Diagnostics and Tuning pack. These packs are controlled by database parameters and some…

Read More

ORA-17506: I/O Error Simulation when backup controlfile

Issue : ORA-17506: I/O Error Simulation when backup of  a controlfile Observation : When trying to backup a controlfile it throws the below error ERROR ———————– SQL> alter database backup…

Read More

JNDI Creation Failed For EBS Database

Issue : JNDI Creation Failed For EBS Database Observation : When attempting to create JNDI as per step 4 the following error occurs. The edit lock associated with this edit…

Read More

Could not authenticate to Oracle Database Cloud Backup Module

Issue : Could not authenticate to Oracle Database Cloud Backup Module Observation : Oracle Database Cloud Backup Module Install Tool, build 2016-10-07 java.net.ConnectException: Connection refused at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339)…

Read More

Creating Physical Standby using RMAN Backup

Creating Physical Standby using RMAN Backup: A physical standby database is an exact, block-for-block copy of a primary database. A physical standby is maintained as an exact copy through a process…

Read More

Schema validation errors while parsing /Weblogic/Admin/config/config.xml

While starting weblogic aAdmin server getting error as below Schema validation errors while parsing /Weblogic/Oracle/Admin/config/config.xml – Expected elements ‘administration-protocol@http://xmlns.oracle.com/weblogic/domain wldf-system-resource   Solution: set JAVA_OPTIONS=%JAVA_OPTIONS% -Dweblogic.configuration.schemaValidationEnabled=false

Read More

HOW TO RESOLVE ORA-04031: UNABLE TO ALLOCATE 11513896 BYTES OF SHARED MEMORY (“LARGE POOL”,”LARGE POOL”,”CTWR DBA BUFFER”)

Step1: We want to ensure the block change tracking is enabled in our database or not by using the below sql statement. i.e, SQL> select filename,status from v$block_change_tracking; FILENAME ——————————————————————————–…

Read More

Mail server configuration in 12c Reports

For the mail server configuration in 12c reports, need to the update the rwserver.conf files with mail server credentials. cd $DOMAIN_HOME/config/fmwconfig/components/ReportsServerComponent/repserv1 Edit the rwserver.conf and update the below, From :…

Read More

Grants Are Not Replicating In Golden Gate

Grants Are Not Replicating In Golden Gate SYMPTOMS Grants are not being replicated from source to target when using Integrated extract CAUSE Bug 30120608 : Capture skipping included grant after…

Read More

How to apply SSL/HTTPS vendor certificate for apex application deployed on apache tomcat

Description: This article shows how to enable HTTPS for Tomcat. It uses a Third party vendor certificate for wildcard SSL and It should be format of certificate  .jks or .pem.…

Read More