Oracle Database 19c (19.17.0.0) Single 사일런트 모드 설치

https://devcami.tistory.com/24

리눅스 설치과정

Oracle Linux 7.9 OS 설치 / VirtualBox / NAT SSH 접속 설정

	OS / Oracle 환경
EDITION	EE
RAC	SINGLE
VERSION	Oracle 19c
PATCH	19.17.0.0
SERVER	Linux 7.9 (5.4.17-2102.201.3.el7uek.x86_64)
이슈 사항	이기종 DB간 호환성 테스트 (Tibero <-> ORACLE) // ODBC 사용

오라클 설치 ㄱㅂㅈㄱ

 

OS 사전 셋팅

 

설치내역 확인

[root@localhost ~]# cat /etc/oracle-release
Oracle Linux Server release 7.9
[root@localhost ~]# cat /etc/redhat-release
Red Hat Enterprise Linux Server release 7.9 (Maipo)
[root@localhost ~]# uname -r
5.4.17-2102.201.3.el7uek.x86_64

리눅스 설정 변경

- host 변경

[root@localhost ~]# vi /etc/hosts

------------------------- 추가
10.0.2.15 tibero
-------------------------

[root@localhost ~]# hostname
localhost.localdomain
[root@localhost ~]# hostnamectl status
   Static hostname: localhost.localdomain
         Icon name: computer-vm
           Chassis: vm
        Machine ID: e7a72f6744bda547b5e2b84634fd9a12
           Boot ID: 89bcbb9fa89e4d5abc1cd05dc5edf0cf
    Virtualization: kvm
  Operating System: Oracle Linux Server 7.9
       CPE OS Name: cpe:/o:oracle:linux:7:9:server
            Kernel: Linux 5.4.17-2102.201.3.el7uek.x86_64
      Architecture: x86-64
[root@localhost ~]# hostnamectl set-hostname tibero
[root@localhost ~]# hostnamectl status
   Static hostname: tibero
         Icon name: computer-vm
           Chassis: vm
        Machine ID: e7a72f6744bda547b5e2b84634fd9a12
           Boot ID: 89bcbb9fa89e4d5abc1cd05dc5edf0cf
    Virtualization: kvm
  Operating System: Oracle Linux Server 7.9
       CPE OS Name: cpe:/o:oracle:linux:7:9:server
            Kernel: Linux 5.4.17-2102.201.3.el7uek.x86_64
      Architecture: x86-64

- 커널 파라미터 확인

[TIBERO|root:/u01/app/oraInventory]> vi /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

[TIBERO|root:/u01/app/oraInventory]> vi /etc/security/limits.d/oracle-database-preinstall-19c.conf

# oracle-database-preinstall-19c setting for nofile soft limit is 1024
oracle   soft   nofile    1024

# oracle-database-preinstall-19c setting for nofile hard limit is 65536
oracle   hard   nofile    65536

# oracle-database-preinstall-19c setting for nproc soft limit is 16384
# refer orabug15971421 for more info.
oracle   soft   nproc    16384

# oracle-database-preinstall-19c setting for nproc hard limit is 16384
oracle   hard   nproc    16384

# oracle-database-preinstall-19c setting for stack soft limit is 10240KB
oracle   soft   stack    10240

# oracle-database-preinstall-19c setting for stack hard limit is 32768KB
oracle   hard   stack    32768

# oracle-database-preinstall-19c setting for memlock hard limit is maximum of 128GB on x86_64 or 3GB on x86 OR 90 % of RAM
oracle   hard   memlock    134217728

# oracle-database-preinstall-19c setting for memlock soft limit is maximum of 128GB on x86_64 or 3GB on x86 OR 90% of RAM
oracle   soft   memlock    134217728

# oracle-database-preinstall-19c setting for data soft limit is 'unlimited'
oracle   soft   data    unlimited

