Below are the steps to install the Oracle Fusion Middleware Infrastructure 12c required to install Oracle GoldenGate Monitor Pack 12c.
This is PART 1 of a series of articles on how to install the Oracle GoldenGate Monitor 12c.
PART 2: Install Oracle GoldenGate Monitor
PART 3: Create OGG Monitor Repository
PART 4: Configuration of Monitor Server and Client Agent
Before start the install, make sure you have the JDK.
- Oracle JDK 7 Update 15 or higher
[gguser@spbnaggmon01 ~]$ /usr/java/jdk1.7.0_71/bin/java -jar fmw_126.96.36.199.0_infrastructure.jar
Launcher log file is /tmp/OraInstall2014-11-20_11-53-03AM/launcher2014-11-20_11-53-03AM.log.
Starting Oracle Universal Installer
Checking if CPU speed is above 300 MHz. Actual 2396.863 MHz Passed
Checking monitor: must be configured to display at least 256 colors. Actual unknown. Failed <<<<
Checking swap space: must be greater than 512 MB. Actual 8388604 MB Passed
Checking if this platform requires a 64-bit JVM. Actual 64 Passed (64-bit not required)
Checking temp space: must be greater than 300 MB. Actual 911 MB Passed
Some system prerequisite checks failed.
You must fulfill these requirements before continuing with the installation.
Continue? (yes [y] / no [n]) [n]
You have confirmed that the product can be installed on this platform.
Continuing with the installation.
>>> Ignoring failure(s) of required prerequisite checks. Continuing…
Preparing to launch the Oracle Universal Installer from /tmp/OraInstall2014-11-20_11-53-03AM
You can find the log of this install session at:
Logs successfully copied to /ggmon/oracle/oraInventory/logs.
In PART 2 I will demonstrate how to install the Oracle GoldenGate Monitor 12c on top of the Fusion Middleware Infrastructure.
Oracle GoldenGate 12c provides best-of-breed, real-time data integration and heterogeneous database replication. New features include:
- Migration utility for Oracle Streams: A new migration utility, Streams2OGG helps Oracle Streams customers move to Oracle GoldenGate and leverage its latest features, such as integrated capture and delivery processes and advanced conflict management.
- Support for IBM Informix: Oracle GoldenGate 12c now supports real-time data capture and delivery for the latest Informix database versions on all major platforms. Support has also been extended to Oracle GoldenGate Veridata so IBM Informix customers can integrate and replicate high volumes of real-time data throughout their heterogeneous business environments.
- Extended support for Microsoft SQL Server and MySQL: The new release adds support for real-time, log-based capture and delivery for Microsoft SQL Server 2012 and 2014 as well as MySQL Community Edition databases.
- SOCKS5 compliance: Oracle GoldenGate 12c now leverages customers’ SOCKS compliance setting for data transfer, enabling customers to replicate between on-premises and cloud environments without an extra VPN connection open.
- Support for big data: Oracle GoldenGate Adapter for Java enables integration with Oracle NoSQL, Apache Hadoop, Apache HDFS, Apache HBase, Apache Storm, Apache Flume, Apache Kafka, and others and allows real-time, noninvasive data streaming into big data targets to give customers new insights into business and improve the customer experience.
- Out-of-sync data repair: In addition to comparing heterogeneous databases and reporting data discrepancies without interrupting business operations, Oracle GoldenGate Veridata 12c now provides data repair and revalidation capabilities for out-of-sync data.
- Data capture from Oracle Active Data Guard: Oracle Active Data Guard customers who want to remove any replication impact on their production environment can use Oracle GoldenGate 12c on their standby systems to capture data in real time.
- Simplified application upgrades: The new release simplifies the upgrade process for customers leveraging the Oracle Database Edition-Based Redefinition feature by coordinating the upgrades and bringing the target database to the same edition-based version.
- Improved management and monitoring: Customers using the new release also gain the ability to start and stop processes, edit parameter files, collect information about operations, and diagnose issues easily with Oracle Enterprise Manager Plug-In 12.1.3, part of Oracle Management Pack for Oracle GoldenGate 12c.
Should you need help implementing your GoldenGate Strategy feel free to contact us (403) 479-9861
Full release from Oracle: http://www.oracle.com/us/corporate/press/2368822
My Friend Matt has written a good comparison between GoldenGate and Informatica, he should have asked first, as there is no comparison.. :-)
Nevertheless, a really good reading and learning.
Using oradebug one can get a dump of sessions parameters that are modified at session level, like optimization parameters.
SQL> alter session set sql_trace=true;
SQL> alter session set optimizer_mode=first_rows;
-- connect to session
SQL> oradebug setmypid
SQL> oradebug dump modified_parameters 1;
SQL> oradebug tracefile_name;
Contents of the tracefile:
*** 2012-05-28 14:35:25.005
Processing Oradebug command ‘dump modified_parameters 1′
DYNAMICALLY MODIFIED PARAMETERS:
sql_trace = TRUE
optimizer_mode = FIRST_ROWS
*** 2012-05-28 14:35:25.005
Oradebug command ‘dump modified_parameters 1′ console output:
Using the following SQL one can find the current number of processes and sessions connected and also max utilization so one can check if you need to increase the values of the parameter
SQL> select resource_name, current_utilization, max_utilization from v$resource_limit where resource_name in ('processes','sessions');
RESOURCE_NAME CURRENT_UTILIZATION MAX_UTILIZATION
------------------------------ ------------------- ---------------
processes 146 196
sessions 157 210