### 1. Create Groups and Users
[root@localhost ~]# /usr/sbin/groupadd -g 54321 oinstall
[root@localhost ~]# /usr/sbin/groupadd -g 54322 dba
[root@localhost ~]# /usr/sbin/groupadd -g 54323 oper
[root@localhost ~]# /usr/sbin/useradd -u 54321 -g oinstall -G dba,oper oracle
### 2. Create Working Directory and Set Permissions
[root@localhost ~]# mkdir -p /u01/app/oracle/product/19.3.0/db_1
[root@localhost ~]# chown -R oracle:oinstall /u01/
[root@localhost ~]# chmod -R 777 /u01/
### 3. Edit Environment Variables for Oracle User
[oracle@localhost ~]$ vi .bash_profile
export NLS_LANG=”SIMPLIFIED CHINESE_CHINA.AL32UTF8″
#export NLS_LANG=”SIMPLIFIED CHINESE_CHINA.ZHS16GBK”
export LANG=EN_US.UTF-8
export ORACLE_HOME=/u01/app/oracle/product/19.3.0/db_1
export PATH=$PATH:/u01/app/oracle/product/19.3.0/db_1/bin
export ORACLE_SID=GPS
[oracle@localhost ~]$ source .bash_profile
### 4. Modify Kernel Parameters
“`sh
[root@localhost ~]# vi /etc/sysctl.conf
# Maximum number of open files in Linux
fs.file-max = 6815744
# Concurrent threads
kernel.sem = 250 32000 100 128
kernel.shmmni = 4096
kernel.shmall = 1073741824
kernel.shmmax = 8589934592
kernel.panic_on_oops = 1
# Default size of socket protocol receive buffer
net.core.rmem_default = 262144
# Maximum size of socket protocol receive buffer
net.core.rmem_max = 4194304
# Default size of socket protocol send buffer
net.core.wmem_default = 262144
# Maximum size of socket protocol send buffer
net.core.wmem_max = 1048576
# Maximum number of asynchronous IO requests
fs.aio-max-nr = 1048576
## Specify the range of ports that the system can open
net.ipv4.ip_local_port_range = 9000 65500
[root@localhost ~]# sysctl –system
5. Install Required Packages
yum -y install bc gcc gcc-c++ binutils compat-libcap1 compat-libstdc++ dtrace-modules dtrace-modules-headers ace-ctf-devel libX11 libXau libXi libXtst libXrender libXrender-devel libgcc librdmacm-devel libstdc++ libstdc++-devel
yum -y install libxcb make smartmontools sysstat
6. Download and Unzip Installation Package
[root@localhost ~]# su – oracle
[oracle@localhost ~]$ unzip LINUX.X64_193000_db_home.zip -d /u01/app/oracle/product/19.3.0/db_1/
7. Install Graphical Interface Requirements
[root@localhost ~]# yum -y install xorg-x11-apps
[root@localhost ~]# export DISPLAY=IP_of_SSH_machine:0.0
Install Xmanager on the SSH machine, refer to this link
[root@localhost ~]# xclock # A pop-up interface indicates success
[root@localhost ~]# yum install -y xorg-x11-server-utils-7.7-20.el7.x86_64
[root@localhost ~]# yum -y install xdpyinfo
# Before executing Oracle graphical installation
[root@localhost ~]# xhost +
access control disabled, clients can connect from any host
[root@localhost ~]# su – oracle
[oracle@localhost ~]$ export DISPLAY=IP_of_SSH_machine:0.0
[oracle@localhost ~]$ xdpyinfo
8. Install Oracle
[oracle@localhost db_1]./runInstaller
For installation process, refer to this link
9. Configure Remote Connection
“`
su – oracle
cd /u01/app/oracle/product/19.3.0/db_1/network/admin/
vi listener.ora vi tnsnames.ora Adjust HOST IP to the remote input IP address
Switch to sqlplus operation sqlplus /nolog — or log in as admin sqlplus / as sysdba
You will be prompted Connected. (Connection successful), displaying SQL> :
Stop listener: lsnrctl stop;
Stop service (instance): shutdown immediate;
Start service (instance): startup;
Start listener: lsnrctl start;