$ oslevel -g
Fileset Actual
Level Maintenance Level
-----------------------------------------------------------------------------
bos.rte 5.3.11.0 5.3.0.0
1. Download GG Media from http://www.oracle.com/technetwork/middleware/goldengate/downloads/index.html
Accept the
License Agreement and download following file
2. Create Installation Directory
$ mkdir -p /u40/oracle/ggs
3. FTP GG Media to above folder with filezilla
or any other ftp software
$
cd /u40/oracle/ggs
$
ls -tlr
total
97592
-rw-r----- 1 oracle
oinstall 49963147 Sep 10 10:46 ogg112101_ggs_AIX_ppc_ora11g_64bit.zip
4. Unzip the media
$ unzip
ogg112101_ggs_AIX_ppc_ora11g_64bit.zip
5. Untar the tar file
$ tar -xvof ggs_AIX_ppc_ora11g_64bit.tar
6. Add installation directory and database
library path to environment. Better to add in profile.
export
PATH=$PATH:/u40/oracle/ggs
export
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/u40/oracle/ggs
7. Make sure Oracle Home and SID are set as GG
owner will connect to this database by default.
$
echo $ORACLE_SID
PRODM
$
echo $ORACLE_HOME
/u40/oracle/PRODM/db/tech_st/11.2.0.3
8. Start the GG Command Interpreter
pwd
/u40/oracle/ggs
$
./ggsci
Oracle
GoldenGate Command Interpreter for Oracle
Version
11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230
AIX
5L, ppc, 64bit (optimized), Oracle 11g on Apr 23 2012 05:03:51
Copyright
(C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.
9. GGSCI (nmcretek02) 1>CREATE SUBDIRS
Creating
subdirectories under current directory /u40/oracle/ggs
Parameter
files
/u40/oracle/ggs/dirprm: already exists
Report
files
/u40/oracle/ggs/dirrpt: created
Checkpoint
files
/u40/oracle/ggs/dirchk: created
Process
status files
/u40/oracle/ggs/dirpcs: created
SQL
script files
/u40/oracle/ggs/dirsql: created
Database
definitions files
/u40/oracle/ggs/dirdef: created
Extract
data files
/u40/oracle/ggs/dirdat: created
Temporary
files
/u40/oracle/ggs/dirtmp: created
Stdout
files
/u40/oracle/ggs/dirout: created
10. GGSCI (nmcretek02) 2> exit
11.
Now we
have to create the GG Admin or owner user and its default tablespace
$
sqlplus / as sysdba
select
instance_name from v$instance;
select
NAME from v$datafile;
create
tablespace ggs_data datafile '/u40/oracle/PRODM/db/apps_st/data/ggs_data01.dbf'
size 200M;
create
user ggs_owner identified by ggs_owner
default tablespace ggs_data temporary tablespace temp;
grant
connect,resource to ggs_owner;
grant
select any dictionary, select any table to ggs_owner;
grant
create table to ggs_owner;
grant
flashback any table to ggs_owner;
grant
execute on dbms_flashback to ggs_owner;
grant
execute on utl_file to ggs_owner;
12. To confirm that the GoldenGate user we created
is able to connect to the Oracle database
$
ggsci
>
DBLOGIN USERID ggs_owner, PASSWORD ggs_owner
>
exit
13. Enable supplemental logging at the database
level otherwise we will get this error when we try to start the Extract process
sqlplus
/ as sysdba
ALTER
DATABASE ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
14. Please go through following documentation for more details
Oracle® GoldenGate
Oracle
Installation and Setup Guide 11g Release
2 (11.2.1.0.0)
E27278-01
Oracle® GoldenGate
Windows
and UNIX Administrator’s Guide 11g Release
2 (11.2.1.0.0)
E27273-01
No comments:
Post a Comment