To upgrade from Oracle 11gR2 to Oracle 18c/19c, we need to remove Streams setup. For detailed steps, refer to the section “Removing an Oracle Streams Configuration” in the Oracle Streams Concepts and Administration Guide specific for the Oracle release from which you are removing. It is observed that even though there are no Streams Processes or Rules. sqlplus […]
Category: Oracle 19c
Installing Oracle Database 19c with GitHub Repos
In this post, we can use GitHub repository to fetch the repos and then be installing the Oracle Database 19c. GitHub must be installed for this feature prerequisite. In your VM or Bare Metal, check the status and version of GitHub if it is installed. [root@ORA006 ~]# git version bash: git: command not found As GitHub is not […]
Oracle 19C Active Data Guard DML Redirection Feature
This article describes about the Oracle 19C new feature – Active Data Guard DML Redirection. ACTIVE DATA GUARD DML REDIRECT feature enables DML operation on the standby database to be redirected to and run on the primary database instead of failing, where the data changes will be applied. The updated data will then be streamed […]
Creating and Configuring an Oracle Database for RPM Based
In the last post, we installed Oracle 19c Database Software by running RPM Package. Now, we are going to create and configure a Database with default Setting.Log in as root and run the below command to configure an Oracle Database instance. [root@oracle19c dbhome_1]# /etc/init.d/oracledb_ORCLCDB-19c configure Configuring Oracle Database ORCLCDB. [FATAL] [DBT-06103] The port (1,521) is […]
ORACLE 19C RPM BASED SOFTWARE INSTALLATION
Oracle 19c can be installed on Oracle Linux using an RPM. This article describes the RPM installation of Oracle Database 19c 64-bit on Oracle Linux 7 (OL7) 64-bit. The naming convention for RPM packages is name–version–release.architecture.rpm. Installing Oracle Database RPM Manually Login as Root and Download and install the Oracle Preinstallation RPM [root@oracle19c sw]# curl -o […]
Manual upgrading Oracle database 11gR2 to 19c
Manual upgrading Oracle database 11gR2 to 19c If you want to know how we upgrade an 11.2.0.4 database to 19.0.0.0.0 using DBUA, click here. This article explains how to upgrade 11.2.0.3 and above, and 12.1.0.1, 12.2.0.1, 18c to 19.0.0.0.0 manually. Manually upgrading to 19c There are many DBAs who don’t want to follow the recommended […]
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 […]