Today, I’m bringing you an article with the steps to update the ODA version to 19.17. What’s new? As usual, this version brings the latest PSUs to database and grid homes with their bug fixes. It also brings the latest 21.8 databases. The only new features the release note are: Which ODA is compatible with […] Read more
A friend called me asking for help because a tablespace did not reduce size after purging the data. I explained to him how to identify high-water marks, and decided to write this article. This article explains, with examples, how to view the high-water mark and when the high-water mark is reset. The queries in this […] Read more
Change Oracle DB name using NID: How to Change the DBID, DBNAME Using NID Utility (Doc ID 863800.1) 1. In Real Application Cluster, we need to set cluster_database parameter to false and mount an instance on only one node: sqlplus / as sysdba alter system set cluster_database=false scope=spfile; oracle@db01:~# . oraenv ORACLE_SID = [DUTSDB] ? […] Read more
1 Introduction This document contains all information related to the migration of database Oracle Database Enterprise Edition to Oracle Database Standard Edition. This document describes: 1.1 Migration Method The primary method used for the migration will be by Oracle Data Pump for the following reasons: 2 ... Read more
As we saw in the article Overview of Burstable Instances, I will demonstrate how to create a Burstable Instance today. Open the navigation menu and click Compute. Under Compute, click Instances. Click Create instance. Enter a name for the instance. You can add or change the name later. The name doesn’t need to be unique because an Oracle Cloud Identifier (OCID) […] Read more