16 July 2014
Notes: Instructions on patching 11.2.0.x database to 11.2.0.4
Install 11.2.0.4 software
Run Xming
export DISPLAY=xxx:0.0
export TEMP=xxxx
cd your_stage_directorey
Check first what options are installed on your database:
select * from v$option where PARAMETER in
('Partitioning','OLAP','Oracle Label
Security','Oracle Database Vault','Real Application Testing','Data Mining');
cd stage_dir/18031668
opatch prereq CheckConflictAgainstOHWithDetail
-ph ./
There should be no conflicts
opatch apply
This will apply 17478514 18031668. After that you need to apply two more patches.
ld: warning: option -Q appears more than once, first setting taken -- You can safely ignore Each patch takes few minutes
cd $ORACLE_HOME/rdbms/admin
sqlplus / as sysdba
SQL> STARTUP
SQL> @catbundle.sql psu apply
select
opatch apply
This will apply 17478514 18031668. After that you need to apply two more patches.
ld: warning: option -Q appears more than once, first setting taken -- You can safely ignore Each patch takes few minutes
cd $ORACLE_HOME/rdbms/admin
sqlplus / as sysdba
SQL> STARTUP
SQL> @catbundle.sql psu apply
select
substr(id,1,10) id,
substr(action,1,10) action,
substr(version,1,8) version,
substr(BUNDLE_SERIES,1,6) bundle,
substr(comments,1,20) comments
from registry$history;
substr(action,1,10) action,
substr(version,1,8) version,
substr(BUNDLE_SERIES,1,6) bundle,
substr(comments,1,20) comments
from registry$history;
./runInstaller
.... takes 5-10 min
Patching
Set new line in oratab: (I like setting env this way, you don't
have to)
vi /var/opt/oracle/oratab
new:/opt/oracle/product/db/11.2.0.4:Y
. oraenv with new
Install OPatch utility version 11.2.0.3.6 or later
cd stage_dir/OPatch
cp p6880880_112040_SOLARIS64.zip $ORACLE_HOME
oh;unzip p6880880_112040_SOLARIS64.zip
export PATH =$ORACLE_HOME/OPatch:/usr/ccs/bin:$PATH
cd ../17551261; opatch apply
cd ../17767676; opatch apply
** clean up ~/temp and remove "new" from oraenv
Upgrade Database
Run this before upgrade: @$ORACLE_HOME/rdbms/admin/utlu112i.sql
PURGE DBA_RECYCLEBIN;
EXECUTE dbms_stats.gather_dictionary_stats;
show parameter recycle
alter system set recyclebin=off scope=spfile;
restart
export DISPLAY=xxx:0.0
export TEMP=xxx
DR part
On the production:
alter system switch logfile;
alter system set db_recovery_file_dest_size=6G scope=both;
DGMGRL> DISABLE CONFIGURATION;
Both prod and DR: SQL> ALTER SYSTEM SET
DG_BROKER_START=FALSE;
alter system set log_archive_dest_state_2='DEFER' scope=both;
show parameter dg_broker_config
Make a copy of the file
Shut down standby
CREATE RESTORE POINT UPG_11204 GUARANTEE FLASHBACK DATABASE;
CREATE RESTORE POINT UPG_11204 GUARANTEE FLASHBACK DATABASE;
cd $ORACLE_HOME//bin
./dbua
(use all default option, except for:
-- untick "Configure DB with OEM"
Started at 7:40am - (50% at 8am ) finished at 8:07am .
Errors with ORA-6512 WMSYS.OWM_MIG _PKG can be ignored.
After upgrade
On both prod and DR:
export ORACLE_HOME=
oh; cd bin
stop listeners
. oraenv
xxx
oh
cp network/admin/*.ora file to a new home
alter system set recyclebin=on scope=spfile;
restart
start listeners
DR part
Standby:
Make a copy of the existing password file
Copy the production password file from the old home
Copy the spfile files from the old home
Copy the broker files from the old home
cp network/admin/*.ora file to a new home
vi /var/opt/oracle/oratab and change the oracle home
. oraenv
Mount the physical standby database(s) on the new Oracle home
(upgraded version).
Note: The standby database(s) should not be opened until the primary database
upgrade is completed.
Production:
alter system set log_archive_dest_state_2='ENABLE' scope=both;
Both : ALTER SYSTEM SET DG_BROKER_START=TRUE scope=both;
DGMGRL> ENABLE CONFIGURATION
alter system set db_recovery_file_dest_size=2G scope=both;
--put back the old size
If all ok, DROP RESTORE POINT UPG_11204;
Check DST is version 14:
SELECT version FROM v$timezone_file;
Verify the PSU Post Install steps were
run in the DB
select substr(action_time,1,30)
action_time,
rman target xx@xx catalog
UPGRADE CATALOG
UPGRADE CATALOG (do it twice)
Change the housekeeping file
Change any other scripts/cron jobs
Change the Config in the Grid
Deinstall
Deinstall the home:
oh; cd ../11.2.0.3/network/admin
mv listener.ora listener.ora.old
set ORACLE_HOME=xxx (old home)
cd $ORACLE_HOME
$ORACLE_HOME/deinstall/deinstall
Comments:
<< Home
Hi Tanja,
Thank you very (very, very...) much for these notes. I have been struggling to get all steps working, this was for me the correct way to do it.
Thanks!
Post a Comment
Thank you very (very, very...) much for these notes. I have been struggling to get all steps working, this was for me the correct way to do it.
Thanks!
<< Home
