1. Upgrading to Oracle GoldenGate Monitor
  2. Upgrading the Oracle Database

10 Upgrading the Oracle Database

This chapter describes the tasks you perform to upgrade Oracle GoldenGate Monitor with an Oracle Database.

This chapter includes the following sections:

Note:

This upgrade supports only the latest version of Oracle 11g R3 and Oracle 12c R1 database software releases. For current database support information for Oracle GoldenGate Monitor 12c (12.2.1), see "Platform Support" in Installing and Configuring Oracle GoldenGate Monitor.

10.1 Creating the Required 12.2.1 Schema Using RCU for 11g Upgrades

This section is only applicable to 11g upgrades. It is not applicable to 12c upgrades because the required schema already exists.

Note:

Before running RCU for Oracle 12c databases, ensure the following:

  • The character set is AL32UTF8. You must do this because the default character set is not supported by RCU.

  • You are using a plug-able database. By default, a container database will enable in Oracle 12c, so RCU supports only plug-able database, not container database.

To create the 12.2.1 database schema, run the Repository Creation Utility, which is part of the product installation. To launch RCU, navigate to ORACLE_HOME/oracle_common/bin and enter:

For Linux or UNIX:

$ ./rcu

For Windows:

C:\ rcu.bat

RCU will open, displaying the Welcome screen.

Navigate the RCU screens as instructed in the following table to update the database.

Note:

Some of the RCU items that this procedure instructs you to select might already be selected by default. If an item on a screen is already selected and the instructions below tell you to select it, be careful not to deselect it.

Screen Upgrade Action

Welcome

Click Next.

Create Repository

  1. Select System Load and Product Load.

  2. Click Next.

Database Connection Details

  1. Enter the Oracle GoldenGate Monitor database details.

  2. Click Next.

Select Components

  1. Under the AS Common Services node, select the following schemata:

    • Audit Services

    • Audit Services Append

    • Audit Services Viewer

    • Oracle Platform Security Services

    Note: Do not select the Monitor Server schema in this step.

  2. Click Next.

    A progress window appears, checking off each schema as its prerequisites are met.

  3. Click OK.

Schema Passwords

  1. Enter the necessary password, if it's not already there, and confirm it.

  2. Click Next.

Map Tablespaces

Click Next.

Schema creation for the selected services will commence.

Summary

Review the schema information and click Create.

Creation Summary

Click Close.

Parent topic: Upgrading the Oracle Database

10.2 Upgrade Readiness Check

Before beginning an upgrade, you must use the UA to perform an upgrade readiness check. The UA runs a read-only check on various database contents including the schema version, required tables, and columns. If the schema version is already at the upgraded or latest version of Oracle GoldenGate Monitor or there are unexpected or missing tables or columns found, the readiness test will fail. If a failure occurs, the UA provides the test details and any exceptions in the UA logs, and the readiness test results are provided in the ORACLE_HOME/oracle_common/upgrade/logs/postreadiness.txt file. Like RCU, UA is included in the product installation.

Use one of the following sections to perform your readiness check:

Parent topic: Upgrading the Oracle Database

10.2.1 Performing an 11g Readiness Check

On your existing 11g Oracle GoldenGate Monitor server, navigate to ORACLE_HOME/oracle_common/upgrade/bin and enter:

For Linux or UNIX:

$ ./ua -readiness

For Windows:

C:\ ua.bat -readiness

Navigate the UA screens as instructed in the following table to upgrade your server.

Screen Upgrade Action

Welcome

Click Next.

Schemas

Ensure Schemas is selects and click Next.

Available Components

  1. Select Oracle GoldenGate Monitor.

  2. Click Next.

OGGMON Schema

  1. Enter the Oracle GoldenGate Monitor schema name and password.

  2. Click Next.

Readiness Summary

Click Next.

Readiness Check

Click Continue. You can use the View Readiness Report button to view your results.

Readiness Success

Click Close.

Parent topic: Upgrade Readiness Check

10.2.2 Performing a 12.1.3 Schema Readiness Check

On your existing Oracle GoldenGate Monitor server, navigate to ORACLE_HOME/oracle_common/upgrade/bin and enter:

For Linux or UNIX:

$ ./ua -readiness

For Windows:

C:\ ua.bat -readiness

Navigate the UA screens as instructed in the following table to upgrade your server.

Screen Upgrade Action

Welcome

Click Next.

WebLogic Components

Ensure WebLogic Component Configurations - offline checks only is selected and click Next.

Component List

Click Next.

Readiness Summary

Click Next.

Readiness Check

Click Continue. You can use the View Readiness Report button to view your results.

Readiness Success

Click Close.

Parent topic: Upgrade Readiness Check

10.2.3 Performing a 12.1.3 Domain Readiness Check

On your existing Oracle GoldenGate Monitor server, navigate to WEBLOGIC_HOME/oracle_common/upgrade/bin and enter:

Note:

Ensure that you go to your Oracle WebLogic home directory not your Oracle home directory.

For Linux or UNIX:

$ ./ua -readiness

For Windows:

C:\ ua.bat -readiness

Navigate the UA screens as instructed in the following table to upgrade your server.

Screen Upgrade Action

Welcome

Click Next.

WebLogic Components

Ensure WebLogic Component Configurations - offline checks only is selected and click Next.

Component List

Click Next.

Readiness Summary

Click Next.

Readiness Check

Click Continue. You can use the View Readiness Report button to view your results.

Readiness Success

Click Close.

Parent topic: Upgrade Readiness Check

10.3 Schema Upgrade Instructions

Upgrading Oracle GoldenGate Monitor Server for Oracle databases is a two-stage process:

  1. Creating the Required 12.2.1 Schema Using RCU for 11g Upgrades
  2. Upgrade the Server and Schema by Running UA

Note:

Ensure that the existing Monitor server is stopped before you proceeding with the following steps.

Parent topic: Upgrading the Oracle Database

10.3.1 Upgrade the Server and Schema by Running UA

Note:

Ensure that the existing Oracle GoldenGate Monitor Server 11g pointed to the schema you are going to upgrade is stopped before commencing with this procedure.

With the repository created, you next run UA to upgrade the database to version 12c (12.2.1). Navigate to ORACLE_HOME/oracle_common/upgrade/bin and enter:

For Linux or UNIX:

$ ./ua

For Windows:

C:\ ua.bat

The UA Welcome screen appears.

Use one of the following sections to perform your schema upgrade:

Parent topic: Schema Upgrade Instructions

10.3.1.1 Upgrading an 11g Schema

Upgrading the Server

Navigate the UA screens as instructed in the following table to upgrade your server.

Screen Upgrade Action

Welcome

Click Next.

Schemas

Ensure Schemas is selects and click Next.

Available Components

  1. Select Oracle GoldenGate Monitor.

  2. Click Next.

Prerequisites

  1. Select all three prerequisites.

  2. Click Next.

OGGMON Schema

  1. Enter the Oracle GoldenGate Monitor schema name and password.

  2. Click Next.

OGGMON Schema Prefix

  1. Enter the same schema prefix you used when creating the STB schema in RCU.

  2. Click Next.

Examine

Click Next.

Upgrade Summary

Click Upgrade.

Upgrade Progress

Click Next.

Upgrade Success

Click Close.

The /ua_timestamp.log,ua_timestamp.out files are generated at $oracle_common/upgrade/logs under the 12g ORACLE_HOME.

Upgrading the Oracle GoldenGate Monitor Server Configuration

The UA updates the Monitor Server configuration files to the latest 12.2.1 configuration by maintaining your existing set property values. It creates a oggmon.properties file in the domain_name/config/monitorserver/cfg/ directory, with an encrypted password entry that is used in JMX communication between Monitor Server and Agent.

Navigate to ORACLE_HOME/oracle_common/upgrade/bin and enter:

For Linux or UNIX:

$ ./ua

For Windows:

C:\ ua.bat

Navigate the UA screens as instructed in the following table to upgrade your server.

The UA Welcome screen appears.

Screen Upgrade Action

Welcome

Click Next.

Schemas

Ensure Schemas is selects and click Next.

WebLogic Components

  1. Select WebLogic Component Configurations and enter the domain directory to be upgraded.

  2. Click Next.

Component List

Click Next.

Prerequisites

  1. Select all three prerequisites.

  2. Click Next.

OGGMON Schema

  1. Enter or select the OGGMON schema connect string, and the DBA and schema user names and passwords.

  2. Click Next.

OGG Monitor Installed Version

  1. Select OGG Monitor 11g.

  2. Enter the directory that contains your 11g configuration files.

  3. Click Next.

Examine

Click Next.

Upgrade Summary

Click Upgrade.

Upgrade Progress

Click Next.

Upgrade Success

Click Close.

This completes the Oracle GoldenGate Monitor Server for Oracle database upgrade process.

10.3.1.2 Upgrading 12.1.3

Use this section to upgrade your 12.1.3 schema, WebLogic domain, and Oracle GoldenGate Monitor Server.

Upgrading the Server

Navigate the UA screens as instructed in the following table to upgrade your server.

Screen Upgrade Action

Welcome

Click Next.

Schemas

Ensure Schemas is selects and click Next.

Available Components

  1. Select Oracle GoldenGate Monitor and Oracle Platform Security Services. Oracle Audit Services is automatically selected.

  2. Click Next.

Domain Directory

Enter the directory for the domain you are upgrading or browse for it, then click Next.

Prerequisites

  1. Select all three prerequisites.

  2. Click Next.

IAU Schema

  1. Enter or select the IAU schema connect string, and the DBA and schema user names and passwords.

  2. Click Next.

