Monday, November 4, 2019

Upgrade to 12c using RMAN Duplicate with Noopen clause and Backup Location (Doc ID 2022820.1)

In this Document
Purpose
Scope
Details
References

APPLIES TO:

Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.

PURPOSE

Method for Duplicating a 12c database using RMAN Backup created by a lower release (i.e 10gR2, 11gR1, 11gR2)

SCOPE

In 12c, the RMAN duplicate command has new "NOOPEN" option which clones the database but does not open the auxiliary.  This feature can be used to duplicate a database to higher version.

Note: This note provides the example for upgrading the database using  "RMAN DUPLICATE using BACKUP LOCATION with NOOPEN clause" and applicable ONLY for said method
Note:  This note covers the RMAN duplicate with noopen clause procedure. If you choose to upgrade the database after the RMAN procedure completes, please insure the Pre Upgrade Checks are completed PRIOR to starting the upgrade.

DETAILS

When cloning (duplicating) a database to a higher version, traditionally (prior to 12c), you must use restore/recover of an RMAN backup.  This is because the database in the destination must be opened with UPGRADE option.  Therefore, the RMAN duplicate could not be used because RMAN automatically opens the auxiliary database with resetlogs.  This would fail with error 'ORA-39700: database must be opened with UPGRADE option'.  
In RMAN 12c, a new option is available "NOOPEN" requesting RMAN to complete the duplicate activity but NOT open the auxiliary database.    This would allow for the 'open upgrade' option to be manually executed when going between versions.
"NOOPEN":  It specifies that the duplicate database must not be opened after duplicate is completed.
Steps to duplicate a database to 12c:
1)   Execute Preupgrade script (preupgrd.sql) at 11g database. This script will validate 11g database for upgrade and provide recommendations. This script is available in the 12c $ORACLE_HOME/rdbms/admin directory.  Note, both preupgrd.sql and utluppkg.sql (called by preupgrd.sql) must be copied from 12c.
Note: This method performs duplicate using backup. The database backup should be taken after performing pre-upgrade steps of target database version.
         Suppose we are going to upgrade to 12.2, then database should be taken after performing pre-upgrade tasks of 12.2 version.
      

Note: Database upgrade compatible matrix will be applicable for this upgrade.
To upgrade to 12.1 the minimum required version in each release are
ReleaseMinimum require version
10g10.2.0.5.0
11gR111.1.0.7.0
11gR211.2.0.2.0
12cR112.1.0.1.0 

To upgrade to 12.2 the minimum required version in each release are

ReleaseMinimum require version
11gR211.2.0.3 / 11.2.0.4
12c12.1.0.1 / 12.1.0.2


2) Once Preupgrade checks are complete, take complete backup of 11g database
RMAN> connect target / catalog <catalog_schema>/<password>@<catalog database>
RMAN> backup database format '/<PATH>/db_%U' plus archivelog format '/<PATH>/arch_%U';
RMAN> backup current controlfile format '/<source_backup PATH>/cf_%U'; 
This will generate a set of backupsets in source_backup directory.
3) Move these backup and pfile to 12c host:
Using OS command like scp , we can copy the backup pieces to Destination server
Example: scp -p <backup-piece> user@<host>:/<dest_backup PATH>/
4) Create password file for 12c database. We can choose new name for 12c database using duplicate method
$ORACLE_HOME/bin/orapwd file=orapw<sid> password=<password>
5)  Edit copied pfile and make necessary changes.  Set necessary values like:
db_name =  
controfile_name =
db_file_name_convert and log_file_name_convert ( if source and destination locations are different ) 
6) startup the Auxiliary instance in NOMOUNT
SQL> connect / as sysdba
SQL> startup nomount
 7) From RMAN connect this instance as AUXILIARY
Example:
$ export ORACLE_SID=<oracle sid value>
RMAN> connect auxiliary /
 8) Using RMAN 12c, execute the duplicate command.  In this example, '/u01/backup' denotes RMAN backup location on destination.  Note, “NOOPEN” option is specified.
RMAN> DUPLICATE DATABASE TO <new DB > NOOPEN  BACKUP LOCATION '/<dest_backup PATH>/' ;


Once it completes exit from Rman.

RMAN> exit
9) Once RMAN completes, the auxiliary database remains in MOUNT mode.  Within sqlplus, you can open the database with UPGRADE option:
 SQL> alter database open resetlogs upgrade;

Ensure the tempfiles have got created.

Select * from v$tempfile ;

Check the files exist physically on disk.

10)Execute Manual upgrade scripts.
In 12c manual upgrade can be done parallel using perl utility catctl.pl
$ cd $ORACLE_HOME/rdbms/admin
$ $ORACLE_HOME/perl/bin/perl  catctl.pl –n 4 –l /<PATH> catupgrd.sql
 
n – number of parallel process to execute catupgrd.sql
l – log location for catupgrd.sql. Based on number of process log files gets created (catupgrd<n-1>.log to catupgrd0.log)
11) Execute post upgrade scripts (please refer Document reference given for 12.1 and 12.2 accordingly)
 $ORACLE_HOME/perl/bin/perl  catctl.pl –n 4 –l /<PATH> catuppst.sql

References:

For 12.1
Complete Checklist for Manual Upgrades to Oracle Database 12c Release 1 (12.1) (Doc ID 1503653.1)
http://docs.oracle.com/database/121/RCMRF/rcmsynta020.htm#RCMRF126

For 12.2 please refer
Complete Checklist for Manual Upgrades to Non-CDB Oracle Database 12c Release 2 (12.2) Document 2173141.1
 12) Check the database component status to confirm upgrade completion
Connect as SYS user to the database
col comp_id format a10
col comp_name format a30
col version format a10
col status format a8
select substr(comp_id,1,15) comp_id,substr(comp_name,1,30) comp_name,substr(version,1,10) version,status from dba_registry

NOTE:  If using this method to upgrade an existing database, be aware that once the auxiliary database is created and opened, no further recovery is allowed from the source.
 

REFERENCES

NOTE:1503653.1 - Complete Checklist for Manual Upgrades to Oracle Database 12c Release 1 (12.1)
http://docs.oracle.com/database/121/RCMRF/rcmsynta020.htm#RCMRF126
NOTE:551141.1 - Database Server Upgrade/Downgrade Compatibility Matrix
NOTE:419550.1 - Different Upgrade Methods For Upgrading Your Database
 

Was this document helpful?

 
   
 

Document Details

 
Email link to this documentOpen document in new windowPrintable Page
REFERENCE
PUBLISHED
01-Aug-2019
01-Aug-2019
   
 

Related Products

 
Oracle Database Cloud Schema Service
Oracle Database Exadata Cloud Machine
Oracle Database Exadata Express Cloud Service
Oracle Cloud Infrastructure - Database Service
Oracle Database Cloud Exadata Service
Show More
   
Didn't find what you are looking for?
at No comments:

Master Note For Oracle Database Upgrades and Migrations (Doc ID 1152016.1)

In this Document
Purpose
Scope
Details
 Ask Questions, Get Help, And Share Your Experiences With This Article
 General
 How To
 Diagnostic Tools
 Known Issues
 Preupgrade Tool Issues
 During Upgrade Issues
 Post Upgrade Issues
 DBUA Specific Issues
 Using My Oracle Support Effectively
 Generic Links
References

APPLIES TO:

Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.

PURPOSE

This Master Note is intended to provide an index and references to the most frequently used My Oracle Support Notes with respect to Oracle Database Upgrade and Migration. This Master Note is subdivided into categories to allow for easy access and reference to notes that are applicable to your area of interest within Upgrade and Migration.

SCOPE

This note serves as a guide through the various stages of upgrading/migrating a database.
It is applicable to upgrade/migration done via DBUA or the manual method.
It assumes you have already Installed Oracle software.
The intended audience is from junior DBA's to senior DBA's
This will cover the following versions of these products:
Oracle Server - Version: 8.0.6.x though 18c

DETAILS

Ask Questions, Get Help, And Share Your Experiences With This Article

Would you like to explore this topic further with other Oracle Customers, Oracle Employees, and Industry Experts?
Click here to join the discussion where you can ask questions, get help from others, and share your experiences with this specific article.

Discover discussions about other articles and helpful subjects by clicking here to access the main My Oracle Support Community page for Database Install/Upgrade.

General

Note 1561791.1 Upgrade / Downgrade Assistant: Oracle Database/Client
Note 419550.1 Different Upgrade Methods For Upgrading Your Database
Note 551141.1 Database Server Upgrade/Downgrade Compatibility Matrix
Note 730365.1 Oracle Database Upgrade Path Reference List
Note 455744.1 Best Practices to Minimize Downtime During Upgrade
Note 739485.1 How to estimate the time required to upgrade a database ?
Note 1515747.1 Oracle Database 12c Release 1 (12.1) Upgrade New Features
Note 1493645.1 Oracle Database 12c Release 1 (12.1) DBUA : Understanding New Changes With All New 12.1 DBUA
Note 757245.1 Can you Upgrade RDBMS and Convert From 32-bit to 64-bit Binaries Directly on Linux or Windows based Intel Platforms Using the Database Upgrade Assistant (DBUA)
<Note 1320966.1> Things to Consider Before Upgrading to 11.2.0.2 to Avoid Poor Performance or Wrong Results
Note 1392633.1 Things to Consider Before Upgrading to 11.2.0.3 to Avoid Poor Performance or Wrong Results
Note 733205.1 Migration Of An Oracle Database Across OS Platforms (Generic Platform)
Note 785351.1 Oracle 11gR2 Upgrade Companion
Note 601807.1 Oracle 11gR1 Upgrade Companion
Note 466181.1 10g Upgrade Companion
Oracle Database Upgrade Guide 12c Release 1 (18c)
Oracle Database Upgrade Guide 12c Release 1 (12.2)
Oracle Database Upgrade Guide 12c Release 1 (12.1)
Oracle Database Upgrade Guide 11g Release 2 (11.2)
Oracle Database Upgrade Guide 11g Release 1 (11.1)
Oracle Database Upgrade Guide 10g Release 2 (10.2)
Oracle Database Upgrade Guide 10g Release 1 (10.1)
Oracle Database Upgrade Guide 9i Release 2 (9.2)

How To

Note 251.1 Database Upgrade Planner from 10.2 to 11.2
Note 264.1 Database Upgrade Planner from 9.2 to 11.2
Note 732897.1 How to Log Good Service Requests for Database Upgrade/Migration Issues
Note 1503653.1 Complete Checklist for Manual Upgrades to Oracle Database 12c Release 1 (12.1)
Note 1516557.1 Complete Checklist for Upgrading to Oracle Database 12c Release 1 (12.1) using DBUA

Note 1932762.1 Complete checklist for 12c Upgrade PDBs - Everything At Once (Full CDB Upgrade)
Note 1933391.1 Complete checklist for 12c R1 PDB upgrade (Upgrading single/multiple PDB)
Note 1933011.1 Complete checklist for DBUA upgrade from 12.1.0.1 to 12.1.0.n

Note 837570.1 Complete Checklist for Manual Upgrades to 11gR2
Note 870814.1 Complete checklist to upgrade the database to 11gR2 using DBUA
Note.1276368.1 Complete checklist for out-of-place manual upgrade from previous 11.2.0.N version to the latest 11.2.0.N patchset.
Note 1377613.1 In-Place Upgrade on UNIX For Single Instance 11gR2 Database
Note 429825.1 Complete Checklist for Manual Upgrades to 11gR1
Note 556477.1 Complete Checklist for Upgrades to 11gR1 using DBUA
Note 316889.1 Complete Checklist for Manual Upgrades to 10gR2
Note 263809.1 Complete checklist for manual upgrades to 10gR1 (10.1.0.x)
Note 159657.1 Complete Upgrade Checklist for Manual Upgrades from 8.X / 9.0.1 to Oracle9iR2 (9.2.0)
Note 117048.1 How to Upgrade from Standard to Enterprise Edition
Note 139642.1 Converting An Enterprise Edition Database To Standard Edition
Note 1437019.1 How To Prevent Apex From Being Installed During DB Upgrade
Note 1516616.1 Oracle Database 12c Release 1 (12.1) DBUA in Silent mode
Note 790559.1 RMAN Restore of Backups as Part of a Database Upgrade
Note 2022820.1 Upgrade to 12c database using RMAN Duplicate with NOOPEN clause
Note 2189854.1 Complete Checklist for Upgrading to Oracle Database 12c Release 2 (12.2) using DBUA
Note 2173141.1 Complete Checklist for Manual Upgrades to Non-CDB Oracle Database 12c Release 2 (12.2)
Note 2240413.1 Complete Checklist for upgrading Oracle 12.1 Container Database (CDB) to Oracle Database 12c Release 2 (12.2) using DBUA
Note 2171026.1 How to Upgrade Pluggable Databases (PDBs) Sequentially to 12.2
Note 2243613.1 Oracle Database Upgrade Known issues - 12.2
Note 2316310.1 Oracle Database 12c Release 2 (12.2) Upgrade New Features
Note 2418045.1 Oracle DB 18c - Complete Checklist for Manual Upgrades to Non-CDB Oracle Database 18c
Note 2421552.1 Oracle 18c - Complete Checklist for upgrading Oracle 12.x Container Database (CDB) to Oracle Database 18c (18.x) using DBUA
Note 2422037.1 Oracle 18c - DBUA In Silent Mode
Note 2418576.1 Oracle 18c - Complete Checklist for Upgrading to Oracle Database 18c (18.x) using DBUA
Note 2422161.1 Oracle 18c - Complete checklist for Manual Upgrade for Multitenant Architecture Oracle Databases from 12.1.x.x to 18.x.x.x
Note 2416661.1 Oracle DB 18c - How to Downgrade a 18c Non CDB Database to Previous Release
Note 2419368.1 Oracle DB 18c - How to Downgrade a 18c Container Database to Previous Release
Note 2421060.1 Oracle 18c - How to Downgrade a Single Pluggable Oracle Database ( PDB ) from 18c Database to previous release
Note 2414935.1 Patches to apply before upgrading Oracle GI and DB to 18c or downgrading to previous release