# oracle-database-preinstall-19c setting for data hard limit is 'unlimited'
oracle   hard   data    unlimited

// 확인
[TIBERO|root:/u01/app/oraInventory]> ulimit -Sn
1024
[TIBERO|root:/u01/app/oraInventory]> ulimit -Hn
4096
[TIBERO|root:/u01/app/oraInventory]> ulimit -Su
31661
[TIBERO|root:/u01/app/oraInventory]> ulimit -Hu
31661
[TIBERO|root:/u01/app/oraInventory]> ulimit -Ss
8192
[TIBERO|root:/u01/app/oraInventory]> ulimit -Hs
unlimited

- Selinux mode를 Permissive로 변경

*SELinux : 관리자가 시스템 액세스 권한을 제어할 수 있는 리눅스 보안 아키텍처

- When using SELINUX=enforcing, SELinux policy is enforced, and SELinux denies access based on SELinux policy rules. Denial messages are logged. - When using SELINUX=permissive, SELinux policy is not enforced. SELinux does not deny access, but denials are logged for actions that would have been denied if running SELinux in enforcing mode. - When using SELINUX=disabled, SELinux is disabled, the SELinux module is not registered with the Linux kernel, and only DAC rules are used.

[root@localhost ~]# vi /etc/selinux/config
------------------------------------------------------------
#SELINUX=enforcing
SELINUX=permissive
------------------------------------------------------------
[root@localhost ~]# setenforce permissive //바로 적용

- temp 재설정

[root@localhost ~]# df -h
Filesystem           Size  Used Avail Use% Mounted on
tmpfs                3.9G     0  3.9G   0% /dev/shm


[root@localhost ~]# vi /etc/fstab
------------------------------------------------------------ 추가
tmpfs                   /dev/shm                tmpfs   size=8g         0 0
------------------------------------------------------------
[root@localhost ~]# mount -o remount /dev/shm
[root@localhost ~]# df -h
Filesystem           Size  Used Avail Use% Mounted on
tmpfs                8.0G     0  8.0G   0% /dev/shm

 

- 프로세스 정리

[TIBERO|root:/run/media]> systemctl stop bluetooth.service
[TIBERO|root:/run/media]> systemctl disable bluetooth.service
Removed symlink /etc/systemd/system/dbus-org.bluez.service.
Removed symlink /etc/systemd/system/bluetooth.target.wants/bluetooth.service.

[TIBERO|root:/run/media]> systemctl stop firewalld
[TIBERO|root:/run/media]> systemctl disable firewalld
Removed symlink /etc/systemd/system/multi-user.target.wants/firewalld.service.
Removed symlink /etc/systemd/system/dbus-org.fedoraproject.FirewallD1.service.

[TIBERO|root:/run/media]> systemctl stop chronyd
[TIBERO|root:/run/media]> systemctl disable chronyd

[TIBERO|root:/run/media]> systemctl stop ntpdate
[TIBERO|root:/run/media]> systemctl disable ntpdate

[TIBERO|root:/run/media]> systemctl stop avahi-daemon
Warning: Stopping avahi-daemon.service, but it can still be activated by:
  avahi-daemon.socket
[TIBERO|root:/run/media]> systemctl disable avahi-daemon
Removed symlink /etc/systemd/system/multi-user.target.wants/avahi-daemon.service.
Removed symlink /etc/systemd/system/sockets.target.wants/avahi-daemon.socket.
Removed symlink /etc/systemd/system/dbus-org.freedesktop.Avahi.service.

[TIBERO|root:/run/media]> systemctl stop libvirtd
[TIBERO|root:/run/media]> systemctl disable libvirtd.service
Removed symlink /etc/systemd/system/multi-user.target.wants/libvirtd.service.
Removed symlink /etc/systemd/system/sockets.target.wants/virtlogd.socket.
Removed symlink /etc/systemd/system/sockets.target.wants/virtlockd.socket.

- 그룹 및 유저 생성 / 패스워드 등록

[TIBERO|root:/root]> groupadd dba
[TIBERO|root:/root]> useradd -g dba -G dba oracle
[TIBERO|root:/root]> passwd oracle
Changing password for user oracle.
New password: 
Retype new password: 
passwd: all authentication tokens updated successfully.

- 설치경로 생성 및 오라클 권한 부여

[TIBERO|root:/root]> mkdir -p /u01/app/oracle/product/19.17.0.0/dbhome_1
[TIBERO|root:/root]> mkdir -p /u01/media/engine
[TIBERO|root:/root]> mkdir -p /u01/media/patch
[TIBERO|root:/root]> mkdir -p /u01/media/rpm
[TIBERO|root:/root]> mkdir -p /u01/app/oraInventory
[TIBERO|root:/root]> chown -R oracle:dba /u01
[TIBERO|root:/root]> chmod -R 775 /u01

- 패키지 설치

[TIBERO|root:/root]> cd /u01/media/rpm
[TIBERO|root:/u01/media/rpm]> ls -al
total 924
drwxrwxr-x. 2 oracle dba    4096 Feb  7 08:15 .
drwxrwxr-x. 6 oracle dba      54 Feb  7 08:13 ..
-rw-r--r--. 1 root   root 903336 Feb  7 08:15 ksh-20120801-142.0.1.el7.x86_64.rpm
-rw-r--r--. 1 root   root  12624 Feb  7 08:15 libaio-devel-0.3.109-13.el7.x86_64.rpm
-rw-r--r--. 1 root   root  19552 Feb  7 08:15 oracle-database-preinstall-19c-1.0-2.el7.x86_64.rpm

[TIBERO|root:/u01/media/rpm]> rpm -ivh ksh-20120801-142.0.1.el7.x86_64.rpm 
warning: ksh-20120801-142.0.1.el7.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
Preparing...                          ################################# [100%]
Updating / installing...
   1:ksh-20120801-142.0.1.el7         ################################# [100%]
[TIBERO|root:/u01/media/rpm]> rpm -ivh libaio-devel-0.3.109-13.el7.x86_64.rpm 
warning: libaio-devel-0.3.109-13.el7.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
Preparing...                          ################################# [100%]
Updating / installing...
   1:libaio-devel-0.3.109-13.el7      ################################# [100%]
[TIBERO|root:/u01/media/rpm]> rpm -ivh oracle-database-preinstall-19c-1.0-2.el7.x86_64.rpm 
warning: oracle-database-preinstall-19c-1.0-2.el7.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
Preparing...                          ################################# [100%]
Updating / installing...
   1:oracle-database-preinstall-19c-1.################################# [100%]

- bash_profile 설정

// root

export PATH
export TZ=Asia/Seoul
export GRID_HOME=/u01/app/oracle/product/19.17.0.0/dbhome_1
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/product/19.17.0.0/dbhome_1

export ORACLE_SID=TIBERO

export PATH=$PATH:$ORACLE_HOME/bin:$GRID_HOME/bin

export PS1='[$ORACLE_SID|\u:$PWD]> '
set -o vi
stty erase ^H

alias ss='sqlplus / as sysdba'
alias ob='cd $ORACLE_BASE'
alias oh='cd $ORACLE_HOME'
alias dbs='cd $ORACLE_HOME/dbs'
alias net='cd $GRID_HOME/network/admin'
alias ..='. ~/.bash_profile'
alias ...='vi  ~/.bash_profile'
alias ora="su - oracle"

// oracle

export PATH
export TZ=Asia/Seoul
export GRID_HOME=/u01/app/oracle/product/19.17.0.0/dbhome_1
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/product/19.17.0.0/dbhome_1

export ORACLE_SID=TIBERO

export PATH=$PATH:$ORACLE_HOME/bin:$GRID_HOME/bin

export PS1='[$ORACLE_SID|\u:$PWD]> '
set -o vi
stty erase ^H

alias ss="sqlplus / as sysdba"
alias oh="cd $ORACLE_HOME"
alias ob="cd $ORACLE_BASE"
alias net="cd $ORACLE_HOME/network/admin"
alias ..='. ~/.bash_profile'
alias ...='vi  ~/.bash_profile'
export NLS_DATE_FORMAT='YYYY/MM/DD HH24:MI:SS'

 

DB 엔진 (software) 설치

oracle user

1. 파일 압축 해제

[TIBERO|oracle:/home/oracle]> cd /u01/media/engine/
[TIBERO|oracle:/u01/media/engine]> ls -al
total 2987996
drwxrwxr-x. 2 oracle dba          42 Feb  7 08:23 .
drwxrwxr-x. 5 oracle dba          44 Feb  7 08:25 ..
-rw-r--r--. 1 root   root 3059705302 Feb  7 08:25 LINUX.X64_193000_db_home.zip
[TIBERO|oracle:/u01/media/engine]> unzip LINUX.X64_193000_db_home.zip -d $ORACLE_HOME

2. response file 수정

[TIBERO|oracle:/u01/app/oracle/product/19.17.0.0/dbhome_1/install/response]> ls -al
total 24
drwxr-xr-x.  2 oracle dba    28 Apr 18  2019 .
drwxr-xr-x. 10 oracle dba  4096 Apr 18  2019 ..
-rw-r--r--.  1 oracle dba 19932 Feb  6  2019 db_install.rsp
[TIBERO|oracle:/u01/app/oracle/product/19.17.0.0/dbhome_1/install/response]> vi db_install.rsp

// db_install.rsp

oracle.install.option=INSTALL_DB_SWONLY
UNIX_GROUP_NAME=dba
INVENTORY_LOCATION=/u01/app/oraInventory
ORACLE_HOME=/u01/app/oracle/product/19.17.0.0/dbhome_1
ORACLE_BASE=/u01/app/oracle
oracle.install.db.InstallEdition=EE
oracle.install.db.OSDBA_GROUP=dba
oracle.install.db.OSOPER_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
oracle.install.db.rootconfig.executeRootScript=false    => true,false 선택,  false일 경우 Manually 하게 ROOT SCRIPT 실행 
oracle.install.db.rootconfig.configMethod=ROOT        => ROOT, SUDO 중 선택, executeRootScript 설정값이 true 일 경우 선택
oracle.install.db.config.starterdb.type=GENERAL_PURPOSE
oracle.install.db.config.starterdb.SID=TIBERO
oracle.install.db.config.starterdb.characterSet=AL32UTF8

3. 패치파일 준비

[TIBERO|oracle:/u01/media/engine]> cd $ORACLE_HOME
[TIBERO|oracle:/u01/app/oracle/product/19.17.0.0/dbhome_1]> mv $ORACLE_HOME/OPatch $ORACLE_HOME/OPatch_old
[TIBERO|oracle:/u01/media/patch]> ls -al
total 1666080
drwxrwxr-x. 2 oracle dba         87 Feb  7 08:24 .
drwxrwxr-x. 5 oracle dba         44 Feb  7 08:25 ..
-rwxrwxr-x. 1 oracle dba 1580330977 Feb  7 08:25 p34419443_190000_Linux-x86-64.zip
-rwxrwxr-x. 1 oracle dba  125734641 Feb  7 08:24 p6880880_190000_Linux-x86-64.zip
[TIBERO|oracle:/u01/media/patch]> unzip p6880880_190000_Linux-x86-64.zip -d $ORACLE_HOME
[TIBERO|oracle:/u01/media/patch]> $ORACLE_HOME/OPatch/opatch version
OPatch Version: 12.2.0.1.33

OPatch succeeded.

