Yearly Archives: 2021

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

Insert script with error log table

1. Overview This document will be helpful to insert data from intermediate table to source table  with error log table 2. Technologies and Tools Used Oracle Plsql code.   3. Use Case Load…

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 change the “Node Manager” Log Level in Oracle WebLogic Server – Version 10.3 and later

How to change the Node Manager Log Level? Log Level for the Node Manager can be set in the “NodeManager.properties” file usually located under “WL_HOME\common\nodemanager” folder. “NodeManager.properties” file contains a…

Read More

Caps Lock On/Off indicator in Oracle APEX.

Overview This document explains how to show Caps Lock On/off Indicator in Oracle Apex. Sometimes it is necessary to check whether caps lock is on or off. Capslock (on/off) indicator functionality is…

Read More

How to disable update for a particular column in Oracle APEX Interactive Grid

Overview This document explains how to disable update for a particular column in Interactive Grid using the Read Only property of a column. Technologies and Tools Used The following technologies…

Read More

Disable update for a particular column in Oracle APEX Interactive Grid

Overview This document explains how to disable update for a particular column in Interactive Grid using the Read Only property of a column. Technologies and Tools Used The following technologies…

Read More