Diagnostic Tools

DB Upgrade/Migration-Troubleshooting Tool
Note 884522.1 How to Download and Run Oracle's Database Pre-Upgrade Utility
Note 556610.1 Script to Collect DB Upgrade/Migrate Diagnostic Information (dbupgdiag.sql)
Note 212588.1 How To Investigate/Diagnose Hanging Issues When Upgrading or Migrating (includes DBMA & DBUA)
Note 577775.1 Dbua or Migration Is Hanging What to do?
Note 428118.1 How to enable Java code tracing for DBUA, DBCA and NETCA?

Known Issues

Preupgrade Tool Issues

Note 407031.1 ORA-01403 no data found while running utlu102i.sql/utlu102x.sql on 8174 database
Note 271733.1 ORA-600 [17069] During Upgrade Using Database Upgrade Assistant, Utlu101i.sql or Utlu102i.sql
Note 549276.1 Utlu102i.sql Shows "WARNING: The database has not been patched to release 10.1.0.4.2" Showed
Note 370825.1 UTLU102I.SQL Reports That Already-Installed Components Need To Be Installed
Note 797750.1 "WARNING: --> Database contains schemas with objects dependent on network packages" When Running utlu111i.sql
Note 1473478.1 Pre-upgrade script utlu112i.sql errors with ORA-06550 and ORA-00942     
Note 742573.1 Ora-01436: Connect By Loop In User Data" Running utlu102i.Sql/utlu102x.sql Against Database (Before Upgrading)
Note 843899.1 DB Upgrade Throws ORA-25153: Temporary Tablespace Is Empty                                                                                

During Upgrade Issues