[TIBERO|oracle:/u01/media/patch]> unzip p34419443_190000_Linux-x86-64.zip
[TIBERO|oracle:/u01/media/patch]> ls -al
total 1667524
drwxrwxr-x. 3 oracle dba       4096 Feb  7 09:50 .
drwxrwxr-x. 5 oracle dba         44 Feb  7 08:25 ..
drwxr-xr-x. 5 oracle dba         81 Oct 14 14:25 34419443

4. 사일런트 설치 실행

[TIBERO|oracle:/u01/app/oracle/product/19.17.0.0/dbhome_1]> ./runInstaller -silent -responseFile /u01/app/oracle/product/19.17.0.0/dbhome_1/install/response/db_install.rsp -applyRU /u01/media/patch/34419443
Preparing the home to patch...
Applying the patch /u01/media/patch/34419443/...
Successfully applied the patch.
The log can be found at: /u01/app/oraInventory/logs/InstallActions2023-02-07_09-52-34AM/installerPatchActions_2023-02-07_09-52-34AM.log

Launching Oracle Database Setup Wizard...

The response file for this session can be found at:
 /u01/app/oracle/product/19.17.0.0/dbhome_1/install/response/db_2023-02-07_08-49-51AM.rsp

You can find the log of this install session at:
 /tmp/InstallActions2023-02-07_08-49-51AM/installActions2023-02-07_08-49-51AM.log

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

Execute /u01/app/oraInventory/orainstRoot.sh on the following nodes: 
[tibero]
Execute /u01/app/oracle/product/19.17.0.0/dbhome_1/root.sh on the following nodes: 
[tibero]


Successfully Setup Software.
Moved the install session logs to:
 /u01/app/oraInventory/logs/InstallActions2023-02-07_08-49-51AM
 
 
 // 설치 확인
 [TIBERO|oracle:/u01/app/oracle/product/19.17.0.0/dbhome_1]> ss

SQL*Plus: Release 19.0.0.0.0 - Production on Tue Feb 7 08:59:20 2023
Version 19.17.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.

Connected to an idle instance.

SQL>

 

 

 

리스너 구성

[TIBERO|oracle:/u01/app/oracle/product/19.17.0.0/dbhome_1/assistants/netca]> ls -al
total 28
drwxr-xr-x. 5 oracle dba  101 Feb  7 08:50 .
drwxr-xr-x. 9 oracle dba   93 Apr 17  2019 ..
drwxr-xr-x. 2 oracle dba 4096 Apr 17  2019 doc
drwxr-xr-x. 2 oracle dba 4096 Apr 17  2019 images
drwxr-xr-x. 2 oracle dba   23 Apr 17  2019 jlib
-rwxr-x---. 1 oracle dba   88 Apr 21  2007 netca_deinst.sbs
-rw-r-----. 1 oracle dba 6207 Apr  6  2019 netca.rsp
-rwxr-x---. 1 oracle dba 6601 Sep  2  2017 netca.sbs

[TIBERO|oracle:/u01/app/oracle/product/19.17.0.0/dbhome_1/assistants/netca]> netca -silent -responseFile $ORACLE_HOME/assistants/netca/netca.rsp

Parsing command line arguments:
    Parameter "silent" = true
    Parameter "responsefile" = /u01/app/oracle/product/19.17.0.0/dbhome_1/assistants/netca/netca.rsp
Done parsing command line arguments.
Oracle Net Services Configuration:
Profile configuration complete.
Oracle Net Listener Startup:
    Running Listener Control: 
      /u01/app/oracle/product/19.17.0.0/dbhome_1/bin/lsnrctl start LISTENER
    Listener Control complete.
    Listener started successfully.
Listener configuration complete.
Oracle Net Services configuration successful. The exit code is 0


// 리스너 확인
[TIBERO|oracle:/u01/app/oracle/product/19.17.0.0/dbhome_1/assistants/netca]> lsnrctl status

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 07-FEB-2023 09:02:23

