[oracle@racj1 12c]$ cd ../..
[oracle@racj1 /]$ ls
bak boot etc lib lost+found mnt opt proc sbin srv tmp usr
bin dev home lib64 media ogg oracle root selinux sys UltraPath var
[oracle@racj1 /]$ cd /ogg
[oracle@racj1 ogg]$ ls
12c lost+found OGG-12.2.0.1-README.txt README_ora11g.txt
28187520 ogg12.2.0.1.1_Linux_x64_shiphome.zip OGGCORE_12.2.0.1.170919_BLR27731916.pdf
fbo_ggs_Linux_x64_shiphome OGG-12.2.0.1.1-ReleaseNotes.pdf p28187520_12201170919_Linux-x86-64.zip
[oracle@racj1 ogg]$ cd fbo_ggs_Linux_x64_shiphome/
[oracle@racj1 fbo_ggs_Linux_x64_shiphome]$ ls
Disk1
[oracle@racj1 fbo_ggs_Linux_x64_shiphome]$ cd Disk1/
[oracle@racj1 Disk1]$ ls
install response runInstaller stage
[oracle@racj1 Disk1]$ cd response/
[oracle@racj1 response]$ cat
oggcore.rsp
####################################################################
## Copyright(c) Oracle Corporation 2014. All rights
reserved. ##
## ##
## Specify values for the variables listed below to
customize ##
## your installation. ##
## ##
## Each variable is associated with a comment. The
comment ##
## can help to populate the variables with the
appropriate ##
## values. ##
## ##
## IMPORTANT NOTE: This file should be secured to have
read ##
## permission only by the oracle user or an administrator
who ##
## own this installation to protect any sensitive input
values. ##
## ##
####################################################################
#-------------------------------------------------------------------------------
# Do not change the following system generated
value.
#-------------------------------------------------------------------------------
oracle.install.responseFileVersion=/oracle/install/rspfmt_ogginstall_response_schema_v12_1_2
################################################################################
## ##
## Oracle GoldenGate installation option and
details ##
## ##
################################################################################
#-------------------------------------------------------------------------------
# Specify the installation option.
# Specify ORA12c for installing Oracle GoldenGate for Oracle
Database 12c and
# ORA11g for installing Oracle
GoldenGate for Oracle Database 11g
#-------------------------------------------------------------------------------
INSTALL_OPTION=ORA11g
#-------------------------------------------------------------------------------
# Specify a location to install Oracle GoldenGate
#-------------------------------------------------------------------------------
SOFTWARE_LOCATION=/ogg/12c
#-------------------------------------------------------------------------------
# Specify true to start the manager after
installation.
#-------------------------------------------------------------------------------
START_MANAGER=false
#-------------------------------------------------------------------------------
# Specify a free port within the valid range for the manager
process.
# Required only if START_MANAGER is true.
#-------------------------------------------------------------------------------
MANAGER_PORT=7809
#-------------------------------------------------------------------------------
# Specify the location of the Oracle Database.
# Required only if START_MANAGER is true.
#-------------------------------------------------------------------------------
DATABASE_LOCATION=
################################################################################
## ##
## Specify details to Create inventory for Oracle
installs ##
## Required only for the first Oracle product install on a
system. ##
## ##
################################################################################
#-------------------------------------------------------------------------------
# Specify the location which holds the install inventory
files.
# This is an optional parameter if installing on
# Windows based Operating System.
#-------------------------------------------------------------------------------
INVENTORY_LOCATION=
#-------------------------------------------------------------------------------
# Unix group to be set for the inventory
directory.
# This parameter is not applicable if installing on
# Windows based Operating System.
#-------------------------------------------------------------------------------
UNIX_GROUP_NAME=
[oracle@racj1 response]$
[oracle@racj1 response]$ pwd
/ogg/fbo_ggs_Linux_x64_shiphome/Disk1/response
[oracle@racj1 response]$ pwd
/ogg/fbo_ggs_Linux_x64_shiphome/Disk1/response
[oracle@racj1 response]$ cd ../
[oracle@racj1 Disk1]$ ls
install response runInstaller stage
[oracle@racj1 Disk1]$ ./runInstaller
-silent -responseFile
/ogg/fbo_ggs_Linux_x64_shiphome/Disk1/response/oggcore.rsp
Starting Oracle Universal Installer...
Checking Temp space: must be greater than 120
MB. Actual 7302
MB Passed
Checking swap space: must be greater than 150
MB. Actual 16415
MB Passed
Preparing to launch Oracle Universal Installer from
/tmp/OraInstall2018-09-13_06-12-36PM. Please wait ...[oracle@racj1
Disk1]$ You can find the log of this install session at:
/oracle/app/oraInventory/logs/installActions2018-09-13_06-12-36PM.log
[oracle@racj1 Disk1]$ The installation of Oracle GoldenGate
Core was successful.
Please check
'/oracle/app/oraInventory/logs/silentInstall2018-09-13_06-12-36PM.log'
for more details.
Successfully Setup Software.
[oracle@racj1 Disk1]$ more
/oracle/app/oraInventory/logs/silentInstall2018-09-13_06-12-36PM.log
silentInstall2018-09-13_06-12-36PM.log
The installation of Oracle GoldenGate Core was
successful.
[oracle@racj1 Disk1]$ pwd
/ogg/fbo_ggs_Linux_x64_shiphome/Disk1
[oracle@racj1 Disk1]$ cd /ogg/12c
[oracle@racj1 12c]$ ./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 (racj1) 1> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER STOPPED
GGSCI (racj1) 2> create subdirs
Creating subdirectories under current directory /ogg/12c
Parameter files /ogg/12c/dirprm: created
Report files /ogg/12c/dirrpt: created
Checkpoint files /ogg/12c/dirchk: created
Process status files /ogg/12c/dirpcs: created
SQL script files /ogg/12c/dirsql: created
Database definitions files /ogg/12c/dirdef: created
Extract data files /ogg/12c/dirdat: created
Temporary files /ogg/12c/dirtmp: created
Credential store files /ogg/12c/dircrd: created
Masterkey wallet files /ogg/12c/dirwlt: created
Dump files /ogg/12c/dirdmp: created
GGSCI (racj1) 3> exit
[oracle@racj1 12c]$ pwd
/ogg/12c
[oracle@racj1 12c]$ ls
bcpfmt.tpl ddl_setup.sql dirdmp libantlr3c.so oraInst.loc
bcrypt.txt ddl_status.sql dirout libdb-6.1.so oui
cachefiledump ddl_staymetadata_off.sql dirpcs libgglog.so params.sql
cfgtoollogs ddl_staymetadata_on.sql dirprm libggnnzitp.so prvtclkm.plb
checkprm ddl_tracelevel.sql dirrpt libggparam.so prvtlmpg.plb
chkpt_ora_create.sql ddl_trace_off.sql dirsql libggperf.so prvtlmpg_uninstall.sql
convchk ddl_trace_on.sql dirtmp libggrepo.so remove_seq.sql
convprm defgen dirwlt libicudata.so.48 replicat
db2cntl.tpl deinstall dirwww libicudata.so.48.1 retrace
ddl_cleartrace.sql demo_more_ora_create.sql emsclnt libicui18n.so.48 reverse
ddl_create.sql demo_more_ora_insert.sql extract libicui18n.so.48.1 role_setup.sql
ddl_ddl2file.sql demo_ora_create.sql freeBSD.txt libicuuc.so.48 sequence.sql
ddl_disable.sql demo_ora_insert.sql ggcmd libicuuc.so.48.1 server
ddl_enable.sql demo_ora_lob_create.sql ggMessage.dat libxerces-c.so.28 sqlldr.tpl
ddl_filter.sql demo_ora_misc.sql ggparam.dat libxml2.txt srvm
ddl_ora10.sql demo_ora_pk_befores_create.sql ggsci logdump tcperrs
ddl_ora10upCommon.sql demo_ora_pk_befores_insert.sql ggserr.log marker_remove.sql ucharset.h
ddl_ora11.sql demo_ora_pk_befores_updates.sql help.txt marker_setup.sql ulg.sql
ddl_ora9.sql diagnostics install marker_status.sql UserExitExamples
ddl_pin.sql dirchk inventory mgr usrdecs.h
ddl_remove.sql dircrd jdk notices.txt zlib.txt
ddl_session1.sql dirdat keygen oggerr
ddl_session.sql dirdef label.sql OPatch
[oracle@racj1 12c]$ cd ..
[oracle@racj1 ogg]$ ls
12c ogg12.2.0.1.1_Linux_x64_shiphome.zip p28187520_12201170919_Linux-x86-64.zip
fbo_ggs_Linux_x64_shiphome OGG-12.2.0.1.1-ReleaseNotes.pdf
lost+found OGG-12.2.0.1-README.txt
[oracle@racj1 ogg]$ unzip
p28187520_12201170919_Linux-x86-64.zip
Archive: p28187520_12201170919_Linux-x86-64.zip
creating: 28187520/
creating:
28187520/etc/
creating:
28187520/etc/config/
inflating:
28187520/etc/config/actions.xml
inflating:
28187520/etc/config/inventory.xml
creating:
28187520/files/
inflating:
28187520/files/bcpfmt.tpl
inflating:
28187520/files/bcrypt.txt
inflating:
28187520/files/cachefiledump
inflating:
28187520/files/checkprm
inflating:
28187520/files/chkpt_ora_create.sql
inflating:
28187520/files/convchk
inflating:
28187520/files/convprm
inflating:
28187520/files/db2cntl.tpl
inflating:
28187520/files/ddl_cleartrace.sql
inflating:
28187520/files/ddl_create.sql
inflating:
28187520/files/ddl_ddl2file.sql
inflating:
28187520/files/ddl_disable.sql
inflating:
28187520/files/ddl_enable.sql
inflating:
28187520/files/ddl_filter.sql
inflating:
28187520/files/ddl_ora10.sql
inflating:
28187520/files/ddl_ora10upCommon.sql
inflating:
28187520/files/ddl_ora11.sql
inflating:
28187520/files/ddl_ora9.sql
inflating:
28187520/files/ddl_pin.sql
inflating:
28187520/files/ddl_remove.sql
inflating:
28187520/files/ddl_session.sql
inflating:
28187520/files/ddl_session1.sql
inflating:
28187520/files/ddl_setup.sql
inflating:
28187520/files/ddl_status.sql
inflating:
28187520/files/ddl_staymetadata_off.sql
inflating:
28187520/files/ddl_staymetadata_on.sql
inflating:
28187520/files/ddl_tracelevel.sql
inflating:
28187520/files/ddl_trace_off.sql
inflating:
28187520/files/ddl_trace_on.sql
inflating:
28187520/files/defgen
inflating:
28187520/files/demo_more_ora_create.sql
inflating:
28187520/files/demo_more_ora_insert.sql
inflating:
28187520/files/demo_ora_create.sql
inflating:
28187520/files/demo_ora_insert.sql
inflating:
28187520/files/demo_ora_lob_create.sql
inflating:
28187520/files/demo_ora_misc.sql
inflating:
28187520/files/demo_ora_pk_befores_create.sql
inflating:
28187520/files/demo_ora_pk_befores_insert.sql
inflating:
28187520/files/demo_ora_pk_befores_updates.sql
creating:
28187520/files/dirout/
extracting:
28187520/files/dirout/README.txt
creating:
28187520/files/dirwww/
creating:
28187520/files/dirwww/image/
extracting:
28187520/files/dirwww/image/status_1.gif
extracting:
28187520/files/dirwww/image/status_10.gif
extracting:
28187520/files/dirwww/image/status_2.gif
extracting:
28187520/files/dirwww/image/status_3.gif
extracting:
28187520/files/dirwww/image/status_4.gif
extracting:
28187520/files/dirwww/image/status_5.gif
extracting:
28187520/files/dirwww/image/status_6.gif
extracting:
28187520/files/dirwww/image/status_7.gif
extracting:
28187520/files/dirwww/image/status_8.gif
extracting:
28187520/files/dirwww/image/status_9.gif
creating:
28187520/files/dirwww/schema/
inflating:
28187520/files/dirwww/schema/enums.xsd
inflating:
28187520/files/dirwww/schema/file.xsd
inflating:
28187520/files/dirwww/schema/files.xsd
inflating:
28187520/files/dirwww/schema/group-profiles.xsd
inflating:
28187520/files/dirwww/schema/group.xsd
inflating:
28187520/files/dirwww/schema/groups.xsd
inflating:
28187520/files/dirwww/schema/messages.xsd
inflating:
28187520/files/dirwww/schema/metrics.xsd
inflating:
28187520/files/dirwww/schema/mpoints.xsd
inflating:
28187520/files/dirwww/schema/profile.xsd
inflating:
28187520/files/dirwww/schema/profiles.xsd
inflating:
28187520/files/dirwww/schema/registry.xsd
inflating:
28187520/files/dirwww/schema/statuschanges.xsd
creating:
28187520/files/dirwww/style/
inflating:
28187520/files/dirwww/style/default.css
inflating:
28187520/files/dirwww/style/enums.xsl
inflating:
28187520/files/dirwww/style/file.xsl
inflating:
28187520/files/dirwww/style/files.xsl
inflating:
28187520/files/dirwww/style/group-profiles.xsl
inflating:
28187520/files/dirwww/style/group.xsl
inflating:
28187520/files/dirwww/style/groups.xsl
inflating:
28187520/files/dirwww/style/messages.xsl
inflating:
28187520/files/dirwww/style/metrics.xsl
inflating:
28187520/files/dirwww/style/mpoints.xsl
inflating:
28187520/files/dirwww/style/profile.xsl
inflating:
28187520/files/dirwww/style/profiles.xsl
inflating:
28187520/files/dirwww/style/registry.xsl
inflating:
28187520/files/dirwww/style/statuschanges.xsl
inflating:
28187520/files/emsclnt
inflating:
28187520/files/extract
inflating:
28187520/files/freeBSD.txt
inflating:
28187520/files/ggcmd
inflating:
28187520/files/ggMessage.dat
inflating:
28187520/files/ggparam.dat
inflating:
28187520/files/ggsci
inflating:
28187520/files/help.txt
inflating:
28187520/files/keygen
extracting:
28187520/files/label.sql
creating:
28187520/files/lib12/
creating:
28187520/files/lib12/fips/
inflating:
28187520/files/lib12/fips/libccme_asym.so
inflating:
28187520/files/lib12/fips/libccme_base.so
inflating:
28187520/files/lib12/fips/libccme_base_non_fips.so
inflating:
28187520/files/lib12/fips/libccme_ecc.so
inflating:
28187520/files/lib12/fips/libccme_ecc_accel_fips.so
inflating:
28187520/files/lib12/fips/libccme_ecc_accel_non_fips.so
inflating:
28187520/files/lib12/fips/libccme_ecc_non_fips.so
inflating:
28187520/files/lib12/fips/libcryptocme.sig
inflating:
28187520/files/lib12/fips/libcryptocme.so
inflating:
28187520/files/libantlr3c.so
inflating:
28187520/files/libdb-6.1.so
inflating:
28187520/files/libgglog.so
inflating:
28187520/files/libggnnzitp.so
inflating:
28187520/files/libggparam.so
inflating:
28187520/files/libggperf.so
inflating:
28187520/files/libggrepo.so
inflating:
28187520/files/libicudata.so.56
inflating:
28187520/files/libicudata.so.56.1
inflating:
28187520/files/libicui18n.so.56
inflating:
28187520/files/libicui18n.so.56.1
inflating:
28187520/files/libicuuc.so.56
inflating:
28187520/files/libicuuc.so.56.1
inflating:
28187520/files/libxerces-c-3.1.so
inflating:
28187520/files/logdump
inflating:
28187520/files/marker_remove.sql
inflating:
28187520/files/marker_setup.sql
inflating:
28187520/files/marker_status.sql
inflating:
28187520/files/mgr
inflating:
28187520/files/notices.txt
inflating:
28187520/files/oggerr
inflating:
28187520/files/params.sql
inflating:
28187520/files/prvtclkm.plb
inflating:
28187520/files/prvtlmpg.plb
inflating:
28187520/files/prvtlmpg_uninstall.sql
inflating:
28187520/files/remove_seq.sql
inflating:
28187520/files/replicat
inflating:
28187520/files/retrace
inflating:
28187520/files/reverse
inflating:
28187520/files/role_setup.sql
inflating:
28187520/files/sequence.sql
inflating:
28187520/files/server
inflating:
28187520/files/sqlldr.tpl
inflating:
28187520/files/tcperrs
inflating:
28187520/files/ucharset.h
inflating:
28187520/files/ulg.sql
inflating:
28187520/files/usrdecs.h
inflating:
28187520/files/zlib.txt
replace OGG-12.2.0.1-README.txt? [y]es, [n]o, [A]ll, [N]one,
[r]ename: y
inflating:
OGG-12.2.0.1-README.txt
inflating:
OGGCORE_12.2.0.1.170919_BLR27731916.pdf
inflating:
README_ora11g.txt
[oracle@racj1 ogg]$ pwd
/ogg
[oracle@racj1 ogg]$ cd 28187520/
[oracle@racj1 28187520]$ ls
etc files
[oracle@racj1 28187520]$ pwd
/ogg/28187520
[oracle@racj1 28187520]$ export
ORACLE_HOME=/ogg/12c
[oracle@racj1 28187520]$ /ogg/12c/OPatch/opatch apply
Invoking OPatch 11.2.0.1.7
Oracle Interim Patch Installer version 11.2.0.1.7
Copyright (c) 2011, Oracle Corporation. All
rights reserved.
Oracle Home : /ogg/12c
Central Inventory : /oracle/app/oraInventory
from : /etc/oraInst.loc
OPatch version :
11.2.0.1.7
OUI version : 11.2.0.3.0
Log file location :
/ogg/12c/cfgtoollogs/opatch/opatch2018-09-13_18-16-07PM.log
Applying interim patch '28187520' to OH '/ogg/12c'
Verifying environment and performing prerequisite
checks...
Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
Please shutdown Oracle instances running out of this
ORACLE_HOME on the local system.
(Oracle Home = '/ogg/12c')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Patching component oracle.oggcore.ora11g, 12.2.0.0.0...
Patch 28187520 successfully applied
Log file location:
/ogg/12c/cfgtoollogs/opatch/opatch2018-09-13_18-16-07PM.log
OPatch succeeded.
[oracle@racj1 28187520]$ cd /ogg/12c
[oracle@racj1 12c]$ ./ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 12.2.0.1.170919 27731916_FBO
Linux, x64, 64bit (optimized), Oracle 11g on
Sep 4 2018 20:23:18
Operating system character set identified as UTF-8.
Copyright (C) 1995, 2017, Oracle and/or its affiliates. All
rights reserved.
GGSCI (racj1) 1> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER STOPPED
GGSCI (racj1) 2> edit param mgr
PORT 7809
DYNAMICPORTLIST 7940-7950
AUTOSTART EXTRACT *
AUTORESTART EXTRACT *,WAITMINUTES 2,RETRIES 5
LAGREPORTHOURS 1
PURGEOLDEXTRACTS ./dirdat/*, USECHECKPOINTS, minkeepdays
7
CHECKMINUTES 5
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
"dirprm/mgr.prm" [New] 7L, 193C written
GGSCI (racj1) 3> edit param ./GLOBALS
GGSCHEMA oggadm
TRAIL_SEQLEN_6D
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
"./GLOBALS" [New] 3L, 33C written
GGSCI (racj1) 4> view param mgr
PORT 7809
DYNAMICPORTLIST 7940-7950
AUTOSTART EXTRACT *
AUTORESTART EXTRACT *,WAITMINUTES 2,RETRIES 5
LAGREPORTHOURS 1
PURGEOLDEXTRACTS ./dirdat/*, USECHECKPOINTS, minkeepdays
7
CHECKMINUTES 5
GGSCI (racj1) 5> view param ./GLOBALS
GGSCHEMA oggadm
TRAIL_SEQLEN_6D
GGSCI (racj1) 6> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER STOPPED
GGSCI (racj1) 7> start mgr
Manager started.
GGSCI (racj1) 8> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
GGSCI (racj1) 9> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
GGSCI (racj1) 10> exit
[oracle@racj1 12c]$ ps -ef|grep mgr
root 486 2 0 Sep07 ? 00:00:00
[async/mgr]
oracle 35921 1 1 18:18 ? 00:00:00 ./mgr PARAMFILE
/ogg/12c/dirprm/mgr.prm REPORTFILE /ogg/12c/dirrpt/MGR.rpt
PROCESSID MGR USESUBDIRS
oracle 36065 27785 0 18:18
pts/1 00:00:00 grep mgr
[oracle@racj1 12c]$ ssh racj2
Authorized users only.All activities will be monitored and
reported.
[oracle@racj2 ~]$ cd /ogg/12c
[oracle@racj2 12c]$ ./ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 12.2.0.1.170919 27731916_FBO
Linux, x64, 64bit (optimized), Oracle 11g on
Sep 4 2018 20:23:18
Operating system character set identified as UTF-8.
Copyright (C) 1995, 2017, Oracle and/or its affiliates. All
rights reserved.
GGSCI (racj2) 1> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
GGSCI (racj2) 2> stop mgr
Manager process is required by other GGS processes.
Are you sure you want to stop it (y/n)?y
Sending STOP request to MANAGER ...
ERROR: Access denied.
2018-09-13 18:19:55 WARNING
OGG-01742 Command sent to MGR MGR returned with
an ERROR response.
GGSCI (racj2) 3> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
GGSCI (racj2) 4> exit
[oracle@racj2 12c]$ ps -ef|grep mgr
root 486 2 0 Sep11 ? 00:00:00
[async/mgr]
oracle 90547 90287 0 18:20
pts/3 00:00:00 grep mgr
[oracle@racj2 12c]$ exit
logout
Connection to racj2 closed.
[oracle@racj1 12c]$ ./ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 12.2.0.1.170919 27731916_FBO
Linux, x64, 64bit (optimized), Oracle 11g on
Sep 4 2018 20:23:18
Operating system character set identified as UTF-8.
Copyright (C) 1995, 2017, Oracle and/or its affiliates. All
rights reserved.
GGSCI (racj1) 1> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
GGSCI (racj1) 2> stop mgr
Manager process is required by other GGS processes.
Are you sure you want to stop it (y/n)?y
Sending STOP request to MANAGER ...
Request processed.
Manager stopped.
GGSCI (racj1) 3> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER STOPPED
GGSCI (racj1) 4> exit
[oracle@racj1 12c]$ ps -ef|grep mgr
root 486 2 0 Sep07 ? 00:00:00
[async/mgr]
oracle 35921 1 0 18:18 ? 00:00:00 ./mgr PARAMFILE
/ogg/12c/dirprm/mgr.prm REPORTFILE /ogg/12c/dirrpt/MGR.rpt
PROCESSID MGR USESUBDIRS
oracle 37113 27785 0 18:20
pts/1 00:00:00 grep mgr
[oracle@racj1 12c]$ ps -ef|grep mgr
root 486 2 0 Sep07 ? 00:00:00
[async/mgr]
oracle 37115 27785 0 18:20
pts/1 00:00:00 grep mgr
[oracle@racj1 12c]$