测试环境ORACLE 11g单实例打11.2.0.3.13 p19769496 PSU操作流程

2024-05-10 05:48

本文主要是介绍测试环境ORACLE 11g单实例打11.2.0.3.13 p19769496 PSU操作流程,希望对大家解决编程问题提供一定的参考价值,需要的开发者们随着小编来一起学习吧!


1.停止监听  
[oracle@localhost admin]$ lsnrctl stop LISTENER


LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 25-JAN-2015 22:50:17


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


Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))
The command completed successfully 


2、检查数据库是否还存在连接。
[oracle@localhost ~]$ps -ef |grep LOCAL=NO  
oracle    4377  2979  1 22:48 pts/1    00:00:00 grep LOCAL=NO


3、切换日志,关闭数据库。
SQL> alter system checkpoint;


System altered.


SQL> alter system switch logfile;


System altered.


SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.


4、备份ORACLE_HOME目录
cp -R <ORACLE_HOME> <ORACLE_HOME_BAK>


5.进入19769496 psu 解压目录,确保19769496权限为oracle:oinstall  
[oracle@localhost patch]$ cd 19769496/
[oracle@localhost 19769496]$ ll
total 112
drwxr-xr-x. 4 oracle oinstall  4096 Dec  9 22:41 13343438
drwxrwxr-x. 4 oracle oinstall  4096 Dec  9 22:41 13696216
drwxrwxr-x. 4 oracle oinstall  4096 Dec  9 22:41 13923374
drwxrwxr-x. 4 oracle oinstall  4096 Dec  9 22:41 14275605
drwxrwxr-x. 5 oracle oinstall  4096 Dec  9 22:41 14727310
drwxrwxr-x. 4 oracle oinstall  4096 Dec  9 22:41 16056266
drwxrwxr-x. 4 oracle oinstall  4096 Dec  9 22:41 16619892
drwxrwxr-x. 4 oracle oinstall  4096 Dec  9 22:41 16902043
drwxrwxr-x. 5 oracle oinstall  4096 Dec  9 22:41 17540582
drwxrwxr-x. 4 oracle oinstall  4096 Dec  9 22:41 18031683
drwxrwxr-x. 4 oracle oinstall  4096 Dec  9 22:41 18522512
drwxrwxr-x. 4 oracle oinstall  4096 Dec  9 22:41 19121548
drwxrwxr-x. 4 oracle oinstall  4096 Dec  9 22:41 19769496
-rw-rw-r--. 1 oracle oinstall 51692 Jan 17 08:30 README.html
-rw-r--r--. 1 oracle oinstall    21 Dec  9 22:41 README.txt
-rw-r--r--. 1 oracle oinstall  2872 Dec  9 22:42 patchmd.xml


6、检查OPATCH版本,如果版本过低需要到metalink下载最近的OPATCH psu号为为6880880。
OPatch Version: 11.2.0.1.7


OPatch succeeded.


7、下载最近的OPATCH psu号为为6880880,备份原先的OPatch目录,并解压到ORACLE_HOME目录下。
[oracle@localhost ~]$cd $ORACLE_HOME
[oracle@localhost db_1]$ mv OPatch/ OPatch_bak/
[oracle@localhost db_1]$ unzip p6880880_112000_Linux-x86-64.zip


8、再次检查OPATCH版本。
OPatch Version: 11.2.0.3.6


OPatch succeeded.


9、检查是否有与19769496有冲突的PSU。
[oracle@localhost ~]$ cd /home/oracle/patch/19769496/
[oracle@localhost 19769496]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./ 
Oracle Interim Patch Installer version 11.2.0.3.6
Copyright (c) 2013, Oracle Corporation.  All rights reserved.


PREREQ session


Oracle Home       : /opt/app/oracle/product/11.2.0/db_1
Central Inventory : /opt/app/oraInventory
   from           : /opt/app/oracle/product/11.2.0/db_1/oraInst.loc
OPatch version    : 11.2.0.3.6
OUI version       : 11.2.0.3.0
Log file location : /opt/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2015-01-25_22-25-34PM_1.log


Invoking prereq "checkconflictagainstohwithdetail"


Prereq "checkConflictAgainstOHWithDetail" passed.


OPatch succeeded.


