Migrate all listeners – listener.ora, ORACLE wallets, sqlnet.ora, tnsnames.ora to the new ORACLE_HOME.Download and install latest RU/RUR (see list above for what was done at this writing). Install ORACLE software in a new ORACLE_HOME these are known as the binaries. So…major steps whenever a new upgrade cycle is started. For example the listeners for all of the 12.1.0.2 and 12.2.0.1 databases are actually running out of the 18c ORACLE_HOME, the RMAN catalog database is 18c (12.2.0.2), as well as the catalog version being 18c (actually 18.3). So you can upgrade certain components before others. It is the basic premise that Oracle software is backwards compatible for the upgrade/downgrade process. Step-Ordered Approach ….see more of the other blog posts for more explanation. So back to the original task…upgrading from 12.1 to 12.2.0.1 using the following software: V839960-01.zip Oracle Database 12c Release 2 (12.2.0.1.0) for Linux x86-64 Bug 28793062 : PLSQL PACKAGE WITH USER DEFINED TYPE IS THROWING PLS-00801: IN 18C The original plan was to upgrade to 18c but a compile issue made for a slight adjustment to this goal. The above Oracle document lets you know what I was starting with….this post will have the highlights and the high (lows). Complete Checklist for Manual Upgrades to Non-CDB Oracle Database 12c Release 2 (12.2) (Doc ID 2173141.1) Oracle Data Guard Broker Configuration File and Downgrades – now initialization parameters instead of external files.ĬDB 3 PDBs are included with the license for Enterprise Oracle 19c and desupport of non-CDBs with 20c This last part is why I coined this post as the intermediate step of CDB….now is the time to start using this feature if you haven’t in the past. Security Change NO AUTHENTICATION Schema accounts – ” During upgrades to Oracle Database 19c, default Oracle accounts that have not had their passwords reset before upgrade (and are set to EXPIRED status), and that are also set to LOCKED status, are set to NO AUTHENTICATION after the upgrade is complete.” Oracle Streams no longer supported – Goldengate only, Advanced Queueing still is. For example he debunks that Oracle marketing hype that CDB make upgrades easy by “plugging in” newer versions – not exactly true, there is still downtime along with complicated steps.Īll ……DBMS_JOBS migrated to DBMS_SCHEDULER His information has always been forthright, honest and spot-on. Oracle 19c – Complete Checklist for Manual Upgrades to Non-CDB Oracle Database 19c (Doc ID 2539778.1) URLĪlso another great resource is anything posted by Mike Dietriche….he works for Oracle for large upgrades/migrations. Take Our PollStart any migration planning by finding the “Complete Checklist for Manual Upgrades” for that version.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |