Online DBA

  Step by Step Upgrading Database using Autoupgrade utility  <<Back to DB Administration Main Page Step1: create config file  java -jar autoupgrade.jar -create_sample_file config /oracle/ORCL/ORCL_autoupgrade.cfg Step2: Adjust the config file  parameters  global.autoupg_log_dir=/ora_app/cfgtoollogs/autoupgrade upg1.log_dir=/ora_app/cfgtoollogs/autoupgrade/ORCL  upg1.sid=ORCL  upg1.source_home=/ora_app/product/12.1.0.2/home12 upg1.target_home=/ora_app/product/19c/home19 upg1.start_time=NOW  upg1.upgrade_node=host1.merckgroup.com upg1.run_utlrp=yes upg1.timezone_upg=yes step3: Run PreCheck java -jar autoupgrade.jar -config /ora_work/ORCL/ORCL_autoupgrade.cfg -mode analyze AutoUpgrade 24.6.240905 launched with default internal options Processing config file ... +--------------------------------+ | Starting AutoUpgrade execution | +--------------------------------+ 1 Non-CDB(s) will be analyzed Type 'help' to list console commands upg> Job 10...

  Oracle Autoupgrade Available Commands <<Back to DB Administration Main Page java -jar autoupgrade.jar -help Usage: java -jar autoupgrade.jar <option(s)> Syntax: <required> [optional] default* options = <run_type1|run_type2|run_type3> run_type1 = -version | -help | -create_sample_file <options> | -listchecks <checkName> run_type2 = [-settings <settings>]             <-config <config>|-config_values <config_values>>             [-mode <mode>]             [-load_password]             [-restore_on_fail]             [-console | -noconsole]             [-debug]             [-clear_recovery_data [-jobs job#,job#,...]]             [-restore -jobs <job#,job#,...>]>     ...

  <<Back to DB Administration Main Page Creating and adjusting the config file for AutoUpgrade 19c Creating and adjusting the config file for AutoUpgrade 19c In this post I will show you , how you can create a simple AutoUpgrade config file and adjust it for a database upgrade. java -jar $OH19/rdbms/admin/autoupgrade.jar -create_sample_file config oracle@host1 :/oracle/software/autoupgrade/$ java -jar autoupgrade.jar -create_sample_file config Created sample configuration file /oracle/software/autoupgrade/sample_config.cfg sample output: cat /ora_stage/software/autoupgrade/sample_config.cfg # # Sample config file for AutoUpgrade # # build version 24.6.240905 # build date    2024/09/05 11:30:40 -0400 # # # Global configurations # # This directory will include the following: #   (1) AutoUpgrade''s global directory #   (2) Any logs, not directly tied to a job #   (3) Config files #   (4) progress.json and status.json global.autou...

  <<Back to DB Administration Main Page Oracle Database AutoUpgrade tool Starting from oracle 19c there is a tool available to upgrade the databases. This is called oracle auto upgrade and is a recommended method  by oracle to upgrade the database. Start using and adopting it  soon this will be only way to upgrade the database  The idea of the tool is to run the prechecks against multiple databases, fix majority  of the potential issues, set a restore point in case something goes wrong – and then upgrade your databases. And of course, do the postupgrade, recompilation and time zone adjustment. The only thing you need to provide is a config file in text format How to download  AutoUpgrade Tool This tool is available with Oracle Database 19c (19.3)  You can download the most recent version from MOS Note: 2485457.1  AutoUpgrade documentation It is all here included in the Oracle Database 19c Upgrade Guide: Using AutoUpgrade for Oracle Data...

<<Back to DB Administration Main Page DBUA does not list the  database to upgrade Cause :  in correct /etc/oratab entry cat /etc/oratab ORCL1P:/u01/product/11.2.0.4/dbp1 Solution : modify the /etc/oratab as shown below ORCL1P:/u01/product/11.2.0.4/dbp1 :Y

<<Back to DB Administration Main Page How to Convert Classical Database in Multitenant Architecture Database Source DB (Classical Architecture) : ORCL1P Target DB (Multitenant Architecture) : CDB01DB ORCL1P to be plugged as PDB01P into  CDB01DB Container DB ( CDB01DB ) should already be installed and present NOTE: Demonstration in this post assumes the conversion on same host Execute on  ORCL1P Step1>Place the non-CDB in read-only mode SQL>select name from v$database; SQL>shutdown immediate; SQL>startup open read only; SQL> select name,open_mode from v$database; Step2> Prepare Conversion BEGIN  DBMS_PDB.DESCRIBE(  pdb_descr_file => '/ora_temp/rman/ORCL1P/PDB01P.xml'); END; / Step3> shutdown the NON-CDB database ( NONCDB) SQL>shutdown immediate; Execute on  CDB01DB Step4> Check the compatibility. Now connect to the container database, where it need to be plugged. SET SERVEROUTPUT ON DECLARE  compatible CONSTANT VARCHAR2(3)...

<<Back to DB Administration Main Page How to Upgrade from 11g,12c,18c to 19c DB Upgrade Compatibility Matrix Below is minimum version of the database that can be directly upgraded to Oracle 19c. Source Database Target Database 11.2.0.4 19c 12.1.0.2 19c 12.2.0.1 19c 18.1.0.0 19c NOTE: In this post I will demonstrate the upgrade from 12.1.0.2 to 19c. The steps are same for any other version to 19c upgrade. Upgrading the database from 12.1.0.2 to 19c I will be using DBUA its really easy to use and self explanatory as well as recommended options. It automates many things including upgrading Time zone, gathering dictionary statistics , taking restore RMAN backup or creating restore point , starting the listener with new OH etc. etc. Although DBUA can do many thing its recommended to everything possible that can be done upfront to minimize the overall downtime. General Requirement Ensure All DB Components and objects are valid....