10、安装补丁号为19769496的PSU。
[oracle@localhost ~]$ cd /home/oracle/patch/19769496/
[oracle@localhost 19769496]$ /opt/app/oracle/product/11.2.0/db_1/OPatch/opatch apply
Oracle Interim Patch Installer version 11.2.0.3.6
Copyright (c) 2013, Oracle Corporation.  All rights reserved.




Oracle Home       : /opt/app/oracle/product/11.2.0/db_1
Central Inventory : /opt/app/oraInventory
   from           : /opt/app/oracle/product/11.2.0/db_1/oraInst.loc
OPatch version    : 11.2.0.3.6
OUI version       : 11.2.0.3.0
Log file location : /opt/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2015-01-25_19-18-41PM_1.log


Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   13343438  13696216  13923374  14275605  14727310  16056266  16619892  16902043  17540582  18031683  18522512  19121548  19769496  


Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
Provide your email address to be informed of security issues, install and
initiate Oracle Configuration Manager. Easier for you if you use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for details.
Email address/User Name: 


You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]:  y






Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/opt/app/oracle/product/11.2.0/db_1')




Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying sub-patch '13343438' to OH '/opt/app/oracle/product/11.2.0/db_1'


Patching component oracle.rdbms.rsf, 11.2.0.3.0...


Patching component oracle.rdbms, 11.2.0.3.0...


Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...


Verifying the update...
Applying sub-patch '13696216' to OH '/opt/app/oracle/product/11.2.0/db_1'


Patching component oracle.rdbms.rsf, 11.2.0.3.0...


Patching component oracle.rdbms, 11.2.0.3.0...


Patching component oracle.sdo.locator, 11.2.0.3.0...


Patching component oracle.sysman.console.db, 11.2.0.3.0...


Patching component oracle.sysman.oms.core, 10.2.0.4.4...


Verifying the update...
Applying sub-patch '13923374' to OH '/opt/app/oracle/product/11.2.0/db_1'
ApplySession: Optional component(s) [ oracle.network.cman, 11.2.0.3.0 ]  not present in the Oracle Home or a higher version is found.


Patching component oracle.rdbms.rsf, 11.2.0.3.0...


Patching component oracle.rdbms, 11.2.0.3.0...


Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...


Patching component oracle.network.rsf, 11.2.0.3.0...


Patching component oracle.network.listener, 11.2.0.3.0...


Patching component oracle.sysman.console.db, 11.2.0.3.0...


Verifying the update...
Applying sub-patch '14275605' to OH '/opt/app/oracle/product/11.2.0/db_1'
ApplySession: Optional component(s) [ oracle.precomp.lang, 11.2.0.3.0 ]  not present in the Oracle Home or a higher version is found.


Patching component oracle.network.client, 11.2.0.3.0...


Patching component oracle.network.rsf, 11.2.0.3.0...


Patching component oracle.precomp.common, 11.2.0.3.0...


Patching component oracle.rdbms, 11.2.0.3.0...


Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...


Patching component oracle.rdbms.rman, 11.2.0.3.0...


Patching component oracle.rdbms.rsf, 11.2.0.3.0...


Patching component oracle.rdbms.util, 11.2.0.3.0...


Verifying the update...
Applying sub-patch '14727310' to OH '/opt/app/oracle/product/11.2.0/db_1'


Patching component oracle.rdbms, 11.2.0.3.0...


Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...


Patching component oracle.rdbms.rsf, 11.2.0.3.0...


Patching component oracle.sdo.locator, 11.2.0.3.0...


Patching component oracle.sysman.console.db, 11.2.0.3.0...


Patching component oracle.sysman.oms.core, 10.2.0.4.4...


Verifying the update...
Applying sub-patch '16056266' to OH '/opt/app/oracle/product/11.2.0/db_1'
ApplySession: Optional component(s) [ oracle.network.cman, 11.2.0.3.0 ]  not present in the Oracle Home or a higher version is found.


Patching component oracle.network.listener, 11.2.0.3.0...


Patching component oracle.network.rsf, 11.2.0.3.0...


Patching component oracle.ovm, 11.2.0.3.0...


Patching component oracle.rdbms, 11.2.0.3.0...


Patching component oracle.rdbms.rman, 11.2.0.3.0...


Patching component oracle.rdbms.rsf, 11.2.0.3.0...


Patching component oracle.sdo.locator, 11.2.0.3.0...


Patching component oracle.rdbms.deconfig, 11.2.0.3.0...


Verifying the update...
Applying sub-patch '16619892' to OH '/opt/app/oracle/product/11.2.0/db_1'
ApplySession: Optional component(s) [ oracle.precomp.lang, 11.2.0.3.0 ]  not present in the Oracle Home or a higher version is found.


Patching component oracle.marvel, 11.2.0.3.0...


Patching component oracle.precomp.common, 11.2.0.3.0...


Patching component oracle.rdbms, 11.2.0.3.0...


Patching component oracle.rdbms.rman, 11.2.0.3.0...


Patching component oracle.rdbms.rsf, 11.2.0.3.0...


Patching component oracle.sysman.agent, 10.2.0.4.3...


Patching component oracle.sysman.console.db, 11.2.0.3.0...


Patching component oracle.sysman.repository.core, 10.2.0.4.4...


Patching component oracle.xdk, 11.2.0.3.0...


Patching component oracle.xdk.parser.java, 11.2.0.3.0...


Patching component oracle.xdk.rsf, 11.2.0.3.0...


Verifying the update...
Applying sub-patch '16902043' to OH '/opt/app/oracle/product/11.2.0/db_1'
ApplySession: Optional component(s) [ oracle.idm.oid, 11.2.0.3.0 ]  not present in the Oracle Home or a higher version is found.


Patching component oracle.ldap.rsf, 11.2.0.3.0...


Patching component oracle.ldap.rsf.ic, 11.2.0.3.0...


Patching component oracle.owb.rsf, 11.2.0.3.0...


Patching component oracle.rdbms, 11.2.0.3.0...


Patching component oracle.rdbms.rsf, 11.2.0.3.0...


Patching component oracle.sysman.console.db, 11.2.0.3.0...


Verifying the update...
Applying sub-patch '17540582' to OH '/opt/app/oracle/product/11.2.0/db_1'
ApplySession: Optional component(s) [ oracle.precomp.lang, 11.2.0.3.0 ]  not present in the Oracle Home or a higher version is found.


Patching component oracle.rdbms, 11.2.0.3.0...


Patching component oracle.rdbms.rsf, 11.2.0.3.0...


Patching component oracle.sdo, 11.2.0.3.0...


Patching component oracle.ldap.rsf, 11.2.0.3.0...


Patching component oracle.precomp.common, 11.2.0.3.0...


Patching component oracle.ordim.client, 11.2.0.3.0...


Patching component oracle.rdbms.util, 11.2.0.3.0...


Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...


Patching component oracle.sdo.locator, 11.2.0.3.0...


Patching component oracle.rdbms.rman, 11.2.0.3.0...


Patching component oracle.ordim.jai, 11.2.0.3.0...


Verifying the update...
Applying sub-patch '18031683' to OH '/opt/app/oracle/product/11.2.0/db_1'
ApplySession: Optional component(s) [ oracle.precomp.lang, 11.2.0.3.0 ]  not present in the Oracle Home or a higher version is found.


Patching component oracle.rdbms.rsf, 11.2.0.3.0...


Patching component oracle.rdbms, 11.2.0.3.0...


Patching component oracle.ldap.rsf, 11.2.0.3.0...


Patching component oracle.precomp.common, 11.2.0.3.0...


Patching component oracle.rdbms.rman, 11.2.0.3.0...


Patching component oracle.rdbms.util, 11.2.0.3.0...


Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...


Verifying the update...
Applying sub-patch '18522512' to OH '/opt/app/oracle/product/11.2.0/db_1'


Patching component oracle.rdbms.rsf, 11.2.0.3.0...


Patching component oracle.rdbms, 11.2.0.3.0...


Patching component oracle.network.rsf, 11.2.0.3.0...


Patching component oracle.precomp.common, 11.2.0.3.0...


Patching component oracle.rdbms.rman, 11.2.0.3.0...


Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...


Verifying the update...
Applying sub-patch '19121548' to OH '/opt/app/oracle/product/11.2.0/db_1'


Patching component oracle.sysman.console.db, 11.2.0.3.0...


Patching component oracle.rdbms.rsf, 11.2.0.3.0...


Patching component oracle.rdbms.rman, 11.2.0.3.0...


Patching component oracle.rdbms, 11.2.0.3.0...


Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...


Patching component oracle.ordim.client, 11.2.0.3.0...


Patching component oracle.ordim.jai, 11.2.0.3.0...


Verifying the update...
Applying sub-patch '19769496' to OH '/opt/app/oracle/product/11.2.0/db_1'


