Memory and Disk Space Requirements
- Minimum: 1 GB of RAM , Recommended: 2 GB of RAM or more
- 7.2 GB of disk space for the software installation
- 7.5 GB of disk space for the Database files
- At least 1 GB of disk space in the /tmp directory
- Swap space recommendation:
Available RAM Swap Space Required
1. Between 1 GB and 2 GB 1.5 times the size of the RAM
2. Between 2 GB and 16 GB Equal to the size of the RAM
3. More than 16 GB 16 GB
2. Between 2 GB and 16 GB Equal to the size of the RAM
3. More than 16 GB 16 GB
The following packages (or later versions) must be installed
yum install -y bcyum install -y binutils
yum install -y compat-libcap1
yum install -y compat-libstdc++-33
yum install -y compat-libstdc++-33.i686
yum install -y elfutils-libelf.i686
yum install -y elfutils-libelf
yum install -y elfutils-libelf-devel.i686
yum install -y elfutils-libelf-devel
yum install -y fontconfig-devel
yum install -y glibc.i686
yum install -y glibc
yum install -y glibc-devel.i686
yum install -y glibc-devel
yum install -y ksh
yum install -y libaio.i686
yum install -y libaio
yum install -y libaio-devel.i686
yum install -y libaio-devel
yum install -y libX11.i686
yum install -y libX11
yum install -y libXau.i686
yum install -y libXau
yum install -y libXi.i686
yum install -y libXi
yum install -y libXtst.i686
yum install -y libXtst
yum install -y libgcc.i686
yum install -y libgcc
yum install -y librdmacm-devel
yum install -y libstdc++.i686
yum install -y libstdc++
yum install -y libstdc++-devel.i686
yum install -y libstdc++-devel
yum install -y libxcb.i686
yum install -y libxcb
yum install -y make
yum install -y nfs-utils
yum install -y net-tools
yum install -y python
yum install -y python-configshell
yum install -y python-rtslib
yum install -y python-six
yum install -y smartmontools
yum install -y sysstat
yum install -y targetcli
yum install -y unixODBC
Create Required Operating System Groups and Users
groupadd oinstall groupadd dba useradd -g oinstall -G dba oracle
If the oracle user exists, but its primary group is not oinstall or it is not a member of the dba group, then enter the following command:
usermod -g oinstall -G dba oracle
Configuring Kernel Parameters and Resource Limits
For production database systems, Oracle recommends that you tune these values to optimize the performance of the system.
For production database systems, Oracle recommends that you tune these values to optimize the performance of the system.
edit the /etc/sysctl.conf file, and add or edit lines similar to the following:
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
Enter the following command to change the current values of the kernel parameters:
/sbin/sysctl -p
Add the following lines to the "/etc/security/limits.conf" file.
/sbin/sysctl -p
Add the following lines to the "/etc/security/limits.conf" file.
oracle soft nofile 1024
oracle hard nofile 65536
oracle soft nproc 16384
oracle hard nproc 16384
oracle soft stack 10240
oracle hard stack 32768
oracle hard memlock 134217728
oracle soft memlock 134217728
Verify the latest version of PAM is loaded, then add or edit the following line in the /etc/pam.d/login file, if it does not already exist:
session required pam_limits.so
Create the directories in which the Oracle software will be installed.
mkdir -p /u01/app/oracle/product/19.3.0/db_1
chown -R oracle:oinstall /u01
chmod -R 775 /u01
chgrp oinstall /u01/app/oracle/product/19.3.0/db_1
Automatic Setup
If you plan to use the "oracle-database-preinstall-19c" package to perform all your prerequisite setup, issue the following command.
yum install -y oracle-database-preinstall-19c
Download Software
If you have had an existing installation on your system, and you are using the same user account to install this installation, then unset the ORACLE_HOME, ORACLE_BASE, ORACLE_SID, TNS_ADMIN environment variables
unset ORACLE_HOME
unset ORACLE_BASE
unset ORACLE_SID
unset TNS_ADMIN
Use the following command to check the PATH environment variable:
[oracle@joshi ~]$ echo $PATH
/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/home/oracle/.local/bin:/home/oracle/bin
Ensure that the $ORACLE_HOME/bin path is removed from your PATH environment variable.
Installation
Unzip software.
cd /u01/app/oracle/product/19.3.0/db_1
unzip -oq /soft/oracle/LINUX.X64_193000_db_home.zip
From the Oracle home directory, run the runInstaller command to start the Oracle Database Setup Wizard.
[oracle@joshi db_1]$ pwd
/u01/app/oracle/product/19.3.0/db_1
[oracle@joshi db_1]$
[oracle@joshi db_1]$ ./runInstaller
[root@joshi db_1]# /u01/app/oracle/product/19.3.0/db_1/root.sh
Performing root user operation.
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /u01/app/oracle/product/19.3.0/db_1
Enter the full pathname of the local bin directory: [/usr/local/bin]:
The contents of "dbhome" have not changed. No need to overwrite.
The contents of "oraenv" have not changed. No need to overwrite.
The contents of "coraenv" have not changed. No need to overwrite.
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Oracle Trace File Analyzer (TFA - Standalone Mode) is available at :
/u01/app/oracle/product/19.3.0/db_1/bin/tfactl
Note :
1. tfactl will use TFA Service if that service is running and user has been granted access
2. tfactl will configure TFA Standalone Mode only if user has no access to TFA Service or TFA is not installed
[root@joshi db_1]#
Reference;
If you are on Oracle Linux 8 and Red Hat Enterprise Linux 8, you can apply the latest RU & required One-offs during the installation.
Download latest OPatch,prior to launching the Installer.
In case of 19.9 RU & later
===========================================
$ export CV_ASSUME_DISTID=OL7
$ ./runInstaller -applyRU <19.7DBRU patch 31771877 unzip location>
For eg-
$ ./runInstaller -applyRU /u01/app/31771877
where-
31771877 - DATABASE RELEASE UPDATE 19.9.0.0.0
In case of 19.6 RU
===========================================
$ cd /u01/app/oracle/product/19c/dbhome_1
$ export CV_ASSUME_DISTID=OL7
$ ./runInstaller -applyRU <19.6 DBRU patch 30557433 unzip location> -applyOneOffs <19.6 OJVM patch 30484981 unzip location>,<19.6 Oneoff patch 30150710 unzip location>
For eg-
$ ./runInstaller -applyRU /u01/app/30557433 -applyOneOffs /u01/app/30484981,/u01/app/30150710
where-
30557433 - DATABASE RELEASE UPDATE 19.6.0.0.0
30484981 - OJVM RELEASE UPDATE 19.6.0.0.0
30150710 - EM express OneOff patch 19.6.0.0.0
Reference;
Requirements for Installing Oracle Database/Client 19c on OL8 or RHEL8 64-bit (x86-64) (Doc ID 2668780.1)
SILENT MODE
./runInstaller -ignorePrereq -waitforcompletion -silent \
-responseFile /u01/app/oracle/product/19.3.0/db_1/install/response/db_install.rsp \
oracle.install.option=INSTALL_DB_SWONLY \
ORACLE_HOSTNAME=joshi \
UNIX_GROUP_NAME=oinstall \
INVENTORY_LOCATION=/u01/app/oraInventory \
ORACLE_HOME=/u01/app/oracle/product/19.3.0/db_1 \
ORACLE_BASE=/u01/app/oracle \
oracle.install.db.InstallEdition=EE \
oracle.install.db.OSDBA_GROUP=dba \
oracle.install.db.OSBACKUPDBA_GROUP=dba \
oracle.install.db.OSDGDBA_GROUP=dba \
oracle.install.db.OSKMDBA_GROUP=dba \
oracle.install.db.OSRACDBA_GROUP=dba \
SECURITY_UPDATES_VIA_MYORACLESUPPORT=false \
DECLINE_SECURITY_UPDATES=true
Run the root scripts when prompted.
As a root user, execute the following script(s):
1. /u01/app/oraInventory/orainstRoot.sh
2. /u01/app/oracle/product/19.3.0/db_1/root.sh
No comments:
Post a Comment