一、系统环境

操作系统为最小化安装
[root@oracledb ~]# cat /etc/os-release 
NAME="openEuler"
VERSION="22.03 LTS"
ID="openEuler"
VERSION_ID="22.03"
PRETTY_NAME="openEuler 22.03 LTS"
ANSI_COLOR="0;31"

二、RPM方式安装ORACLE19C

1，系统环境参数配置

数据库安装包、补丁文件放在/soft
[root@oracledb ~]# mkdir /soft
[root@oracledb ~]# cd /soft
[root@oracledb soft]# ll
total 7.6G
-rw-r--r--. 1 root root  18K Apr 24 16:39 compat-libcap1-1.10-7.el7.x86_64.rpm
-rw-r--r--. 1 root root 191K Apr 24 16:40 compat-libstdc++-33-3.2.3-72.el7.x86_64.rpm
-rw-r--r--. 1 root root 2.9G Apr 24 20:20 LINUX.X64_193000_db_home.zip
-rw-r--r--. 1 root root 2.6G Apr 24 19:30 oracle-database-ee-19c-1.0-1.x86_64.rpm
-rw-r--r--. 1 root root  18K Apr 24 16:36 oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm
-rw-r--r--. 1 root root 2.2G Apr 24 07:58 p37642901_190000_Linux-x86-64.zip
-rw-r--r--. 1 root root  70M Apr 23 16:03 p6880880_190000_Linux-x86-64.zip
创建脚本自动配置系统环境参数
[root@oracledb soft]# vi system-configure_RPM.sh
#!/bin/bash


#1.关闭防火墙
systemctl stop firewalld
systemctl disable firewalld

#2.关闭selinux
sed -i 's/SELINUX=enforcing/SELINUX=disabled/g' /etc/selinux/config
setenforce 0