Note 412271.1 ORA-600 [22635] and ORA-600 [KOKEIIX1] Reported While Upgrading Or Patching Databases To 10.2.0.3
Note 579523.1 ORA-600 [22635], ORA-600 [KOKEIIX1], ORA-7445 [KOPESIZ] and OCI-21500 [KOXSIHREAD1] Reported While Upgrading To 11.1.0.6 Or 11.1.0.7
Note 1077748.1 Upgrading to 11.1.0.7 Crashes with ORA-600, arguments: [kokeeiix3], [3]
Note 1081627.1 Upgrade to 11.1.0.7 Cancels with ORA-07445. ORA-600[QCTOSTIIX1] Showed at the Alert file.
Note 761711.1 Upgrade From 10.2.0.3 To 11.1.0.7 Using DBUA Throws ORA-600 [kksfbc-reparse-infinite-loop] Error During Update to SYS.AQ_SRVNTFN_TABLE
Note 1067072.1 ORA-600 [kzdugt], [2147483629] While Upgrading From 11gR1 To 11gR2
Note 1077748.1 Upgrading to 11.1.0.7 or 11.2.0.1 Crashes with ORA-600, arguments: [kokeeiix3], [3] or ORA-07445: exception encountered: core dump [qmxdGetMatchingChildren_int]
Note 464716.1 ORA-1722 when running Oracle 11g DBUA utility
Note 730057.1 Upgrading to 11g Fails with ORA-01722 invalid number
Note 859576.1 Upgrading to 11gR1 Stops With ORA-01722 invalid number
Note 744693.1 ORA-00001 For SYS.DIANA_VERSION$ During RDBMS Upgrade From 11.1.0.6 To 11.1.0.7
Note 845768.1 ORA-19905 LOG_ARCHIVE_FORMAT During Upgrade
Note 293658.1 10.1 or 10.2 Patchset Install Getting ORA-29558 JAccelerator (NCOMP) And ORA-06512
Note 557242.1 Upgrade Gives Ora-29558 Error Despite of JAccelerator Has Been Installed
Note 472959.1 "Ora-20000 : Insufficient privileges to analyze an object in Dictionary" During Catupgrd.Sql
Note 470667.1 ORA-1422 During Upgrade To 10.2 or 11.1
Note 554983.1 Error During Migration To 11gR1: Database Is Using An Old Timezone File Version
Note 788087.1 When Running Catupgrd.Sql, Exits With ORA-00904/ORA-00942
Note 802694.1 Catupgrd.Sql Hang While Running dbms_metadata_hack.load_xsd('kusmv.xsd')
Note 1070951.1 11.1.0.6.0->11.2.0.1.0 UPGRADE FAILS WITH ORA-22371 REFERENCING XDB.XDB$PROPERTY_T, VERSION 1
Note 1104643.1 Upgrading Database to 11.2 Fails with ORA-01422
Note 1100828.1 11gr2 Upgrade, Re-Running catupgrd.sql Causes Ora-00001 Errors
Note 1051368.1 Startup Upgrade Gives ORA-202 ORA-17505 ORA-15061 ORA-600 [kccgtt_1]
Note 1091252.1 ORA-31114 "XDB configuration has been deleted or is corrupted" during upgrade to 11.2
Note 1148285.1 "ORA-01166: File number 101 is larger than MAXDATAFILES (100)" While Upgrading To 11.1.0.7 Or 11.2
Note 1326522.1 ORA-7445 [qmxarFindPartition] during database upgrade to 11.2
Note 1329606.1 10.2 Upgrade to 11.2 Hangs While Running Catupgrd.sql
Note 1425763.1 During A Database Upgrade To 11.2, Gathering Dictionary Statistics Takes Too Long (catupgrd.sql, cmpupend.sql)
Note 1465852.1 ORA-00942 reports during upgrade to 11.2.0.3 using manual or DBUA
Note 1466082.1 ORA-02095: Specified Initialization Parameter Cannot Be Modified
Note 1486277.1 SELECT TO_NUMBER('MUST_PATCH_TIMEZONE_FILE_VERSION_ON_NEW_ORACLE_HOME')

Post Upgrade Issues

Note 438210.1 Synonyms Become Invalid Since Upgrading To 10g
Note 456845.1 UTLU102S.SQL May Show Different Results Than Select From DBA_REGISTRY
Note 753041.1 How To Diagnose Components With NON VALID Status In DBA_REGISTRY After an Upgrade
Note 578841.1 How To Find What Objects Are Keeping Catalog And Catproc In Dba_Registry Invalid
Note 443706.1 After Migrate From 9.2.0.7 To 10.2.0.3 We Get Ora-04065 On Plitblm
Note 730136.1 OCI-21500 When Running UTLRP After A Successful Upgrade.
Note 782735.1 Oracle Database Server Component Invalid After Upgrade To 10.2.0.4, 11.1.0.6 Or 11.1.0.7
Note 978040.1 ORA-04045 ORA-04064 ORA-06508 ORA-06512 ERRORS RUNNING utlu111s.sql DURING UPGRADE TO FROM 9.2.0 TO 11.1.0
Note 1313429.1 Is it required to re-install the UTL_* packages after an upgrade to 11.2?
Note 1543850.1 Post Upgrade Scripts - utlu112s.sql & catuppst.sql report many Errors after upgrading Database from 10.2.0.X to 11.2.0.X

DBUA Specific Issues

