GoldenGate 12.1.2.0 Install/Upgrade on OEL 6.4 x86-64

It was about time that I started working with the new release. I’ve had to upgrade my current 11g install, and since I’m on a documentation high these days, I put something together to help anyone else who wants to go through the install.

My current install is OGG 11.2.1.0.13 on Linux 64bit running against an 11.2.0.3 databases.

Vamanos!

Installation

1. Make a copy of your existing GoldenGate install folder after stopping all processes.
[oracle@blue gg12c]$ ls -lhtr
total 578M
-rwxrwx--- 1 root vboxsf 326M Dec 5 15:03 121200_fbo_ggs_Linux_x64_shiphome.zip
-rwxrwx--- 1 root vboxsf 253M Dec 5 18:13 ggate.1121013.tgz
[oracle@blue gg12c]$ unzip 121200_fbo_ggs_Linux_x64_shiphome.zip
[oracle@blue gg12c]$ ls -lhtr
total 579M
drwxrwx--- 1 root vboxsf 102 Sep 25 05:59 fbo_ggs_Linux_x64_shiphome
-rwxrwx--- 1 root vboxsf 276K Oct 6 18:04 OGG_WinUnix_Rel_Notes_12.1.2.0.0.pdf
-rwxrwx--- 1 root vboxsf 92K Oct 6 18:04 Oracle-GoldenGate-12.1.2.0-README.doc
-rwxrwx--- 1 root vboxsf 141K Oct 6 18:04 OGG_WinUnix_Rel_Notes_12.1.2.0.0.doc
-rwxrwx--- 1 root vboxsf 23K Oct 6 18:04 Oracle-GoldenGate-12.1.2.0-README.txt
-rwxrwx--- 1 root vboxsf 326M Dec 5 15:03 121200_fbo_ggs_Linux_x64_shiphome.zip
-rwxrwx--- 1 root vboxsf 253M Dec 5 18:13 ggate.1121013.tgz
[oracle@blue gg12c]$ cd fbo_ggs_Linux_x64_shiphome/
[oracle@blue fbo_ggs_Linux_x64_shiphome]$ ls -lhtr
total 0
drwxrwx--- 1 root vboxsf 204 Sep 25 05:59 Disk1
[oracle@blue fbo_ggs_Linux_x64_shiphome]$ cd Disk1/
[oracle@blue Disk1]$ ls -lhtr
total 4.0K
drwxrwx--- 1 root vboxsf 374 Sep 25 05:59 install
drwxrwx--- 1 root vboxsf 714 Sep 25 05:59 stage
-rwxrwx--- 1 root vboxsf 918 Sep 25 05:59 runInstaller
drwxrwx--- 1 root vboxsf 102 Sep 25 05:59 response
2. Invoke the installer, and lets get started!
[oracle@blue Disk1]$ ./runInstaller 
Starting Oracle Universal Installer...

Checking Temp space: must be greater than 120 MB. Actual 74181 MB Passed
Checking swap space: must be greater than 150 MB. Actual 8015 MB Passed
Checking monitor: must be configured to display at least 256 colors. Actual 16777216 Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2013-12-05_06-14-19PM. Please wait ...
To start, I’ll only install the GoldenGate with DB11g since thats the only instance I have installed on this server at the moment.

NewImage

3. Pick your installation directories. I’ve entered the same location for the software install as my existing GG11g directory to perform an upgrade.

NewImage

4. Click “yes” on this prompt. I think I know what I am doing!

NewImage

5. Review changes and click “Install”.

NewImage

6. Progress is good! If you are prompted whether the directory is not empty, simply select “yes” and proceed.

NewImage

7. Awesome!

NewImage

Upgrade

8. Review the installation, and validate the binaries startup successfully.
[oracle@blue]$ pwd
/u01/app/ggate
[oracle@blue ggate]$ ./ggsci

