Oracle Database 19c
1. Oracle Database Download (Linux x86-64 ZIP(2.8 GB) )
https://www.oracle.com/database/technologies/oracle-database-software-downloads.html
(https://oracle-base.com/articles/19c/oracle-db-19c-installation-on-oracle-linux-7)
2.
The following packages are listed as required. Many of the
packages should be installed already.
Oracle
Installation Prerequisites
root@quiumpc
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-six # ACFS
yum
install -y targetcli # ACFS
yum
install -y smartmontools
yum
install -y sysstat
#
Added by me.
yum
install -y unixODBC
3.
Create the new groups and users.
root@quiumpc
groupadd
-g 54321 oinstall
groupadd
-g 54322 dba
groupadd
-g 54323 oper
useradd
-u 54321 -g oinstall -G dba,oper oracle
passwd
oracle
4.
Manual Setup
If you have not used the "oracle-database-preinstall-19c"
package to perform all prerequisites, you will need to manually perform the
following setup tasks.
Add the following lines to the "/etc/sysctl.conf"
file, or in a file called "/etc/sysctl.d/98-oracle.conf".
-----Go to Computer etc folder
/etc/sysctl.conf
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
Run
one of the following commands to change the current kernel parameters,
depending on which file you edited.
---check
sysctl file
/sbin/sysctl
-p
#
Or
/sbin/sysctl
-p /etc/sysctl.d/98-oracle.conf
5.
Add the following lines to a file called
"/etc/security/limits.d/oracle-database-preinstall-19c.conf" file.
-----Go to Computer etc folder
/etc/security/limits.d/20-nproc.conf
# * soft nproc
unlimited
root soft nproc
unlimited
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
6.
Set secure Linux to permissive by editing the
"/etc/selinux/config" file, making sure the SELINUX flag is set as
follows.
SELINUX=disabled
setenforce
disabled
7.
If you have the Linux firewall enabled, you will need to disable
or configure it, as shown here. To disable it, do the following.
systemctl
stop firewalld
systemctl
disable firewalld
8. If
you are not using Oracle Linux and UEK, you will need to manually disable
transparent huge pages.
Create the directories in which
the Oracle software will be installed.
mkdir -p
/u01/app/oracle/product/19.0.0/dbhome_1
chown -R oracle:oinstall /u01
chmod -R 775 /u01
9.
Copy and paste to dbhome_1 drive oracle Linux software
cd /u01/app/oracle/product/19.0.0/dbhome_1
ls
unzip LINUX.X64_193000_db_home.zip
chown -R oracle:oinstall /u01
chmod -R 775 /u01
cd /u01/app/oracle/product/19.0.0/dbhome_1
xhost +
cd /bin
ls
-----root
chown -R oracle:oinstall /u01
chown -R oracle:oinstall /u01/app/oracle/product/19.0.0/dbhome_1
cd /u01/app/oracle/product/19.0.0/dbhome_1
su oracle
./runInstaller
10. Go to Computer->Home-> Oracle ->Show hidden Files for Sqlplus
bash_profiles
# Oracle Settings
export TMP=/tmp
export TMPDIR=$TMP
export ORACLE_HOSTNAME=localhost.localdomain
export ORACLE_UNQNAME=orcl
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/19.0.0/dbhome_1
export ORA_INVENTORY=/u01/app/oraInventory
export ORACLE_SID=orcl
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
No comments:
Post a Comment