1. Upgrade Guide
  2. Upgrade Oracle Database Server Code and Databases
  3. Upgrade Oracle Database

Upgrade Oracle Database

In this section:

Parent topic: Upgrade Oracle Database Server Code and Databases

Upgrade the Database to Oracle Database 12c Release 1 (12.1.0.2)

Note:

Choose to configure the database to accept connections as a service instead of a SID. Service name requirements for Oracle Clinical include:

  • The service name must be less than 15 characters long.
  • It must not include the domain.
  • It must be all lowercase.

The Oracle Clinical Installer no longer works if you set up connections using the SID.

Note:

If you are installing the Oracle Clinical database on a pluggable Oracle 12.1.0.2 database (PDB), see My Oracle Support article ID 1910177.1, How To Configure TNS / SQLNET using the local_listener parameter for Pluggable Database In Oracle 12c, Allowing a SQLNET Connection to the PDB.

For more information, see:

Parent topic: Upgrade Oracle Database

Clone Your Database

  1. Install Oracle Database 12.1.0.2 binaries in the Oracle_Home.
  2. To use one or more pluggable databases, create an Oracle Database Container Database (CDB). (If you are upgrading multiple databases, you still need only one CDB.)
    Update the listener and tnsnames.ora either before or after the next step.
  3. Clone your database. See Oracle White Paper Cloning Oracle Clinical and TMS Databases (Doc ID 883213.1) on My Oracle Support.

Parent topic: Upgrade the Database to Oracle Database 12c Release 1 (12.1.0.2)

Upgrade the Database to Oracle Database 19c (19.3.0)

If your Oracle database version is 12.1.0.2, you can upgrade the database to the 19c version.

Do one of the following:

For more information, see:

Parent topic: Upgrade Oracle Database

Upgrade in Place from Oracle Database 12.1.0.2 to 19c

Follow instructions in the Oracle Database Upgrade Guide - 19c at https://docs.oracle.com/en/database/oracle/oracle-database/19/upgrd/ using the Database Upgrade Assistant (DBUA) option.

For more information, see Method 1 in the Upgrade and Migrate to Oracle Database 19c White Paper at https://www.oracle.com/a/tech/docs/twp-upgrade-oracle-database-19c.pdf.

Parent topic: Upgrade the Database to Oracle Database 19c (19.3.0)

Clone Your Database on a Oracle Database 19c

To clone your database on a Oracle Database 19c:

  1. Install Oracle Database 19c.
  2. Create an Oracle Database Container Database (CDB) to use one or more pluggable databases.

    Note:

    If you are upgrading multiple databases, you still need only one CDB.
  3. Update the listener and tnsnames.ora.
  4. Clone your database. For instructions, see Cloning Oracle Clinical and TMS Databases White Paper (Doc ID 883213.1) on My Oracle Support.

Parent topic: Upgrade the Database to Oracle Database 19c (19.3.0)