Oracle 11g 打PSU补丁教程

一、环境准备

二、补丁工具准备

三、准备工作

1、 查看组件信息

1. SQL> set linesize 500 pagesize 600
   
2. SQL> col COMP_NAME for a30
   
3. SQL> select COMP_ID,COMP_NAME,VERSION,STATUS from DBA_REGISTRY;
   

2、查看补丁情况

1. SQL> set linesize 500 pagesize 600
   
2. SQL> col ACTION_TIME for a30
   
3. SQL> col COMMENTS for a30
   
4. SQL> select ACTION_TIME, ACTION,version, COMMENTS from sys.DBA_REGISTRY_HISTORY;
   

3、查看无效对象

1. SQL>select count(*) from dba_objects where status<>'VALID';
   

四、开始打补丁

1、更新OPatch版本

(1) 上传p6880880_112000_Linux-x86-64.zip到/home/oracle/opatch目录下, /home/oracle/opatch给777权限。

1. [oracle@myoracledemo ~]$ mkdir opatch
   
2. [oracle@myoracledemo ~]$ cd /home/oracle/opatch
   
3. [root@myoracledemo ~]# cd /home/oracle/opatch/
   
4. [root@myoracledemo opatch]# chown -R oracle.oinstall /home/oracle/opatch/
   

(2) root用户下将原OPatch目录改名。

[oracle@myoracledemo ~]$ mv $ORACLE_HOME/OPatch $ORACLE_HOME/OPatch.bak

2、oracle目录OPatch替换

1. [oracle@myoracledemo ~]$cd /home/oracle/opatch/
   
2. [oracle@myoracledemo ~]$unzip p6880880_112000_Linux-x86-64.zip
   
3. [oracle@myoracledemo ~]$unzip p31537677_112040_Linux-x86-64.zip
   
4. [oracle@myoracledemo opatch]$  mv OPatch /u01/app/oracle/product/11.2.0/db_1
   
5. [oracle@myoracledemo opatch]$ /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch  --verison
   

3、 测试兼容性

1. [oracle@myoracledemo opatch]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/oracle/opatch/31537677 -oh $ORACLE_HOME
   

4、 为数据库做冷备份

1. [oracle@myoracledemo opatch]$ rman target /
   
2. RMAN> run {
   
3. shutdown immediate;
   
4. startup mount;
   
5. allocate channel c1 type disk;
   
6. allocate channel c2 type disk;
   
7. backup full tag='db_full_bak' database format '/home/oracle/rmanbak/full_cold_%d_%s.bak';
   
8. alter database open;
   
9. }
   

然后使用root用户备份oracle_home （将#ORACLE_HOME上级目录整个备份）

1. [oracle@myoracledemo opatch]$tar -zcvpf db_bak.tar.gz /u01/app/oracle/product/11.2.0
   

5、 关闭数据库实例及相关进程 (静态监听、动态监听、EOM、相关服务)

—停止数据库外部进程

1. [root@myoracledemo ~]# ps -ef|grep -v grep |grep LOCAL=NO|awk '{print $2}'|xargs kill -9
   
2. SQL> shutdown immediate;
   

1. [oracle@myoracledemo 11.2.0]$ lsnrctl stop
   
2. [oracle@myoracledemo 11.2.0]$ lsnrctl status
   

1. [oracle@myoracledemo 11.2.0]$ ps -ef |grep ora_|grep -v grep
   
2. [oracle@myoracledemo 11.2.0]$ netstat -an |grep 1521
   
3. [oracle@myoracledemo 11.2.0]$ netstat -an |grep 1158
   

6、给oracle database补丁

1. [root@myoracledemo ~]# yum install -y psmisc*  #centos需要安装这个依赖包
   
2. [oracle@myoracledemo 11.2.0]$ $ORACLE_HOME/OPatch/opatch napply -oh $ORACLE_HOME -local /home/oracle/opatch/31537677
   

7、查看打补丁情况

1. [oracle@myoracledemo db_1]$ /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch lsinv
   

8、升级数据库数据字典、编译无效对象

数据库启动，并加载修改SQL Files到数据库

1. SQL> startup
   

升级数据库数据字典

1. SQL> @?/rdbms/admin/catbundle.sql psu apply
   

编译无效对象的脚本

1. SQL>@?/rdbms/admin/utlrp.sql
   

9、查看 PSU 更新信息

1. SQL>set line 150
   
2. SQL>col ACTION_TIME for a30
   
3. SQL>col ACTION for a8
   
4. SQL>col NAMESPACE for a8
   
5. SQL>col VERSION for a10
   
6. SQL>col BUNDLE_SERIES for a5
   
7. SQL>col COMMENTS for a20
   
8. SQL>select * from dba_registry_history;
   

1. SQL> select count(*) from dba_objects where status<>'VALID';
   

查看监听的情况，启动监听

1. [oracle@myoracledemo db_1]$ lsnrctl start