Copyright (c) 1991, 2019, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=tibero)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date                07-FEB-2023 09:02:06
Uptime                    0 days 0 hr. 0 min. 17 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/19.17.0.0/dbhome_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/tibero/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=tibero)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
The listener supports no services
The command completed successfully

 

데이터 베이스 생성 (dbca)

 

[TIBERO|oracle:/u01/app/oracle/product/19.17.0.0/dbhome_1/assistants/dbca]> ls -al
total 36
drwxr-xr-x. 5 oracle dba    62 Feb  7 08:50 .
drwxr-xr-x. 9 oracle dba    93 Apr 17  2019 ..
-rw-r-----. 1 oracle dba 25502 Apr  6  2019 dbca.rsp
drwxr-xr-x. 2 oracle dba  4096 Apr 17  2019 doc
drwxr-xr-x. 2 oracle dba    41 Apr 17  2019 jlib
drwxr-xr-x. 2 oracle dba  4096 Apr 17  2019 templates
[TIBERO|oracle:/u01/app/oracle/product/19.17.0.0/dbhome_1/assistants/dbca]> vi dbca.rsp

// dbca.rsp

gdbName=TIBERO
sid=TIBERO
templateName=General_Purpose.dbc
sysPassword=***
systemPassword=***
characterSet=AL32UTF8
nationalCharacterSet=AL16UTF16
listeners=LISTENER
totalMemory=4096

[TIBERO|oracle:/u01/app/oracle/product/19.17.0.0/dbhome_1/assistants/dbca]>  dbca -silent -createDatabase -responsefile $ORACLE_HOME/assistants/dbca/dbca.rsp
[WARNING] [DBT-06208] The 'SYS' password entered does not conform to the Oracle recommended standards.
   CAUSE: 
a. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9].
b.The password entered is a keyword that Oracle does not recommend to be used as password
   ACTION: Specify a strong password. If required refer Oracle documentation for guidelines.
[WARNING] [DBT-06208] The 'SYSTEM' password entered does not conform to the Oracle recommended standards.
   CAUSE: 
a. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9].
b.The password entered is a keyword that Oracle does not recommend to be used as password
   ACTION: Specify a strong password. If required refer Oracle documentation for guidelines.
Prepare for db operation
10% complete
Copying database files
40% complete
Creating and starting Oracle instance
42% complete
46% complete
50% complete
54% complete
60% complete
Completing Database Creation
66% complete
69% complete
70% complete
Executing Post Configuration Actions
100% complete
Database creation complete. For details check the logfiles at:
 /u01/app/oracle/cfgtoollogs/dbca/TIBERO.
Database Information:
Global Database Name:TIBERO
System Identifier(SID):TIBERO
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/TIBERO/TIBERO.log" for further details.

// delete database
dbca -silent -deleteDatabase -sourceDB TIBERO

 

[TIBERO|oracle:/u01/app/oracle/product/19.17.0.0/dbhome_1]> ss

SQL*Plus: Release 19.0.0.0.0 - Production on Tue Feb 7 10:11:40 2023
Version 19.17.0.0.0

Copyright (c) 1982, 2022, Oracle.  All rights reserved.


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.17.0.0.0

SQL> select instance_name, status from v$instance ;

INSTANCE_NAME	 STATUS
---------------- ------------
TIBERO		 OPEN

SQL> show parameter db_name

NAME				     TYPE	 VALUE
------------------------------------ ----------- ------------------------------
db_name 			     string	 TIBERO

OPatch 확인

[TIBERO|oracle:/u01/app/oracle/product/19.17.0.0/dbhome_1]> cd $ORACLE_HOME/OPatch
[TIBERO|oracle:/u01/app/oracle/product/19.17.0.0/dbhome_1/OPatch]> ./opatch lspatches
34419443;Database Release Update : 19.17.0.0.221018 (34419443)
29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399)

OPatch succeeded.

설치 완료 ~