OPSS Schema

  1. Enter or select the OPSS schema connect string, and the DBA and schema user names and passwords.

  2. Click Next.

OGGMON Schema

  1. Enter or select the OGGMON schema connect string, and the DBA and schema user names and passwords.

  2. Click Next.

Examine

Click Next.

Upgrade Summary

Click Upgrade.

Upgrade Progress

Click Next.

Upgrade Success

Click Close.

The /ua_timestamp.log,ua_timestamp.out files are generated at $oracle_common/upgrade/logs under the 12g ORACLE_HOME.

Upgrading the WebLogic Domain

Next, you must update the existing 12.1.3 WebLogic domain configuration to a 12.2.1 domain. Navigate to ORACLE_HOME/wlserver/common/bin and enter:

For Linux or UNIX:

$ ./reconfig.sh

For Windows:

C:\ reconfig.bat

The Fusion Middleware Reconfiguration Wizard opens, displaying the Select Domain screen.

Navigate the wizard screens as instructed in the following table to upgrade your domain.

Screen Upgrade Action

Select Domain

Enter the directory for the domain you are upgrading or browse for it, then click Next.

Setup Progress

Click Next.

Domain Mode and JDK

Enter your JDK directory or browse for it, then click Next.

Database Configuration Type

  1. Click Get RCU Configuration to retrieve your database configuration and ensure that it successfully connects.

  2. Click Next.

Component Datasources

Click Next.

JDBC Test

  1. Select all connections.

  2. Click Test Selected Connections.

  3. Click Next.

Advanced Configuration

Do not select anything.

Click Next.

Configuration Summary

Click Reconfig.

Reconfiguration Progress

Click Next.

Reconfiguration Success

Click Finish.

Upgrading the Oracle GoldenGate Monitor Server Configuration

The UA updates the Monitor Server configuration files to the latest 12.2.1 configuration by maintaining your existing set property values. It creates a oggmon.properties file in the domain_name/config/monitorserver/cfg/ directory, with an encrypted password entry that is used in JMX communication between Monitor Server and Agent.

Navigate to ORACLE_HOME/oracle_common/upgrade/bin and enter:

For Linux or UNIX:

$ ./ua

For Windows:

C:\ ua.bat

Navigate the UA screens as instructed in the following table to upgrade your server.

The UA Welcome screen appears.

Screen Upgrade Action

Welcome

Click Next.

Schemas

Ensure Schemas is selects and click Next.

WebLogic Components

  1. Select WebLogic Component Configurations and enter the domain directory to be upgraded.

  2. Click Next.

Component List

Click Next.

Prerequisites

  1. Select all three prerequisites.

  2. Click Next.

OGG Monitor Installed Version

  1. Select OGG Monitor 12.1.3.

  2. Click Next.

OGGMON Schema

  1. Enter or select the OGGMON schema connect string, and the DBA and schema user names and passwords.

  2. Click Next.

Examine

Click Next.

Upgrade Summary

Click Upgrade.

Upgrade Progress

Click Next.

Upgrade Success

Click Close.

This completes the Oracle GoldenGate Monitor Server for Oracle database and domain upgrade process.

10.4 Next Step: Perform Post-Upgrade Tasks

With the upgrade process complete for your database type, you next need to perform certain post-upgrade tasks, which are described in Performing Post-Upgrade Tasks.

  • Applying the Oracle GoldenGate Monitor Patch
    After applying the Oracle GoldenGate Monitor patch 12.2.1.2.171115 (PS2 BP3), optionally, you can execute a table re-partition script to optimize the history purging feature. After the script execution is completed, it reduces the time needed to purge historical data by using the Oracle GoldenGate Monitor server user interface. However, significant amount of time may be needed for script execution depending of amount of existing data.

Parent topic: Upgrading the Oracle Database

10.4.1 Applying the Oracle GoldenGate Monitor Patch

After applying the Oracle GoldenGate Monitor patch 12.2.1.2.171115 (PS2 BP3), optionally, you can execute a table re-partition script to optimize the history purging feature. After the script execution is completed, it reduces the time needed to purge historical data by using the Oracle GoldenGate Monitor server user interface. However, significant amount of time may be needed for script execution depending of amount of existing data.

To apply the patch:
  1. Stop the Oracle GoldenGate Monitor Server.
  2. Apply patch 12.2.1.2.171115 (PS2 BP3) if you have not yet applied it.
  3. Run the following script as SYSDBA user and enter the Oracle GoldenGate Monitor Repository User Name when asked for parameter 1 – <ORACLE_HOME>/oggmon/plugins/upgrade/scripts/grant_permission_oracle.sql.
  4. Run the following script as Monitor Repository User – <ORACLE_HOME>/oggmon/plugins/upgrade/scripts/oracle_partitions.sql.
  5. Start the Oracle GoldenGate Monitor Server.

Parent topic: Next Step: Perform Post-Upgrade Tasks