19.19.0.0.0.230418 Patch 35050341 OJVM RELEASE UPDATE 19.19.0.0.0
环境:
OS:Centos 8
db:19.3.0.0
1.解压
[root@slnngk 35050341]#unzip p35050341_190000_Linux-x86-64.zip
2.修改目录权限
[root@slnngk soft]# chown -R oracle:oinstall ./patch/
3.预检查
[oracle@slnngk 35050341]$ cd /soft/patch/35050341
[oracle@slnngk 35050341]$ /u01/app/oracle/product/19.3.0.0/db_1/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 12.2.0.1.37
Copyright (c) 2023, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/oracle/product/19.3.0.0/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/19.3.0.0/db_1/oraInst.loc
OPatch version : 12.2.0.1.37
OUI version : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.3.0.0/db_1/cfgtoollogs/opatch/opatch2023-04-26_22-22-54PM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
4.安装
停掉监听和数据库
[oracle@slnngk 35050341]$ lsnrctl stop
SQL> connect / as sysdba
Connected.
SQL> shutdown immediate
$ cd /soft/patch/35050341
$ /u01/app/oracle/product/19.3.0.0/db_1/OPatch/opatch apply
5.启动数据库并检查
SQL> connect / as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 2365586752 bytes
Fixed Size 9166144 bytes
Variable Size 520093696 bytes
Database Buffers 1828716544 bytes
Redo Buffers 7610368 bytes
Database mounted.
Database opened.
SQL> alter pluggable database pdb1 open;
Pluggable database altered.
[oracle@slnngk 35050341]$ cd $ORACLE_HOME/OPatch
[oracle@slnngk OPatch]$ ./datapatch -verbose
6.编译无效对象
[oracle@slnngk admin]$ cd $ORACLE_HOME/rdbms/admin
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> @utlrp.sql