Upgrading 11.2.0.2 to 11.2.0.3.1
time to apply patch again…..
today i’ll be upgrading one of our production database from 11.2.0.2 to 11.2.0.3.1
install the software in new oracle home..
./runInstaller -silent \ -ignoreSysPrereqs \ -ignorePrereq \ -responseFile /dbSMKS/software/database/database/response/db_install.rsp \ ORACLE_BASE=/opt/app/oracle \ ORACLE_HOME=/opt/app/oracle/product/11.2.0.3/db_1 \ ORACLE_HOME_NAME=OraDbHome11203 \ oracle.install.option=INSTALL_DB_SWONLY \ oracle.install.db.InstallEdition=EE \ oracle.install.db.DBA_GROUP=dba \ oracle.install.db.OPER_GROUP=dba \ DECLINE_SECURITY_UPDATES=true \ '-ignoreInternalDriverError'
lnx04ora.bai.com: FITSD>BA_GROUP=dba oracle.install.db.OPER_GROUP=dba DECLINE_SECURITY_UPDATES=true '-ignoreInternalDriverError' < Starting Oracle Universal Installer... Checking Temp space: must be greater than 120 MB. Actual 1847 MB Passed Checking swap space: must be greater than 150 MB. Actual 4393 MB Passed Preparing to launch Oracle Universal Installer from /tmp/OraInstall2012-02-09_11-02-28PM. Please wait ...lnx04ora.bai.com: FITSD>[WARNING] [INS-32008] Oracle base location cant be same as the user home directory. CAUSE: The specified Oracle base is same as the user home directory. ACTION: Provide an Oracle base location other than the user home directory. You can find the log of this install session at: /opt/app/oraInventory/logs/installActions2012-02-09_11-02-28PM.log The installation of Oracle Database 11g was successful. Please check '/opt/app/oraInventory/logs/silentInstall2012-02-09_11-02-28PM.log' for more details.
contacted our UNIX support to execute the root.sh scripts
As a root user, execute the following script(s):
1. /opt/app/oracle/product/11.2.0.3/db_1/root.sh
Successfully Setup Software.
[root@dbi04cnc ~]# /opt/app/oracle/product/11.2.0.3/db_1/root.sh
Check /opt/app/oracle/product/11.2.0.3/db_1/install/root_lnx04ora.bai.com_2012-02-09_23-15-03.log for the output of root script
[root@dbi04cnc ~]#
this my database needs to be upgraded.
lnx04ora.bai.com: FITSD>sqlplus '/ as sysdba' SQL*Plus: Release 11.2.0.2.0 Production on Thu Feb 9 23:31:54 2012 Copyright (c) 1982, 2010, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> select name from v$database; NAME --------------------------- FITSD SQL> SQL> SQL> select * from v$version; BANNER -------------------------------------------------------------------------------- Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production PL/SQL Release 11.2.0.2.0 - Production CORE 11.2.0.2.0 Production TNS for Linux: Version 11.2.0.2.0 - Production NLSRTL Version 11.2.0.2.0 - Production
perform the pre upgrade check…
SQL> @utlu112i.sql
Oracle Database 11.2 Pre-Upgrade Information Tool 02-09-2012 23:45:14
Script Version: 11.2.0.3.0 Build: 001
.
**********************************************************************
Database:
**********************************************************************
--> name: FITSD
--> version: 11.2.0.2.0
--> compatible: 11.1.0.0.0
--> blocksize: 8192
--> platform: Linux x86 64-bit
--> timezone file: V14
.
**********************************************************************
Tablespaces: [make adjustments in the current environment]
**********************************************************************
--> SYSTEM tablespace is adequate for the upgrade.
.... minimum required size: 1006 MB
--> SYSAUX tablespace is adequate for the upgrade.
.... minimum required size: 1150 MB
--> UNDOTBS1 tablespace is adequate for the upgrade.
.... minimum required size: 400 MB
--> TEMP tablespace is adequate for the upgrade.
.... minimum required size: 60 MB
.
**********************************************************************
Flashback: OFF
**********************************************************************
**********************************************************************
Update Parameters: [Update Oracle Database 11.2 init.ora or spfile]
Note: Pre-upgrade tool was run on a lower version 64-bit database.
**********************************************************************
--> If Target Oracle is 32-Bit, refer here for Update Parameters:
-- No update parameter changes are required.
.
--> If Target Oracle is 64-Bit, refer here for Update Parameters:
-- No update parameter changes are required.
.
**********************************************************************
Renamed Parameters: [Update Oracle Database 11.2 init.ora or spfile]
**********************************************************************
-- No renamed parameters found. No changes are required.
.
**********************************************************************
Obsolete/Deprecated Parameters: [Update Oracle Database 11.2 init.ora or spfile]
**********************************************************************
-- No obsolete parameters found. No changes are required
.
**********************************************************************
Components: [The following database components will be upgraded or installed]
**********************************************************************
--> Oracle Catalog Views [upgrade] VALID
--> Oracle Packages and Types [upgrade] VALID
--> JServer JAVA Virtual Machine [upgrade] VALID
--> Oracle XDK for Java [upgrade] VALID
--> Oracle Workspace Manager [upgrade] VALID
--> OLAP Analytic Workspace [upgrade] VALID
--> OLAP Catalog [upgrade] VALID
--> EM Repository [upgrade] VALID
--> Oracle Text [upgrade] VALID
--> Oracle XML Database [upgrade] VALID
--> Oracle Java Packages [upgrade] VALID
--> Oracle interMedia [upgrade] VALID
--> Spatial [upgrade] VALID
--> Expression Filter [upgrade] VALID
--> Rule Manager [upgrade] VALID
--> Oracle Application Express [upgrade] VALID
... APEX will only be upgraded if the version of APEX in
... the target Oracle home is higher than the current one.
--> Oracle OLAP API [upgrade] VALID
.
**********************************************************************
Miscellaneous Warnings
**********************************************************************
WARNING: --> Table sys.enabled$indexes exists in the database.
.... DROP TABLE sys.enabled$indexes prior to upgrading the database.
WARNING: --> Database contains INVALID objects prior to upgrade.
.... The list of invalid SYS/SYSTEM objects was written to
.... registry$sys_inv_objs.
.... The list of non-SYS/SYSTEM objects was written to
.... registry$nonsys_inv_objs.
.... Use utluiobj.sql after the upgrade to identify any new invalid
.... objects due to the upgrade.
.... USER MDSYS has 66 INVALID objects.
.... USER MKS has 15 INVALID objects.
.... USER PUBLIC has 2046 INVALID objects.
.... USER CTXSYS has 58 INVALID objects.
.... USER OLAPSYS has 293 INVALID objects.
.... USER FLOWS_FILES has 1 INVALID objects.
.... USER SYSTEM has 15 INVALID objects.
.... USER EXFSYS has 51 INVALID objects.
.... USER APEX_030200 has 783 INVALID objects.
.... USER DBSNMP has 6 INVALID objects.
.... USER ORDSYS has 7 INVALID objects.
.... USER ORDPLUGINS has 2 INVALID objects.
.... USER SYSMAN has 473 INVALID objects.
.... USER XDB has 16 INVALID objects.
.... USER FLOWS_030000 has 429 INVALID objects.
.... USER ORDDATA has 1 INVALID objects.
.... USER SYS has 2337 INVALID objects.
.... USER WMSYS has 119 INVALID objects.
.... USER SI_INFORMTN_SCHEMA has 2 INVALID objects.
WARNING: --> Your recycle bin contains 17 object(s).
.... It is REQUIRED that the recycle bin is empty prior to upgrading
.... your database. The command:
PURGE DBA_RECYCLEBIN
.... must be executed immediately prior to executing your upgrade.
WARNING: --> Database contains schemas with objects dependent on DBMS_LDAP package.
.... Refer to the 11g Upgrade Guide for instructions to configure Network ACLs.
.... USER APEX_030200 has dependent objects.
.... USER FLOWS_030000 has dependent objects.
.
**********************************************************************
Recommendations
**********************************************************************
Oracle recommends gathering dictionary statistics prior to
upgrading the database.
To gather dictionary statistics execute the following command
while connected as SYSDBA:
EXECUTE dbms_stats.gather_dictionary_stats;
**********************************************************************
Oracle recommends reviewing any defined events prior to upgrading.
To view existing non-default events execute the following commands
while connected AS SYSDBA:
Events:
SELECT (translate(value,chr(13)||chr(10),' ')) FROM sys.v$parameter2
WHERE UPPER(name) ='EVENT' AND isdefault='FALSE'
Trace Events:
SELECT (translate(value,chr(13)||chr(10),' ')) from sys.v$parameter2
WHERE UPPER(name) = '_TRACE_EVENTS' AND isdefault='FALSE'
Changes will need to be made in the init.ora or spfile.
**********************************************************************
SQL> spool off;
SQL> SELECT (translate(value,chr(13)||chr(10),' ')) FROM sys.v$parameter2 WHERE UPPER(name) ='EVENT' AND isdefault='FALSE';
no rows selected
SQL> SELECT (translate(value,chr(13)||chr(10),' ')) from sys.v$parameter2 WHERE UPPER(name) = '_TRACE_EVENTS' AND isdefault='FALSE';
no rows selected
SQL>
backup backup backup…. cold backup and start the database
SQL> startup ORACLE instance started. Total System Global Area 1603411968 bytes Fixed Size 2226912 bytes Variable Size 402654496 bytes Database Buffers 1191182336 bytes Redo Buffers 7348224 bytes Database mounted. Database opened. SQL>
set environment variables..
lnx04ora.bai.com: FITSD>pwd /opt/app/oracle/product/11.2.0.3/db_1 lnx04ora.bai.com: FITSD>export ORACLE_HOME=/opt/app/oracle/product/11.2.0.3/db_1 lnx04ora.bai.com: FITSD>export PATH=$ORACLE_HOME/bin:$PATH lnx04ora.bai.com: FITSD>type dbua dbua is a tracked alias for /opt/app/oracle/product/11.2.0.3/db_1/bin/dbua
perform the upgrade using database upgrade assistant.
lnx04ora.bai.com: FITSD>dbua -silent -sid FITSD Log files for the upgrade operation are located at: /opt/app/oracle/cfgtoollogs/dbua/FITSD/upgrade2 Performing Pre Upgrade 1% complete 7% complete Upgrading Oracle Server 8% complete 9% complete 10% complete 10% complete 11% complete 12% complete 13% complete 13% complete 14% complete 15% complete 16% complete 16% complete 17% complete 18% complete 19% complete 20% complete 20% complete 21% complete 22% complete 23% complete 23% complete 24% complete 25% complete 26% complete 26% complete 27% complete 28% complete 29% complete 30% complete 30% complete 31% complete 32% complete 33% complete 33% complete 34% complete 35% complete 36% complete 36% complete 37% complete 38% complete 39% complete 40% complete 40% complete 41% complete 42% complete 43% complete 43% complete 44% complete 45% complete 46% complete 46% complete 47% complete 48% complete 49% complete 50% complete 50% complete 51% complete 52% complete 53% complete 53% complete 54% complete 55% complete 56% complete 56% complete 57% complete 58% complete 59% complete 60% complete 60% complete 61% complete 62% complete 63% complete 63% complete 64% complete 65% complete 66% complete 66% complete 67% complete 68% complete 69% complete 70% complete 70% complete 71% complete 72% complete 73% complete 73% complete 74% complete 75% complete 76% complete 76% complete 77% complete Upgrading JServer JAVA Virtual Machine 79% complete 80% complete 80% complete Upgrading Oracle XDK for Java 82% complete Upgrading OLAP Analytic Workspace 83% complete 84% complete Upgrading OLAP Catalog Upgrading EM Repository Upgrading Oracle Text Upgrading Oracle XML Database Upgrading Oracle Java Packages Upgrading Oracle interMedia Upgrading Spatial Upgrading Oracle Workspace Manager Upgrading Expression Filter Upgrading Rule Manager Upgrading Oracle Application Express Upgrading Oracle OLAP API Performing Post Upgrade 85% complete 86% complete 92% complete Generating Summary Database upgrade has been completed successfully, and the database is ready to use. 100% complete Check the log file "/opt/app/oracle/cfgtoollogs/dbua/logs/silent.log" for upgrade details. lnx04ora.bai.com: FITSD> dont forget to check the logs....
verify…
SQL> select * from v$version; BANNER -------------------------------------------------------------------------------- Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production PL/SQL Release 11.2.0.3.0 - Production CORE 11.2.0.3.0 Production TNS for Linux: Version 11.2.0.3.0 - Production NLSRTL Version 11.2.0.3.0 - Production SQL>
as part of my upgrade… i’ll be applying PSU patch.. not really sure if i can install the patch first before doing the upgrade
so i decided to do it separately.
perform the pre req before running opatch apply
lnx04ora.bai.com: FITSD>opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir ./13343438 Invoking OPatch 11.2.0.1.1 Oracle Interim Patch Installer version 11.2.0.1.1 Copyright (c) 2009, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /opt/app/oracle/product/11.2.0.3/db_1 Central Inventory : /opt/app/oraInventory from : /etc/oraInst.loc OPatch version : 11.2.0.1.1 OUI version : 11.2.0.3.0 OUI location : /opt/app/oracle/product/11.2.0.3/db_1/oui Log file location : /opt/app/oracle/product/11.2.0.3/db_1/cfgtoollogs/opatch/opatch2012-02-10_02-35-40AM.log Patch history file: /opt/app/oracle/product/11.2.0.3/db_1/cfgtoollogs/opatch/opatch_history.txt Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded.
if everything is fine… apply the patch.
lnx04ora.bai.com: FITSD>cd 13343438 lnx04ora.bai.com: FITSD>opatch apply Invoking OPatch 11.2.0.1.1 Oracle Interim Patch Installer version 11.2.0.1.1 Copyright (c) 2009, Oracle Corporation. All rights reserved. Oracle Home : /opt/app/oracle/product/11.2.0.3/db_1 Central Inventory : /opt/app/oraInventory from : /etc/oraInst.loc OPatch version : 11.2.0.1.1 OUI version : 11.2.0.3.0 OUI location : /opt/app/oracle/product/11.2.0.3/db_1/oui Log file location : /opt/app/oracle/product/11.2.0.3/db_1/cfgtoollogs/opatch/opatch2012-02-10_02-36-42AM.log Patch history file: /opt/app/oracle/product/11.2.0.3/db_1/cfgtoollogs/opatch/opatch_history.txt ApplySession applying interim patch '13343438' to OH '/opt/app/oracle/product/11.2.0.3/db_1' Running prerequisite checks... OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only. Please shutdown Oracle instances running out of this ORACLE_HOME on the local system. (Oracle Home = '/opt/app/oracle/product/11.2.0.3/db_1') Is the local system ready for patching? [y|n] y User Responded with: Y Backing up files and inventory (not for auto-rollback) for the Oracle Home Backing up files affected by the patch '13343438' for restore. This might take a while... Backing up files affected by the patch '13343438' for rollback. This might take a while... Patching component oracle.rdbms.rsf, 11.2.0.3.0... Updating archive file "/opt/app/oracle/product/11.2.0.3/db_1/lib/libgeneric11.a" with "lib/libgeneric11.a/kgodm.o" Updating archive file "/opt/app/oracle/product/11.2.0.3/db_1/lib/libcommon11.a" with "lib/libcommon11.a/kdzs.o" Copying file to "/opt/app/oracle/product/11.2.0.3/db_1/rdbms/mesg/oraus.msg" Copying file to "/opt/app/oracle/product/11.2.0.3/db_1/rdbms/mesg/oraus.msb" Patching component oracle.rdbms, 11.2.0.3.0... Updating archive file "/opt/app/oracle/product/11.2.0.3/db_1/lib/libserver11.a" with "lib/libserver11.a/kff.o" Updating archive file "/opt/app/oracle/product/11.2.0.3/db_1/lib/libserver11.a" with "lib/libserver11.a/kfg.o" Updating archive file "/opt/app/oracle/product/11.2.0.3/db_1/lib/libserver11.a" with "lib/libserver11.a/kfx.o" Updating archive file "/opt/app/oracle/product/11.2.0.3/db_1/lib/libserver11.a" with "lib/libserver11.a/kfds.o" Updating archive file "/opt/app/oracle/product/11.2.0.3/db_1/lib/libserver11.a" with "lib/libserver11.a/kfd.o" Updating archive file "/opt/app/oracle/product/11.2.0.3/db_1/lib/libserver11.a" with "lib/libserver11.a/kspt.o" Updating archive file "/opt/app/oracle/product/11.2.0.3/db_1/lib/libserver11.a" with "lib/libserver11.a/kjbr.o" Updating archive file "/opt/app/oracle/product/11.2.0.3/db_1/lib/libserver11.a" with "lib/libserver11.a/kjbl.o" Updating archive file "/opt/app/oracle/product/11.2.0.3/db_1/lib/libserver11.a" with "lib/libserver11.a/kjbm.o" Updating archive file "/opt/app/oracle/product/11.2.0.3/db_1/lib/libserver11.a" with "lib/libserver11.a/kcl.o" Updating archive file "/opt/app/oracle/product/11.2.0.3/db_1/lib/libserver11.a" with "lib/libserver11.a/kjb.o" Updating archive file "/opt/app/oracle/product/11.2.0.3/db_1/lib/libserver11.a" with "lib/libserver11.a/kta.o" Updating archive file "/opt/app/oracle/product/11.2.0.3/db_1/lib/libserver11.a" with "lib/libserver11.a/kjcl.o" Updating archive file "/opt/app/oracle/product/11.2.0.3/db_1/lib/libserver11.a" with "lib/libserver11.a/kjdx.o" Updating archive file "/opt/app/oracle/product/11.2.0.3/db_1/lib/libserver11.a" with "lib/libserver11.a/kjfc.o" Updating archive file "/opt/app/oracle/product/11.2.0.3/db_1/lib/libserver11.a" with "lib/libserver11.a/kjfs.o" Updating archive file "/opt/app/oracle/product/11.2.0.3/db_1/lib/libserver11.a" with "lib/libserver11.a/kji.o" Updating archive file "/opt/app/oracle/product/11.2.0.3/db_1/lib/libserver11.a" with "lib/libserver11.a/kjs.o" Updating archive file "/opt/app/oracle/product/11.2.0.3/db_1/lib/libserver11.a" with "lib/libserver11.a/kju.o" Updating archive file "/opt/app/oracle/product/11.2.0.3/db_1/lib/libserver11.a" with "lib/libserver11.a/kjx.o" Updating archive file "/opt/app/oracle/product/11.2.0.3/db_1/lib/libserver11.a" with "lib/libserver11.a/psdsys.o" Updating archive file "/opt/app/oracle/product/11.2.0.3/db_1/lib/libserver11.a" with "lib/libserver11.a/kfe.o" Updating archive file "/opt/app/oracle/product/11.2.0.3/db_1/lib/libserver11.a" with "lib/libserver11.a/kfksubs.o" Updating archive file "/opt/app/oracle/product/11.2.0.3/db_1/lib/libserver11.a" with "lib/libserver11.a/kdd.o" Updating archive file "/opt/app/oracle/product/11.2.0.3/db_1/lib/libserver11.a" with "lib/libserver11.a/kds.o" Updating archive file "/opt/app/oracle/product/11.2.0.3/db_1/lib/libserver11.a" with "lib/libserver11.a/kdst.o" Updating archive file "/opt/app/oracle/product/11.2.0.3/db_1/lib/libserver11.a" with "lib/libserver11.a/kdt.o" Updating archive file "/opt/app/oracle/product/11.2.0.3/db_1/lib/libserver11.a" with "lib/libserver11.a/kdza.o" Updating archive file "/opt/app/oracle/product/11.2.0.3/db_1/lib/libserver11.a" with "lib/libserver11.a/kcf.o" Updating archive file "/opt/app/oracle/product/11.2.0.3/db_1/lib/libserver11.a" with "lib/libserver11.a/tbsdrv.o" Updating archive file "/opt/app/oracle/product/11.2.0.3/db_1/lib/libserver11.a" with "lib/libserver11.a/qertb.o" Updating archive file "/opt/app/oracle/product/11.2.0.3/db_1/lib/libserver11.a" with "lib/libserver11.a/ksfd.o" Updating archive file "/opt/app/oracle/product/11.2.0.3/db_1/lib/libserver11.a" with "lib/libserver11.a/ksut.o" Updating archive file "/opt/app/oracle/product/11.2.0.3/db_1/lib/libserver11.a" with "lib/libserver11.a/kdst00.o" Updating archive file "/opt/app/oracle/product/11.2.0.3/db_1/lib/libserver11.a" with "lib/libserver11.a/kdstrr.o" Updating archive file "/opt/app/oracle/product/11.2.0.3/db_1/lib/libserver11.a" with "lib/libserver11.a/kdst11.o" Updating archive file "/opt/app/oracle/product/11.2.0.3/db_1/lib/libserver11.a" with "lib/libserver11.a/kdzh.o" Updating archive file "/opt/app/oracle/product/11.2.0.3/db_1/lib/libserver11.a" with "lib/libserver11.a/ctc.o" Updating archive file "/opt/app/oracle/product/11.2.0.3/db_1/lib/libserver11.a" with "lib/libserver11.a/kkpod.o" Updating archive file "/opt/app/oracle/product/11.2.0.3/db_1/lib/libserver11.a" with "lib/libserver11.a/kkpo.o" Updating archive file "/opt/app/oracle/product/11.2.0.3/db_1/lib/libserver11.a" with "lib/libserver11.a/ktss.o" Updating archive file "/opt/app/oracle/product/11.2.0.3/db_1/lib/libserver11.a" with "lib/libserver11.a/ktt.o" Updating archive file "/opt/app/oracle/product/11.2.0.3/db_1/lib/libserver11.a" with "lib/libserver11.a/psdpgi.o" Updating archive file "/opt/app/oracle/product/11.2.0.3/db_1/lib/libserver11.a" with "lib/libserver11.a/k2.o" Updating archive file "/opt/app/oracle/product/11.2.0.3/db_1/lib/libserver11.a" with "lib/libserver11.a/k2r.o" Updating archive file "/opt/app/oracle/product/11.2.0.3/db_1/lib/libserver11.a" with "lib/libserver11.a/k2s.o" Updating archive file "/opt/app/oracle/product/11.2.0.3/db_1/lib/libserver11.a" with "lib/libserver11.a/kpoal8.o" Updating archive file "/opt/app/oracle/product/11.2.0.3/db_1/lib/libserver11.a" with "lib/libserver11.a/ncodef.o" Updating archive file "/opt/app/oracle/product/11.2.0.3/db_1/lib/libserver11.a" with "lib/libserver11.a/npi.o" Updating archive file "/opt/app/oracle/product/11.2.0.3/db_1/lib/libserver11.a" with "lib/libserver11.a/kpostr.o" Updating archive file "/opt/app/oracle/product/11.2.0.3/db_1/lib/libserver11.a" with "lib/libserver11.a/opial7.o" Updating archive file "/opt/app/oracle/product/11.2.0.3/db_1/lib/libserver11.a" with "lib/libserver11.a/opiexe.o" Updating archive file "/opt/app/oracle/product/11.2.0.3/db_1/lib/libserver11.a" with "lib/libserver11.a/psdicd.o" Updating archive file "/opt/app/oracle/product/11.2.0.3/db_1/lib/libserver11.a" with "lib/libserver11.a/kcm.o" Updating archive file "/opt/app/oracle/product/11.2.0.3/db_1/lib/libserver11.a" with "lib/libserver11.a/kcs.o" Updating archive file "/opt/app/oracle/product/11.2.0.3/db_1/lib/libserver11.a" with "lib/libserver11.a/kcv.o" Updating archive file "/opt/app/oracle/product/11.2.0.3/db_1/lib/libserver11.a" with "lib/libserver11.a/knl.o" Updating archive file "/opt/app/oracle/product/11.2.0.3/db_1/lib/libserver11.a" with "lib/libserver11.a/qerrm.o" Updating archive file "/opt/app/oracle/product/11.2.0.3/db_1/lib/libserver11.a" with "lib/libserver11.a/kdst01.o" Updating archive file "/opt/app/oracle/product/11.2.0.3/db_1/lib/libserver11.a" with "lib/libserver11.a/kcbz.o" Updating archive file "/opt/app/oracle/product/11.2.0.3/db_1/lib/libserver11.a" with "lib/libserver11.a/kcb.o" Updating archive file "/opt/app/oracle/product/11.2.0.3/db_1/rdbms/lib/libknlopt.a" with "rdbms/lib/libknlopt.a/kkxwtp.o" Copying file to "/opt/app/oracle/product/11.2.0.3/db_1/rdbms/admin/bundledata_PSU.xml" Copying file to "/opt/app/oracle/product/11.2.0.3/db_1/bin/asmcmdcore" Copying file to "/opt/app/oracle/product/11.2.0.3/db_1/rdbms/lib/kkxwtp.o" Copying file to "/opt/app/oracle/product/11.2.0.3/db_1/psu/11.2.0.3.1/catpsu.sql" Copying file to "/opt/app/oracle/product/11.2.0.3/db_1/psu/11.2.0.3.1/catpsu_rollback.sql" Patching component oracle.rdbms.dbscripts, 11.2.0.3.0... Copying file to "/opt/app/oracle/product/11.2.0.3/db_1/rdbms/admin/c1102000.sql" Copying file to "/opt/app/oracle/product/11.2.0.3/db_1/rdbms/admin/e1102000.sql" Copying file to "/opt/app/oracle/product/11.2.0.3/db_1/rdbms/admin/catfusrg.sql" Running make for target client_sharedlib Running make for target client_sharedlib Running make for target ioracle ApplySession adding interim patch '13343438' to inventory Verifying the update... Inventory check OK: Patch ID 13343438 is registered in Oracle Home inventory with proper meta-data. Files check OK: Files from Patch ID 13343438 are present in Oracle Home. The local system has been patched and can be restarted. OPatch succeeded.
since my database is currently down prior to applying the patch. now we need to start the DB.
lnx04ora.bai.com: FITSD>sqlplus '/ as sysdba' SQL*Plus: Release 11.2.0.3.0 Production on Fri Feb 10 02:39:59 2012 Copyright (c) 1982, 2011, Oracle. All rights reserved. Connected to an idle instance. SQL> startup ORACLE instance started. Total System Global Area 1603411968 bytes Fixed Size 2228784 bytes Variable Size 419433936 bytes Database Buffers 1174405120 bytes Redo Buffers 7344128 bytes Database mounted. Database opened. SQL> exit
now apply the patch to the database.
lnx04ora.bai.com: FITSD>cd $ORACLE_HOME/rdbms/admin lnx04ora.bai.com: FITSD>pwd /opt/app/oracle/product/11.2.0.3/db_1/rdbms/admin lnx04ora.bai.com: FITSD>sqlplus '/ as sysdba' SQL*Plus: Release 11.2.0.3.0 Production on Fri Feb 10 02:40:46 2012 Copyright (c) 1982, 2011, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> @catbundle.sql psu apply
SQL> @catbundle.sql psu apply
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
Generating apply and rollback scripts...
Check the following file for errors:
/opt/app/oracle/cfgtoollogs/catbundle/catbundle_PSU_FITSD_GENERATE_2012Feb10_02_41_05.log
Apply script: /opt/app/oracle/product/11.2.0.3/db_1/rdbms/admin/catbundle_PSU_FITSD_APPLY.sql
Rollback script: /opt/app/oracle/product/11.2.0.3/db_1/rdbms/admin/catbundle_PSU_FITSD_ROLLBACK.sql
PL/SQL procedure successfully completed.
Executing script file...
SQL> COLUMN spool_file NEW_VALUE spool_file NOPRINT
SQL> SELECT '/opt/app/oracle/cfgtoollogs/catbundle/' || 'catbundle_PSU_' || name || '_APPLY_' || TO_CHAR(SYSDATE, 'YYYYMonDD_hh24_mi_ss', 'NLS_DATE_LA NGUAGE=''AMERICAN''') || '.log' AS spool_file FROM v$database;
SQL> SPOOL &spool_file
SQL> exec dbms_registry.set_session_namespace('SERVER')
PL/SQL procedure successfully completed.
SQL> ALTER SESSION SET current_schema = SYS;
Session altered.
SQL> PROMPT Updating registry...
Updating registry...
SQL> INSERT INTO registry$history
2 (action_time, action,
3 namespace, version, id,
4 bundle_series, comments)
5 VALUES
6 (SYSTIMESTAMP, 'APPLY',
7 SYS_CONTEXT('REGISTRY$CTX','NAMESPACE'),
8 '11.2.0.3',
9 1,
10 'PSU',
11 'PSU 11.2.0.3.1');
1 row created.
SQL> COMMIT;
Commit complete.
SQL> SPOOL off
SQL> SET echo off
Check the following log file for errors: /opt/app/oracle/cfgtoollogs/catbundle/catbundle_PSU_FITSD_APPLY_2012Feb10_02_41_07.log
check the history$registry….
ACTION NAMESPACE VERSION BUNDLE_SER COMMENTS ------------------------------ ---------- ---------- ---------- ------------------------------ APPLY SERVER 11.1.0.7 PSU PSU 11.1.0.7.5 CPU view recompilation VIEW INVALIDATE view invalidation UPGRADE SERVER 11.2.0.2.0 Upgraded from 11.1.0.7.0 VIEW INVALIDATE view invalidation UPGRADE SERVER 11.2.0.3.0 Upgraded from 11.2.0.2.0 APPLY SERVER 11.2.0.3 PSU Patchset 11.2.0.2.0 APPLY SERVER 11.2.0.3 PSU PSU 11.2.0.3.1
since we are using RMAN catalog… we need also to upgrade the catalog.
lnx04ora.bai.com: FITSD>/opt/app/oracle/product/11.2.0.3/db_1/bin/rman target / catalog ...... Recovery Manager: Release 11.2.0.3.0 - Production on Fri Feb 10 04:33:40 2012 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. connected to target database: FITSD (DBID=3617642037) connected to recovery catalog database recovery catalog is partially upgraded to 11.02.00.03 RMAN> upgrade catalog; recovery catalog owner is RMAN11GR2 enter UPGRADE CATALOG command again to confirm catalog upgrade RMAN> upgrade catalog; recovery catalog upgraded to version 11.02.00.03 DBMS_RCVMAN package upgraded to version 11.02.00.03 DBMS_RCVCAT package upgraded to version 11.02.00.03 RMAN>
don’t forget to configure the listener…
baikodaker
hi,
did you had to take any special step for DST patches?
did you had any trouble deleting old oracle home as a post upgrade steps?
thanks,
Nikhil
hi Nikhil,
thanks for visiting… no i did not do anything special.
1 week after the upgrade old oracle home was deleted.
How long did the upgrade take?
sorry for late reply …. i was on vacation for more than a month.
the process take 30mins to 1 hour.
Hi Nikhil,
1. On install the software in new oracle home, did you come up with this command or did it come from the upgrade instruction ? Is it where the new Oracle_Home location is decided ?
2.how to check the history$registry ?
Thanks,
Paul
Hi Paul,
1. 11.2.0.3 needs to be installed on new OH. its also included in the document, i think. it also safe installing on new OH to minimize downtime.
because while installing and apply the latest patch, your DB still running and will be shutdown/restarted only during the actual upgrade.
2.select * history$registry.
thanks for visiting my site..
In addition, could you explain why run root.sh, and why UNIX support was needed to run root.shl.
Thanks,
Paul
root.sh needs to be executed with root privilege. unless you have access to root then you don’t need the Unix guys.