Home > 11g > Key RDBMS Install Differences in 11gR2

Key RDBMS Install Differences in 11gR2

April 26, 2013

Difference Category Difference Item 11gR2 11gR1 10gR2 10gR1 9iR2
RDBMS File Structure $O_B / $O_H relationship Each $O_H has a corresponding $O_B. It is recommended that one Oracle Base location be shared by all the Oracle Homes per user. You must set an $ORACLE_BASE. Each $O_H has a corresponding $O_B. It is recommended that one Oracle Base location be shared by all the Oracle Homes per user. By default, $ORACLE_BASE will be set to $ORACLE_HOME. All $ORACLE_HOMEs have a common $ORACLE_BASE All $ORACLE_HOMEs have a common $ORACLE_BASE All $ORACLE_HOMEs have a common $ORACLE_BASE
default inventory location $ORACLE_BASE/../oraInventory $ORACLE_BASE/../oraInventory $ORACLE_BASE/oraInventory $ORACLE_BASE/oraInventory $ORACLE_BASE/oraInventory
cdump directory $ORACLE_BASE/diag/rdbms/{SID}/{SID}/cdump $ORACLE_BASE/diag/rdbms/{SID}/{SID}/cdump $ORACLE_BASE/admin/{SID}/cdump $ORACLE_BASE/admin/{SID}/cdump $ORACLE_BASE/admin/{SID}/cdump
control backup to trace files $ORACLE_BASE/diag/rdbms/{SID}/{SID}/trace $ORACLE_BASE/diag/rdbms/{SID}/{SID}/trace $ORACLE_BASE/admin/{SID}/udump $ORACLE_BASE/admin/{SID}/udump $ORACLE_BASE/admin/{SID}/udump
Difference Category Difference Item 11gR2 11gR1 10gR2 10gR1 9iR2
RDBMS Log File Locations alert logs $ORACLE_BASE/diag/rdbms/{SID}/{SID}/alert $ORACLE_BASE/diag/rdbms/{SID}/{SID}/alert $ORACLE_BASE/admin/{SID}/bdump/alert_{SID}.log $ORACLE_BASE/admin/{SID}/bdump/alert_{SID}.log $ORACLE_BASE/admin/{SID}/bdump/alert_{SID}.log
SQL Script Names migration script
(upgrades DB between major release levels)
@?/rdbms/admin/catupgrd.sql @?/rdbms/admin/catupgrd.sql @?/rdbms/admin/catupgrd.sql u#######.sql
For example: u0902000.sql
See NOTE 263809.1 for other scripts
u#######.sql
For example: u0800060.sql
See NOTE 159657.1 for other scripts
patchset script
(modifies DB at patchset level within the same release)
@?/rdbms/admin/catupgrd.sql @?/rdbms/admin/catupgrd.sql @?/rdbms/admin/catupgrd.sql @?/rdbms/admin/catpatch.sql @?/rdbms/admin/catpatch.sql
downgrade script
(Removing the Patch Set Software)
@?/rdbms/admin/catdwgrd.sql @?/rdbms/admin/catdwgrd.sql @?/rdbms/admin/catdwngrd.sql @?/rdbms/admin/catbkout.sql
and then
@?/rdbms/admin/catbkout.sql
and then
Difference Category Difference Item 11gR2 11gR1 10gR2 10gR1 9iR2
Startup Modes manual migration startup upgrade startup upgrade startup upgrade startup upgrade startup migrate
CPU Patchset Post-Install Task
(@catcpu.sql or @catbundle.sql script)
startup startup startup startup startup
CPU Patchset Post-Install Task
(@view_recompile script)
startup upgrade startup upgrade startup upgrade startup upgrade startup migrate
Release Patchset Post-Install Task startup upgrade startup upgrade startup upgrade startup upgrade startup migrate
Difference Category Difference Item 11gR2 11gR1 10gR2 10gR1 9iR2
Opatch Version number 11.2.0.x.x 11.1.0.x.x 10.2.0.x.x 1.0.0.0.xx 1.0.0.0.xx
opatch lock file $ORACLE_HOME/.patch_storage/patch_locked $ORACLE_HOME/.patch_storage/patch_locked $ORACLE_HOME/.patch_storage/patch_locked $ORACLE_HOME/.patch_storage/patch_locked $ORACLE_HOME/.patch_storage/patch_locked
opatch apply logs $ORACLE_HOME/cfgtoollogs/opatch/ $ORACLE_HOME/cfgtoollogs/opatch/ $ORACLE_HOME/cfgtoollogs/opatch/ $ORACLE_HOME/.patch_storage $ORACLE_HOME/.patch_storage
opatch rollback logs $ORACLE_HOME/cfgtoollogs/opatch/ $ORACLE_HOME/cfgtoollogs/opatch/ $ORACLE_HOME/cfgtoollogs/opatch/ $ORACLE_HOME/.patch_storage $ORACLE_HOME/.patch_storage
opatch rollback files
(scripts)
$ORACLE_HOME/.patch_storage/{patch id} $ORACLE_HOME/.patch_storage/{patch id} $ORACLE_HOME/.patch_storage/{patch id} $ORACLE_HOME/.patch_storage/{patch id} $ORACLE_HOME/.patch_storage/{patch id}
opatch history log $ORACLE_HOME/cfgtoollogs/opatch/opatch_history.txt $ORACLE_HOME/cfgtoollogs/opatch/opatch_history.txt $ORACLE_HOME/cfgtoollogs/opatch/opatch_history.txt did not exist did not exist
Difference Category Difference Item 11gR2 11gR1 10gR2 10gR1 9iR2
Tool Log Location Automatic Diagnostic Repository (ADR) $ORACLE_BASE/diag/rdbms/{SID}/{instance}/ $ORACLE_BASE/diag/rdbms/{SID}/{instance}/ Did not exist Did not exist Did not exist
DBCA $ORACLE_BASE/cfgtoollogs/dbca $ORACLE_BASE/cfgtoollogs/dbca $ORACLE_HOME/cfgtoollogs/ $ORACLE_HOME/assistants/dbca/logs $ORACLE_HOME/assistants/dbca/logs
DBUA (aka DBMA) $ORACLE_BASE/cfgtoollogs/ $ORACLE_BASE/cfgtoollogs/ $ORACLE_HOME/cfgtoollogs/ $ORACLE_HOME/assistants/dbma/logs $ORACLE_HOME/assistants/dbma/logs
EMCA $ORACLE_BASE/cfgtoollogs/ $ORACLE_BASE/cfgtoollogs/ $ORACLE_HOME/cfgtoollogs/ $ORACLE_HOME/assistants/emca/logs $ORACLE_HOME/assistants/emca/logs
NETCA $ORACLE_BASE/cfgtoollogs/ $ORACLE_BASE/cfgtoollogs/ $ORACLE_HOME/cfgtoollogs/ $ORACLE_HOME/assistants/netca/logs $ORACLE_HOME/assistants/netca/logs
OUI $ORACLE_BASE/../oraInventory/logs/ $ORACLE_BASE/../oraInventory/logs/ $ORACLE_HOME/cfgtoollogs/ $ORACLE_BASE/oraInventory/logs/ $ORACLE_BASE/oraInventory/logs/
Difference Category Difference Item 11gR2 11gR1 10gR2 10gR1 9iR2
Common Problems $O_H file permissions already correct after install already correct after install 10.2.0.1 – correct after patch 4516865
10.2.0.2+ – correct after Post-Install Tasks step
10.1.0.1 thru 10.1.0.4 – correct after install
10.1.0.5 – correct after Post-Install Tasks step
9201 thru 9206 – correct after install
9207+ – correct after patch 4533592
DST March 2007 (version 4) TimeZone files Included in release Included in release 10.1.0.1 thru 10.2.0.3 – Patch required. See NOTE 359145.1
10.2.0.4 – Included in patchset
Patch required. See NOTE 359145.1 Patch required. See NOTE 359145.1
Documented OS foundation All Install Guides recommend “default-RPMs”, and offer “reduced RPMs” as an alternative Clusterware for Linux states “default-RPMs” are required.
All other platforms and products – only implied
The required OS foundation is only implied The required OS foundation is only implied The required OS foundation is only implied
Difference Category Difference Item 11gR2 11gR1 10gR2 10gR1 9iR2
Cloning Functionality Oracle OUI and OPatch User’s Guide 11g Release 1 (11.2) for Windows and UNIX, chapter 6
and NOTE 300062.1, “How to Clone an Existing RDBMS Installation Using OUI”
Oracle OUI and OPatch User’s Guide 11g Release 1 (11.1) for Windows and UNIX, chapter 6
and NOTE 300062.1, “How to Clone an Existing RDBMS Installation Using OUI”
Oracle OUI and OPatch User’s Guide 10g Release 2 (10.2) for Windows and UNIX, chapter 7
and NOTE 300062.1, “How to Clone an Existing RDBMS Installation Using OUI”
does not actually work properly Note 300062.1
Metalink Notes Manual Migration Note 837570.1 Note 429825.1 Note 316889.1 Note 263809.1 Note 159657.1
Advertisements
Categories: 11g
%d bloggers like this: