ORACLE19-install oel7.6 OK

 

Oracle Database 19c Step by Step Installation On Oracle Linux 7.6

https://randydba.blogspot.com/2019/07/oracle-database-19c-step-by-step.html

This post describes the installation of Oracle Database 19c 64-bit on Oracle Linux 7.6  x86-64 bit. The Linux server needs a minimum of 3G swap and secure Linux set to permissive. An example of this type of Linux installation can be seen here.

Download Software

Download the Oracle software from oracle edelivery.

Oracle Installation Prerequisites

Automatic Setup

Use the "oracle-database-preinstall-19c" package to perform all your prerequisite setup.

# yum install -y oracle-database-preinstall-19c

If you are using RHEL7 or CentOS7, you can pick up the PRM from the OL7 repository and install it. It will pull the dependencies from your normal repositories.

# yum install -y https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm

install dari cd dan donwload package http://mirror.centos.org/centos/7/os/x86_64/Packages/compat-libstdc++-33-3.2.3-72.el7.x86_64.rpm

Hosts File

Set a fully qualified name for the server in the "/etc/hosts" file.

< IP-address >  < fully-qualified-machine-name >  < machine-name >

# vi /etc/hosts

Set the correct hostname in the "/etc/hostname" file.

# vi /etc/hostname

arandy.cm

NB!! Make sure you can ping the hostname you added in the host file.

Additional Setup

Set the password for the "oracle" user.

# passwd oracle

Set secure Linux to permissive by editing the "/etc/selinux/config" file. 

# vi /etc/selinux/config

SELINUX=permissive

Once the change is complete, run the following command.

# setenforce Permissive

Disable the Linux firewall.

# systemctl stop firewalld
# systemctl disable firewalld

Create the directories in which the Oracle software will be installed.

mkdir -p /u01/app/oracle/product/19.3.0/dbhome_1
mkdir -p /u02/oradata
chown -R oracle:oinstall /u01 /u02
chmod -R 775 /u01 /u02

Reboot the server and login in with the oracle user using the password that we set above. 

Hope you haven’t forgotten your password if you have don’t worry just log in as the root user and reset the password again with passwd command.

# reboot

 Set Environment variables.

Add the following environment variables in the .bash_profile file.

$ vi .bash_profile

# Oracle Settings

export TMP=/tmp

export TMPDIR=$TMP

export ORACLE_HOSTNAME=arandy.cm

export ORACLE_UNQNAME=cdb1

export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=$ORACLE_BASE/product/19.3.0/dbhome_1

export ORA_INVENTORY=/u01/app/oraInventory

export ORACLE_SID=cdb1

export PDB_NAME=pdb1

export DATA_DIR=/u02/oradata

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/jlib:$ORACLE_HOME/rdbms/jlib

$ . .bash_profile

Unzip the File 

Switch to the ORACLE_HOME directory and unzip the software directly into this path.

Please note that after you must have downloaded the installation file you have to transfer them into the VM. This can be done with Filezilla or by using the scp command in the terminal.

$ cd $ORACLE_HOME
$ unzip -oq /home/oracle/LINUX.X64_193000_db_home.zip

Run the Installer

Log into the oracle user, start the Oracle Universal Installer (OUI) by issuing the following command and follow the GUI guided steps

$ cd $ORACLE_HOME
$ ./runInstaller

Select the install option Set Up Software Only and click Next:

Select the install option Single Instance database installation and click Next:

Select the install option Enterprise Edition and click Next:

 Click Next.

 Click Next.

 Click Next.

 Click Next.

 Click Next.

Make sure all Prerequisite Checks Succeeded.

Click Install.

Run the root scripts when prompted.

As a root user, execute the following script(s):
# /u01/app/oraInventory/orainstRoot.sh
# /u01/app/oracle/product/19.0.0/dbhome_1/root.sh

Click Close.

You are now ready to create a database.

Database Creation

You create a database using the Database Configuration Assistant (DBCA). The interactive mode will display GUI screens to allow user input.

After successfully installing the database software, start the listener:

# Start the listener
$ lsnrctl start

To create the database using the interactive mode, start the Database Configuration Assistance (dbca) by issuing the following command and follow the GUI guided steps

# Interactive mode.
$ dbca

Click Next.

Typical configuration:

Global database name: cdb1

Storage type: File System

Database file location: /u02/oradata

Fast Recovery Area (FRA): {ORACLE_BASE}/fast_recovery_area/{DB_UNIQUE_NAME}

Database character set: AL32UTF8

Adminitrative password: SysOracle_47   

Pluggable database name: pdb1

Click Next.

Click Finish.

Database Summary.

Database creation finish.

Once the Database 19c successfully created, validate the database using the following command.

$ sqlplus / as sysdba
SQL> select banner_full from v$version;

SQL> select instance_name,status from v$instance;

SQL> select con_id, name, open_mode from v$pdbs;

Hope this helps!!

Caution: Any information or materials on this blog is provided for educational purposes only. It has been tested internally, however, we do not guarantee that it will work for you. Ensure that you run it in your test environment before using.

Thanks,
randyDBA { serving to discover }

------------------------------------------------------------

[root@finacc oracle]# vi /etc/security/limits.d/20-nproc.conf  
[root@finacc oracle]# vi /etc/sysctl.d/99-sysctl.conf  
[root@finacc oracle]# sysctl -p
fs.file-max = 6815744
kernel.sem = 250 32000 100 128
kernel.shmmni = 4096
kernel.shmall = 1073741824
kernel.shmmax = 4398046511104
kernel.panic_on_oops = 1
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
net.ipv4.conf.all.rp_filter = 2
net.ipv4.conf.default.rp_filter = 2
fs.aio-max-nr = 1048576
net.ipv4.ip_local_port_range = 9000 65500
[root@finacc oracle]# cd /u01/app/oraInventory/
[root@finacc oraInventory]#