Oracle GoldenGate学习之--AIX rac系统安装配置(1)
系统环境
操作系统:AIX5.3-09
DB Soft: Oracle 10gR2
Cluster: CRS 10.2.0.1
如下图所示:
本案例是用于基于VG Concurrent 的共享存储:
系统环境实在AIX系统上构建的Oracle RAC
下载OGG:
1、配置共享文件系统(安装OGG)
NODE1:
VOLUME GROUP: rootvg VG IDENTIFIER: 00040f8a00004c0000000140c6da55a7
VG STATE: active PP SIZE: 128 megabyte(s)
VG PERMISSION: read/write TOTAL PPs: 546 (69888 megabytes)
MAX LVs: 256 FREE PPs: 190 (24320 megabytes)
LVs: 17 USED PPs: 356 (45568 megabytes)
OPEN LVs: 16 QUORUM: 2 (Enabled)
TOTAL PVs: 1 VG DESCRIPTORS: 2
STALE PVs: 0 STALE PPs: 0
ACTIVE PVs: 1 AUTO ON: yes
MAX PPs per VG: 32512
MAX PPs per PV: 1016 MAX PVs: 32
LTG size (Dynamic): 256 kilobyte(s) AUTO SYNC: no
HOT SPARE: no BB POLICY: relocatable
创建文件系统/ogg
[[email protected] /]#lsvg -l rootvg
rootvg:LV NAME TYPE LPs PPs PVs LV STATE MOUNT POINT
hd5 boot 1 1 1 closed/syncd N/A
hd6 paging 16 16 1 open/syncd N/A
hd8 jfslog 1 1 1 open/syncd N/A
hd4 jfs 48 48 1 open/syncd /
hd2 jfs 24 24 1 open/syncd /usr
hd9var jfs 16 16 1 open/syncd /var
hd3 jfs 16 16 1 open/syncd /tmp
hd1 jfs 16 16 1 open/syncd /home
hd10opt jfs 8 8 1 open/syncd /opt
lg_dumplv sysdump 8 8 1 open/syncd N/A
lv00 jfs 120 120 1 open/syncd /u01
lv01 jfs 1 1 1 open/syncd /var/adm/csd
paging00 paging 16 16 1 open/syncd N/A
lv02 jfs 32 32 1 open/syncd /arch
lv03 jfs 16 16 1 open/syncd /dsk1
lv04 jfs 16 16 1 open/syncd /dsk2
lv05 jfs 1 1 1 open/syncd /flash_rcy
lv_ogg jfs 10 10 1 closed/syncd N/A[[email protected] /]#mount /ogg
[[email protected] /]#df -m
Filesystem MB blocks Free %Used Iused %Iused Mounted on
/dev/lv_ogg 1280.00 1239.78 4% 17 1% /ogg
共享文件系统[[email protected] /]#cat /etc/exports
/soft2 -sec=sys:krb5p:krb5i:krb5:dh,rw,access=aix212:aix199
/flash_rcy -sec=sys:krb5p:krb5i:krb5:dh,rw,root=aix212
/ogg -sec=sys:krb5p:krb5i:krb5:dh,rw=aix212,access=aix212,root=aix212
[[email protected] /]#exportfs -av
exportfs: re-exported /soft2
exportfs: re-exported /flash_rcy
exportfs: re-exported /ogg
NODE2:
查看node1共享
[[email protected]@ /]#showmount -e aix211export list for aix211:
/soft2 aix212,aix199
/flash_rcy (everyone)
/ogg aix212
mount 文件系统[[email protected]@ /]#mount -o rw,bg,hard,intr,rsize=65536,wsize=65536,timeo=600,vers=3,sec=sys aix211:/ogg /ogg
[[email protected]@ /]#df -m
Filesystem MB blocks Free %Used Iused %Iused Mounted on
aix211:/ogg 1280.00 1239.78 4% 17 1% /ogg
编辑filesystems文件[[email protected]@ /]#cat /etc/filesystems
/ogg:
dev = "/ogg"
vfs = nfs
nodename = 192.168.8.211
mount = true
options = rw,bg,hard,intr,rsize=65536,wsize=65536,timeo=600,vers=3,sec=sys
account = false
2、解压安装ogglost+found ogg112101_ggs_AIX_ppc_ora10.2_64bit.zip
[[email protected] ogg]#unzip ogg112101_ggs_AIX_ppc_ora10.2_64bit.zipArchive: ogg112101_ggs_AIX_ppc_ora10.2_64bit.zip
inflating: ggs_AIX_ppc_ora10.2_64bit.tar
inflating: OGG_WinUnix_Rel_Notes_11.2.1.0.1.pdf
inflating: Oracle GoldenGate 11.2.1.0.1 README.doc
inflating: Oracle GoldenGate 11.2.1.0.1 README.txtOGG_WinUnix_Rel_Notes_11.2.1.0.1.pdf ggs_AIX_ppc_ora10.2_64bit.tar
Oracle GoldenGate 11.2.1.0.1 README.doc lost+found
Oracle GoldenGate 11.2.1.0.1 README.txt ogg112101_ggs_AIX_ppc_ora10.2_64bit.zip
[[email protected] ogg]#tar xvf ggs_AIX_ppc_ora10.2_64bit.tarx .
x ./mgr, 4421047 bytes, 8635 tape blocks
x ./ggsci, 5779790 bytes, 11289 tape blocks
x ./ggcmd, 2871133 bytes, 5608 tape blocks
x ./ggMessage.dat, 1257280 bytes, 2456 tape blocks
x ./help.txt, 169753 bytes, 332 tape blocks
x ./tcperrs, 759 bytes, 2 tape blocks
x ./bcrypt.txt, 1725 bytes, 4 tape blocks
x ./libxml2.txt, 1668 bytes, 4 tape blocks
x ./zlib.txt, 1476 bytes, 3 tape blocks
x ./freeBSD.txt, 1968 bytes, 4 tape blocks
x ./notices.txt, 213535 bytes, 418 tape blocks
x ./libxerces-c.a, 9209080 bytes, 17987 tape blocks
x ./libicui18n38.a, 9302329 bytes, 18169 tape blocks
x ./libicuuc38.a, 6302602 bytes, 12310 tape blocks
x ./libicudata38.a, 15580952 bytes, 30432 tape blocks
x ./libantlr3c.so, 260012 bytes, 508 tape blocks
......
3、创建ogg缺省目录
Could not load program ./ggsci:
Dependent module libclntsh.so could not be loaded.
Could not load module libclntsh.so.
System error: No such file or directory
出现以上错误!
[[email protected] /]#chown -R oracle:dba /ogg
[[email protected] ogg]#su - oracleOracle 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 10.2 on Apr 23 2012 07:27:46
Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.
GGSCI (aix211) 2> help
GGSCI Command Summary:
Object: Command:
SUBDIRS CREATE
ER INFO, KILL, LAG, SEND, STATUS, START, STATS, STOP
EXTRACT ADD, ALTER, CLEANUP, DELETE, INFO, KILL,
LAG, REGISTER, SEND, START, STATS, STATUS, STOP
UNREGISTER
EXTTRAIL ADD, ALTER, DELETE, INFO
GGSEVT VIEW
MANAGER INFO, SEND, START, STOP, STATUS
MARKER INFO
PARAMS EDIT, VIEW
REPLICAT ADD, ALTER, CLEANUP, DELETE, INFO, KILL, LAG, SEND,
START, STATS, STATUS, STOP
REPORT VIEW
RMTTRAIL ADD, ALTER, DELETE, INFO
TRACETABLE ADD, DELETE, INFO
TRANDATA ADD, DELETE, INFO
SCHEMATRANDATA ADD, DELETE, INFO
CHECKPOINTTABLE ADD, DELETE, CLEANUP, INFO
Commands without an object:
(Database) DBLOGIN, LIST TABLES, ENCRYPT PASSWORD, FLUSH SEQUENCE
MININGDBLOGIN
(DDL) DUMPDDL
(Miscellaneous) FC, HELP, HISTORY, INFO ALL, OBEY, SET EDITOR, SHELL,
SHOW, VERSIONS, ! (note: you must type the word
COMMAND after the ! to display the ! help topic.)
i.e.: GGSCI (sys1)> help ! command
For help on a specific command, type HELP .
Example: HELP ADD REPLICAT
GGSCI (aix211) 3> create subdirs
Creating subdirectories under current directory /ogg
Parameter files /ogg/dirprm: already exists
Report files /ogg/dirrpt: created
Checkpoint files /ogg/dirchk: created
Process status files /ogg/dirpcs: created
SQL script files /ogg/dirsql: created
Database definitions files /ogg/dirdef: created
Extract data files /ogg/dirdat: created
Temporary files /ogg/dirtmp: created
Stdout files /ogg/dirout: created
在node2使用ogg:[[email protected]@ /]#chown oracle:dba /ogg
[[email protected]@ /]#su - oracle
[[email protected]@ W]$cd /ogg
[[email protected]@ W]$bash
[[email protected]@ ogg]$./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 10.2 on Apr 23 2012 07:27:46
Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.
GGSCI (aix212) 1> help
GGSCI Command Summary:
Object: Command:
SUBDIRS CREATE
ER INFO, KILL, LAG, SEND, STATUS, START, STATS, STOP
EXTRACT ADD, ALTER, CLEANUP, DELETE, INFO, KILL,
LAG, REGISTER, SEND, START, STATS, STATUS, STOP
UNREGISTER
EXTTRAIL ADD, ALTER, DELETE, INFO
GGSEVT VIEW
MANAGER INFO, SEND, START, STOP, STATUS
MARKER INFO
PARAMS EDIT, VIEW
REPLICAT ADD, ALTER, CLEANUP, DELETE, INFO, KILL, LAG, SEND,
START, STATS, STATUS, STOP
REPORT VIEW
RMTTRAIL ADD, ALTER, DELETE, INFO
TRACETABLE ADD, DELETE, INFO
TRANDATA ADD, DELETE, INFO
SCHEMATRANDATA ADD, DELETE, INFO
CHECKPOINTTABLE ADD, DELETE, CLEANUP, INFO
Commands without an object:
(Database) DBLOGIN, LIST TABLES, ENCRYPT PASSWORD, FLUSH SEQUENCE
MININGDBLOGIN
(DDL) DUMPDDL
(Miscellaneous) FC, HELP, HISTORY, INFO ALL, OBEY, SET EDITOR, SHELL,
SHOW, VERSIONS, ! (note: you must type the word
COMMAND after the ! to display the ! help topic.)
i.e.: GGSCI (sys1)> help ! command
For help on a specific command, type HELP .
Example: HELP ADD REPLICAT
GGSCI (aix212) 2>
@至此,AIX下ogg安装完成,配置和应用,待续......
原文:http://tiany.blog.51cto.com/513694/1554448