DAY 07 - DATABASE INSTALLATION (19c)

v  LOGIN as ROOT user
 
Setup IP address
 
[root@dbserver ~]$ nmtui
 
v  [Configure network settings such as network interface names, IP addresses, DNS servers]
v  IPv4 CONFIGURATION <Automatic> OR CAN BE MANUALLY SET IP ADDRESS
v  IPv6 CONFIGURATION <Ignore>
 
[root@dbserver ~]$ ping google.com
[root@dbserver ~]$ yum update -y 
 
v  [Update all installed packages and their dependencies to their latest versions available in the configured repositories.]
 
[root@dbserver ~]$ vi /etc/sysconfig/selinux 
 
v  disabled 
v  [SELinux (Security-Enhanced Linux) is a Linux kernel security module that provides mandatory access control (MAC) for system resources]
 
[root@dbserver ~]$ vi /etc/hostname 
 
v  dbserver
 
[root@dbserver ~]$ vi /etc/hosts 
 
v  20.20.20.22 dbaserver.shohan.com dbserver
v  [Hosts file is used to map hostnames to IP addresses]
 
Linux firewall will need to disable
 
[root@dbserver ~]$ systemctl stop firewalld
[root@dbserver ~]$ systemctl disable firewalld
 
yum install -y oracle-database-preinstall-19c
 
yum install -y bc    
yum install -y binutils
yum install -y compat-libcap1
yum install -y compat-libstdc++-33
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
yum install -y nfs-utils
yum install -y python
yum install -y python-configshell
yum install -y python-rtslib
yum install -y python-six
yum install -y targetcli
yum install -y smartmontools
yum install -y sysstat
yum install -y unixODBC
 
Create the directories in which the Oracle software will be installed
 
v  OINSTALL : FOR SOFTWARE INSTALLATION
v  DBA : TO MANAGE DATABASE

v  ORACLE BINARY LOCATION [ALL EXECUTABLE FILES ARE THERE]
     /u01/app/oracle/product/19.0.0/dbhome_1/bin
 
[root@dbserver ~]$ mkdir -p /u01/app/oracle/product/19.0.0/db_home
[root@dbserver ~]$ chown -R oracle:oinstall /u01
[root@dbserver ~]$ chmod -R 775 /u01
 
Set the password for the Oracle user
 
[root@dbserver ~]$ passwd oracle
[root@dbserver ~]$ reboot
 
v  LOGIN as ORACLE user
 
PRE-DATABASE CREATION STEPS
              
SET THE BASH PROFILE [environment variable - SHORT CUT]
                             
[oracle@dbserver ~]$ vi .bash_profile
 
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/product/19.0.0/db_home
export ORACLE_SID=maxcdb
export PATH=$ORACLE_HOME/bin:$PATH
 
[oracle@dbserver ~]$ . .bash_profile [RUN BASH PROFILE]
 
Keep Database Installation File
 
[oracle@dbserver ~]$ cd /u01/app/oracle/product/19.0.0/db_home

Unzip Database Installation File
 
[oracle@dbserver ~]$ unzip LINUX.X64_193000_db_home.zip
 
Install software only
 
[oracle@dbserver db_home]$ ./runInstaller
 
 
OPTIONAL
 
If WE DO NOT set .bash_profile

[oracle@dbserver ~]$ . oraenv
 
v  maxcdb
v  /u01/app/oracle/product/19.0.0/db_home
 
 
NETMGR | NETCA
 
Listeners: 

Database services

v  Maxcdb
v  maxpdb
 
Service naming [TNS]:
 
Net Service Name: maxcdb
TCP/IP (internet protocol)
Host Name : dbserver/ip address 
Port : 1521
Service Name : maxcdb
Connection Type : Dedicated Server
 
Net Service Name : maxpdb
TCP/IP (internet protocol)
Host Name : dbserver/ip address 
Port : 1521
Service Name : maxpdb
Connection Type : Dedicated Server
              
[oracle@dbserver ~]$ lsnrctl start
[oracle@dbserver ~]$ dbca
 
Database creation 
 
v  maxcdb
v  maxpdb
 
Check database is fully installed
 
[oracle@dbserver ~]$ cat /etc/oratab
 
¥  Check Process
 
[oracle@dbserver ~]$ ps -ef | grep smon
[oracle@dbserver ~]$ ps -ef | grep pmon
[oracle@dbserver ~]$ ps -ef | grep maxcdb
 
 
¥  mEmOrY SIZE DeFaULT -- OPTIONAL
 
[root@dbserver ~]$ vi /etc/fstab
 
v  tmpfs         /dev/shm        tmpfs   defaults,size=8g        0 0
 
[root@dbserver ~]$ mount -o remount /dev/shm/