APTARE IT Analytics Release Notes

To upgrade the Oracle database binaries:

1. Perform a cold backup of your Oracle database. This means that you'll physically copy or backup the files to another location. This cold backup will simplify the restore process, in the event of unanticipated data loss.
2. Export your Oracle database. This can be done manually prior to the upgrade, or you can elect to have it done as part of the upgrade process.
3. Verify that you have the current version of the Oracle 19c Installer binaries.
4. Total temporary file system (tmpfs) memory must be 24 GB or greater, otherwise Oracle will fail to start. Increase the size of tmpfs, typically in /etc/fstab.
5. Download the following Oracle patches from Veritas and keep them in a directory on the server where Oracle Database will be installed.

   • p31281355_190000_Linux-x86-64.zip

   • p30565805_198000DBRU_Linux-x86-64.zip

   The path for this directory will be required by the Oracle database installer during the upgrade process. Oracle database installer will install these patches as part of upgrade.

   Oracle installer installs only the above-listed patches. Any other patches released by Oracle must be installed manually.

6. Verify that the Oracle Database does not have any invalid objects. The installer will verify if the Database has any invalid objects. If any invalid objects are found, the installer will prompt the user to delete them. It is recommended to consult with support before deleting the invalid objects.
7. Login as root on the server where the APTARE IT Analytics Database will be installed. Typically, this is also the Portal server.
8. Place the ISO image into the /mnt directory.
9. Mount the ISO image that you downloaded.

   mkdir /mnt/diskd

   mount -o loop <sc_dbinstaller_XXXXX_XXX_linux.iso> /mnt/diskd

   where you substitute the relevant name of the ISO file that you downloaded.

10. Enter the following commands to start the installer:

    cd /
    /mnt/diskd/install_oracle.sh
    

    The command copies the ORACLE binaries into /opt/aptare/oracle19c.

11. Press Enter to read the entire EULA license agreement and accept the agreement. The upgrade process begins by detecting an existing Oracle installation and switching to upgrade mode.
12. Provide the absolute directory path where recommended Oracle patches are downloaded.

    Note:

    aptare user must have write access to the directory where these patches are downloaded.

    The Database upgrade process will install the Oracle security patches if they are available in this system. aptare user must have write access to the directory where these patches are downloaded. Enter the absolute directory path where these patches are downloaded.

13. Enter PROCEED to proceed with the upgrade.

    This takes 3-5 minutes to complete, as it installs files into /opt/aptare/oracle19c.

    Creating group aptare...Done.
        Creating user aptare...with default Group aptare... Done.
        Creating group dba...Done.
        Adding user aptare to group dba...Done.
        Creating ORACLE_HOME directory in /opt/aptare/oracle ... Done.
        Setting up database directories /data01 /data02 /data03 /data04
        /data05 /data06... Done.
        Installing ORACLE binaries in /opt/aptare/oracle19c ...
        Extracting files... Please wait, this process will take 3-5 minutes to complete... Done.
        Setting permissions for oracle files ... Done.
        Done.
    

14. The Oracle Database installer will install the recommended Oracle patches. Before installing the Oracle patches, Oracle installer will verify the Oracle Inventory. If any issue is observed, it will re-create the Oracle inventory.
15. After the extraction of Oracle 19c binaries, the pre-upgrade process begins. This includes:

    • Acknowledgement that a cold backup was performed. As part of the upgrade process, Oracle 19c binaries will be installed to your system, upgraded using an auto upgrade utility and converted to Container-Based DB (CDB). A cold backup of the Oracle data files is required to protect against possible errors and data loss.

    • Compatibility check verifies if the existing database is compatible for direct upgrade to Oracle 19c

    • Database Export. This is required. As part of this process you can either verify the export or direct the upgrader to export it for you.

      • Verification of a database export: An Oracle database export is required. This export is in addition to the full Oracle filesystem cold backup. If this step was taken prior to the upgrade process you must enter SKIP and then enter the existing database export file name and location.

        OR

      • Export the database: An Oracle database export is required. If you did not do this prior to the upgrade, and verify it, the upgrader can export it for you. This export is in addition to the full Oracle filesystem cold backup. Enter PROCEED to export the database and enter a location for the upgrader to place the files. This step can require 20-30 minutes depending on the size of the database.

16. Once the pre-upgrade processes are complete the utility will complete the Oracle upgrade.
17. After the successful completion of pre-upgrade process, the database upgrade process will start using the Autoupgrade utility. During the process, the following is displayed:

     [exec] Autoupgrade Utility Started.
         [exec] aptare
         [exec] AutoUpgrade tool launched with default options
         [exec] Processing config file ...
         [exec] +--------------------------------+
         [exec] | Starting AutoUpgrade execution |
         [exec] +--------------------------------+
         [exec] 1 databases will be processed
    

    After successful completion of the process, the following is displayed:

     [exec] Autoupgrade Utility Started.
         [exec] aptare
         [exec] AutoUpgrade tool launched with default options
         [exec] Processing config file ...
         [exec] +--------------------------------+
         [exec] | Starting AutoUpgrade execution |
         [exec] +--------------------------------+
         [exec] 1 databases will be processed
         [exec] Job 100 completed
         [exec] ------------------- Final Summary --------------------
         [exec] Number of databases            [ 1 ]
         [exec] 
         [exec] Jobs finished successfully     [1]
         [exec] Jobs failed                    [0]
         [exec] Jobs pending                   [0]
         [exec] ------------- JOBS FINISHED SUCCESSFULLY -------------
         [exec] Job 100 for scdb
         [exec] Autoupgrade Utility Finished.