Note 315184.1 Database Upgrade Assistant Hangs On Collecting Server Information
Note 567037.1 DBUA hangs at 82% for More than an Hour When Upgrading APPS DB to 10GR2
Note 339887.1 Failed Upgrade ''Dbua Thinks This Is A Rerun Operation'' ORA-01507
Note 603015.1 DBUA Fails with ORA-32004 and "Dbua Thinks This Is A Rerun Operation"
Note 729909.1 Upgrading to 11.1.0 and DBUA reports ORA-4023 On SYS.STANDARD
Note 789779.1 DBUA Error ORA-04031 unable to allocate 4120 bytes of shared memory, ORA-01034 ORACLE not available, ORA-00600 internal error code, arguments [504]
Note 271733.1 ORA-600 [17069] During Upgrade Using Database Upgrade Assistant, Utlu101i.sql or Utlu102i.sql
Note 308377.1 "ORA-01031 Insufficient Privileges" During An Upgrade Using DBUA On Unix/Linux
Note.386855.1 'startup migrate' failed with ORA-64 while upgrading to 10.2.0.2 with DBUA
Note 816457.1 DBUA unable to connect to the database for upgrade
Note 431437.1 10g DBUA Failed To Bring Up 9i Database. ORA-00119 ORA-00132 ORA-01078
Note 604248.1 DBUA Fails with ORA-0119 ORA-0132 ORA-1078 Upgrading to 10gR2
Note 391283.1 ORA-27054 NFS error while using DBUA to upgrade to 10gR2
Note 444148.1 Upgrading to 10gr2 Using Dbua Stops With An Alarm Sign At Step1
Note 737400.1 Ora-01408 Error Upgrading from 9i to 11g using Dbua
Note 559075.1 Dbua Won't Find Init<SID>.Ora During Upgrade Although It Is At The Right Location
Note 1321814.1 Underscore (Hidden) Parameters will not be retained after upgrade using DBUA
Note 1078388.1 Upgrdade to 11.2 via DBUA fails on ASMCA error on a database with no RAC or ASM
Note 980693.1 11gR2 DBUA States "The CEP File does not provide the version directive"
Note 1066828.1 11GR2 DBUA ORA-06550 PLS-00201 IDENTIFIER SYS.DBMS_JAVA MUST BE DECLARED
Note 1067422.1 DBUA ERROR: DOES NOT PROVIDE VERSION DIRECTIVE
Note 1066116.1 DBUA RAISES ORA-942 WHILE UPGRADING EXPRESSION FILTER COMPONENT
Note 1304849.1 DBUA: Database Is Missing From List Of Candidate Databases To Be Upgraded
Note 1364808.1 DBUA fails with error "Database is not open, restart database in open mode and try again" when upgrading from 10.2 to 11.2
Note 1466447.1 Database Upgrade Assistant (DBUA) Displays A Dialog Box When There Are Special Characters In The Pfile
Note 1477555.1 DBUA FAILS WITH "FOR INPUT STRING: 8,192" ERROR
Note 1453545.1 Database Upgrade using DBUA failed with invalid specification for system parameter LOCAL_LISTENER
Note 1427179.1 11.2.0.3 DBUA Hangs While Specifying ASM Disk To FRA

Using My Oracle Support Effectively

Note 166650.1 Working Effectively With Global Customer Support

Generic Links

Note 854428.1 Patch Set Updates for Oracle Products
Note 1061295.1 Patch Set Updates - One-off Patch Conflict Resolution
Note 268895.1 Oracle Database Server Patchset Information, Versions: 8.1. 7 to 11.2.0
Note 161549.1 Oracle Database Server and Networking Patches for Microsoft Platforms
Note 161818.1 Oracle Database (RDBMS) Releases Support Status Summary
Information on Security Patch Updates (SPU's)

The window below is a live discussion of this article (not a screenshot).  We encourage you to join the discussion by clicking the "Reply" link below for the entry you would like to provide feedback on.  If you have questions or implementation issues with the information in the article above, please share that below.

REFERENCES

NOTE:1520299.1 - Master Note For Oracle Database 12c Release 1 (12.1) Database/Client Installation/Upgrade/Migration Standalone Environment (Non-RAC)
NOTE:1351051.2 - Information Center: Install and Configure Database Server/Client Installations
NOTE:1351112.2 - Information Center: Upgrading and Migration Oracle Database
NOTE:1292089.1 - Master Note for Oracle XML Database (XDB) Install / Deinstall
NOTE:1151427.1 - Master Note For Oracle Database Downgrade
at No comments:
Subscribe to: Posts (Atom)

Database Options/Management Packs Usage Reporting for Oracle Databases 11.2 and later (Doc ID 1317265.1)

  Database Options/Management Packs Usage Report You can determine whether an option is currently in use in a database by running options_pa...