Patchset/PSU Patch Number Description
11.1.0.7.11 13621679 DATABASE PATCH SET UPDATE 11.1.0.7.11 (INCLUDES CPU APR2012)
Patch 13621679 - 11.1.0.7.11 Patch Set Update
=============================================
http://bbs.dbsupport.cn/thread-160-1-1.html
Patch InformationPatch Set Update (PSU) patches are cumulative. That is, the content of all previous PSUs is included in the latest PSU patch.
PSU 11.1.0.7.11 includes all fixes previously included in PSU 11.1.0.7.10 and those listed in .
To install the PSU 11.1.0.7.11 patch, the Oracle home must have the 11.1.0.7.0 Database installed. Subsequent PSU patches can be installed on Oracle Database 11.1.0.7.0 or any PSU with a lower 5th numeral version than the one being installed.
OPatch Utility
==============
You must use the OPatch utility version 11.1.0.8.2 or later to apply this patch. Oracle recommends that you use the latest released OPatch 11.1, which is available for download from My Oracle Support patch6880880 by selecting the 11.1.0.0.0 release.
For information about OPatch documentation, including any known issues, see My Oracle Support Note 293369.1 OPatch documentation list.
PSU Patching 11G Steps on PRIMARY database
==========================================
check DR sysnc status
=====================
http://select-star-from.blogspot.in/2013/09/data-guard-sync-status.html
------------------------------------------------------------------------------------------------------------------
Start OEM black out
===================
Confirmation
Blackout "Blackout-Apr 24 1998 9:33:42 PM" created successfully, Blackout status will be propagated to the target(s) shortly.
------------------------------------------------------------------------------------------------------------------
Node 1: (AS ORACLE)
===================
$ hostname
$ uname
$ bash
$ date
$ df -kg or df -h
$ cat /etc/oratab or cat/var/opt/oracle/oratab ------> Note ASM and Database Home Paths
$ ps -ef| grep pmon
$ ps -ef| grep tns
$ ps -ef| grep emagent
$ ps -ef|grep oracle
$ ps -ef| grep d.bin
$ ps -ef|grep crs
root 344170 1 0 Apr 24 - 0:00 /oradb/crs/product/11.1.0/crs_1/bin/oclskd.bin
$ cd /oradb/app/admin/orasw/patches/PSU_patches/Jan2012
$ opatch version
$ /oradb/crs/product/11.1.0/crs_1/OPatch/opatch version
$ /oradb/asm/product/11.1.0/asm_1/OPatch/opatch version
$ /oradb/app/oracle/product/11.1.0/db_1/OPatch/opatch version
$ which opatch
/oradb/app/oracle/product/11.1.0/db_1/OPatch/opatch
. oraenv --- asm instance
$ opatch lsinventory
. oraenv --- database 1 instance
$ opatch lsinventory
. oraenv --- database 2 instance
$ opatch lsinventory
$ ps -ef| grep pmon
$ srvctl status database -d <database_1> or srvctl status instance -d <database_1> -i <database_1_instance>
$ srvctl status database -d <database_2> or srvctl status instance -d <database_2> -i <database_2_instance>
$ srvctl status asm -n <Node 1>
$ srvctl status asm -n <Node 2>
$ srvctl status listener -n <Node 1>
$ srvctl status listener -n <Node 2>
$ srvctl status nodeapps -n <Node 1>
$ srvctl status nodeapps -n <Node 2>
$ ps -ef|grep oracle or ps -ef|grep emagent
./emctl status agent or /oradb/app/oracle/product/agent1/agent11g/bin/emctl status agent
$ cd /oradb/crs/product/11.1.0/crs_1/bin
$ ./crsctl check cluster
$ cd /oradb/crs/product/11.1.0/crs_1/bin
$ ./crsctl check crs
$ cd /oradb/crs/product/11.1.0/crs_1/bin
$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
$ srvctl stop database -d <database_1> or srvctl stop insatnce -d <database_1> -i <database_1_instance>
$ srvctl stop database -d <database_2> -o immediate or srvctl stop insatnce -d <database_2> -i <database_2_instance>
$ srvctl stop asm -n <Node 1>
$ srvctl stop asm -n <Node 2>
$ srvctl stop listener -n <Node 1>
$ srvctl stop listener -n <Node 2>
$ srvctl stop nodeapps -n <Node 1>
$ srvctl stop nodeapps -n <Node 2>
$ ps -ef|grep oracle or ps -ef|grep emagent
./emctl stop agent or /oradb/app/oracle/product/agent1/agent11g/bin/emctl stop agent
$ ps -ef| grep oracle
$ lsnrctl stop -------------------------------to stop default listener
$ ps -ef| grep oracle
------------------------------------------------------------------------------------------------------------------
Node 2: (AS ORACLE)
===================
$ hostname
$ uname
$ bash
$ date
$ df -kg or df -h
$ cat /etc/oratab or cat/var/opt/oracle/oratab ------> Note ASM and Database Home Paths
$ ps -ef| grep pmon
$ ps -ef| grep tns
$ ps -ef| grep emagent
$ ps -ef|grep oracle
$ ps -ef| grep d.bin
$ ps -ef|grep crs
root 344170 1 0 Apr 24 - 0:00 /oradb/crs/product/11.1.0/crs_1/bin/oclskd.bin
$ cd /oradb/app/admin/orasw/patches/PSU_patches/Jan2012
$ opatch version
$ /oradb/crs/product/11.1.0/crs_1/OPatch/opatch version
$ /oradb/asm/product/11.1.0/asm_1/OPatch/opatch version
$ /oradb/app/oracle/product/11.1.0/db_1/OPatch/opatch version
$ which opatch
/oradb/app/oracle/product/11.1.0/db_1/OPatch/opatch
$ ps -ef| grep pmon
$ ps -ef|grep oracle or ps -ef|grep emagent
./emctl status agent or /oradb/app/oracle/product/agent1/agent11g/bin/emctl status agent
$ cd /oradb/crs/product/11.1.0/crs_1/bin
$ ./crsctl check cluster
$ cd /oradb/crs/product/11.1.0/crs_1/bin
$ ./crsctl check crs
$ cd /oradb/crs/product/11.1.0/crs_1/bin
$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
$ ps -ef|grep oracle or ps -ef|grep emagent
./emctl stop agent or /oradb/app/oracle/product/agent1/agent11g/bin/emctl stop agent
$ ps -ef| grep oracle
$ lsnrctl stop -------------------------------to stop default listener
$ ps -ef| grep oracle
------------------------------------------------------------------------------------------------------------------
Pre-rootpatch
=============
Node 1: (AS ROOT)
=================
# cd /oradb/crs/product/11.1.0/crs_1/bin
# ./crsctl check cluster
# ./crsctl check crs
# ./crsctl stop crs
# ps -ef| grep oracle
# ssh <Node 2>
# cd /oradb/crs/product/11.1.0/crs_1/bin
# ./crsctl check cluster
# ./crsctl check crs
# ./crsctl stop crs
# ps -ef| grep oracle
# exit
# hostname
<Node 1>
# ps -ef| grep pmon ---- (0 instances running)
# cd /oradb/app/admin/orasw/patches/PSU_patches/Jan2012/CRS/111077/11724953
# sh custom/scripts/prerootpatch.sh -crshome /oradb/crs/product/11.1.0/crs_1 -crsuser oracle
# ssh <Node 2>
# ps -ef| grep pmon ---- (0 instances running)
# cd /oradb/app/admin/orasw/patches/PSU_patches/Jan2012/CRS/111077/11724953
# sh custom/scripts/prerootpatch.sh -crshome /oradb/crs/product/11.1.0/crs_1 -crsuser oracle
# exit
# hostname
<Node 1>
------------------------------------------------------------------------------------------------------------------
Pre-patch
=========
Node 1: (AS ORACLE)
===================
$ cd /oradb/app/admin/orasw/patches/PSU_patches/Jan2012/CRS/111077/11724953
$ custom/scripts/prepatch.sh -crshome /oradb/crs/product/11.1.0/crs_1
$ cd /oradb/app/admin/orasw/patches/PSU_patches/Jan2012/CRS/111077/11724953
$ custom/server/11724953/custom/scripts/prepatch.sh -dbhome /oradb/asm/product/11.1.0/asm_1
$ cd /oradb/app/admin/orasw/patches/PSU_patches/Jan2012/CRS/111077/11724953
$ custom/server/11724953/custom/scripts/prepatch.sh -dbhome /oradb/app/oracle/product/11.1.0/db_1
------------------------------------------------------------------------------------------------------------------
Opatch Apply
============
Node 1: (AS ORACLE)
===================
CRS
===
$ cd /oradb/app/admin/orasw/patches/PSU_patches/Jan2012/CRS/111077
$ opatch napply -oh /oradb/crs/product/11.1.0/crs_1 -id 11724953
ASM
===
$ cd /oradb/app/admin/orasw/patches/PSU_patches/Jan2012/CRS/111077/11724953/custom/server
$ opatch napply custom/server/ -oh /oradb/asm/product/11.1.0/asm_1 -id 11724953
RDBMS
=====
$ cd /oradb/app/admin/orasw/patches/PSU_patches/Jan2012/CRS/111077/11724953/custom/server
$ opatch napply custom/server/ -oh /oradb/app/oracle/product/11.1.0/db_1 -id 11724953
------------------------------------------------------------------------------------------------------------------
Do the post configure for CRS and RDBMS home
============================================
Node 1: (AS ORACLE)
===================
CRS
===
$ cd /oradb/app/admin/orasw/patches/PSU_patches/Jan2012/CRS/111077/11724953/custom/scripts
$ ./postpatch.sh -crshome /oradb/crs/product/11.1.0/crs_1
ASM
===
$ cd /oradb/app/admin/orasw/patches/PSU_patches/Jan2012/CRS/111077/11724953/custom/server/11724953
$ ./custom/scripts/postpatch.sh -dbhome /oradb/asm/product/11.1.0/asm_1
RDBMS
=====
$ cd /oradb/app/admin/orasw/patches/PSU_patches/Jan2012/CRS/111077/11724953/custom/server/11724953
$ ./custom/scripts/postpatch.sh -dbhome /oradb/app/oracle/product/11.1.0/db_1
------------------------------------------------------------------------------------------------------------------
11.1.0.7.11 PSU (13621679) and (9734685)
========================================
Node 1: (AS ORACLE)
===================
13621679
========
$ cd /oradb/app/admin/orasw/patches
$ chmod -R 777 PSU_patches
$ cd PSU_patches
$ pwd
/oradb/app/admin/orasw/patches/PSU_patches
$ ls -lrt p13621679_111070_AIX5L.zip
$ unzip p13621679_111070_AIX5L.zip
$ ls -lrt
$ cd 13621679
$ pwd
ASM
===
$ /oradb/app/admin/orasw/patches/PSU_patches/13621679
$ opatch apply -oh /oradb/asm/product/11.1.0/asm_1
RDBMS
=====
$ cd /oradb/app/admin/orasw/patches/PSU_patches/13621679
$ opatch apply -oh /oradb/app/oracle/product/11.1.0/db_1
------------------------------------------------------------------------------------------------------------------
9734685
=======
$ cd /oradb/app/admin/orasw/patches/PSU_patches/
$ ls -lrt p9734685_1110711_AIX64-5L.zip
$ unzip p9734685_1110711_AIX64-5L.zip
ASM
===
$ cd /oradb/app/admin/orasw/patches/PSU_patches/9734685
$ opatch apply -oh /oradb/asm/product/11.1.0/asm_1
RDBMS
=====
$ cd /oradb/app/admin/orasw/patches/PSU_patches/9734685
$ opatch apply -oh /oradb/app/oracle/product/11.1.0/db_1
------------------------------------------------------------------------------------------------------------------
After 9734685 Patch applied relink has to be done in both ASM and DB homes ------- Linking Oracle
==========================================================================
Node 1: (AS ORACLE)
===================
RDBMS
=====
$ cd /oradb/app/oracle/product/11.1.0/db_1/rdbms/lib
$ make -f ins_rdbms.mk ipc_g ioracle
ASM
===
$ cd /oradb/asm/product/11.1.0/asm_1/rdbms/lib
$ make -f ins_rdbms.mk ipc_g ioracle
Node 2: (AS ORACLE)
=======
RDBMS
=====
$ cd /oradb/app/oracle/product/11.1.0/db_1/rdbms/lib
$ make -f ins_rdbms.mk ipc_g ioracle
ASM
===
$ cd /oradb/asm/product/11.1.0/asm_1/rdbms/lib
$ make -f ins_rdbms.mk ipc_g ioracle
------------------------------------------------------------------------------------------------------------------
Post-rootpatch
==============
Node 1: (AS ROOT)
=================
# cd /oradb/app/admin/orasw/patches/PSU_patches/Jan2012/CRS/111077/11724953
# /oradb/app/admin/orasw/patches/PSU_patches/Jan2012/CRS/111077/11724953/custom/scripts/postrootpatch.sh -crshome /oradb/crs/product/11.1.0/crs_1
# ps -ef | grep pmon --- Both the db and asm instances will be up and running
# ssh <Node 2>
# cd /oradb/app/admin/orasw/patches/PSU_patches/Jan2012/CRS/111077/11724953/custom/scripts/postrootpatch.sh -crshome /oradb/crs/product/11.1.0/crs_1
# ps -ef | grep pmon --- Both the db and asm instances will be up and running
------------------------------------------------------------------------------------------------------------------
Start ASM
------------------------------------------------------------------------------------------------------------------
Run on each database, only in one node
======================================
NODE 1: (AS ORACLE)
===================
$ sqlplus /nolog
Enter user-name: / as sysdba
Connected to an idle instance.
SQL>startup;
SQL>@?/rdbms/admin/catbundle.sql psu apply
SQL>exit
$. oraenv ---- --- database 2 instance
$ sqlplus /nolog
Enter user-name: / as sysdba
SQL>startup;
SQL>@?/rdbms/admin/catbundle.sql psu apply
SQL>exit
------------------------------------------------------------------------------------------------------------------
Patch Validation:-
================
opatch lsinventory | grep 11724953
opatch lsinventory | grep 13621679
opatch lsinventory | grep 9734685
start local listeners, (if any)
$ cd /oradb/crs/product/11.1.0/crs_1/bin
$ ./crsctl check cluster
$ cd /oradb/crs/product/11.1.0/crs_1/bin
$ ./crsctl check crs
$ cd /oradb/crs/product/11.1.0/crs_1/bin
$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
$ hostname
$ uname
$ bash
$ date
$ who -b
$ uptime
$ df -kg or df -h
$ cat /etc/oratab or cat/var/opt/oracle/oratab ------> Note ASM and Database Home Paths
$ ps -ef| grep pmon
$ ps -ef| grep tns
$ ps -ef| grep emagent
$ ps -ef|grep oracle
$ ps -ef| grep d.bin
$ ps -ef|grep crs
$ ps -ef| grep pmon
$ srvctl status database -d <database_1>
$ srvctl status database -d <database_2>
$ srvctl status asm -n <Node 1>
$ srvctl status asm -n <Node 2>
$ srvctl status listener -n <Node 1>
$ srvctl status listener -n <Node 2>
$ srvctl status nodeapps -n <Node 1>
$ srvctl status nodeapps -n <Node 2>
$ ps -ef|grep oracle or ps -ef|grep emagent
./emctl status agent or /oradb/app/oracle/product/agent1/agent11g/bin/emctl status agent
Run on each database only in one node
=====================================
NODE 1: (AS ORACLE)
===================
SQL> select name db_name,DB_UNIQUE_NAME,instance_name,status,DATABASE_STATUS,open_mode, database_role, host_name,platform_id,version db_version,log_mode,flashback_on ,protection_mode,protection_level,LOGINS,to_char(STARTUP_TIME,'DD-MON-YYYY HH24:MI:SS') "UP TIME" from gv$instance,v$database;
SQL> select to_char(sysdate,'yyyy-mm-dd HH24:MI:SS') from dual
/
SQL>
col ACTION_TIME for a12
col NAMESPACE for a10
col VERSION for a10
col BUNDLE_SERIES for a15
col COMMENTS for a20
select action_time, action,namespace, version, id,bundle_series, comments from registry$history;
------------------------------------------------------------------------------------------------------------------
check DR sysnc status
=====================
http://select-star-from.blogspot.in/2013/09/data-guard-sync-status.html
------------------------------------------------------------------------------------------------------------------
Stop OEM black out
==================
Confirmation
Request to stop blackout "Blackout-Apr 24 1998 9:33:42 PM" was processed successfully, Blackout status will be propagated to the target(s) shortly.
------------------------------------------------------------------------------------------------------------------
11.1.0.7.11 13621679 DATABASE PATCH SET UPDATE 11.1.0.7.11 (INCLUDES CPU APR2012)
Patch 13621679 - 11.1.0.7.11 Patch Set Update
=============================================
http://bbs.dbsupport.cn/thread-160-1-1.html
Patch InformationPatch Set Update (PSU) patches are cumulative. That is, the content of all previous PSUs is included in the latest PSU patch.
PSU 11.1.0.7.11 includes all fixes previously included in PSU 11.1.0.7.10 and those listed in .
To install the PSU 11.1.0.7.11 patch, the Oracle home must have the 11.1.0.7.0 Database installed. Subsequent PSU patches can be installed on Oracle Database 11.1.0.7.0 or any PSU with a lower 5th numeral version than the one being installed.
OPatch Utility
==============
You must use the OPatch utility version 11.1.0.8.2 or later to apply this patch. Oracle recommends that you use the latest released OPatch 11.1, which is available for download from My Oracle Support patch6880880 by selecting the 11.1.0.0.0 release.
For information about OPatch documentation, including any known issues, see My Oracle Support Note 293369.1 OPatch documentation list.
PSU Patching 11G Steps on PRIMARY database
==========================================
check DR sysnc status
=====================
http://select-star-from.blogspot.in/2013/09/data-guard-sync-status.html
------------------------------------------------------------------------------------------------------------------
Start OEM black out
===================
Confirmation
Blackout "Blackout-Apr 24 1998 9:33:42 PM" created successfully, Blackout status will be propagated to the target(s) shortly.
------------------------------------------------------------------------------------------------------------------
Node 1: (AS ORACLE)
===================
$ hostname
$ uname
$ bash
$ date
$ df -kg or df -h
$ cat /etc/oratab or cat/var/opt/oracle/oratab ------> Note ASM and Database Home Paths
$ ps -ef| grep pmon
$ ps -ef| grep tns
$ ps -ef| grep emagent
$ ps -ef|grep oracle
$ ps -ef| grep d.bin
$ ps -ef|grep crs
root 344170 1 0 Apr 24 - 0:00 /oradb/crs/product/11.1.0/crs_1/bin/oclskd.bin
$ cd /oradb/app/admin/orasw/patches/PSU_patches/Jan2012
$ opatch version
$ /oradb/crs/product/11.1.0/crs_1/OPatch/opatch version
$ /oradb/asm/product/11.1.0/asm_1/OPatch/opatch version
$ /oradb/app/oracle/product/11.1.0/db_1/OPatch/opatch version
$ which opatch
/oradb/app/oracle/product/11.1.0/db_1/OPatch/opatch
. oraenv --- asm instance
$ opatch lsinventory
. oraenv --- database 1 instance
$ opatch lsinventory
. oraenv --- database 2 instance
$ opatch lsinventory
$ ps -ef| grep pmon
$ srvctl status database -d <database_1> or srvctl status instance -d <database_1> -i <database_1_instance>
$ srvctl status database -d <database_2> or srvctl status instance -d <database_2> -i <database_2_instance>
$ srvctl status asm -n <Node 1>
$ srvctl status asm -n <Node 2>
$ srvctl status listener -n <Node 1>
$ srvctl status listener -n <Node 2>
$ srvctl status nodeapps -n <Node 1>
$ srvctl status nodeapps -n <Node 2>
$ ps -ef|grep oracle or ps -ef|grep emagent
./emctl status agent or /oradb/app/oracle/product/agent1/agent11g/bin/emctl status agent
$ cd /oradb/crs/product/11.1.0/crs_1/bin
$ ./crsctl check cluster
$ cd /oradb/crs/product/11.1.0/crs_1/bin
$ ./crsctl check crs
$ cd /oradb/crs/product/11.1.0/crs_1/bin
$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
$ srvctl stop database -d <database_1> or srvctl stop insatnce -d <database_1> -i <database_1_instance>
$ srvctl stop database -d <database_2> -o immediate or srvctl stop insatnce -d <database_2> -i <database_2_instance>
$ srvctl stop asm -n <Node 1>
$ srvctl stop asm -n <Node 2>
$ srvctl stop listener -n <Node 1>
$ srvctl stop listener -n <Node 2>
$ srvctl stop nodeapps -n <Node 1>
$ srvctl stop nodeapps -n <Node 2>
$ ps -ef|grep oracle or ps -ef|grep emagent
./emctl stop agent or /oradb/app/oracle/product/agent1/agent11g/bin/emctl stop agent
$ ps -ef| grep oracle
$ lsnrctl stop -------------------------------to stop default listener
$ ps -ef| grep oracle
------------------------------------------------------------------------------------------------------------------
Node 2: (AS ORACLE)
===================
$ hostname
$ uname
$ bash
$ date
$ df -kg or df -h
$ cat /etc/oratab or cat/var/opt/oracle/oratab ------> Note ASM and Database Home Paths
$ ps -ef| grep pmon
$ ps -ef| grep tns
$ ps -ef| grep emagent
$ ps -ef|grep oracle
$ ps -ef| grep d.bin
$ ps -ef|grep crs
root 344170 1 0 Apr 24 - 0:00 /oradb/crs/product/11.1.0/crs_1/bin/oclskd.bin
$ cd /oradb/app/admin/orasw/patches/PSU_patches/Jan2012
$ opatch version
$ /oradb/crs/product/11.1.0/crs_1/OPatch/opatch version
$ /oradb/asm/product/11.1.0/asm_1/OPatch/opatch version
$ /oradb/app/oracle/product/11.1.0/db_1/OPatch/opatch version
$ which opatch
/oradb/app/oracle/product/11.1.0/db_1/OPatch/opatch
$ ps -ef| grep pmon
$ ps -ef|grep oracle or ps -ef|grep emagent
./emctl status agent or /oradb/app/oracle/product/agent1/agent11g/bin/emctl status agent
$ cd /oradb/crs/product/11.1.0/crs_1/bin
$ ./crsctl check cluster
$ cd /oradb/crs/product/11.1.0/crs_1/bin
$ ./crsctl check crs
$ cd /oradb/crs/product/11.1.0/crs_1/bin
$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
$ ps -ef|grep oracle or ps -ef|grep emagent
./emctl stop agent or /oradb/app/oracle/product/agent1/agent11g/bin/emctl stop agent
$ ps -ef| grep oracle
$ lsnrctl stop -------------------------------to stop default listener
$ ps -ef| grep oracle
------------------------------------------------------------------------------------------------------------------
Pre-rootpatch
=============
Node 1: (AS ROOT)
=================
# cd /oradb/crs/product/11.1.0/crs_1/bin
# ./crsctl check cluster
# ./crsctl check crs
# ./crsctl stop crs
# ps -ef| grep oracle
# ssh <Node 2>
# cd /oradb/crs/product/11.1.0/crs_1/bin
# ./crsctl check cluster
# ./crsctl check crs
# ./crsctl stop crs
# ps -ef| grep oracle
# exit
# hostname
<Node 1>
# ps -ef| grep pmon ---- (0 instances running)
# cd /oradb/app/admin/orasw/patches/PSU_patches/Jan2012/CRS/111077/11724953
# sh custom/scripts/prerootpatch.sh -crshome /oradb/crs/product/11.1.0/crs_1 -crsuser oracle
# ssh <Node 2>
# ps -ef| grep pmon ---- (0 instances running)
# cd /oradb/app/admin/orasw/patches/PSU_patches/Jan2012/CRS/111077/11724953
# sh custom/scripts/prerootpatch.sh -crshome /oradb/crs/product/11.1.0/crs_1 -crsuser oracle
# exit
# hostname
<Node 1>
------------------------------------------------------------------------------------------------------------------
Pre-patch
=========
Node 1: (AS ORACLE)
===================
$ cd /oradb/app/admin/orasw/patches/PSU_patches/Jan2012/CRS/111077/11724953
$ custom/scripts/prepatch.sh -crshome /oradb/crs/product/11.1.0/crs_1
$ cd /oradb/app/admin/orasw/patches/PSU_patches/Jan2012/CRS/111077/11724953
$ custom/server/11724953/custom/scripts/prepatch.sh -dbhome /oradb/asm/product/11.1.0/asm_1
$ cd /oradb/app/admin/orasw/patches/PSU_patches/Jan2012/CRS/111077/11724953
$ custom/server/11724953/custom/scripts/prepatch.sh -dbhome /oradb/app/oracle/product/11.1.0/db_1
------------------------------------------------------------------------------------------------------------------
Opatch Apply
============
Node 1: (AS ORACLE)
===================
CRS
===
$ cd /oradb/app/admin/orasw/patches/PSU_patches/Jan2012/CRS/111077
$ opatch napply -oh /oradb/crs/product/11.1.0/crs_1 -id 11724953
ASM
===
$ cd /oradb/app/admin/orasw/patches/PSU_patches/Jan2012/CRS/111077/11724953/custom/server
$ opatch napply custom/server/ -oh /oradb/asm/product/11.1.0/asm_1 -id 11724953
RDBMS
=====
$ cd /oradb/app/admin/orasw/patches/PSU_patches/Jan2012/CRS/111077/11724953/custom/server
$ opatch napply custom/server/ -oh /oradb/app/oracle/product/11.1.0/db_1 -id 11724953
------------------------------------------------------------------------------------------------------------------
Do the post configure for CRS and RDBMS home
============================================
Node 1: (AS ORACLE)
===================
CRS
===
$ cd /oradb/app/admin/orasw/patches/PSU_patches/Jan2012/CRS/111077/11724953/custom/scripts
$ ./postpatch.sh -crshome /oradb/crs/product/11.1.0/crs_1
ASM
===
$ cd /oradb/app/admin/orasw/patches/PSU_patches/Jan2012/CRS/111077/11724953/custom/server/11724953
$ ./custom/scripts/postpatch.sh -dbhome /oradb/asm/product/11.1.0/asm_1
RDBMS
=====
$ cd /oradb/app/admin/orasw/patches/PSU_patches/Jan2012/CRS/111077/11724953/custom/server/11724953
$ ./custom/scripts/postpatch.sh -dbhome /oradb/app/oracle/product/11.1.0/db_1
------------------------------------------------------------------------------------------------------------------
11.1.0.7.11 PSU (13621679) and (9734685)
========================================
Node 1: (AS ORACLE)
===================
13621679
========
$ cd /oradb/app/admin/orasw/patches
$ chmod -R 777 PSU_patches
$ cd PSU_patches
$ pwd
/oradb/app/admin/orasw/patches/PSU_patches
$ ls -lrt p13621679_111070_AIX5L.zip
$ unzip p13621679_111070_AIX5L.zip
$ ls -lrt
$ cd 13621679
$ pwd
ASM
===
$ /oradb/app/admin/orasw/patches/PSU_patches/13621679
$ opatch apply -oh /oradb/asm/product/11.1.0/asm_1
RDBMS
=====
$ cd /oradb/app/admin/orasw/patches/PSU_patches/13621679
$ opatch apply -oh /oradb/app/oracle/product/11.1.0/db_1
------------------------------------------------------------------------------------------------------------------
9734685
=======
$ cd /oradb/app/admin/orasw/patches/PSU_patches/
$ ls -lrt p9734685_1110711_AIX64-5L.zip
$ unzip p9734685_1110711_AIX64-5L.zip
ASM
===
$ cd /oradb/app/admin/orasw/patches/PSU_patches/9734685
$ opatch apply -oh /oradb/asm/product/11.1.0/asm_1
RDBMS
=====
$ cd /oradb/app/admin/orasw/patches/PSU_patches/9734685
$ opatch apply -oh /oradb/app/oracle/product/11.1.0/db_1
------------------------------------------------------------------------------------------------------------------
After 9734685 Patch applied relink has to be done in both ASM and DB homes ------- Linking Oracle
==========================================================================
Node 1: (AS ORACLE)
===================
RDBMS
=====
$ cd /oradb/app/oracle/product/11.1.0/db_1/rdbms/lib
$ make -f ins_rdbms.mk ipc_g ioracle
ASM
===
$ cd /oradb/asm/product/11.1.0/asm_1/rdbms/lib
$ make -f ins_rdbms.mk ipc_g ioracle
Node 2: (AS ORACLE)
=======
RDBMS
=====
$ cd /oradb/app/oracle/product/11.1.0/db_1/rdbms/lib
$ make -f ins_rdbms.mk ipc_g ioracle
ASM
===
$ cd /oradb/asm/product/11.1.0/asm_1/rdbms/lib
$ make -f ins_rdbms.mk ipc_g ioracle
------------------------------------------------------------------------------------------------------------------
Post-rootpatch
==============
Node 1: (AS ROOT)
=================
# cd /oradb/app/admin/orasw/patches/PSU_patches/Jan2012/CRS/111077/11724953
# /oradb/app/admin/orasw/patches/PSU_patches/Jan2012/CRS/111077/11724953/custom/scripts/postrootpatch.sh -crshome /oradb/crs/product/11.1.0/crs_1
# ps -ef | grep pmon --- Both the db and asm instances will be up and running
# ssh <Node 2>
# cd /oradb/app/admin/orasw/patches/PSU_patches/Jan2012/CRS/111077/11724953/custom/scripts/postrootpatch.sh -crshome /oradb/crs/product/11.1.0/crs_1
# ps -ef | grep pmon --- Both the db and asm instances will be up and running
------------------------------------------------------------------------------------------------------------------
Start ASM
------------------------------------------------------------------------------------------------------------------
Run on each database, only in one node
======================================
NODE 1: (AS ORACLE)
===================
$ sqlplus /nolog
Enter user-name: / as sysdba
Connected to an idle instance.
SQL>startup;
SQL>@?/rdbms/admin/catbundle.sql psu apply
SQL>exit
$. oraenv ---- --- database 2 instance
$ sqlplus /nolog
Enter user-name: / as sysdba
SQL>startup;
SQL>@?/rdbms/admin/catbundle.sql psu apply
SQL>exit
------------------------------------------------------------------------------------------------------------------
Patch Validation:-
================
opatch lsinventory | grep 11724953
opatch lsinventory | grep 13621679
opatch lsinventory | grep 9734685
start local listeners, (if any)
$ cd /oradb/crs/product/11.1.0/crs_1/bin
$ ./crsctl check cluster
$ cd /oradb/crs/product/11.1.0/crs_1/bin
$ ./crsctl check crs
$ cd /oradb/crs/product/11.1.0/crs_1/bin
$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
$ hostname
$ uname
$ bash
$ date
$ who -b
$ uptime
$ df -kg or df -h
$ cat /etc/oratab or cat/var/opt/oracle/oratab ------> Note ASM and Database Home Paths
$ ps -ef| grep pmon
$ ps -ef| grep tns
$ ps -ef| grep emagent
$ ps -ef|grep oracle
$ ps -ef| grep d.bin
$ ps -ef|grep crs
$ ps -ef| grep pmon
$ srvctl status database -d <database_1>
$ srvctl status database -d <database_2>
$ srvctl status asm -n <Node 1>
$ srvctl status asm -n <Node 2>
$ srvctl status listener -n <Node 1>
$ srvctl status listener -n <Node 2>
$ srvctl status nodeapps -n <Node 1>
$ srvctl status nodeapps -n <Node 2>
$ ps -ef|grep oracle or ps -ef|grep emagent
./emctl status agent or /oradb/app/oracle/product/agent1/agent11g/bin/emctl status agent
Run on each database only in one node
=====================================
NODE 1: (AS ORACLE)
===================
SQL> select name db_name,DB_UNIQUE_NAME,instance_name,status,DATABASE_STATUS,open_mode, database_role, host_name,platform_id,version db_version,log_mode,flashback_on ,protection_mode,protection_level,LOGINS,to_char(STARTUP_TIME,'DD-MON-YYYY HH24:MI:SS') "UP TIME" from gv$instance,v$database;
SQL> select to_char(sysdate,'yyyy-mm-dd HH24:MI:SS') from dual
/
SQL>
col ACTION_TIME for a12
col NAMESPACE for a10
col VERSION for a10
col BUNDLE_SERIES for a15
col COMMENTS for a20
select action_time, action,namespace, version, id,bundle_series, comments from registry$history;
------------------------------------------------------------------------------------------------------------------
check DR sysnc status
=====================
http://select-star-from.blogspot.in/2013/09/data-guard-sync-status.html
------------------------------------------------------------------------------------------------------------------
Stop OEM black out
==================
Confirmation
Request to stop blackout "Blackout-Apr 24 1998 9:33:42 PM" was processed successfully, Blackout status will be propagated to the target(s) shortly.
------------------------------------------------------------------------------------------------------------------
No comments:
Post a Comment