Oracle Database Resource Portfolio - Install, Upgrade & Patching

Key Install, Upgrade & Patching Articles

Best Practice Documents

• Oracle 12cR1 Upgrade Companion [Document 1462240.1]
• Oracle 11gR2 Upgrade Companion [Document 785351.1]
• Upgrade Advisor: Database 11.2 to 12.1 [Document 1600704.1]
• Upgrade Advisor: Database from 10.2 to 11.2 [Document 251.1]
• Patching & Maintenance Advisor: Database (DB) Oracle Database 11.2.0.x [Document 331.1]
• Database 12c Post Patch SQL Automation [Document 1585822.1]
• Best Practices to Minimize Downtime During Upgrade [Document 455744.1]
• Oracle Database 12.1 Online Documentation - Installing and Upgrading Library
• Oracle Database 11.2 Online Documentation - Installing and Upgrading Library
• How to Verify the Integrity of a Patch/Software Download? [Document 549617.1]
• Setting up and Managing the Oracle Database with Enterprise Manager 12c - Video Demonstrations [Document 1672202.1]

Best Practice Webcasts

The following Best Practice / New Feature Webcasts are available:

Oracle Database New Features 12c	Recording	.pdf
Oracle Database 12.1 Install Features / Changes	Recording	.pdf
Oracle 12c: New Database Initialization Parameters	Recording	.pdf
12c Upgrade and New Features	Recording	.pdf
Oracle Database 12c Patching New Features	Recording	.pdf
Database Inventory: Concepts and troubleshooting	Recording	.pdf
Basic Administration of Multitenant Database	Recording	.pdf
Oracle Multitenant: Configuration and Customization Fundamentals	Recording	.pdf

For other webcasts, refer to  Document:1456176.1 Database Advisor Webcasts: Current Schedule and Archived recordings

Health Checks

• Script to Collect DB Upgrade/Migrate Diagnostic Information [Document 556610.1]
• How to Download and Run Oracle's Database Pre-Upgrade Utility [Document 884522.1]
• RDA 4 - Health Check / Validation Engine Guide [Document 250262.1]
• Health Check Alert: Oracle Database support status notification [Document 1095609.1]

Tools

Troubleshooting Assistants

• Oracle Database - Client / Install / Deinstall / Cloning [Document 1555012.2]
• Oracle Database/Client Upgrade - Downgrade [Document 1561791.2]
• Patching Oracle Database/Client [Document 1561792.2]

Premium Knowledge Content Notes

• Information Center: Upgrading and Migration Oracle Database [Document 1351112.2]
• Oracle Database 12c Release 1 Information Center [Document 1595421.2]
• Oracle Database Upgrade Path Reference List [Document 730365.1]
• Master Note For Oracle Database 12c Release 1 (12.1) Database/Client Installation/Upgrade/Migration Standalone Environment (Non-RAC) [Document 1520299.1]
• Unix Operating Systems Installation and Configuration Requirements Quick Reference (8.0.5 to 11.2) [Document 169706.1]
• Master Note of Linux OS Requirements for Database Server [Document 851598.1]
• Minimum Software Versions and Patches Required to Support Oracle Products on IBM Power Systems [Document 282036.1]
• Master Note for Real Application Testing Option [Document 1464274.1]
• How To Clone An Existing RDBMS Installation Using OUI [Document 300062.1]
• Migration Of An Oracle Database Across OS Platforms (Generic Platform) [Document 733205.1]
• Oracle Database 12.1 : FAQ on Queryable Patch Inventory [Document 1530108.1]
• Patch Set Updates for Oracle Products [Document 854428.1]
• Lifetime Support and Support Policies - Oracle Database Overview [Document 1351163.1]

MOS Communities

• Oracle Database Install/Upgrade/Opatch Community
• Patch Reviews - DB Community

How-To / FAQ

• How to Use the My Oracle Support Conflict Checker Tool for Patches Installed with OPatch [Document 1091294.1]
• Relinking Oracle Home FAQ ( Frequently Asked Questions) [Document 1467060.1]
• Oracle Universal Installer (OUI) FAQ [Document 458893.1]
• OPATCH FAQ [Document 242993.1]
• Frequently Asked Questions (FAQ): Patching Oracle Database Server [Document 1446582.1]
• Steps To Recreate Central Inventory(oraInventory) In RDBMS Homes [Document 556834.1]

How-to / Troubleshooting Webcasts

The following Install ,Upgrade ,Patching How-to / Troubleshooting Webcasts are available:

