2 Upgrading for 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 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 Server.

2.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.

Important:

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 Oracle12c, 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 ar e 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.

2.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:

2.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.

2.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.

2.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.

2.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:

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

2.3.1 Upgrade the Server and Schema by Running UA

Warning:

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:

2.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.

2.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.

2.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 Chapter 4, "Performing Post-Upgrade Tasks".