This chapter contains these sections:
This section guides you through the steps required to set up a WebLogic domain if you are using an Oracle database. If you are running either a SQL Server database, see Configuring Oracle GoldenGate Monitor Server for SQL Server Databases.
To create a Oracle Database repository, use this procedure:
Follow the instructions in Creating a Repository to create a repository; however, note the following exceptions for SQL Server:
When you reach the Database Connection Details screen, set Database Type to Oracle Database and set the appropriate connection information. Click Next.
The Select Components screen appears.
On the Select Components screen, select Monitor Server and Service Table (by default, this should already be selected).
Follow the remaining repository creation process. You should have these schema generated:
OGGMON
(the product-specific schema)
STB
OPSS
IAU
IAU_APPEND
IAU_VIEWER
In addition to Oracle databases, Oracle GoldenGate Monitor also supports the SQL Server database. The configuration instructions covered in Configuring Oracle GoldenGate Monitor Server for Oracle Databases applies only to that database provider. For the SQL Server database, you need to use the same tools though follow somewhat different procedures. Those procedures are explained in this section:
Before you begin, do the following:
Set:
ISOLATION LEVEL,ALTER DATABASE $(DATABASE_NAME) SET READ_COMMITTED_SNAPSHOT ON
Ensure the database is case-sensitive:
DECLARE @collate sysname select @collate = convert(sysname, serverproperty('Collation')) IF ( charindex(N'_CI', @collate) > 0 ) BEGIN select @collate = replace(@collate, N'_CI', N'_CS') exec ('ALTER database $(DATABASE_NAME) COLLATE ' + @collate)
To create a SQL Server repository, use this procedure:
Follow the instructions in Creating a Repository to create a repository; however, note the following exceptions for SQL Server:
When you reach the Database Connection Details screen, set Database Type to SQL Server database and set the appropriate connection information. Click Next.
The Select Components screen appears.
On the Select Components screen, select Monitor Server and Service Table (by default, this should already be selected).
Follow the remaining repository creation process. You should have these schema generated:
OGGMON (the product-specific schema)
STB
OPSS
IAU
IAU_APPEND
IAU_VIEWER
You will use the WebLogic Server Configuration Wizard to create the domain for all supported databases. This tool guides you through the process of creating a WebLogic domain by selecting the product components to include in your domain or by selecting template JAR files. If necessary, you can also customize the domain to suit your environment by adding and configuring Managed Servers, clusters, and machine definitions, or customizing predefined JDBC data sources and JMS file store directories. The procedures in this chapter will guide you through the simplest configuration scenario. To learn more about other capabilities of the Configuration Wizard, see Oracle Fusion Middleware Creating WebLogic Domains Using the Configuration Wizard.
Assuming WebLogic Server is installed properly (see Install Oracle WebLogic Server 12c (12.2.1)), launch the Configuration Wizard by doing the following:
On Linux:
$ ORACLE_HOME/oracle_common/common/bin/config.sh
On Windows:
C:\ORACLE_HOME\oracle_common\common\bin\config.cmd
For specifics about ORACLE_HOME
, see Install Oracle WebLogic Server 12c (12.2.1).
The Configuration Wizard starts and the Configuration Type screen appears.
To create the domain, navigate the Configuration Wizard screens providing the necessary information as described on the following table. For additional, generic information on each screen, click the screen name in the Screen column:
Screen | Configuration Action |
---|---|
Ensure Create a new domain is selected then:
|
|
|
|
|
|
|
|
|
|
Verify the schema information and click Next. |
|
Verify the schema information and click Next. |
|
|
|
|
|
By default, the server name is AdminServer and the port is 7001, although you can always change default values. For example, you can change the server name AdminServer to OGGMONAdminServer. If port 7001 is already in use, replace it with an unused port number.Make selections as necessary and click Next. |
|
The managed server name is already populated with the default, MONITORSERVER_server1, and the port number with 7003. You can change these values, if desired. Also, if port 7003 is already in use, replace it with an unused port number. Either accept the defaults of update the data and click Next. |
|
Click Next. |
|
Click Next. |
|
Click Next. |
|
Review the configuration details and click Create. |
|
When configuration creation is complete, click Next. |
|
|
The WebLogic Server domain for the Monitor product with Oracle database is now configured.
The final steps in configuring Oracle GoldenGate Monitor Server is setting properties as defined in this section.
Configure the JMX Server Properties
To verify that you have successfully Oracle GoldenGate Monitor Server, start the server. This is a two-to-three-step process comprised of:
To start the Administration Server, do the following:
Note:
This section is optional. Do it only if you need to update your Oracle GoldenGate Monitor Server credentials. If you do not need to do so, proceed to Start the WebLogic Managed Server).
Use WLST to create or update your wallet's Oracle GoldenGate Monitor Server credentials: