| Key RDBMS Install Differences in 11gR2 [ID 881063.1] | |||||
| Modified 08-JAN-2010 Type REFERENCE Status PUBLISHED | |||||
In this Document
Purpose
Scope
Key RDBMS Install Differences in 11gR2
Applies to:
Oracle Server - Enterprise Edition - Version: 9.2.0.4 to 11.2.0.2Information in this document applies to any platform.
Purpose
The Purpose of this NOTE is to provide a quick reference of some of the key differences between the Oracle RDBMS 11gR2 Product, and previous Oracle RDBMS 9iR2, 10g, and 11g products in the single focus area of RDBMS install and patching. It is not intended to document every known RDBMS install and patching difference, nor is it intended to document any differences beyond the RDBMS install and patching focus.Scope
Although the intended scope of this matrix is Oracle Install and Patching Support Engineers, it may also be of some limited use to other Oracle Support Engineers. Because this general overview of RDBMS install and patching differences may also be of help in Installation Planning to Oracle Customer's, it is also published externally.Key RDBMS Install Differences in 11gR2
QUICK REFERENCE
----------------------------------------------------
Jump to Difference Category:
RDBMS File Structure RDBMS Log File Locations SQL Script Names Startup Modes Opatch Tool Log Locations Common Problems Cloning Metalink Notes
DISCLAIMER
------------
Whenever a contradiction arises between this document and Metalink-Certification, Metalink-Certification is the Certification authority.
Users of this bulletin are obligated to provide real-time corrections/updates in the form of Metalink "Feedback" submissions to ensure the accuracy and up-to-date status of this bulletin.
| 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) | no 11gR2 patchsets yet | startup | startup | startup | startup | |
| CPU Patchset Post-Install Task (@view_recompile script) | no 11gR2 patchsets yet | startup upgrade | startup upgrade | startup upgrade | startup migrate | |
| Release Patchset Post-Install Task | no 11gR2 patchsets yet | startup upgrade | startup upgrade | startup upgrade | startup migrate | |
| Difference Category | Difference Item | 11gR2 | 11gR1 | 10gR2 | 10gR1 | 9iR2 |
| Opatch | Version number | 11.1.0.x.x (not 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 |
Blogged with the Flock Browser
No hay comentarios:
Publicar un comentario