GoldenGate 12c: Installation for Oracle DB

Oracle Goldengate is undoubtedly one of best replication solution for oracle to oracle as other supported databases with ease to configuration and manageability. Today we will explore installation of Oracle Golden Gate 12c for Oracle 11g database from OUI. We need to install software on both source and target servers.

Environment details

OEL 5.x x86-64 for source and target machines

Oracle 11.2.0.4.9 databases for source and target

GolgenGate binary 12.1.2.1.0

Software Download

  1. Go to Url https://edelivery.oracle.com
  2. login using your id and accept license agreements
  3. Select a Product Pack – Oracle Fusion Middleware
  4. Platform – Linux x86-64
  5. Click on GO
  6. Choose “Oracle GoldenGate on Oracle v12.1.2.1 Media Pack for Linux x86-64
  7. Click Continue
  8. Click on Download

Installation user for installation

Read more of this post

Advertisements

Step by Step Installation of OEM 12c

Few important things to be consider before going for OEM 12c on your environment. First EM 12c is more resource demanding as compared to 10g & 11g versions. Second It’s re-engineered for better monitoring and administration capabilities and not compatible with older versions of agents, so the day you rolling 12c in your environment, you have to install 12c agent on all targets.

Package Requirements for Oracle Management Service

In our case we are setting up EM 12C on Oracle Linux 5.x 64 bit

binutils-2.17.50.0.6

gcc -4.1.1

glibc-common-2.3.4

glibc-devel-2.5-49 (32-bit version as well as the 64-bit version)

libaio-0.3.106

libstdc++ -4.1.1

libXtst-1.0.1-3.1(x86_64)

make-3.81

rng-utils-2.0

setarch-1.6

sysstat-5.0.5

xorg-x11-utils     (This package is required only for GUI-based interactive installation, and not for silent installation)

Read more of this post

Step By Step Installation of 11.2.0.3.0 Standalone RDBMS Software

Going forward with 11gR2 oracle recommending out of place upgrade so providing full installer for major upgrades (i.e. 11.2.0.1.0 , 11.2.0.2.0, 11.2.0.3.0) instead of patchsets. Then we can apply bundle patch or custom patches based on our requirement.

For 11.2.0.3.0, software is available on MOS with patch number 10404530 and could be easily downloadable. This patch contains total 7 files but we need only p10404530_112030_platform_1of7.zip & p10404530_112030_platform_2of7.zip (2.32 GB) to install DB software. This patch is actually full release and could be used for upgrade as well as new installation.

Prerequisite RPMs

binutils-2.17.50.0.6

compat-libstdc++-33-3.2.3

elfutils-libelf-0.125

elfutils-libelf-devel-0.125

elfutils-libelf-devel-static-0.125

gcc-4.1.2

gcc-c++-4.1.2

glibc-2.5-24

glibc-common-2.5

glibc-devel-2.5

glibc-headers-2.5

kernel-headers-2.6.18

ksh-20060214

libaio-0.3.106

libaio-devel-0.3.106

libgcc-4.1.2

libgomp-4.1.2

libstdc++-4.1.2

libstdc++-devel-4.1.2

make-3.81

numactl-devel-0.9.8.i386

sysstat-7.0.2

unixODBC-devel-2.2.11-7.1.i386.rpm

unixODBC-2.2.11-7.1.i386.rpm

Note: 64 bit installation also searches for i386 unixodbc rpms.

Read more of this post

Pierre blog

Pierre Forstmann Oracle Database blog

flashdba

Oracle databases, storage and the high-performance world of flash memory

Future Veterans

Ramblings about Oracle

Ranjeet Srivastava

Smile! You’re at the best blog ever

Kevin Closson's Blog: Platforms, Databases and Storage

Platform, Database and Storage Topics

Real Life Database / SQL Experiences : An Oracle Blog from Vivek Sharma

Being an Oracle Professional, I like to share all my Real Life Performance Tuning Challenges and Experiences. The Content and Views on this site are my own and not necessarily those of Oracle. While, I write on my real life experiences, the resolutions mentioned are solely mine. Comments / Criticisms are always a welcome.

Frits Hoogland Weblog

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

OraStory

Dominic Brooks on Oracle Performance, Tuning, Data Quality & Sensible Design ... (Now with added Sets Appeal)

ASM Support Guy

Just Another Crazy Oracle DBA

Exadata Certification

Just Another Crazy Oracle DBA

Carlos Sierra's Tools and Tips

Tools and Tips for Oracle Performance and SQL Tuning

Sangram keshari's Oracle Blog

The Fusion Middleware Administration & Database Administration Blog

Amit Saraswat

Just Another Crazy Oracle DBA

Oracle Scratchpad

Just another Oracle weblog

The Tom Kyte Blog

Just Another Crazy Oracle DBA

Hemant's Oracle DBA Blog

Just Another Crazy Oracle DBA

Uwe Hesse

about Database Technology

Richard Foote's Oracle Blog

Focusing Specifically On Oracle Indexes, Database Administration and Some Great Music