Patching component oracle.sysman.agent, 10.2.0.4.3...


Patching component oracle.ovm, 11.2.0.3.0...


Patching component oracle.xdk, 11.2.0.3.0...


Patching component oracle.rdbms.util, 11.2.0.3.0...


Patching component oracle.rdbms, 11.2.0.3.0...


Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...


Patching component oracle.xdk.parser.java, 11.2.0.3.0...


Patching component oracle.oraolap, 11.2.0.3.0...


Patching component oracle.rdbms.rsf, 11.2.0.3.0...


Patching component oracle.xdk.rsf, 11.2.0.3.0...


Verifying the update...


OPatch found the word "warning" in the stderr of the make command.
Please look at this stderr. You can re-run this make command.
Stderr output:
ins_precomp.mk:19: warning: overriding commands for target `pcscfg.cfg'
/opt/app/oracle/product/11.2.0/db_1/precomp/lib/env_precomp.mk:2160: warning: ignoring old commands for target `pcscfg.cfg'
/opt/app/oracle/product/11.2.0/db_1/precomp/lib/ins_precomp.mk:19: warning: overriding commands for target `pcscfg.cfg'
/opt/app/oracle/product/11.2.0/db_1/precomp/lib/env_precomp.mk:2160: warning: ignoring old commands for target `pcscfg.cfg'






OPatch found the word "warning" in the stderr of the make command.
Please look at this stderr. You can re-run this make command.
Stderr output:
ins_emagent.mk:113: warning: overriding commands for target `nmosudo'
ins_emagent.mk:52: warning: ignoring old commands for target `nmosudo'
/opt/app/oracle/product/11.2.0/db_1/sysman/lib/ins_emagent.mk:113: warning: overriding commands for target `nmosudo'
/opt/app/oracle/product/11.2.0/db_1/sysman/lib/ins_emagent.mk:52: warning: ignoring old commands for target `nmosudo'




Composite patch 19769496 successfully applied.
OPatch Session completed with warnings.
Log file location: /opt/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2015-01-25_19-18-41PM_1.log


OPatch completed with warnings.


11、进入admin目录,执行catbundle.sql脚本更新数据字典。
[oracle@localhost ~]$ cd $ORACLE_HOME/rdbms/admin
[oracle@localhost admin]$ sqlplus '/as sysdba'


SQL*Plus: Release 11.2.0.3.0 Production on Sun Jan 25 22:01:32 2015


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


Connected to an idle instance.


SQL> 
SQL> 
SQL> 
SQL> startup
ORACLE instance started.


Total System Global Area  780824576 bytes
Fixed Size    2232432 bytes
Variable Size  562040720 bytes
Database Buffers  213909504 bytes
Redo Buffers    2641920 bytes
Database mounted.
Database opened.
SQL> @catbundle.sql psu apply  


12、查询registry$history 来查看PSU级别。
SQL>select substr(action_time,1,30) action_time,   
    substr(id,1,8) id,   
    substr(action,1,10) action,   
    substr(version,1,8) version,   
    substr(comments,1,20) comments   
    from registry$history; 


ACTION_TIME ID  ACTION     VERSION  COMMENTS
---------------------------------------- ---------------- ---------- -------------------- ------------------------------
17-SEP-11 10.21.11.595816 AM 0  APPLY      11.2.0.3  Patchset 11.2.0.2.0
19-JAN-15 12.02.35.037223 AM 0  APPLY      11.2.0.3  Patchset 11.2.0.2.0
25-JAN-15 08.04.12.093341 PM 13  APPLY      11.2.0.3  PSU 11.2.0.3.13


13.执行完catbundle.sql后,会在$ORACLE_HOME/rdbms/admin目录下生成catbundle_PSU_<database SID>_APPLY.sql,catbundle_PSU_<database SID>_ROLLBACK.sql两个脚本。  
[oracle@localhost admin]$ cd $ORACLE_HOMErdbms/admin/
[oracle@localhost admin]$ ll catbundle_*
-rw-r-----. 1 oracle oinstall 2262 Jan 25 19:54 catbundle_PSU_ORCL_APPLY.sql
-rw-r-----. 1 oracle oinstall 2311 Jan 25 19:54 catbundle_PSU_ORCL_ROLLBACK.sql
  
catbundle_PSU_ORCL_ROLLBACK.sql用于回滚PSU时使用  

