In this post, we are going to create ADWC database on OCI. We assume that you must have OCI account with valid credentials and compartments. Launch the web browser and Log into your assigned OCI account. Expand the Hamburger menu and select “Autonomous Data Warehouse” or alternatively, click on “Autonomous Data Warehouse” on the welcome […]
All posts by Skant Gupta
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 […]
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 […]
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 […]
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 […]
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 @ […]
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 […]
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. […]
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 […]
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$ […]