This is a chapter describes the prerequisites you must meet before you can successfully install and configure Oracle GoldenGate Monitor. It is comprised of these sections
Note:
If your machine configuration already meets the criteria specified in this chapter, proceed to Chapter 3, "Installing Oracle GoldenGate Monitor".The target machine is that computer on which you are running the Oracle GoldenGate Monitor instance. Install JDK 7.1 on this machine and set JAVA_HOME
and PATH
environment variables with JDK 1.7 path.
For more information on installing JDK 1.7, see the "JDK 7 and JRE 7 Installation Guide" at:
http://docs.oracle.com/javase/7/docs/webnotes/install/index.html
After installing the certified JDK (JDK 1.7.0_15 or higher), use the Oracle Fusion Middleware 12c (12.1.3) Infrastructure installer to install Oracle WebLogic Server and the Oracle Java Required Files (JRF) Infrastructure services. Download the installer fmw_
WLS_version
_infrastructure.jar
(where WLS_version
represents the supported WebLogic Server version; for example, 12.1.3.0.0), which you can obtain from:
http://www.oracle.com/technetwork/developer-tools/adf/downloads/index.html
or from the Oracle Software Delivery Cloud, at:
For more details on obtaining Oracle Fusion Middleware Infrastructure installer, see "Understanding and Obtaining the Oracle Fusion Middleware Infrastructure Distribution" in Installing and Configuring the Oracle Fusion Middleware Infrastructure.
For details on installing Oracle WebLogic Server and JRF, see "Installing the Oracle Fusion Middleware Infrastructure Software" in Installing and Configuring the Oracle Fusion Middleware Infrastructure.
Oracle GoldenGate Monitor supports these databases:
Database | Version | Documentation |
---|---|---|
Oracle | 11gR2, 12c | http://www.oracle.com/technetwork/indexes/documentation/index.html#database |
MySQL | 5.5 | http://www.oracle.com/technetwork/indexes/documentation/index.html#database |
SQL Server | 2008, 2012 | 2008: http://www.microsoft.com/en-us/download/details.aspx?id=30437
2012: |
The MySQL and Microsoft SQL Server databases do not support the Oracle Platform Security Service (OPSS) so configuring them requires different steps than the Oracle database. If you are installing either of these non-Oracle databases, you should familiarize yourself with these additional steps, see Section 4.2, "Configuring Oracle GoldenGate Monitor Server for Non-Oracle Databases".
Oracle Fusion Middleware only supports schemas in a byte-mode database. The nls_length_semantics
initialization parameter on the database where the schemas reside must be set to BYTE
; setting this parameter to CHAR
is not supported.
To check the values of this parameter using SQL*Plus, you can use the show parameters command:
prompt> sqlplus "sys/password as sysdba"SQL> show parameters nls_length_semantics
Replace password with the actual password for the SYS user.
Alternatively, you can check the values by querying the V$PARAMETER
view:
prompt> sqlplus "sys/password as sysdba"SQL> select name,value from v$parameter;
With the prerequisites met, you will now install Oracle GoldenGate Monitor. For instructions, see Section 3, "Installing Oracle GoldenGate Monitor"