Oracle Database 19c Multitenant Architecture Installation

Updated: Aug 7

We will begin the installation with a most popular database in the world that provides various solutions for managing data from large, medium and small institutions and global companies. The versions we are going to work on will be the most recent Database 19c for production use at this stage at the moment we will not put the Automatic Storage Mangement.

Note .:

To help your DBA career download our Oracle Scripts now and collaborate, CLICK FOR ALL


Requirements:

  • 64-bit Oracle Database 19c on 64-bit Oracle Linux 7 (RHEL7 or CentOS7). Know more...

  • RAM memory At least 1 GB of RAM for Oracle database installations To avoid slowing down, we recommend 2 GB of RAM.

  • Disk Oracle recommends that you allocate 100 GB to allow additional space for patches.

  • Minimum of 2G SWAP

  • Secure Linux set to Permissive.

Download software Oracle Database 19c for Linux x86-64:

Oracle Database 19c (19.3) for Linux x86-64 (LINUX.X64_193000_db_home.zip)

https://www.oracle.com/database/technologies/oracle19c-linux-downloads.html


Let's prepare Installation:


A tip, ideal and to do the full S.O update, remembering that this is not mandatory yet another recommendation.

# yum update -y

Package Installation:


It is necessary to install the packages that are listed below, it is possible that some of them are already installed.

yum install -y bc    
yum install -y binutils
yum install -y compat-libcap1
yum install -y compat-libstdc ++ - 33
yum install -y dtrace-modules
yum install -y dtrace-modules-headers
yum install -y dtrace-modules-provider-headers
yum install -y dtrace-utils
yum install -y elfutils-libelf
yum install -y elfutils-libelf-devel
yum install -y fontconfig-devel
yum install -y glibc
yum install -y glibc-devel
yum install -y ksh
yum install -y libaio
yum install -y libaio-devel
yum install -y libdtrace-ctf-devel
yum install -y libXrender
yum install -y libXrender-devel
yum install -y libX11
yum install -y libXau
yum install -y libXi
yum install -y libXtst
yum install -y libgcc
yum install -y librdmacm-devel
yum install -y libstdc ++
yum install -y libstdc ++ - devel
yum install -y libxcb
yum install -y make
yum install -y net-tools # Clusterware
yum install -y nfs-utils # ACFS
yum install -y python # ACFS
yum install -y python-configshell # ACFS
yum install -y python-rtslib # ACFS
yum install -y python-seis # ACFS
yum install -y unixODBC
yum install -y targetcli # ACFS
yum install -y smartmontools
yum install -y sysstat

Kernel parameter values:


Now using any text editor we will put the settings in the file "/etc/sysctl.conf" and it can also be found in "/etc/sysctl.d/98-oracle.conf".

fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 4294967295
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576

To change the current values of the kernel parameters:

# /sbin/sysctl --system
## Or
#/sbin/sysctl -p

Review the values, if they are incorrect, edit the file again as the command below will show you parameters.

# /sbin/sysctl -a

Add the following lines to a file called "/etc/security/limits.d/limits.conf" file.


orades   soft   nofile    1024
orades   hard   nofile    65536
orades   soft   nproc    16384
orades   hard   nproc    16384
orades   soft   stack    10240
orades   hard   stack    32768
orades   hard   memlock    134217728
orades   soft   memlock    134217728

Networks parameter values:


Configure hosts:


It must have a name for the server. In this example we will use the following:

Ip: 192.168.1.19;

Hostname: orades-19c;

With any text editor add to the file "/etc /hosts"

127.0.0.1 localhost localhost.localdomain localhost4  
192.168.1.19 orades-19c.localdomain orades-19c 

Configuring SELINUX with a text editor edit / etc / selinux / config as follows:


SELINUX=permissive

Run the following command. (If the command does not force the change, it is likely that the server must be restarted).

# setenforce Permissive

Let's go to the Linux firewall and disable it as the commands:

# systemctl stop firewalld 
# systemctl desativar firewalld

Configuring Groups and Directories:


Create the new groups and users.

groupadd -g 501 oinstall
groupadd -g 502 dba
groupadd -g 503 oper
#groupadd -g 504 backupdba
#groupadd -g 505 dgdba
#groupadd -g 506 kmdba
#groupadd -g 507 asmdba
#groupadd -g 508 asmoper
#groupadd -g 509 asmadmin

useradd -u 501 -g oinstall -G dba,oper orades

Set user password.

passwd orades

Database 19c software will be installed in the following directories that must be created below:

mkdir -p /u01/app/orades/product/19.0.0/db_1
chown -R orades:oinstall /u01
chmod -R 775 /u01

Log into the oracle user orades and configure the variables in .bash_profile. Add the following parameters as below:

# Oracle Settings
export TMP=/tmp
export TMPDIR=/$TMP
export ORACLE_BASE=/u01/app/orades
export ORACLE_HOME=$ORACLE_BASE/product/19.0.0/db_1
export ORACLE_SID=orades
export ORACLE_TERM=xterm
export PATH=/usr/sbin:/usr/local/bin:/$PATH
export PATH=$ORACLE_HOME/bin:/$PATH
export LD_LIBRARY_PATH=/$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib

If you are using X emulation then set the DISPLAY environmental variable.

DISPLAY=<machine-name>:0.0; export DISPLAY

Installation of Oracle 19c Database Binaries.


Go to where you downloaded Oracle Database 19c for Linux x86-64 software and unzip the file.

cd /u01/app/orades/product/19.0.0/db_1
unzip -d LINUX.X64_193000_db_home.zip

After decompression, execute the command below:

./runInstaller

Step1 : Click create and configure a single instance database:


Step2 : Click Server class


Step3 : Select Enterprise Edition


Step 4: Choose location for ORACLE_BASE


Step 5: Select configuration type as General Purpose / Transaction Processing.


Step 6: Enter Database name ORADES


Nota: Check the "Create as Container Database" flag. (If you want the Database stay with Multitenant Architecture)


At this point we’ll leave Enabled Automatic Memory Management and move on.


Step 7: Select File System this installation we will not put the database with Automatic Storage Management (ASM). Enter File location;

Nota:

To learn more about Automatic Storage Management (Click here...)

We will not check Register with Enterprise Manager (EM) next


Step 8: Enable Archive log mode option for database.


Step 9: Enter SYS and SYSTEM user password.


Step 10: Check S.O groups for installation.


A new feature in the installation of database 19c and that you can now automatically run the script run configuration just check the flag and put the root password.

More we will execute manually click next.


Step 11: Check Prerequisite checks for 19c database installation.


Step 12: Check Summary. And click on install,

In the middle of the installation you will be asked to run the following script as the root user do exactly what is in the image.


Run the scripts;
/u01/app/orades/product/19.0.0/db_1/root.sh
Case require execution of the script below:
/u01/app/oraInventory/orainstRoot.sh
Please create the "oraInventory" directory and give permission.
Once the scripts have been executed, click OK on the screen Step 16 of 17.

We finished the simplest installation of Oracle database 19c.


Step 14: Finally we will check if the database is Ok as the simple command below:

Oracle database 19c installation is completed successfully.


To help with administration download our Oracle scripts now and collaborate, CLICK FOR ALL