How to resolve patch conflicts with MOS Conflict Checker?	Recording	.pdf
Automation of patch conflict resolution and deployment through EM 12c	Recording	.pdf
Oracle DB: How to resolve conflicts and discover available patches	Recording	.pdf
Composite Patching	Recording	.pdf

For other webcasts, refer to  Document:1456176.1 Database Advisor Webcasts: Current Schedule and Archived recordings

Oracle Database Resource Portfolio - Support Tools

Oracle Database Resource Portfolio - Support Tools

Support Tools 

Diagnosability Framework

Since DB 11g, trace files relevant to a critical database incidents are stored in the Automatic Diagnostic Repository (ADR). Using ADRCI (ADR Command Interpreter) or the Support Workbench, customers can package the files specific to the incident via the Incident Packaging Service (IPS) . All they need is run a command to package the incident corresponding diagnostics and upload the package through My Oracle Support (MOS) to the SR. The package will include the alert log and all the relevant trace files related to the incident.

With DB 12c, improvements focus is on  first failure diagnostics for database components, not just critical issues. Notes covering changes in the major product areas will be incorporated in notes to be listed here.

• TFA RAC and DB Support Tools Bundle [Document 1594347.1]
• Benefits of TFA RAC and DB Support Tools Bundle (Video) [Document 2147819.1]
• 11g Understanding Automatic Diagnostic Repository [Document 422893.1]
• Master Note for 11g Diagnosability - ADR and Packaging [Document 1283137.1]
• ADR and Packaging [Document 1283137.1]
• 11g Quick Steps to Package and Send Critical Error Diagnostic Information to Support [Document 443529.1]
• 11g Quick Steps - How to create an IPS package using Support Workbench [Document 1091653.1]
• Demo showing usage of various diagnostic tools, inc. Support Workbench and ADRCI

Troubleshooting Tools

Troubleshooting tools provide recommendations to resolve common issues by analyzing uploaded files. When a known solution is available, the tool will display the symptoms and causes which can lead to the issue and one or more suggestions for resolving the issue.

Benefits of using the Troubleshooting Tools:

• Analyzes uploaded files to provide recommendations when a known solution is available
• Troubleshooting report can be saved for later use
• Diagnostic Guide is available
• Create SR option available which will automatically populate many of the SR fields

• ORA-600 Troubleshooting Tool Overview / Tool
• ORA-7445 Troubleshooting Tool Overview / Tool
• ORA-3137 Troubleshooting Tool Overview/ Tool
• ORA-4030 Troubleshooting Tool Overview / Tool
• ORA-4031 Troubleshooting Tool Overview / Tool
• ORA-2730x Troubleshooting Tool Overview / Tool
• RAC Node Eviction Troubleshooting Tool Overview / Tool 
• ORA-1578 Troubleshooting Tool Overview / Tool 

Troubleshooting Assistants

"Assistants" are created by Oracle Support helping you to find KM documents that will meet specified symptoms.
Instead of typing the symptoms into our Knowledge Search engine, the Assistant presents a list of symptoms to choose from for a certain topic. Once the symptom is selected, the Assistant then engages in a dialogue and presents further options to the user to select from in order to clarify the issue and/or errors.

• Oracle Database - Client / Install / Deinstall / Cloning [Document 1555012.2 ]
• Get Assistance to Understand and Solve Oracle DBCA Issues [Document 1615456.2]
• Oracle Database/Client Upgrade - Downgrade [Document 1561791.2]
• Patching Oracle Database/Client [Document 1561792.2]

• Understand and Troubleshoot Startup/Shutdown Issues [Document 1591095.2]

• Oracle Grid Infrastructure Upgrade [Document 1553630.2]
• Oracle Grid Infrastructure Install [Document 1551639.2]
• Oracle Grid Infrastructure Patching [Document 1553605.2]

• Get Assistance to understand and solve Oracle Database Server Corruptions [Document 1543698.2]
• Handling Block Corruptions in oracle7 / 8 / 8i / 9i / 10g / 11g [Document 1598103.2]

• Resolve Issues with Oracle Undo Management (ORA-01555, ORA-30036, ORA-01628, ORA-01552, etc.) [Document 1575667.2]

• ORA-00600 [729] (Interactive Guide to resolving your error)  [Document 1560220.2]
• Oracle Database Error ORA-600 [kdsgrp1] (Interactive Guide to Resolving Your Error) [Document 1569722.2]
• Oracle Database Error ORA-600 [17285] (Interactive Guide to Resolving Your Error) [Document 1612876.2]

• Get Assistance to Understand and Solve Oracle Resource Manager [Document 1606825.2]

• Oracle Database ORA-00060 Errors on Single Instance (Non-RAC) Diagnosing Using Deadlock Graphs in ORA-00060 Trace Files(Document 1550091.2)