Oracle GoldenGate Command Interpreter for Oracle
Version 12.1.2.0.0 17185003 OGGCORE_12.1.2.0.0_PLATFORMS_130924.1316_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Sep 25 2013 00:31:13
Operating system character set identified as UTF-8.

Copyright (C) 1995, 2013, Oracle and/or its affiliates. All rights reserved.

GGSCI (blue.color) 1> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING
EXTRACT STOPPED E_GG 00:00:00 00:37:10
REPLICAT STOPPED R_GG 00:00:00 00:37:10
9. Upgrade the Checkpointtable. This needs to be done on both source and target databases!
GGSCI (blue.color) 2> dblogin userid ggate, password ggate
Successfully logged into database.

GGSCI (blue.color) 5> upgrade checkpointtable

No checkpoint table specified. Using GLOBALS specification (ggate.checkpoint)...

Successfully upgraded checkpoint table ggate.checkpoint.
10. Start the Extract
GGSCI (blue.color) 2> start e_gg

Sending START request to MANAGER ...
EXTRACT E_GG starting

GGSCI (blue.color) 3> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING
EXTRACT ABENDED E_GG 00:00:00 00:38:40
REPLICAT STOPPED R_GG 00:00:00 00:38:40

11. Interesting, did I miss something? What does the report file say?

2013-12-05 21:40:13  ERROR   OGG-01416  File ./dirdat/lt000005, with format RELEASE 11.2, does not match current format specification of RELEASE 12.1. Modify the parameter file to specify format RELEASE 11.2 or issue ETROLLOVER prior to restart.
12. Ok, my mistake 🙂
Modify the parameter file to specify format RELEASE 11.2 or issue ETROLLOVER prior to restart.
12.1. Option #1: Let’s make the correct parameter change and try again. Add the following to the EXTTRAIL ./dirdat/lt in the extracts parameter file.
EXTTRAIL ./dirdat/lt, FORMAT RELEASE 11.2
12.2. Option #2: Start a new trail sequence by issuing a roll-over command.
GGSCI> alter extract e_gg etrollover

12.2.1. Starting it again!

GGSCI (blue.color) 6> start e_gg

Sending START request to MANAGER ...
EXTRACT E_GG starting

GGSCI (blue.color) 7> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING
EXTRACT RUNNING E_GG 00:00:00 00:00:04
REPLICAT STOPPED R_GG 00:00:00 00:54:46
12.3. Great, now we can make the same change to the replicat’s parameter file and start it.
GGSCI (blue.color) 13> start r_gg

Sending START request to MANAGER ...
REPLICAT R_GG starting

GGSCI (blue.color) 14> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING
EXTRACT RUNNING E_GG 00:00:00 00:00:04
REPLICAT RUNNING R_GG 00:00:00 00:00:01
13. Excellent!! Now we are done with the installation of 12c and upgrade of 11g to 12c!
Hopefully this has been educational for you. I hope to dive further into some of the new features in 12c.

Cheers!

Advertisements

2 comments

  1. Hello Maas,

    Thanks for this post, it is very simple and easy to understand. Could you also share, some of the new features of v12 that you might be using. My database is 11.2.0.3.9 and at this point we are using goldengate v11.2.1.0.1.

    Thanks,
    Kumar.

  2. Jamsher · · Reply

    Hello Maas,

    Thanks for sharing this post. Can you please share new OGG 12C features you are using in your environment.

    Best Regards
    Jamsher

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Musings

Things I see and learn!

Thoughts from James H. Lui

If you Care a Little More, Things Happen. Bees can be dangerous. Always wear protective clothing when approaching or dealing with bees. Do not approach or handle bees without proper instruction and training.

bdt's oracle blog

Sharing experience (by Bertrand Drouvot)

Frits Hoogland Weblog

IT Technology; Oracle, linux, TCP/IP and other stuff I find interesting

Vishal desai's Oracle Blog

Just another WordPress.com weblog

%d bloggers like this: