Oracle Database 18.3.0 upgrade PSU 18.5.0 on ASM_upgrade, migrate & consolidate to oracle database -优快云博客

本文链接：https://blog.youkuaiyun.com/sandy9919/article/details/87358152

本文详细介绍了在Oracle数据库中安装和验证Patch Set Update (PSU)的步骤，包括检查软件和数据库版本，安装PSU，重启服务，以及验证安装是否成功。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1 软件环境

OPatch：12.2.0.1.14

PSU：p28822489_180000_Linux-x86-64.zip

2 Database版本信息

set line 200
col BANNER_FULL for a39
col banner for a39
col banner_legacy for a39
select  * from v$version;

set line 188
col product for a50
col version for a15
col version_full for a15
col status for a15
select * from product_component_version;

查看数据字典

set line 188
col ACTION_TIME   for a30
col ACTION        for a12
col NAMESPACE     for a12
col VERSION       for a22
col BUNDLE_SERIES for a10
col COMMENTS      for a40
select * from dba_registry_history;

3 查看OPatch版本

$ORACLE_HOME/OPatch/opatch version

4 查看已安装PSU信息

$ORACLE_HOME/OPatch/opatch lsinventory

5 安装PSU

停止数据库实例

shutdown immediate

解压PSU包

unzip p28822489_180000_Linux-x86-64.zip -d psu

应用PSU

cd psu/28822489
$ORACLE_HOME/OPatch/opatch apply

启动HAS服务

crsctl start has -all
crsctl status res -t

启动PDB实例

#查看实例状态

col name for a15
col open_mode for a10
col database_role for a15
col db_unique_name for a15
col cdb for a10
select name,open_mode,database_role,db_unique_name,cdb from v$database;

#查看PDB状态

select con_id,dbid,con_uid,name,open_mode,restricted from v$pdbs;

#查看PDB service状态

set lines 100
col name format a20
col network_name format a20
col pdb format a20
select service_id,name,network_name,global_service,pdb,enabled from dba_services

注册PSU

$ORACLE_HOME/OPatch/datapatch -verbose

查看数据字典更新

set line 188
col ACTION_TIME   for a30
col ACTION        for a12
col NAMESPACE     for a12
col VERSION       for a22
col BUNDLE_SERIES for a10
col COMMENTS      for a49
select * from dba_registry_history;