PSU手动升级

admin

1.创建软件目录上传软件并调整权限：1.1上传软件

chown -R oracle:oinstall /cdcora/software/

chmod -R 775 /cdcora/software/

备份grid和oracle用户的 $ORACLE_HOME/ 相关目录

1.2 备份

如: tar cvpf - app |gzip >  /cdcora/app.tar.gz

1.3 检查可用操作系统空间

df -g

1.4检查DB基础情况

SQL> set pages 100 lines 150

SQL> col owner for a30

SQL> col comp_name for a50

SQL>

SQL> select owner, count(*) from dba_objects where status='INVALID' group by owner order by 1;

2.升级opatch 版本：

两节点都需要操作

oracle用户

su - oracle

cd /awrdump/software

mv $ORACLE_HOME/OPatch $ORACLE_HOME/OPatch.bak

unzip p6880880_112000_AIX64-5L_PSU.zip -d $ORACLE_HOME/

$ORACLE_HOME/OPatch/opatch version

grid用户

su - grid

su

mv $ORACLE_HOME/OPatch $ORACLE_HOME/OPatch.bak

cd /awrdump/software

unzip p6880880_112000_AIX64-5L_PSU.zip -d $ORACLE_HOME/

[root@node1 soft]# cd $ORACLE_HOME

[root@node1 grid]# ls -l  | grep OPatch

drwxr-x---. 15 root root      4096 Apr 12 15:49 OPatch

drwxr-xr-x.  8 grid oinstall   212 Oct 31  2017 OPatch.bak

[root@node1 grid]# chown -R grid:oinstall OPatch

[root@node1 grid]# chmod -R 775 OPatch

$ORACLE_HOME/OPatch/opatch version

3.解压PSU软件：

两节点都需要操作

su - oracle

cd /cdcora/software

unzip p30463729_112040_AIX64-5L_PSU.zip

4.检查冲突：

两节点都需要操作

two node:

oracle用户

su - oracle:

cd /cdcora/software/30463729/30501155

$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./

grid用户

su - grid:

cd /cdcora/software/30463729/30501155

$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./

5.确认集群及数据库状态：

两节点都需要操作

crsctl status resource -t

cluster  开启状态

database 开启状态

listener 开启状态

6.opatch 升级grid and db 软件：

PSU的实际目录为准

root用户

crsctl stop crs

slibclean

/grid/11.2.0/crs/install/rootcrs.pl -unlock

/grid/11.2.0/perl/bin/perl /grid/11.2.0/crs/install/rootcrs.pl -unlock

grid用户

/grid/11.2.0/OPatch/opatch napply -oh /grid/11.2.0 -local /awrdump/software/30463729/30501155/29938455 -silent -ocmrf /home/grid/ocm1.rsp

/grid/11.2.0/OPatch/opatch napply -oh /grid/11.2.0 -local /awrdump/software/30463729/30501155/29509309 -silent -ocmrf /home/grid/ocm1.rsp

/grid/11.2.0/OPatch/opatch  apply -oh /grid/11.2.0 -local /awrdump/software/30463729/30501155/30298532 -silent -ocmrf /home/grid/ocm1.rsp

oracle用户

/awrdump/software/30463729/30501155/29938455/custom/server/29938455/custom/scripts/prepatch.sh -dbhome /oracle/app/oracle/product/11.2.0

/oracle/app/oracle/product/11.2.0/OPatch/opatch napply -oh /oracle/app/oracle/product/11.2.0 -local /awrdump/software/30463729/30501155/29938455/custom/server/29938455  -silent -ocmrf /oracle/app/oracle/product/11.2.0/OPatch/ocm/bin/ocm.rsp

/oracle/app/oracle/product/11.2.0/OPatch/opatch  apply -oh /oracle/app/oracle/product/11.2.0 -local /awrdump/software/30463729/30501155/30298532 -silent -ocmrf /oracle/app/oracle/product/11.2.0/OPatch/ocm/bin/ocm.rsp

/oracle/app/oracle/product/11.2.0/OPatch/opatch  apply -oh /oracle/app/oracle/product/11.2.0 -local /awrdump/software/30463729/30503372 -silent -ocmrf /oracle/app/oracle/product/11.2.0/OPatch/ocm/bin/ocm.rsp

/awrdump/software/30463729/30501155/29938455/custom/server/29938455/custom/scripts/postpatch.sh -dbhome /oracle/app/oracle/product/11.2.0

#as root

/grid/11.2.0/rdbms/install/rootadd_rdbms.sh

/grid/11.2.0/perl/bin/perl /grid/11.2.0/crs/install/rootcrs.pl -patch

7.更新数据库信息

node1:

oracle:

cd $ORACLE_HOME/rdbms/admin

su - oracle

sqlplus /nolog

connect /as sysdba

@catbundle.sql psu apply

8.检查失效对象，编译失效对象：

oracle:

cd $ORACLE_HOME/rdbms/admin

su - oracle

sqlplus /nolog

connect /as sysdba

select count(*) from dba_objects where status='INVALID';

@utlrp.sql

9.验证

两节点都需要操作

oracle用户

su - oracle

$ORACLE_HOME/OPatch/opatch lspatches

$ORACLE_HOME/OPatch/opatch lsinventory

grid用户

su - grid

$ORACLE_HOME/OPatch/opatch lspatches

$ORACLE_HOME/OPatch/opatch lsinventory

crsctl stat res -t

验证数据库无效对象

select owner,count(*) from dba_objects where status = 'INVALID' group by owner;

验证数据库访问和监听服务是否正常

lnsrctl service LISETENER  (listener_NAME)   ///

select inst_id,username,count(*) from gv$session group by inst_id,username order by 3 desc;

10.回退方案

cd /oracle

gunzip < /cdcora/app.tar.gz | tar xvf -