Oracle 19c Installation On Linux

/
/
/
348 Views

Oracle 19c is one of the latest releases of the Oracle Database Management System. It comes with a lot of new features, enhancements, and improvements over the previous releases. Oracle 19c is the long-term support release that guarantees stability, reliability, and security for enterprises. Installing Oracle 19c on Linux is a straightforward process, but it requires some preparation and attention to details. In this article, we will guide you through the step-by-step process of installing Oracle 19c on Linux.

System Requirements

Before you start the installation process, you need to make sure that your system meets the following requirements:

  • Operating System: Oracle Linux 7.4 or later, Red Hat Enterprise Linux 7.4 or later, SUSE Linux Enterprise Server 12 SP3 or later
  • RAM: At least 4GB of RAM
  • Hard Disk Space: At least 10GB of free disk space
  • CPU: At least 2 cores

Step 1: Download the Oracle 19c Software

First, you need to download the Oracle 19c software from the Oracle website. You will need an Oracle account to download the software. Go to the Oracle Database 19c Downloads page, and select the Linux x86-64 bit version. Download the software to a directory on your system, and extract the files from the zip archive.

Step 2: Install Required Packages

Before you start the Oracle 19c installation process, you need to install some required packages on your system. Open a terminal and run the following command as root:

arduino
# yum install -y binutils.x86_64 compat-libcap1.x86_64 gcc.x86_64 gcc-c++.x86_64 glibc.i686 glibc.x86_64 glibc-devel.i686 glibc-devel.x86_64 ksh compat-libstdc++-33 libaio.i686 libaio.x86_64 libaio-devel.i686 libaio-devel.x86_64 libgcc.i686 libgcc.x86_64 libstdc++.i686 libstdc++.x86_64 libstdc++-devel.i686 libstdc++-devel.x86_64 libXi.i686 libXi.x86_64 libXtst.i686 libXtst.x86_64 make.x86_64 sysstat.x86_64

Step 3: Configure Kernel Parameters

Next, you need to configure some kernel parameters to optimize your system for Oracle 19c. Open the /etc/sysctl.conf file and add the following lines at the end of the file:

arduino
fs.file-max = 6815744
kernel.sem = 250 32000 100 128
kernel.shmmni = 4096
kernel.shmall = 1073741824
kernel.shmmax = 4398046511104
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576

Save and close the file. Then, run the following command to apply the changes:

arduino
# sysctl -p

Step 4: Create Oracle User and Groups

To install Oracle 19c, you need to create an Oracle user and some groups. Open a terminal and run the following commands as root:

arduino
# groupadd oinstall
# groupadd dba
# useradd -g oinstall -G dba oracle

Step 5: Configure Environment Variables

Next, you need to configure some environment variables for the Oracle user. Open the .bash_profile file in the Oracle user’s home directory and add the following lines at the end of the file:

bash
# Oracle Settings
export TMP=/tmp
export TMPDIR=$TMP

export ORACLE_HOSTNAME=your_hostname
export ORACLE_UNQNAME=cdb1
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/19.0.0/dbhome_1
export ORACLE_SID=cdb1

export PATH=$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib

umask 022

Replace “your_hostname” with the hostname of your system. Save and close the file. Then, run the following command to activate the changes:

shell
# source ~/.bash_profile

Step 6: Install Oracle 19c

Now, you are ready to start the Oracle 19c installation process. Open a terminal and switch to the directory where you extracted the Oracle 19c software. Run the following command as the Oracle user:

shell
$ ./runInstaller

The Oracle Universal Installer will launch. Follow the steps below to complete the installation:

  1. Select the “Install database software only” option and click “Next”.
  2. Choose the language and click “Next”.
  3. Select the edition of Oracle 19c that you want to install and click “Next”.
  4. Choose the installation location and click “Next”.
  5. Select the type of database installation and click “Next”. You can choose either a “General Purpose/Transaction Processing” database or a “Data Warehouse” database.
  6. Configure the database file locations and click “Next”.
  7. Specify the database administrator password and click “Next”.
  8. Configure the network settings and click “Next”.
  9. Choose the database character set and click “Next”.
  10. Review the installation summary and click “Install”.
  11. Wait for the installation to complete.
  12. Click “Close” to exit the Oracle Universal Installer.

Step 7: Configure the Listener

After the installation is complete, you need to configure the listener for Oracle 19c. Open a terminal and switch to the Oracle user. Run the following commands:

shell
$ cd $ORACLE_HOME/network/admin
$ vi listener.ora

Add the following lines to the file:

scss
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = your_hostname)(PORT = 1521))
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = cdb1)
(SID_NAME = cdb1)
(ORACLE_HOME = /u01/app/oracle/product/19.0.0/dbhome_1)
)
)

Replace “your_hostname” with the hostname of your system. Save and close the file. Then, run the following command to start the listener:

ruby
$ lsnrctl start

Step 8: Create a Database

Finally, you can create a database in Oracle 19c. Open a terminal and switch to the Oracle user. Run the following commands:

sql
$ sqlplus / as sysdba
SQL> create database cdb1
user sys identified by sys_password
user system identified by system_password
maxlogfiles 5
maxlogmembers 5
maxdatafiles 100
character set AL32UTF8
national character set AL16UTF16
extent management local;

Replace “sys_password” and “system_password” with the passwords that you want to use for the SYS and SYSTEM users. You can customize the database parameters to meet your specific requirements. Wait for the database creation to complete.

Frequently Asked Questions

What are the system requirements for installing Oracle 19c on Linux?

The system requirements for Oracle 19c on Linux are:

Operating System: Oracle Linux 7.4 or later, Red Hat Enterprise Linux 7.4 or later, SUSE Linux Enterprise Server 12 SP3 or later

RAM: At least 4GB of RAM

Hard Disk Space: At least 10GB of free disk space

CPU: At least 2 cores

Do I need to install any packages before installing Oracle 19c on Linux?

Yes, you need to install some required packages before installing Oracle 19c on Linux. You can use the command mentioned in step 2 of this article to install the required packages.

How do I configure kernel parameters for Oracle 19c on Linux?

You can configure kernel parameters by editing the /etc/sysctl.conf file and adding the required parameters. You can use the commands mentioned in step 3 of this article to configure the kernel parameters.

How do I create an Oracle user and groups on Linux?

You can create an Oracle user and groups by using the commands mentioned in step 4 of this article.

How do I configure environment variables for Oracle 19c on Linux?

You can configure environment variables by editing the .bash_profile file in the Oracle user’s home directory and adding the required variables. You can use the commands mentioned in step 5 of this article to configure the environment variables.

How do I start the Oracle Universal Installer on Linux?

You can start the Oracle Universal Installer by running the runInstaller script from the directory where you extracted the Oracle 19c software. You need to run this script as the Oracle user.

How do I configure the listener for Oracle 19c on Linux?

You can configure the listener by editing the listener.ora file in the $ORACLE_HOME/network/admin directory and adding the required configuration. You can use the commands mentioned in step 7 of this article to configure the listener.

How do I create a database in Oracle 19c on Linux?

You can create a database by using SQL*Plus and running the create database command. You can use the commands mentioned in step 8 of this article to create a database.

Can I install Oracle 19c on other operating systems?

Yes, you can install Oracle 19c on other operating systems such as Windows, macOS, and other Linux distributions. However, the system requirements and installation steps may vary.

Is it recommended to install Oracle 19c on a production environment?

Yes, Oracle 19c is the long-term support release that guarantees stability, reliability, and security for enterprises. It is recommended to install Oracle 19c on a production environment.


Leave a Comment

Your email address will not be published. Required fields are marked *

This div height required for enabling the sticky sidebar