IT Tutorial IT Tutorial | Oracle DBA | SQL Server, Goldengate, Exadata, Big Data, Data ScienceTutorial
I will explain Oracle database 19c installation step by step on Linux 7.6 and RHEL and Oracle 19c database installation | 19c New Features in this post
Lets remember that Oracle has announced that Oracle 19c is available yet.
If you want to install Oracle 18c, you can read following article.
Oracle Database 18c Step by Step Installation on Linux 7.6 and RHEL -2
Oracle 19c New Features
- Automatic Indexing
- Data-guard DML Redirect
- Partitioned Hybrid Tables
- Real-time Stats + Stats Only Queries features.
Oracle 19c database installation | 19c New Features
We are downloading Oracle database 19c version from Oracle Support. The Oracle database 19c installation file will be downloaded from https://support.oracle.com or https://edelivery.oracle.com and transfered to the our Linux server.
oracle-database-preinstall-19c
You should install Oracle preinstall package like following. Oracle 19c preinstall yum package is not available yet. So I have installed oracle-database-preinstall-18c.x86_64 package.
[root@MehmetSalih ~]# yum install oracle-database-preinstall-18c.x86_64
Unzip installation zip folder and execute runInstaller like following screenshot.
I have choosen ” Create and Configure a single instance database” option to install Oracle database 19c. Click Next button.
In this step, we choose Server Class and not Desktop class. If you are going to set up a test environment, you can choose Desktop class, but you need to select Server class for Live environment setups.
This step asks for the database edition preference. Especially in institutions, those who install this installation should pay attention. If you have an Enterprise Edition license, you should install Enterprise edition, and if your IT budget is low, you should install the Standard edition.
In this step we define the Oracle database 19c software home folder.
In this step, we choose the General purpose for OLTP systems, if we were setting up a database for the datawarehouse systems, we had to choose the second option.
In this step, we give name of our database Global and Instance name.
This step is one of the most important steps in creating a Database. So you need to be careful in this step, some changes may not be changed later. Database memory management is defined in this step, whether it is manual or manual. Database memory management will be discussed in detail in the next sections.
This step sets the Database Character set. The character is also a critical parameter for the database setup because it is one of the unchanging properties after installation. In live environments or production environments, these features should be determined according to the compatibility of software with software teams and which character is compatible with the set.
In this step, we will store our Oracle database 19c files on the File system.
If you have Enterprise manager Cloud control then you can register with typing informations.
You should choose recovery of your database. If you install this database for production, you should enable recovery.
Define sys and system paswords like following.
Define operating system groups like following.
You can choose ” Automatically run configurations scripts ” for running root.sh script automatically.
You can see verification results and you can ignore swap size.
You can see installation summary with below screenshot. Click install button to start installation.
Click yes button to run scripts.
Oracle database 19c installation is complete like following.
Second article about Oracle database 19c installation is like following link.
Oracle Database 19c on Linux 7.6 Step by Step Installation -2
You can Read the following article to learn Oracle 20c New Features and Installation.
Oracle 20c New Features and Step by Step Installation Oracle Database 20c on Linux
Do you want to learn Oracle Database for Beginners, then read the following articles.
Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )
Hi, Very descriptive article. But, I wonder if these steps are good for CentOS / RHEL 7 as well. Because, the preinstall RPM only works on Oracle Linux.
Hope you clarify it?
great share
I’m impressed, I must say. Rarely do I come across a blog that’s both equally educative and engaging, and let me tell you, you have hit the nail on the head. The issue is something too few men and women are speaking intelligently about. I am very happy I came across this in my search for something relating to this.|
thanks
Thank! Your tutorial is very detailed
You are welcome, keep in following
It is really a great and useful piece of information.
I am happy that you simply shared this helpful information with us.
Please keep us informed like this. Thanks for sharing.
thanks
Point/Add the Oracle yum repos to your CentOS or RHEL yum to install the Oracle pre-req pkgs
Hey pls, Iḿ trying to install oracle database in Ubuntu and Iḿ running into errors….could you pls lend a helping hand. Your assistance will be highly appreciated. -Thanks
what is the problem or error ?
I like to setup the software only (using silent installation), patch it to the latest PSU and create my dbs afterwards (if possible also doing it silent). Makes things a lot easier and you don’t need any X11 forwarding for it.
Yeah You are right, i am also using Silent install and i have writen its article as follows. But Silent installation requires more DBA Skills, this article is for beginner or Middle level DBAs..
https://ittutorial.org/oracle-database-12c-silent-installation/