New initialization parameters in Oracle Database 19c “_optimizer_gather_stats_on_conventional_dml” and “_optimizer_use_stats_on_conventional_dml” which are true by default _optimizer_stats_on_conventional_dml_sample_rate (at 100%) DATA_GUARD_MAX_IO_TIME DATA_GUARD_MAX_LONGIO_TIME ADG_REDIRECT_DML (TRUE or FALSE) MAX_DATAPUMP_JOBS_PER_PDB aws_pdb_autoflush_enabled (TRUE or FALSE)
Read MoreIntroduction: 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 MoreIssue : 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 MoreIssue : 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 MoreIssue : 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 MoreCreating 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 MoreWhile 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 MoreStep1: 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 MoreFor 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 MoreGrants 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