• Database Storage [Document 1552419.2]

• Get Assistance to Understand and Troubleshoot Oracle DBMS_SCHEDULER [Document 1585228.2]

• Database Object Partitioning  [Document 1580800.2]

• Troubleshooting Performance Issues [Document 1543445.2]
• Diagnosing the Cause of a Slow Query [Document 1542608.2]
• SQL Performance Issues [Document 1542678.2]
• Get Assistance to understand and solve Oracle SQL issues [Document 1564632.2]

• Oracle Multimedia and interMedia Installation and Upgrade [Document 1614436.2]

• NLS - Custom Character set, Locale Builder, Incorrect Numbers, 'Value Too Large' Errors While Inserting Data etc [Document 1628888.2]
• Database Character set Conversion [Document 1900564.2]
• CSSCAN (Characterset Scanner)[Document 1900629.2]
• DMU (Database Migration Assistant for Unicode) Tool [Document 1900712.2]

Data Collection Tools

Data Collection tools provide an easy user interface for capturing data and helping with issue diagnosis.  

• RAC and DB Support Tools Bundle [Document 1594347.1]
• Remote Diagnostic Agent [Document 414966.1]
• Diagnostic Assistant [Document 201804.1]
• Trace File Analyzer Collector (TFA) [Document 1513912.1]
• CRS Diagnostic Data Gathering: A Summary of Common tools and their Usage [Document 783456.1]
• SQLT (SQLTXPLAIN) - Tool that helps to diagnose a SQL statement performing poorly or one that produces wrong results [Document 215187.1]

 Monitoring Tools

Monitoring Tools assist with capturing and observing performance metrics for your environment including database, operating system etc.

• RAC and DB Support Tools Bundle [Document 1594347.1]
• OS Watcher Black Box [Document 301137.1]
• Cluster Health Monitor (CHM) FAQ [Document 1328466.1]
• ORATop oratop - utility for near real-time monitoring of databases, RAC and Single Instance [Document 1500864.1]
• Procwatcher: Script to Monitor and Examine Oracle DB and Clusterware Processes [Document 459694.1]
• Lite Onboard Transaction Monitor (LTOM) [Document 352363.1]

 Health Checks / Verification

 Health Checks and Verification tools can alert you about a potential issue before the issue actually occurs.

• RAC and DB Support Tools Bundle [Document 1594347.1]
• My Oracle Support Health Check Catalog [Document 868955.1]
• ORAchk - Oracle Configuration Audit Tool [Document 1268927.1]
• High Availability Check (HA_Check) included in RACCHECK [Document 1505808.1]
• SQL Tuning Health Check (SQLHC) [Document 1366133.1]
• Procwatcher: Script to Monitor and Examine Oracle and CRS Processes [Document 459694.1]
• Cluster Verification Utility (CLUVFY) FAQ [Document 316817.1]

Oracle Database Resource Portfolio - Getting Started

This index provides a single, easy-to-navigate comprehensive library of Oracle Database resources. Quickly and easily access the latest alerts, news, best practices, health checks, tools, recommended communities, and troubleshooting information.

Stay Informed

• Database Support News [Document 230.1]
• Get Proactive with Oracle Database [Document 1389167.1]
• Index of Oracle Database Information Centers [Document 1568043.2]
• Advisor Webcasts for Oracle Database [Document 1456176.1]
• Diagnostic Tools Catalog [Document 559339.1]
• Documentation Library

Stay Connected

• Oracle Database Twitter
• Oracle Database Facebook
• Oracle Database Support Blog
• Database Communities
• Oracle Database YouTube

Get Accredited

• Oracle Support Accreditation Community (MOSC)
• Oracle Support Accreditation ⿿ Series Index [Document 1583898.1]
• Oracle Support Accreditation Series for Level 1 My Oracle Support [Document 1579751.1]
• Oracle Support Accreditation Series - Oracle Database [Document 1584010.1]

Support Policies

• Oracle Lifetime Support (portal)
• Lifetime Support and Support Policies - Oracle Database Overview [Document 1351163.1]
• Lifetime Support Policy: Oracle Technology Products (pdf)
• Oracle Software Technical Support Policies (pdf)
• Release Schedule of Current Database Releases [Document 742060.1]
• Database, FMW, EM Grid Control, and OCS Software Error Correction Support Policy [Document 209768.1]
• Oracle Database (RDBMS) Releases Support Status Summary [Document 161818.1]

Webcasts

• Oracle Database Advisor Webcast Schedule and Archive recordings [Document 1456176.1]