Upgrade Oracle Database

See the following:

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

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 Thesaurus Management System include:

• The service name must be less than 15 characters long.

• It must not include the domain.

• It must be all lowercase.

The Oracle Thesaurus Management System Installer no longer works if you set up connections using the SID.

Note:

If you are installing the Oracle Thesaurus Management System 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:

• Clone Your Database
  

Clone Your Database

1. Install Oracle Database 12.1.0.2 binaries in the Oracle_Home. See Review Database Requirements and Recommendations.
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, article ID 883213.1 on My Oracle Support.

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:

• Upgrade in Place from Oracle Database 12.1.0.2 to 19c
  
• Clone Your Database on a Oracle Database 19c
  

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.

Clone Your Database on a Oracle Database 19c

1. Install Oracle Database 19c. For instructions, see Install Oracle Database.
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.