这篇关于测试环境ORACLE 11g单实例打11.2.0.3.13 p19769496 PSU操作流程的文章就介绍到这儿,希望我们推荐的文章对编程师们有所帮助!



http://www.chinasem.cn/article/975606

相关文章

Python调用Orator ORM进行数据库操作

《Python调用OratorORM进行数据库操作》OratorORM是一个功能丰富且灵活的PythonORM库,旨在简化数据库操作,它支持多种数据库并提供了简洁且直观的API,下面我们就... 目录Orator ORM 主要特点安装使用示例总结Orator ORM 是一个功能丰富且灵活的 python O

python使用fastapi实现多语言国际化的操作指南

《python使用fastapi实现多语言国际化的操作指南》本文介绍了使用Python和FastAPI实现多语言国际化的操作指南,包括多语言架构技术栈、翻译管理、前端本地化、语言切换机制以及常见陷阱和... 目录多语言国际化实现指南项目多语言架构技术栈目录结构翻译工作流1. 翻译数据存储2. 翻译生成脚本

Linux流媒体服务器部署流程

《Linux流媒体服务器部署流程》文章详细介绍了流媒体服务器的部署步骤,包括更新系统、安装依赖组件、编译安装Nginx和RTMP模块、配置Nginx和FFmpeg,以及测试流媒体服务器的搭建... 目录流媒体服务器部署部署安装1.更新系统2.安装依赖组件3.解压4.编译安装(添加RTMP和openssl模块

oracle DBMS_SQL.PARSE的使用方法和示例

《oracleDBMS_SQL.PARSE的使用方法和示例》DBMS_SQL是Oracle数据库中的一个强大包,用于动态构建和执行SQL语句,DBMS_SQL.PARSE过程解析SQL语句或PL/S... 目录语法示例注意事项DBMS_SQL 是 oracle 数据库中的一个强大包,它允许动态地构建和执行

前端原生js实现拖拽排课效果实例

《前端原生js实现拖拽排课效果实例》:本文主要介绍如何实现一个简单的课程表拖拽功能,通过HTML、CSS和JavaScript的配合,我们实现了课程项的拖拽、放置和显示功能,文中通过实例代码介绍的... 目录1. 效果展示2. 效果分析2.1 关键点2.2 实现方法3. 代码实现3.1 html部分3.2

0基础租个硬件玩deepseek,蓝耘元生代智算云|本地部署DeepSeek R1模型的操作流程

《0基础租个硬件玩deepseek,蓝耘元生代智算云|本地部署DeepSeekR1模型的操作流程》DeepSeekR1模型凭借其强大的自然语言处理能力,在未来具有广阔的应用前景,有望在多个领域发... 目录0基础租个硬件玩deepseek,蓝耘元生代智算云|本地部署DeepSeek R1模型,3步搞定一个应

PLsql Oracle 下载安装图文过程详解

《PLsqlOracle下载安装图文过程详解》PL/SQLDeveloper是一款用于开发Oracle数据库的集成开发环境,可以通过官网下载安装配置,并通过配置tnsnames.ora文件及环境变... 目录一、PL/SQL Developer 简介二、PL/SQL Developer 安装及配置详解1.下

轻松上手MYSQL之JSON函数实现高效数据查询与操作

《轻松上手MYSQL之JSON函数实现高效数据查询与操作》:本文主要介绍轻松上手MYSQL之JSON函数实现高效数据查询与操作的相关资料,MySQL提供了多个JSON函数,用于处理和查询JSON数... 目录一、jsON_EXTRACT 提取指定数据二、JSON_UNQUOTE 取消双引号三、JSON_KE

springboot启动流程过程

《springboot启动流程过程》SpringBoot简化了Spring框架的使用,通过创建`SpringApplication`对象,判断应用类型并设置初始化器和监听器,在`run`方法中,读取配... 目录springboot启动流程springboot程序启动入口1.创建SpringApplicat

C++实现封装的顺序表的操作与实践

《C++实现封装的顺序表的操作与实践》在程序设计中,顺序表是一种常见的线性数据结构,通常用于存储具有固定顺序的元素,与链表不同,顺序表中的元素是连续存储的,因此访问速度较快,但插入和删除操作的效率可能... 目录一、顺序表的基本概念二、顺序表类的设计1. 顺序表类的成员变量2. 构造函数和析构函数三、顺序表