Setup of Oracle Golden Gate for Oracle Database 11G
Setup of Oracle Golden Gate for Oracle Database 11G
$ mkdir OGG_HOME
[oracle@oracleTestServer ~]$ cd /backup/OGG_HOME/
[oracle@oracleTestServer OGG_HOME]$ pwd
/backup/OGG_HOME
[oracle@oracleTestServer OGG_HOME]$ ls
fbo_ggs_Linux_x64_shiphome.zip
[oracle@oracleTestServer OGG_HOME]$ unzip fbo_ggs_Linux_x64_shiphome.zip
[oracle@oracleTestServer OGG_HOME]$ ls
fbo_ggs_Linux_x64_shiphome OGG-12.2.0.1.1-ReleaseNotes.pdf
fbo_ggs_Linux_x64_shiphome.zip OGG-12.2.0.1-README.txt
[oracle@oracleTestServer OGG_HOME]$ cd fbo_ggs_Linux_x64_shiphome/Disk1/
[oracle@oracleTestServer Disk1]$ ls
install response runInstaller stage
[oracle@oracleTestServer Disk1]$ ./runInstaller
(Select the Oracle Goldengate for Oracle Database 11g & Fallow the Instruction)
Note:
Install this OGG into the New Location
[oracle@oracleTestServer 11.2.0]$ pwd
/u01/app/oracle/product/11.2.0
[oracle@oracleTestServer 11.2.0]$ mkdir ogg_home
(After completion of the Installation, You can view the below OGG Files)
[oracle@oracleTestServer 11.2.0]$ cd ogg_home/
[oracle@oracleTestServer ogg_home]$ ls
bcpfmt.tpl ddl_trace_on.sql freeBSD.txt marker_setup.sql
bcrypt.txt defgen ggcmd marker_status.sql
cachefiledump deinstall ggMessage.dat mgr
cfgtoollogs demo_more_ora_create.sql ggparam.dat notices.txt
checkprm demo_more_ora_insert.sql ggsci oggerr
chkpt_ora_create.sql demo_ora_create.sql ggserr.log OPatch
convchk demo_ora_insert.sql help.txt oraInst.loc
convprm demo_ora_lob_create.sql install oui
db2cntl.tpl demo_ora_misc.sql inventory params.sql
ddl_cleartrace.sql demo_ora_pk_befores_create.sql jdk prvtclkm.plb
ddl_create.sql demo_ora_pk_befores_insert.sql keygen prvtlmpg.plb
ddl_ddl2file.sql demo_ora_pk_befores_updates.sql label.sql prvtlmpg_uninstall.sql
ddl_disable.sql diagnostics libantlr3c.so remove_seq.sql
ddl_enable.sql dirbdb libdb-6.1.so replicat
ddl_filter.sql dirchk libgglog.so retrace
ddl_ora10.sql dircrd libggnnzitp.so reverse
ddl_ora10upCommon.sql dirdat libggparam.so role_setup.sql
ddl_ora11.sql dirdef libggperf.so sequence.sql
ddl_ora9.sql dirdmp libggrepo.so server
ddl_pin.sql dirout libicudata.so.48 sqlldr.tpl
ddl_remove.sql dirpcs libicudata.so.48.1 srvm
ddl_session1.sql dirprm libicui18n.so.48 tcperrs
ddl_session.sql dirrpt libicui18n.so.48.1 ucharset.h
ddl_setup.sql dirsql libicuuc.so.48 ulg.sql
ddl_status.sql dirtmp libicuuc.so.48.1 UserExitExamples
ddl_staymetadata_off.sql dirwlt libxerces-c.so.28 usrdecs.h
ddl_staymetadata_on.sql dirwww libxml2.txt zlib.txt
ddl_tracelevel.sql emsclnt logdump
ddl_trace_off.sql extract marker_remove.sql
Now Verify the GGSCI
[oracle@oracleTestServer ogg_home]$ ./ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Dec 12 2015 00:54:38
Operating system character set identified as UTF-8.
Copyright (C) 1995, 2015, Oracle and/or its affiliates. All rights reserved.
GGSCI (oracleTestServer.psp.local) 1> create subdirs
Creating subdirectories under current directory /u01/app/oracle/product/11.2.0/ogg_home
Parameter files /u01/app/oracle/product/11.2.0/ogg_home/dirprm: already exists
Report files /u01/app/oracle/product/11.2.0/ogg_home/dirrpt: already exists
Checkpoint files /u01/app/oracle/product/11.2.0/ogg_home/dirchk: already exists
Process status files /u01/app/oracle/product/11.2.0/ogg_home/dirpcs: already exists
SQL script files /u01/app/oracle/product/11.2.0/ogg_home/dirsql: already exists
Database definitions files /u01/app/oracle/product/11.2.0/ogg_home/dirdef: already exists
Extract data files /u01/app/oracle/product/11.2.0/ogg_home/dirdat: already exists
Temporary files /u01/app/oracle/product/11.2.0/ogg_home/dirtmp: already exists
Credential store files /u01/app/oracle/product/11.2.0/ogg_home/dircrd: already exists
Masterkey wallet files /u01/app/oracle/product/11.2.0/ogg_home/dirwlt: already exists
Dump files /u01/app/oracle/product/11.2.0/ogg_home/dirdmp: already exists
GGSCI (oracleTestServer.psp.local) 2> show all;
Parameter settings:
SET SUBDIRS ON
SET DEBUG OFF
Current directory: /u01/app/oracle/product/11.2.0/ogg_home
Using subdirectories for all process files
Editor: vi
Reports (.rpt) /u01/app/oracle/product/11.2.0/ogg_home/dirrpt
Parameters (.prm) /u01/app/oracle/product/11.2.0/ogg_home/dirprm
Replicat Checkpoints (.cpr) /u01/app/oracle/product/11.2.0/ogg_home/dirchk
Extract Checkpoints (.cpe) /u01/app/oracle/product/11.2.0/ogg_home/dirchk
Process Status (.pcs) /u01/app/oracle/product/11.2.0/ogg_home/dirpcs
SQL Scripts (.sql) /u01/app/oracle/product/11.2.0/ogg_home/dirsql
Database Definitions (.def) /u01/app/oracle/product/11.2.0/ogg_home/dirdef
Dump files (.dmp) /u01/app/oracle/product/11.2.0/ogg_home/dirdmp
Masterkey wallet files (.wlt) /u01/app/oracle/product/11.2.0/ogg_home/dirwlt
Credential store files (.crd) /u01/app/oracle/product/11.2.0/ogg_home/dircrd
GGSCI (oracleTestServer.psp.local) 3> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING ---- Default the Manager Port is assign as 7809 & it will be in running state
[oracle@oracleTestServer ogg_home]$ exit
Logout
[oracle@oracleTestServer ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Sat Jun 17 15:37:19 2017
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> SELECT log_mode FROM v$database;
LOG_MODE
------------
ARCHIVELOG
SQL> SELECT force_logging, supplemental_log_data_min FROM v$database;
FOR SUPPLEME
--- --------
YES IMPLICIT
SQL> ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
Database altered.
SQL> ALTER SYSTEM SWITCH LOGFILE;
System altered.
SQL> SELECT force_logging, f_min FROM v$database;
FOR SUPPLEME
--- --------
YES YES
SQL> alter system set ENABLE_GOLDENGATE_REPLICATION=true scope=both;
System altered.
SQL> CREATE USER ogguser IDENTIFIED BY ogguser;
User created.
SQL> GRANT CONNECT, RESOURCE, UNLIMITED TABLESPACE TO ogguser;
Grant succeeded.
SQL> GRANT dba TO ogguser;
Grant succeeded.
SQL> create tablespace goldengate datafile '/u01/app/oracle/oradata/prim/goldengate.dbf' size 100m;
Tablespace created.
SQL> alter database datafile '/u01/app/oracle/oradata/prim/goldengate.dbf' autoextend on;
Database altered.
SQL> alter user ogguser default tablespace goldengate;
User altered.
Test the user created:
SQL> select username,default_tablespace from dba_users where username='OGGUSER';
USERNAME DEFAULT_TABLESPACE
------------------------------ ------------------------------
OGGUSER GOLDENGATE
SQL> connect ogguser/ogguser
Connected.
Create the sample table * insert some record init
SQL> create table ggtest(eno number(10));
Table created.
SQL> insert into ggtest values(&eno);
Enter value for eno: 1
SQL> commit;
Commit complete.
SQL> select * from ggtest;
ENO
----------
1
2
3
4
5
[oracle@oracleTestServer ogg_home]$ ./ggsci
GGSCI (oracleTestServer.psp.local) 1> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
GGSCI (oracleTestServer.psp.local) 2> edit param ./global
GGSCHEMA ogguser
[oracle@oracleTestServer ogg_home]$ !sq
SQL> @role_setup.sql;
GGS Role setup script
This script will drop and recreate the role GGS_GGSUSER_ROLE
To use a different role name, quit this script and then edit the params.sql script to change the gg_role parameter to the preferred name. (Do not run the script.)
You will be prompted for the name of a schema for the GoldenGate database objects.
NOTE: The schema must be created prior to running this script.
NOTE: Stop all DDL replication before starting this installation.
Enter GoldenGate schema name:ogguser
Wrote file role_setup_set.txt
PL/SQL procedure successfully completed.
Role setup script complete
Grant this role to each user assigned to the Extract, GGSCI, and Manager processes, by using the following SQL command:
GRANT GGS_GGSUSER_ROLE TO <loggedUser>
where <loggedUser> is the user assigned to the GoldenGate processes.
SQL> grant GGS_GGSUSER_ROLE TO OGGUSER;
Grant succeeded.
GGSCI (oracleTestServer.psp.local) 3> view param mgr
PORT 7809
GGSCI (oracleTestServer.psp.local) 5> view param ./global
GGSCHEMA ogguser
GGSCI (oracleTestServer.psp.local) 9> add extract extract,tranlog begin now
EXTRACT added.
GGSCI (oracleTestServer.psp.local) 10> add exttrail ./dirdat/ex,extract extract
EXTTRAIL added.
Login to the user created
GGSCI (oracledbtest.local) 4> dblogin userid ogguser, password ogguser
Successfully logged into database
-----------------------------------------------Hence the Setup is done ---------------------------------
If any clarification, Please revert me back 24/7 - E-mail : sayeed202@gmail.com
Comments
Post a Comment