Installing Oracle Database 19c with GitHub Repos

In this post, we can use GitHub reposirotry to fetch the repos and then be installing the Oracle Database 18c.  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.

As GitHub is not configured, we use YUM to install it with […]

Read More

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 […]

Read More

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.

To resolve the above error, make sure /etc/hosts has configured properly and ping […]

Read More

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

Download the .rpm […]

Read More

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 […]

Read More

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.

Stay tuned for more articles on Oracle 19c  Thank you for giving your valuable […]

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.

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 […]

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.

Select a “Set Up Software Only” and click next. Select on “Single instance database Installation” and click on next. Select on “Enterprise […]

Read More

More New Features in Oracle Database 19c

The following are changes in Oracle Installation for Oracle Database release 19c. Root Scripts Automation Support for Oracle Database Installation Rapid Home Provisioning (RHP) Name Change Starting with Oracle Database 19c and Oracle Grid Infrastructure 19c, Rapid Home Provisioning is renamed to Fleet Patching and Provisioning (FPP). The following are changes in Oracle Database Data Warehousing for […]

Read More