MOS-Oracle Database (DocID1533057.1)

Installation/upgrade/downgrade/migration

Document 1525335.1 OPatch-Where can I find the latest OPatch? [Video]

Document 1525396.1 migrate Oracle DB across OS platforms

How to downgrade Document 1525777.1 from database 11.2 to a previous version (including 11.2.0.3-11.2.0.1)

Document 1577660.1 Database Upgrade/downgrade Compatibility Matrix

Document 1577288.1 script for collecting Database Upgrade/migration diagnostic information (dbupgdiag. SQL)

How to pre-process records in SYS. AUD $ before upgrading Document 1577326.1 from version 10.1 or later to version 11.1 or later

Document 1577379.1 how to download and run the Oracle Database Pre-upgrade Utility

Document 1602485.1 is a complete check list for manual upgrades from earlier 11.2.0.N versions to the latest 11.2.0.N patch set.

Document 1602861.1 changes to the single-host installation of Oracle Database 12.1

Document 1602904.1 requirements for installing Oracle Database 12.1 On Solaris 11

Document 1602908.1 requirements for installing Oracle Database 12.1 On RHEL5 or OL5 64-bit (x86-64)

Document 1603241.1 requirements for installing Oracle Database 12.1 On RHEL6 or OL6 64-bit (x86-64)

Document 1603242.1 12.1.0.1 and later database security patches

Document 1602865.1 Oracle Database 12c version 1 (12.1) upgrade New Features

Document 1602851.1 Oracle Database 12c version 1 (12.1) DBUA: learn about new changes in DBUA 12.1

Document 1602878.1 Oracle Database 12c version 1 (12.1) DBUA silent mode

Document 1602889.1 how to downgrade a 12c database to a previous version

Where can I download the 1602849.1 Oracle Database client software on Windows 2008/7 in Document 10.2?

Daily Management

Document 1525394.1 changing the database character set (NLS_CHARACTERSET)

Document 1525395.1 warning log information: Private Strand Flush Not Complete

Document 1525787.1 necessity and impact of index Reconstruction

Document 1526118.1 Checkpoint optimization and troubleshooting guide

Document 1526120.1 11g: scheduler maintenance task or Autotasks

Document 1526122.1 common AUM analysis/diagnosis scripts

Document 1526134.1 different methods for creating IPS packages in ADR

Document 1548826.1 diagnoses and resolves ORA-4030 errors

Document 1548858.1 correctly sets NLS_LANG in Unix

Document 1548891.1 how to perform health checks on the database

Document 1549185.1 checklist of performance degradation issues with data pump export (expdp) and import (impdp) Tools

Document 1577321.1 how can we close the database in the shortest way?

Document 1577370.1 correctly set NLS_LANG in Microsoft Windows

Document 1577374.1 study the script of B-tree Index Structure

Document 1577380.1 RDBMS Patch Set patch number Quick Reference

Document 1602891.1 use the database parameter PGA_AGGREGATE_LIMIT to limit the process size

Document 1603267.1 Unicode Character Set in Oracle Database

Document 1602850.1 generates a ORA-01841 from the SQL plus query 12.1.0.1.0 database of version 10.2.0.3

Performance problems

Document 1523048.1 FAQ: How to Use AWR reports to diagnose database performance problems

Document 1523934.1 troubleshooting: Shared Pool optimization and Library Cache Latch conflict Optimization

Document 1526574.1 SQLT diagnostic tool

Document 1523462.1 how to collect 10046 Trace (SQL _TRACE) used to diagnose performance problems)

Document 1523938.1 * how to collect Optimizer statistics on 11g

Document 1526578.1 OSWatcher Black Box User Guide (including: [Video])

Document 1525791.1 FAQ: 'cursor: mutex... '/'cursor: pin...'/'library cache: mutex... 'type wait event

Performance and Wrong Results issues that need attention on Document 1522948.1 11.2.0.2

Performance and Wrong Results issues that need attention on Document 1523016.1 11.2.0.3

Document 1549184.1 best practices: proactively avoids database and query-related performance problems

Document 1549179.1 best practices: Proactive data collection for performance issues

Document 1548524.1 Library Cache diagnostics: Lock, Pin, and Load Lock

Document 1549181.1 * why is the index not used in the query?

Cluster and storage

Document 1526083.1 RAC and Oracle Clusterware best practices and Beginner's Guide (platform-independent)

Document 1525820.1 RAC and Oracle Clusterware best practices and Beginner's Guide (Linux)

Document 1526517.1 RAC and Oracle Clusterware best practices and Beginner's Guide (Solaris)

Document 1526541.1 RAC and Oracle Clusterware best practices and Beginner's Guide (Windows)

Document 1526555.1 RAC and Oracle Clusterware best practices and Beginner's Guide (AIX)

Document 1526557.1 RAC and Oracle Clusterware best practices and Beginner's Guide (HP-UX)

Document 1525761.1 uses Diagwait as a diagnostic tool to obtain more information for diagnosing Oracle Clusterware node eviction

Document 1525819.1 11 things that must be done to keep the RAC cluster environment stable

Document 1524455.1 five most common problems that cause node restart, eviction, or CRS unexpected restart

Document 1526147.1 five problems with Grid Infrastructure startup

Five problems that cause instance eviction in Document 1526186.1

Document 1526158.1 CRS diagnostic data collection: common tools and usage Summary

Document 1549191.1 five most common problems that cause RAC instance crashes

Document 1549192.1 five common CRS/Grid Infrastructure Installation Problems

Document 1549168.1 most common 11gR2 RAC Installation Problems

Document 1602038.1: five most common problems that cause Scan VIP and Scan Listener faults

Document 1602033.1 RACcheck-RAC configuration audit tool

Document 1602035.1 top five common CRS Cluster patching Problems

Document 1602076.1 five most common database and/or instance performance problems in the RAC Environment

Document 1602417.1 10g and 11gR1 ASM Best Practices

Document 1602450.1 ASM 11gR2: how to upgrade the ASM instance to version 11gR2 (11.2.0.X )?

Document 1602048.1 common 11gR2 Grid Infrastructure upgrade Problems

High Availability

Document 1526160.1 step-by-step guide for using rman duplicate... from active database to create a physical standby DATABASE

Document 1526162.1 FAQs about restoration or replication between different versions and platforms

Document 1526163.1 how to format damaged blocks that do not belong to any segment

Document 1526562.1 Oracle10g/11g-Recovery Manager (RMAN) Getting Started Guide

Document 1526911.1 handles Oracle block corruption in Oracle7/8/8i/9i/10g/11g

Document 1549189.1 10 Best Practices for backup and recovery

Document 1577628.1 how to install Patchset, PSU, or CPU in the Data Guard Physical Standby Environment

Document 1577382.1 configure RMAN to clear archived logs that have been applied to the standby Database

Document 1602424.1 maximum performance/maximum availability RMAN backup in the Data Guard Environment

Document 1602082.1 common RMAN 11.2 Problems

Document 1602437.1 supports heterogeneous Master/Slave systems in physical Data Guard

TimesTen Memory Database

Document 1536728.1 TimesTen Memory Database (IMDB) version supports Abstract

Document 1566407.1 how to evaluate the size of the core file after TimesTen Core dumps occurs

Document 1566405.1 how to evaluate, calculate, and configure TimesTen regular log Archiving

In Document 1566430.1 TimesTen, how long does it take to update statistics?

Document 1602473.1 method: Enable Core Dump for the TimesTen Process