New tables/views in Oracle 19c Database
New tables/views in Oracle 19c Database dba_auto_index_config dba_sql_quarantine V$SQL_TESTCASES DBA_REGISTRY_BACKPORTS
Read MoreNew initialization parameters in Oracle Database 19c
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 MoreOracle 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 MoreORA-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 MoreJNDI 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 MoreCould 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 MoreCreating 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 MoreSchema 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 MoreHOW 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 MoreMail 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