Installing Oracle GoldenGate Studio 12c

1. Open a terminal shell window and create a directory for the Fusion Middleware Infrastructure software. It will be installed in /u01/app/oracle/ogg_mon.

   $ mkdir -p /u01/app/oracle/ogg_mon
   $
   

2. Change directory to /home/oracle/Downloads where you previously downloaded and unpacked the Fusion Middleware Infrastructure software. Invoke Java with the -jar and -Xmx1024M options to start the Oracle Fusion Middleware Infrastructure installer.

   $ cd /home/oracle/Downloads 
   $ java -jar -Xmx1024M fmw_12.2.1.0.0_infrastructure.jar

3. The installer GUI starts. Click Next when the Welcome page is displayed, to proceed with the installation.

4. The second step of the installation affects the way you want to manage auto updates. Accept the default, Skip Auto Updates and click Next.

5. The third step of the installation asks you to determine the installation location, or the Oracle Home for Oracle GoldenGate Monitor Server. Enter /u01/app/oracle/ogg_mon as the Oracle Home directory and click View to check weather other Fusion Middleware products may have been installed there. No products are expected to be found there. The installer should display "No Features are installed at selected Oracle home." Click Next to proceed with the installer.

   

6. Step four is concerned with the installation type. Select "Fusion Middleware Infrastructure" (no examples) and click Next to continue the installation.

7. The installer performs the prerequisite checks. It verifies that the Operating System is in the compatibility matrix, and that the version of Java used to launch the installer is supported by the current version of Oracle Fusion Middleware Infrastructure. If both checks succeed, the installer displays two green ticks. Click Next to continue.

8. In step 6, the installer asks you to enter your email in case security updates are available and you should be informed. Unselect "I wish to receive security updates via My Oracle Support" and click Next.

9. The installer displays a pop-up window alerting you to the fact that you did not provide an email address. Click Yes to remain uninformed of security issues and proceed with the installation.

   

10. The installer displays the installation summary in step seven. Verify the installation parameters and click Install.

11. The installation is performed and the installation progress page is displayed. There are eight steps:

    • Prepare
    • Copy
    • Generating Libraries
    • Performing String Substitutions
    • Linking
    • Setup
    • Saving the inventory
    • Post install scripts

    The installer progresses and displays a green tick to the left of all steps as soon as they are performed. Eventually eight ticks are displayed when the installation completes successfully. Click Next to display the installation complete report.

    

12. An installation summary is displayed by the installer, which shows the installation location and the feature set which was successfully installed. Examine the output and click Finish to terminate the installer.

    

1. Open a terminal shell window and change directory where you downloaded the Oracle GoldenGate Monitor Server. By default that directory is the default download directory for your broweser. If you are connected as the "oracle" user to your computer, and you are using either Oracle Linux or a Red Hat derivative, that directory is /home/oracle/Downloads. Locate the V78177-01.zip file and use unzip to decompress it.

   $ unzip V78177-01.zip
   Archive: V78177-01.zip
     inflating:: fmw_12.2.1.0.0_ogg.jar
   $
   

2. Launch the installer using the java -jar command. You must increase the maximum heap size allocated to the JVM to one gigabyte:

   $ java -jar -Xmx1024m fmw_12.2.1.0.0_ogg.jar
   $
   

   The splash window for the Fusion Middleware 12c GG Monitor_Veridata installer is displayed.

   

   Click Next when the Welcome page appears. Accept the default (Skip Auto Updates) in the Auto Updates page and click Next.

3. Step 3 of the installation asks you to enter the Oracle Home directory for the Oracle Fusion Middleware Infrastructure software. Enter /u01/app/oracle/ogg_mon (or the directory where and Fusion Middleware Infrastructure has been installed, if in your environment you installed the software elsewhere in the file system) click the View button to access the Feature Sets installed in the Oracle Home directory for Fusion Middleware. Verify that Fusion Middleware is found by the installer and click Next to proceed with the installation.

   

4. In step 4, the installer asks you to select what type of installation you want to perform. Choose Oracle GoldenGate Monitor Server and Monitor Agent and click Next to proceed to step 5.

   

5. The installer performs some prerequisite checks. Two green tick signs are displayed to signify that the checks succeeded. Click Next to proceed.

6. An installation summary window is displayed by the installer. Verify the location and the feature sets (both Monitor Server and Monitor Agent must be installed) and click Install to start the installation.

7. The installation progress window appears. There are 8 steps performed during the installation. A green tick appears beside each step as soon as that step completes successfully. Eventually all steps are perfomed and the next button becomes active. Click Next to proceed.

   

8. The installer displays the Installation Complete screen. Click Finish to close the installer.

   

1. Open a terminal shell window and change directory where you downloaded the Oracle GoldenGate Monitor Agent. By default that directory is the default download directory for your browser (/home/oracle/Downloads.) Locate the fmw_12.2.1.1.0_oggstudio.jar file. Make sure you have the environment variable JAVA_HOME set, pointing to an Oracle JDK release 8 supported by Oracle Fusion Middleware. If your JAVA_HONME variable is not set, you can set it on-the-fly in your shell (simply type: export JAVA_HOME=/usr/java/latest and press Enter.) To make sure everything is fine, invoke java with the -version parameter. Invoke Java with the -jar option to start the Oracle Goldengate Studio installer.

   $ cd /home/oracle/Downloads
   [Downloads]$ echo $JAVA_HOME
   /usr/java/latest							
   [Downloads]$ java -version
   java version "1.8.0_77"
   Java(TM) SE Runtime Environment (build 1.8.0_77-b02)
   Java HotSpot(TM) 64-Bit Server VM (build 25.77-b02, mixed mode)
   [Downloads]$ java -jar fmw_12.2.1.1.0_oggstudio.jar

2. The installer GUI starts. Click Next when the Welcome page is displayed, to proceed with the installation.

3. The second step of the installation affects the way you want to manage auto updates. Accept the default, Skip Auto Updates and click Next.

4. The third step of the installation asks you to determine the installation location, or the Oracle Home for Oracle GoldenGate Studio. If you already have installed other Fusion Middleware components, select the common Oracle Home directory and click View to check the other Fusion Middleware products you might have in the common Oracle Home directory. In this example, the computer used for this OBE already has a Fusion Middleware Oracle Home with a few products installed (/u01/app/oracle/Middleware/Oracle_Home)

   

   If Oracle GoldenGate Studio is the only Oracle Fusion Middleware you are going to install, select a new, empty directory and click View. The installer will check the directory, verifying that no other Fusion Middleware products are present, and will display: No Features are installed at selected Oracle Home.

   

   Important:This release of Oracle GoldenGate Studio expects to be installed on a standalone, self contained Oracle Home directory. So, even if you already have other Fusion Middleware products already installed, create a completely new Oracle Home and install Oracle GoldenGate Studio there. In this OBE the chosen directory path is /u01/app/oracle/ogg_studio but you can chose a different path in your environment. Click Next to proceed with the installation.

5. Step four is concerned with the installation type. At present, the installer only gives one option: Complete Install. Click Next to continue the installation.

6. The installer performs the prerequisite checks. It verifies that the Operating System is in the compatibility matrix, and that the version of Java used to launch the installer is supported by the current version of Oracle GoldenGate Studio. If both checks succeed, the installer displays two green ticks. Click Next to continue.

   

7. The installer displays the installation summary in step six. Verify the installation parameters and click Install.

8. The installation is performed and the installation progress page is displayed. There are eight steps:

   • Prepare
   • Copy
   • Generating Libraries
   • Performing String Substitutions
   • Linking
   • Setup
   • Saving the inventory
   • Post install scripts

   The installer progresses and displays a green tick to the left of all steps as soon as they are performed. Eventually eight ticks are displayed when the installation completes successfully. Click Next to display the installation complete report.

   

9. An installation summary is displayed by the installer, which shows the installation location and the feature set which was successfully installed. Examine the output and click Finish to terminate the installer.

   

10. Edit the .bashrc file in your home directory and set the FMW_HOME variable to point to the /u01/app/oracle/ogg_studio the Oracle Home for Oracle GoldenGate Studio.

    Open a terminal shell window, use vi or gedit to edit the .bashrc file and open a new line. Insert the variable definition commands shown below:

    FMW_HOME=/u01/app/oracle/ogg_studio
    export FMW_HOME

1. Open a terminal shell window (or reuse an open shell window.) Make sure you source the .bashrc file. Change directory to your home directory using cd ~ and source .bashrc:

   $ cd ~
   $ . .bashrc

2. Change directory to $FMW_HOME/oracle_common/bin and start rcu.

   $ cd $FMW_HOME/oracle_common/bin
   $ ./rcu

   RCU starts. Click Next to go past the initial welcome screen.

3. In step 2, accept the defaults ("Create Repository" and "System Load and Product Load") and click Next

   

4. In step 3, you must enter the Oracle database connection parameters:

   Database Parameter	Value
   Database Type	Oracle Database
   Host Name	localhost
   Port	1521
   Service Name	ogg12
   Username	sys
   Password	<Password for user SYS>
   Role	SYSDBA

   Click Next to proceed.

   

5. The RCU displays a window which shows the progress while the pre-requisites are checked. Eventually, three green tick signs appear beside the three prerequisites verified by RCU:

   • Initializing repository configuration metadata
   • Obtain properties of the specified database
   • Check requirement for specified database

   Click OK to dismiss the window and proceed to the next step.

   

6. In RCU step 4, accept the default for "Crate new prefix" (DEV) and make sure you select "Oracle GoldenGate" and "Repository" at the bottom of the form. Accept the default for "Schema Owner" (DEV_OGGSTUDIO_REPO) - Click Next to proceed.

   

7. RCU displays another "Checking Prerequisites" window. When the prerequistes have been verified, click OK to dismiss the window and proceed to step 5.

   

8. Step 5 of the installation asks you to define a password for main and auxiliary schema users. Accept the default ("Use same passwords for all schemas") and enter a password twice. Click Next to proceed.

   

9. In step 6, you must set up the password for the Repository Supervisor user. Enter a password for the supervisor and confirm it (enter the same password twice) and accept the default for the Encryption Algorithm (do not enter a value, which defaults to AES-128 bit.) Click Next to proceed.

   

10. In step 7, accept all defaults (tablespace names to be created and assigned to repository schema owners) and click Next to proceed.

    

11. RCU displays a window to allow you to confirm the tablespace creation in Oracle. Click OK to confirm.

    

12. RCU displays a window which tracks the tablespace creation progress. Eventually two green ticks appears beside the tasks to mean that the tablespace requirements were checked and passed validation, and that the tablespace were successfully created. Click OK to dismiss the Creating Tablespaces window and to proceed to step 8.

    

13. Step 8 displays a summary of the options chosen so far. Revise the options, then click Create to proceed with the creation of the tablespaces.

    

14. RCU displays the progress window which shows the repository system load. There are four tasks being performed:

    • Execute pre create operations
    • Common Infrastructure Services
    • Repository
    • Execute post create operations

    Eventually, a green tick appears beside each of the operations, signifying that the operation in question completed successfully.

    

15. When all repository creation operations complete, the progress window disappears and the completion summary window (step 9) is displayed. If you wish, you can display the log file for the entire RCU repository creation session by clicking the rcu.log button. Click Close to dismiss the window.

    

1. Open a terminal shell window (or reuse an open shell window.) Change directory to /u01/app/oracle/ogg_mon/oracle_common/bin and start rcu.

   $ cd /u01/app/oracle/ogg_mon/oracle_common/bin
   $ ./rcu

   RCU starts. Click Next to go past the initial welcome screen.

2. In step 2, accept the defaults ("Create Repository" and "System Load and Product Load") and click Next

   

3. In step 3, you must enter the Oracle database connection parameters:

   Database Parameter	Value
   Database Type	Oracle Database
   Host Name	localhost
   Port	1521
   Service Name	ogg12
   Username	sys
   Password	<Password for user SYS>
   Role	SYSDBA

   Click Next to proceed.

   

4. The RCU displays a window which shows the progress while the pre-requisites are checked. Eventually, three green tick signs appear beside the three prerequisites verified by RCU:

   • Initializing repository configuration metadata
   • Obtain properties of the specified database
   • Check requirement for specified database

   Click OK to dismiss the window and proceed to the next step.

   

5. In RCU step 4, change the default for "Crate new prefix" (DEV1) to "OGG" and make sure you select "Oracle GoldenGate" and "Monitor Server" at the bottom of the form. Accept the default for "Schema Owner" (OGG_OGGMON) - Click Next to proceed.

   

