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 […]
Here I would be discussing how to upgrade Oracle 11gR2 (184.108.40.206) database to Oracle 19c (220.127.116.11.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 […]
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;
DBMS_MVIEW.REFRESH_ALL_MVIEWS(num_failures,'C','', TRUE, FALSE);
PL/SQL procedure successfully completed.
SQL> SQL> select count(1) from sumdelta$;
Stay tuned for more articles on Oracle 19c Thank you for giving your valuable […]
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 if you want enable archive log mode. Create a new […]
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 “Set Up Software Only” and click next. Select on “Single instance database Installation” and click on next. Select on “Enterprise […]
Exadata System Software Release 18.104.22.168.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 @ […]
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 […]
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. […]
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 […]
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$ […]