Oracle 19c Installation On Linux
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:
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:
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:
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:
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:
# 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:
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:
./runInstaller
The Oracle Universal Installer will launch. Follow the steps below to complete the installation:
- Select the “Install database software only” option and click “Next”.
- Choose the language and click “Next”.
- Select the edition of Oracle 19c that you want to install and click “Next”.
- Choose the installation location and click “Next”.
- Select the type of database installation and click “Next”. You can choose either a “General Purpose/Transaction Processing” database or a “Data Warehouse” database.
- Configure the database file locations and click “Next”.
- Specify the database administrator password and click “Next”.
- Configure the network settings and click “Next”.
- Choose the database character set and click “Next”.
- Review the installation summary and click “Install”.
- Wait for the installation to complete.
- 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:
cd $ORACLE_HOME/network/admin
vi listener.ora
Add the following lines to the file:
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:
$ 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:
$ 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.