6. RCU displays another "Checking Prerequisites" window. When the prerequistes have been verified, click OK to dismiss the window and proceed to step 5.

   

7. Step 5 of the installation asks you to define a password for main and auxiliary schema users. Accept the default ("Use same passwords for all schemas") and enter a password twice. Click Next to proceed.

   

8. In step 6, accept all defaults for tablespace mapping and click Next to proceed.

   

9. RCU displays a window to allow you to confirm the tablespace creation in Oracle. Click OK to confirm.

   

10. RCU displays a window which tracks the tablespace creation progress. Eventually two green ticks appears beside the tasks to mean that the tablespace requirements were checked and passed validation, and that the tablespace were successfully created. Click OK to dismiss the Creating Tablespaces window and to proceed to step 7.

    

11. Step 7 displays a summary of the options chosen so far. Revise the options, then click Create to proceed with the creation of the tablespaces.

    

12. RCU displays the progress window which shows the repository system load. There are eight tasks being performed:

    • Execute pre create operations
    • Common Infrastructure Services
    • Audit Services Append
    • Audit Services Viewer
    • Audit Services
    • Oracle Platform Security Services
    • Monitor Server
    • Execute post create operations

    Eventually, a green tick appears beside each of the operations, signifying that the operation in question completed successfully.

    

13. When all repository creation operations complete, the progress window disappears and the completion summary window (step 8) is displayed. If you wish, you can display the log file for the entire RCU repository creation session by clicking the rcu.log button. Click Close to dismiss the window and terminate RCU.

    

Test the newly created repository by launching Oracle GoldenGate Studio and connect to it.

1. To launch Oracle GoldenGate Studio, invoke its executable image from the command line:

   $ $FMW_HOME/oggstudio/bin/oggstudio

2. The Oracle GoldenGate Studio splash window appears.

   

3. After a few seconds, OGG Studio asks you if you want to import preferences from a previously installed release of OGG Studio. Click No to continue.

   

4. The splash window resumes and after a few seconds the Oracle GoldenGate Studio main page is displayed. On the left pane you have the "Projects" tab with only one option available, Connect to Repository. The right pane shows the OGG Studio Start Page, with links to tutorials and documentation. Click Connect to Repository.

   

5. OGG Studio displays the "Repository Connection" window. Click the green plus sign (+) to define a new set of connection parameters.

   

6. In the "Repository Connection Information" window you must enter several parameters. The Studio Connection parameter are:

   Studio Connection Parameter	Value
   Login name	MyStudio
   User	SUPERVISOR
   Password	<Password you set using RCU>

   The Database Connection parameters are:

   Database Connection Parameter	Value
   User	DEV_OGGSTUDIO_REPO
   Password	<Password you set using RCU>
   Driver	Oracle JDBC Driver
   Driver Name	oracle.jdbc.OracleDriver
   URL	jdbc:oracle:thin:@localhost:1521:ogg12

   

7. After you entered all parameters click Test to make sure OGG Studio can, in fact, connect to its repository. If an error occurs, check for typos and spelling mistakes, correct them and click Test again until the "Successful Connection" window appears.

   

8. Before proceeding, you want to make the MyStudio connection your default login. Select the "Default Connection" check box, and a "Confirmation" dialog box appears. Click Yes to confirm.

   Click OK on the "Repository Connection Information" window to connect to the repository.

   

9. Since this is your first connection, OGG Studio asks you if you want to create a wallet password to keep both Studio and Repository connection credentials encrypted. Select Store passwords in secure wallet and enter the wallet password twice. The default expiration policy is 180 days. You can either accept the default or change it. In this example the expiration policy is set to 999 days.

   

10. The "Repository Connection" window appears, the MyStudio login name already selected and both user and password automatically filled. Click OK to connect to the repository

    

11. Oracle Goldengate Studio displays its main page, you can now star creating projects and solutions.

    

    Oracle GoldenGate Studio successfully connected to its repository, but in order to be proficiently used, OGG Studio needs the Oracle GoldenGate Monitor server and its agents configured and running. Please consult the OBE Creating and Configuring Oracle GoldenGate 12c Monitor Server and Agents to Work with Oracle GlodenGate Studio 12c to learn how to configure OGG monitor and how to deploy OGG Studio solutions to your replication infrastructure.

    This last step concludes this OBE.