Oracle Database 18c new features
Oracle Database 18c new features Versions 18.1.0 18.2.0 18.3.0 General Features in 18C we can configure ORACLE_HOME in read-only mode. we can CANCEL any database session SQL query (instead…
Read MoreData Guard New Features in Oracle 18c and 19c
Data Guard New Features in Oracle 18c and 19c Data Guard Oracle Data Guard ensures high availability disaster recovery and data protection for enterprise data Data Guard maintains these standby…
Read MoreNew Features in Oracle Database 19c
General Multimodel partitioning with Hybrid partitioning allowing some partitions in the database and some as external partitions even in hdfs New ALTER SYSTEM statement clause FLUSH PASSWORDFILE_METADATA_CACHE Clear flashback logs…
Read MoreData Guard Physical Standby Setup Using the Data Guard Broker in Oracle Database 18c
Data Guard Physical Standby Setup Using the Data Guard Broker in Oracle Database 18c Data Guard is the name for Oracle’s standby database solution, used for disaster recovery and high…
Read MoreDBMS_JOB Jobs Converted to DBMS_SCHEDULER Jobs in Oracle Database 19c
DBMS_JOB Jobs Converted to DBMS_SCHEDULER Jobs in Oracle Database 19c The DBMS_JOB package has been deprecated since 12cR2. Oracle 19c takes the demise of the DBMS_JOB package a step further by converting any DBMS_JOB jobs to DBMS_SCHEDULER jobs.…
Read MoreORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-20001: Statistics Advisor: Invalid task name for the current user During the 12c database creation process , you can see ORA-20001 error in the alert log file when the “SYS.ORA…
Read MoreORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired The error is raised when the following statement is executed against the Oracle Database. SQL> truncate table WRI$_OPTSTAT_HISTHEAD_HISTORY; truncate…
Read MoreORA-16826: apply service state is inconsistent with the DelayMins property
ORA-16826: apply service state is inconsistent with the DelayMins property Workaround: Check DG configuration: DGMGRL> show configuration Configuration – new_DG_CONFIG Protection Mode: MaxPerformance Databases: new – Primary database newia –…
Read MoreTo find the user process_id from EBS Front End R12
Navigate to System Administrator–> Security –> User –> Monitor Note the User Name and Oracle Process ID Now run this sql as &PID=Oracle Process ID &USER_NAME=User Name SELECT SUBSTR(d.user_name,1,30) “User…
Read MoreUPGRADE ORACLE APEX FROM 5.0.X TO 18.1
Current Setup : Apex Version : Oracle Apex 5.0 Webserver : ORDS Running on Apache Tomcat 9 DB Version : Oracle 12.2 • Step 1: Download Apex 18.1 from Oracle…
Read More