#3.编辑yum源
mount /dev/cdrom /mnt/
cd /etc/yum.repos.d/
rm -rf ./*
echo '
[base]
name=base
baseurl=file:///mnt/
enable=1
gpgcheck=0' >> openEuler.repo
yum clean all

#4.安装包
yum install -y libnsl* 
yum install -y bc 
yum install -y compat-libcap1* 
yum install -y compat-libcap* 
yum install -y binutils  
yum install -y compat-libstdc++-33  
yum install -y elfutils-libelf  
yum install -y elfutils-libelf-devel  
yum install -y gcc  
yum install -y gcc-c++  
yum install -y glibc-2.5  
yum install -y glibc-common  
yum install -y glibc-devel  
yum install -y glibc-headers  
yum install -y ksh 
yum install -y libaio  
yum install -y libaio-devel  
yum install -y libgcc  
yum install -y libstdc++  
yum install -y libstdc++-devel  
yum install -y make  
yum install -y sysstat  
yum install -y unixODBC  
yum install -y unixODBC-devel 
yum install -y binutils* 
yum install -y compat-libstdc* 
yum install -y elfutils-libelf* 
yum install -y gcc* 
yum install -y glibc* 
yum install -y ksh* 
yum install -y libaio* 
yum install -y libgcc* 
yum install -y libstdc* 
yum install -y make* 
yum install -y sysstat* 
yum install -y libXp* 
yum install -y glibc-kernheaders  
yum install -y unzip 
yum -y install net-tools libaio-devel sysstat xorg-x11-utils xorg-x11-xauth ksh libstdc++-devel smartmontools /soft/compat-libcap1-1.10-7.el7.x86_64.rpm /soft/compat-libstdc++-33-3.2.3-72.el7.x86_64.rpm

#5.编辑hosts文件
echo "192.168.244.128 oracledb" >> /etc/hosts

#6.修改linux内核文件
echo '
kernel.shmmax = 7730941132
kernel.shmall = 1887436
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048586
fs.file-max = 6815744
net.ipv4.tcp_max_tw_buckets = 6000
net.ipv4.ip_local_port_range = 9000 65500
net.ipv4.tcp_tw_recycle = 0
net.ipv4.tcp_tw_reuse = 1
#net.core.somaxconn = 262144
net.core.netdev_max_backlog = 262144
net.ipv4.tcp_max_orphans = 262144
net.ipv4.tcp_max_syn_backlog = 262144
net.ipv4.tcp_synack_retries = 2
net.ipv4.tcp_syn_retries = 1
net.ipv4.tcp_fin_timeout = 1
net.ipv4.tcp_keepalive_time = 30
net.ipv4.tcp_keepalive_probes = 6
net.ipv4.tcp_keepalive_intvl = 5
net.ipv4.tcp_timestamps = 0
fs.aio-max-nr = 1048576
net.ipv4.conf.all.rp_filter = 2
net.ipv4.conf.default.rp_filter = 2' >> /etc/sysctl.conf
sysctl -p

#7.修改linux限制文件
echo '
oracle   soft   nofile    65536
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' >> /etc/security/limits.conf

#8.修改/etc/pam.d/login文件
echo '
session required pam_limits.so' >> /etc/pam.d/login
#9.修改环境变量
echo '
if [ $USER = "oracle" ]; then
   if [ $SHELL = "/bin/ksh" ]; then
      ulimit -p 16384
      ulimit -n 65536
      else
      ulimit -u 16384 -n 65536
   fi
fi' >> /etc/profile
source /etc/profile
[root@oracledb soft]# chmod +x system-configure_RPM.sh
[root@oracledb soft]# ./system-configure_RPM.sh

2，安装preinstall.rpm

[root@oracledb soft]# rpm -ivh --nodeps oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm
warning: oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
Verifying...                          ################################# [100%]
Preparing...                          ################################# [100%]
Updating / installing...
   1:oracle-database-preinstall-19c-1.################################# [100%]
--用RPM方式安装的时候会创建oracle用户和组，oracle用户的环境变量配置为空--
[root@oracledb soft]# vi /home/oracle/.bash_profile
# Source /root/.bashrc if user has one
[ -f ~/.bashrc ] && . ~/.bashrc
export TMP=/tmp
export TMPDIR=$TMP
export ORACLE_SID=orcl
export ORACLE_BASE=/opt/oracle
export ORACLE_HOME=$ORACLE_BASE/product/19c/dbhome_1
export INVENTORY_LOCATION=/opt/oracle/oraInventory
export TNS_ADMIN=$ORACLE_HOME/network/admin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
#export NLS_LANG="SIMPLIFIED CHINESE_CHINA.ZHS16GBK"
export NLS_DATE_FORMAT="YYYY-MM-DD HH24:MI:SS"
export PATH=$ORACLE_HOME/bin:/bin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/X11R6/bin:$PATH:$HOME/bin：$ORACLE_HOME/OPatch
umask 022
[root@oracledb soft]# source /home/oracle/.bash_profile

3，安装ORACLE 19C

[root@oracledb soft]# rpm -ivh oracle-database-ee-19c-1.0-1.x86_64.rpm
warning: oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
Verifying...                          ################################# [100%]
Preparing...                          ################################# [100%]
Updating / installing...
   1:oracle-database-preinstall-19c-1.################################# [100%]
[root@oracledb soft]# rpm -ivh oracle-database-ee-19c-1.0-1.x86_64.rpm
warning: oracle-database-ee-19c-1.0-1.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
Verifying...                          ################################# [100%]
Preparing...                          ################################# [100%]
Updating / installing...
   1:oracle-database-ee-19c-1.0-1     ################################# [100%]
[INFO] Executing post installation scripts...
[INFO] Oracle home installed successfully and ready to be configured.
To configure a sample Oracle Database you can execute the following service configuration script as root: /etc/init.d/oracledb_ORCLCDB-19c configure
安装完成，修改初始化配置文件
[root@oracledb soft]# vi /etc/init.d/oracledb_ORCLCDB-19c
根据实际情况修改sid、字符集等
export ORACLE_HOME=/opt/oracle/product/19c/dbhome_1

export ORACLE_VERSION=19c
export ORACLE_SID=orcl
export TEMPLATE_NAME=General_Purpose.dbc
export CHARSET=ZHS16GBK
export PDB_NAME=orcl
export LISTENER_NAME=LISTENER
export NUMBER_OF_PDBS=1
export CREATE_AS_CDB=false
根据实际情况修改监听端口及数据文件路径
[root@oracledb soft]# vi /etc/sysconfig/oracledb_ORCLCDB-19c.conf
# LISTENER_PORT: Database listener
LISTENER_PORT=1521

# ORACLE_DATA_LOCATION: Database oradata location
ORACLE_DATA_LOCATION=/oradata
[root@oracledb soft]# cp /etc/sysconfig/oracledb_ORCLCDB-19c.conf /etc/sysconfig/oracledb_orcl-19c.conf
[root@oracledb ~]# mkdir /archivelog
[root@oracledb ~]# chown -R oracle:oinstall /archivelog/
[root@oracledb ~]# mkdir /oradata
[root@oracledb ~]# chown -R oracle:oinstall /oradata/
[root@oracledb ~]# chmod -R 755 /oradata/

4，初始化实例

root@oracledb soft]# /etc/init.d/oracledb_ORCLCDB-19c configure
Configuring Oracle Database orcl.
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
70% complete
Executing Post Configuration Actions
100% complete
Database creation complete. For details check the logfiles at:
 /opt/oracle/cfgtoollogs/dbca/orcl.
Database Information:
Global Database Name:orcl
System Identifier(SID):orcl
Look at the log file "/opt/oracle/cfgtoollogs/dbca/orcl/orcl.log" for further details.

Database configuration completed successfully. The passwords were auto generated, you must change them by connecting to the database using 'sqlplus / as sysdba' as the oracle user.

5，数据库基本配置

（1），开启归档

[oracle@oracledb ~]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Fri Apr 25 17:45:38 2025
Version 19.3.0.0.0

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


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

SQL> alter system set log_archive_dest_1='location=/archivelog';
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.

Total System Global Area 2332031560 bytes
Fixed Size                  8899144 bytes
Variable Size             520093696 bytes
Database Buffers         1795162112 bytes
Redo Buffers                7876608 bytes
Database mounted.
SQL> alter database archivelog;

Database altered.

SQL> alter database open;

Database altered.

SQL> alter system switch logfile;

System altered.

SQL> alter system switch logfile;

System altered.

SQL> alter system switch logfile;

（2），最佳实践参数

SQL> create pfile='/home/oracle/orclpfile.ora' from spfile;

alter system set "_b_tree_bitmap_plans"=false            sid='*'      scope=spfile;
alter system set "_bloom_filter_enabled"=FALSE        sid='*'         scope=spfile;
alter system set "_cleanup_rollback_entries"=5000        sid='*'      scope=spfile;
alter system set "_datafile_open_errors_crash_instance"=false sid='*' scope=spfile;
alter system set "_datafile_write_errors_crash_instance"=false sid='*' scope=spfile;
alter system set "_cursor_obsolete_threshold" =100   sid='*'          scope=spfile;
alter system set "_db_block_numa"=1       sid='*'    scope=spfile;
alter system set "_drop_stat_segment"=1    sid='*'     scope=spfile;
alter system set "_enable_pdb_close_abort"=true    sid='*'  scope=spfile;
alter system set "_enable_pdb_close_noarchivelog"=false  sid='*'  scope=spfile;
alter system set "_fix_control"='8611462:OFF'  sid='*'  scope=spfile;
alter system set "_gc_policy_time"=0   sid='*'   scope=spfile;
alter system set "_ges_direct_free_res_type"=CTARAHDXBB  sid='*'  scope=spfile;
alter system set "_index_partition_large_extents"=FALSE sid='*' scope=spfile;
alter system set "_keep_remote_column_size"=TRUE sid='*' scope=spfile;
alter system set "_ktb_debug_flags"=8   sid='*'  scope=spfile;
alter system set "_library_cache_advice"=false   sid='*'  scope=spfile;
alter system set "_memory_imm_mode_without_autosga"=FALSE  sid='*' scope=spfile;
alter system set "_optimizer_ads_use_result_cache" = FALSE sid='*' scope=spfile;
alter system set "_optimizer_aggr_groupby_elim"=FALSE  sid='*' scope=spfile;
alter system set "_optimizer_dsdir_usage_control"=0  sid='*' scope=spfile;
alter system set "_optimizer_adaptive_cursor_sharing"=false sid='*' scope=spfile;
alter system set "_optimizer_extended_cursor_sharing"=none sid='*' scope=spfile;
alter system set "_optimizer_extended_cursor_sharing_rel"=none sid='*' scope=spfile;
alter system set "_optimizer_mjc_enabled"=FALSE  sid='*' scope=spfile;
alter system set "_optimizer_null_accepting_semijoin"=false sid='*' scope=spfile;
alter system set "_optimizer_null_aware_antijoin"=false  sid='*' scope=spfile;
alter system set "_optimizer_reduce_groupby_key"=FALSE  sid='*' scope=spfile;
alter system set "_optimizer_unnest_scalar_sq"=false sid='*' scope=spfile;
alter system set "_optimizer_use_feedback"=false  sid='*' scope=spfile;
alter system set "_part_access_version_by_number"=FALSE sid='*' scope=spfile;
alter system set "_partition_large_extents"=FALSE sid='*' scope=spfile;
alter system set "_partition_large_extents"=FALSE sid='*'  scope=spfile;
alter system set "_px_use_large_pool"=true  sid='*'  scope=spfile;
alter system set "_report_capture_cycle_time"=0  sid='*' scope=spfile;
alter system set "_rollback_segment_count"=2000 sid='*' scope=spfile;
alter system set "_serial_direct_read"=never sid='*' scope=spfile;
alter system set "_sort_elimination_cost_ratio"=1 sid='*' scope=spfile;
alter system set "_sql_plan_directive_mgmt_control"=0  sid='*' scope=spfile;
alter system set "_sys_logon_delay"=0  sid='*' scope=spfile;
alter system set "_undo_autotune"=false sid='*'  scope=spfile;
alter system set "_use_adaptive_log_file_sync"=FALSE sid='*'  scope=spfile;
alter system set "_use_single_log_writer"=true  sid='*' scope=spfile;
alter system set "_ksxp_ipclw_enabled"=true  sid='*' scope=spfile;
alter system set "_shared_pool_reserved_pct"=20  sid='*' scope=spfile;
alter system set audit_trail=none   sid='*'  scope=spfile;
alter system set autotask_max_active_pdbs=10  sid='*' scope=spfile;
alter system set cell_offload_processing=false  sid='*'  scope=spfile;
alter system set control_file_record_keep_time=31 sid='*' scope=spfile;
alter system set db_cache_advice=off  sid='*'  scope=spfile;
alter system set db_files=5000   sid='*'  scope=spfile;
alter system set deferred_segment_creation=false  sid='*'  scope=spfile;
alter system set enable_ddl_logging=true  sid='*' scope=spfile;
alter   system   set   event='28401   trace   name   context   forever,level   1','60025   trace   name   contextforever','10943   trace   name   context   forever,level   2097152','10949   trace   name   context   forever,level1','10262 trace name context forever, level 90000' sid='*' scope=spfile;
alter system set filesystemio_options=setall  sid='*' scope=spfile;
alter system set max_shared_servers=0  sid='*'  scope=spfile;
alter system set memory_target=0  sid='*'  scope=spfile;alter system set open_cursors=3000  sid='*'  scope=spfile；
alter system set open_links =40   sid='*'  scope=spfile;alter system set open_links_per_instance =40   sid='*'  scope=spfile;
alter system set optimizer_adaptive_plans=FALSE   sid='*'  scope=spfile;
alter system set parallel_force_local=true sid='*'  scope=spfile;
alter system set pga_aggregate_limit=0 sid='*'  scope=spfile;
alter system set resource_manager_plan='FORCE:' sid='*'  scope=spfile;
alter system set result_cache_max_size=0  sid='*'  scope=spfile;
alter system set sec_max_failed_login_attempts=100  sid='*'  scope=spfile;
alter system set session_cached_cursors=300 sid='*' scope=spfile;
alter system set shared_servers=0    sid='*' scope=spfile;
alter system set temp_undo_enabled=false sid='*'  scope=spfile;
alter system set undo_retention=10800  sid='*' scope=spfile;

6，更新补丁

（1），更新OPatch

[oracle@oracledb ~]$ cd $ORACLE_HOME
[oracle@oracledb ~]$ mv OPatch/ OPatch.bak
[oracle@oracledb ~]$ unzip /soft/p6880880_190000_Linux-x86-64.zip -d /opt/oracle/product/19c/dbhome_1/
[oracle@oracledb dbhome_1]$ OPatch/opatch version
OPatch Version: 12.2.0.1.46

OPatch succeeded.

（2），补丁检测

[oracle@oracledb dbhome_1]$ cp /soft/p37642901_190000_Linux-x86-64.zip /home/oracle
[oracle@oracledb dbhome_1]$ cd /home/oracle/
[oracle@oracledb ~]$ unzip p37642901_190000_Linux-x86-64.zip 
[oracle@oracledb ~]$ cd 37642901/
[oracle@oracledb 37642901]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 12.2.0.1.46
Copyright (c) 2025, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /opt/oracle/product/19c/dbhome_1
Central Inventory : /opt/oracle/oraInventory
   from           : /opt/oracle/product/19c/dbhome_1/oraInst.loc
OPatch version    : 12.2.0.1.46
OUI version       : 12.2.0.7.0
Log file location : /opt/oracle/product/19c/dbhome_1/cfgtoollogs/opatch/opatch2025-04-25_17-53-29PM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.
检测通过

（3），更新补丁

[oracle@oracledb 37642901]$ lsnrctl stop
[oracle@oracledb 37642901]$ sqlplus / as sysdba
SQL> shutdown immediate
[oracle@oracledb 37642901]$ opatch apply
Oracle Interim Patch Installer version 12.2.0.1.46
Copyright (c) 2025, Oracle Corporation.  All rights reserved.


Oracle Home       : /opt/oracle/product/19c/dbhome_1
Central Inventory : /opt/oracle/oraInventory
   from           : /opt/oracle/product/19c/dbhome_1/oraInst.loc
OPatch version    : 12.2.0.1.46
OUI version       : 12.2.0.7.0
Log file location : /opt/oracle/product/19c/dbhome_1/cfgtoollogs/opatch/opatch2025-04-25_17-54-59PM_1.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   37642901  

Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/opt/oracle/product/19c/dbhome_1')


Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...

Applying interim patch '37642901' to OH '/opt/oracle/product/19c/dbhome_1'
ApplySession: Optional component(s) [ oracle.network.gsm, 19.0.0.0.0 ] , [ oracle.assistants.asm, 19.0.0.0.0 ] , [ oracle.crypto.rsf, 19.0.0.0.0 ] , [ oracle.pg4appc, 19.0.0.0.0 ] , [ oracle.pg4mq, 19.0.0.0.0 ] , [ oracle.oraolap.mgmt, 19.0.0.0.0 ] , [ oracle.precomp.companion, 19.0.0.0.0 ] , [ oracle.rdbms.ic, 19.0.0.0.0 ] , [ oracle.rdbms.tg4db2, 19.0.0.0.0 ] , [ oracle.sdo.companion, 19.0.0.0.0 ] , [ oracle.tfa, 19.0.0.0.0 ] , [ oracle.ons.cclient, 19.0.0.0.0 ] , [ oracle.options.olap, 19.0.0.0.0 ] , [ oracle.ons.eons.bwcompat, 19.0.0.0.0 ] , [ oracle.options.olap.api, 19.0.0.0.0 ] , [ oracle.network.cman, 19.0.0.0.0 ] , [ oracle.rdbms.tg4sybs, 19.0.0.0.0 ] , [ oracle.rdbms.tg4tera, 19.0.0.0.0 ] , [ oracle.oid.client, 19.0.0.0.0 ] , [ oracle.ldap.ztk, 19.0.0.0.0 ] , [ oracle.java.sqlj.sqljruntime, 19.0.0.0.0 ] , [ oracle.net.cman, 19.0.0.0.0 ] , [ oracle.xdk.companion, 19.0.0.0.0 ] , [ oracle.rdbms.tg4msql, 19.0.0.0.0 ] , [ oracle.rdbms.tg4ifmx, 19.0.0.0.0 ] , [ oracle.jdk, 1.8.0.191.0 ] , [ oracle.jdk, 1.8.0.391.11 ]  not present in the Oracle Home or a higher version is found.
***以上提示不知道对数据库后续使用是否有影响***


Patching component oracle.jdk, 1.8.0.201.0...
Patch 37642901 successfully applied.
Sub-set patch [29517242] has become inactive due to the application of a super-set patch [37642901].
Please refer to Doc ID 2161861.1 for any possible further required actions.
Log file location: /opt/oracle/product/19c/dbhome_1/cfgtoollogs/opatch/opatch2025-04-25_17-54-59PM_1.log

OPatch succeeded.

[oracle@oracledb ~]$ opatch lspatches
37642901;Database Release Update : 19.27.0.0.250415 (37642901)
29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399)

OPatch succeeded.
[oracle@oracledb 37642901]$ sqlplus / as sysdba
SQL> startup
SQL> set lines 200
SQL> col STATUS for a12
SQL> col ACTION for a10
SQL> col DESCRIPTION for a55
SQL> col ACTION_TIME for a32 
SQL> select patch_id,action,status,action_time,description from dba_registry_sqlpatch;
 PATCH_ID ACTION     STATUS       ACTION_TIME                      DESCRIPTION
---------- ---------- ------------ -------------------------------- -------------------------------------------------------
  29517242 APPLY      SUCCESS      25-APR-25 05.41.49.101922 PM     Database Release Update : 19.3.0.0.190416 (29517242)

[oracle@oracledb ~]$ sqlplus -v

SQL*Plus: Release 19.0.0.0.0 - Production
Version 19.27.0.0.0

（4），执行脚本

安装补丁之后，还需要将有变化的SQL加载到数据库中，这里可以直接运行Datapatch工具将这些修改的SQL重新加载到数据库中
[oracle@oracledb 37642901]$ datapatch -verbos
SQL Patching tool version 19.27.0.0.0 Production on Fri Apr 25 18:10:24 2025
Copyright (c) 2012, 2025, Oracle.  All rights reserved.

Log file for this invocation: /opt/oracle/cfgtoollogs/sqlpatch/sqlpatch_14500_2025_04_25_18_10_24/sqlpatch_invocation.log

Connecting to database...OK
Gathering database info...done
Bootstrapping registry and package to current versions...done
Determining current state...done

Current state of interim SQL patches:
  No interim patches found

Current state of release update SQL patches:
  Binary registry:
    19.27.0.0.0 Release_Update 250406131139: Installed
  SQL registry:
    Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 25-APR-25 05.41.49.101922 PM

Adding patches to installation queue and performing prereq checks...done
Installation queue:
  No interim patches need to be rolled back
  Patch 37642901 (Database Release Update : 19.27.0.0.250415 (37642901)):
    Apply from 19.3.0.0.0 Release_Update 190410122720 to 19.27.0.0.0 Release_Update 250406131139
  No interim patches need to be applied
  
  Installing patches...
  
  Patch installation complete.  Total patches installed: 1

Validating logfiles...done
Patch 37642901 apply: SUCCESS
  logfile: /opt/oracle/cfgtoollogs/sqlpatch/37642901/27123174/37642901_apply_ORCL_2025Apr25_18_10_59.log (no errors)
SQL Patching tool complete on Fri Apr 25 18:17:15 2025

（5），查看版本变化

datapatch 工具加载修改的SQL之后会将patch添加到dba_registry_sqlpatch试图中，以反应patch的应用情况。 查询试图可以看到patch的APPLY状态为”SUCCESS”。

[oracle@oracledb 37642901]$ sqlplus / as sysdba
SQL> set lines 200
SQL> col STATUS for a12
SQL> col ACTION for a10
SQL> col DESCRIPTION for a55
SQL> col ACTION_TIME for a32
SQL> select patch_id,action,status,action_time,description from dba_registry_sqlpatch;

  PATCH_ID ACTION     STATUS       ACTION_TIME                      DESCRIPTION
---------- ---------- ------------ -------------------------------- -------------------------------------------------------
  29517242 APPLY      SUCCESS      25-APR-25 05.41.49.101922 PM     Database Release Update : 19.3.0.0.190416 (29517242)
  37642901 APPLY      SUCCESS      25-APR-25 06.16.42.621812 PM     Database Release Update : 19.27.0.0.250415 (37642901)

至此，操作结束。