ogg静默安装软件和打补丁
(2018-09-13 18:24:14)分类: oracle |
[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@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
replace OGG-12.2.0.1-README.txt? [y]es, [n]o, [A]ll, [N]one,
[r]ename: y
[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
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]$