Upgrade Database from Oracle 11gR2 to Oracle 19c

Here I would be discussing how to upgrade Oracle 11gR2 (11.2.0.4) database to Oracle 19c (19.2.0.0.0) on the same server. This upgrade process was done on Oracle Linux 7.6 (x86_64). I used DBUA (Database Upgrade Assistant) to perform this upgrade. DBUA is also a recommended way to perform the upgrade as it would automate almost everything for you. You should be able to […]

Read More

Refreshing Materialized Views (mv_refresh)

To upgrade from Oracle 11gR2 to Oracle 18c/19c, we need to refresh materialized views. Oracle recommends that all materialized views (MV’s) are refreshed before upgrading the database because this will clear the MV logs and the sumdelta$ table, and make the UPGRADE process faster. SQL> declare num_failures integer(3) :=0; begin DBMS_MVIEW.REFRESH_ALL_MVIEWS(num_failures,’C’,”, TRUE, FALSE); end; / PL/SQL procedure successfully […]

Read More

Creating the Database 19c on- premise

After installing Oracle 19c home, now we are going to create to database on-premise. Run the DBCA after setting the Oracle Home. [oracle@oracle19c ~]$ export ORACLE_HOME=/u01/app/oracle/product/19.0.0/dbhome_1 [oracle@oracle19c ~]$ export PATH=$ORACLE_HOME/bin:$PATH [oracle@oracle19c ~]$ dbca Select Database type as Oracle Single Instance database. Provide the database name as SID. Use the default template. Check the enable archiving […]

Read More

Installing Oracle 19c Binary on OEL 7.6

In this post, we are installing Oracle 19c binaries on OEL 7.6. First, we need to download the software then unzip it on oracle home and start runInstaller from the software location. [root@oracle19c ~]# mkdir -p /u01/app/oracle/product/19.0.0/dbhome_1 [root@oracle19c ~]# chown -R oracle:oinstall /u01 [root@oracle19c ~]# chmod -R 775 /u01 [oracle@oracle19c ~]# ./runinstaller & Select a […]

Read More

Oracle Exadata Database Machine 19.1.0 Documentation

Exadata System Software Release 19.1.0.0.0 is now generally available. This release lays the foundation for the Autonomous Database and improves every aspect of Exadata with 20+ features and enhancements. All new features and enhancements are available on all supported Exadata generations, protecting customer investment across all Exadata deployment models: on-premises, Cloud Service, and Cloud @ […]

Read More

Oracle Database 19c Now Available

The latest generation of the world’s #1 database, Oracle Database 19c, is now available on LiveSQL.oracle.com. Oracle Database 19c is a long term support release, with premier support planned through March 2023 and extended support through March 2026. For the latest Oracle Database 19c availability on other platforms, check out Document ID 742060.1 on My Oracle Support […]

Read More

RestAPI for Oracle DBaaS Cookbook

Written by Oracle Certified Master Skant Gupta and Oracle Certified Professional HariPrasath Rajaram are diligently planned to direct the readers about the usage of RestAPI with DBaaS. This book covers the most important trends providing operational best practice knowledge required for executing different API methods and calls facilitating the administration and execution of DBaaS features with Rest. […]

Read More

Oracle Database 18c New Features Book

Written by Oracle Certified Master Skant Gupta and Oracle Certified Master & Oracle ACED Joel Pérez describes the myriad new and enhanced capabilities available in the latest Oracle Database release. This book is meticulously planned for the audience keen to learn all about the amazing new features being offered by Oracle Database 18c. You must […]

Read More

ORA-00600 [qosdExpStatRead: expcnt mismatch]

Recently started seeing this error on few of the Exadata environments. ORA–00600: internal error code, arguments:[qosdExpStatRead: expcnt mismatch] Cause  This is due to sys.exp_obj$. EXP_CNT mismatch rows of sys.exp_stat$ Following SQL is used to check issue data of some objects. if there are some rows return, that means data issue. With b as ( select count(*) cnt,objn,snapshot_id from sys.exp_stat$ […]

Read More