Installing Oracle 19c

Applies to: On premises

You can use these steps to set up Oracle 19c for the OpenPages® and Cognos® databases.

About this task

The steps in this task are provided to help you understand the overall process. For more information, see the Oracle documentation.

For information about upgrading Oracle, see Upgrading Oracle to 19c (in-place) or Upgrading Oracle to 19c (migration).

Procedure

  1. Do the Oracle pre-installation steps and check that your system meets the installation prerequisites.
  2. Download the Oracle installation package for your operating system.
    For example:
    • Windows: WINDOWS.X64_193000_db_home.zip
    • Linux: LINUX.X64_193000_db_home.zip
  3. Create the ORACLE_HOME directory.

    This directory is where you will install Oracle.

    On Linux, for example, you can use the following command:
    mkdir -p /home/oracle/app/product/19.3
  4. Extract the Oracle installation package into the ORACLE_HOME directory.

    The Oracle installer does not allow you to install to a different directory.

    For example, on Linux, run the following commands:
    cd /home/oracle/app/product/19.3
    unzip /tmp/LINUX.X64_180000_db_home.zip
  5. Start the Oracle installation program.
    • Windows: Open a command prompt as an administrator, and then run setup.exe .
    • Linux: Run ./runInstaller.
  6. Use the installation wizard to install Oracle.
    Use the defaults, except for the following options:
    • On the Select Installation Option page, select Create and configure a single database instance.
    • On the System Class page, select Server class.
    • On the Install Type page, select Typical install.
    • On the Typical Installation page, enter the values that are appropriate for your environment.
      For example, if you want to use Oracle Pluggable Database (PDB), you can use the following values:
      • For the Global Database Name, type OPCDB.
      • Select Create as Container Database.
      • For the Pluggable database name, type OP.
      Or, if you are not using Oracle Pluggable Database, you can use the following values:
      • For the Global Database Name, type OP.
      • Clear the Create as Container Database check box.
    • For the character set, use AMERICAN_AMERICA.AL32UTF8.
    • On the Prerequisite Checks page, fix any issues. If issues are marked fixable, click Fix & Check Again. Fix any other issues manually.
    • For Linux only:
      • Install all recommended packages. For example:
        yum install -y nfs-utils smartmontools compat-libstdc++-33-3.2.3
      • If the maximum stack size is an issue, log in as root and edit the /etc/security/limits.conf file. Add these lines:
        * soft stack 10240
        * hard stack 10240

        Log back in as oracle and re-run the installer.

      • If swap size is an issue, run the following command as the root user to increase the swap size:
        dd if=/dev/zero of=/swapfile count=8096 bs=1MiB
        mkswap /swapfile
        chmod 600 /swapfile
        swapon /swapfile

        Where count is the amount in megabytes by which to increase the swap size.

        When the errors are fixed, you can continue with the installation.

      • Run the root.sh script as instructed.