root/root
1.ip
#public ip
10.1xxx.22 n01
10.1xxx.23 n02
#virtual ip
10.1xxx.24 n01-vip
10.1xxx.25 nt02-vip
#scan ip
10.1xxxx.26 nd-scan
#private ip
77.77.77.45 n01-priv
77.77.77.43 n02-priv
2.os info
df -g
Filesystem GB blocks Free %Used Iused %Iused Mounted on
/dev/hd4 0.88 0.58 35% 18718 12% /
/dev/hd2 4.25 1.51 65% 52859 13% /usr
/dev/hd9var 0.50 0.14 73% 6338 15% /var
/dev/hd3 0.12 0.11 12% 53 1% /tmp
/dev/hd1 0.12 0.12 1% 7 1% /home
/dev/hd11admin 0.12 0.12 1% 7 1% /admin
/proc - - - - - /proc
/dev/hd10opt 0.50 0.27 47% 2814 4% /opt
/dev/livedump 0.25 0.25 1% 4 1% /var/adm/ras/livedump
/dev/fslv00 15.00 15.00 1% 4 1% /ptf
/dev/oracle_lv 50.00 49.80 1% 4 1% /oracle
/dev/grid_lv 50.00 49.80 1% 4 1% /grid
$ lsvg rootvg
VOLUME GROUP: rootvg VG IDENTIFIER: 00c7c14000004c0000000165c6f6f9c4
VG STATE: active PP SIZE: 128 megabyte(s)
VG PERMISSION: read/write TOTAL PPs: 1198 (153344 megabytes)
MAX LVs: 256 FREE PPs: 86 (11008 megabytes)
LVs: 15 USED PPs: 1112 (142336 megabytes)
OPEN LVs: 14 QUORUM: 2 (Enabled)
TOTAL PVs: 2 VG DESCRIPTORS: 3
STALE PVs: 0 STALE PPs: 0
ACTIVE PVs: 2 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
PV RESTRICTION: none INFINITE RETRY: no
DISK BLOCK SIZE: 512 CRITICAL VG: no
FS SYNC OPTION: no
chfs -a size=2048M /tmp
内存:
bootinfo -r
16777216
swap:
lsps -s
Total Paging Space Percent Used
16384MB 0%
cpu:
bootinfo -y
64
lsattr -EHl proc0
attribute value description user_settable
frequency 2301696000 Processor Speed False
smt_enabled true Processor SMT enabled False
smt_threads 2 Processor SMT threads False
state enable Processor state False
type PowerPC_POWER5 Processor type False
主机:
oslevel -r
7100-05
prtconf|grep System
System Model: IBM,9119-595
+ sys0 System Object
+ sysplanar0 System Planar
3.存储(3-10)
lsdev | grep hdisk
hdisk0 Available Virtual SCSI Disk Drive
hdisk1 Available Virtual SCSI Disk Drive
hdisk2 Available Virtual SCSI Disk Drive
hdisk3 Available Virtual SCSI Disk Drive
hdisk4 Available Virtual SCSI Disk Drive
hdisk5 Available Virtual SCSI Disk Drive
hdisk6 Available Virtual SCSI Disk Drive
hdisk7 Available Virtual SCSI Disk Drive
hdisk8 Available Virtual SCSI Disk Drive
hdisk9 Available Virtual SCSI Disk Drive
hdisk10 Available Virtual SCSI Disk Drive
4.date
ntracd02[/oracle/soft]#lssrc -ls xntpd
Program name: /usr/sbin/xntpd
Version: 3
Leap indicator: 00 (No leap second today.)
Sys peer: 10.168.25.101
Sys stratum: 5
Sys precision: -17
Debug/Tracing: DISABLED
Root distance: 0.083847
Root dispersion: 0.005585
Reference ID: 10.168.25.101
Reference time: df55730b.f241b000 Wed, Sep 26 2018 10:52:59.946
Broadcast delay: 0.003906 (sec)
Auth delay: 0.000122 (sec)
System flags: bclient pll monitor filegen
System uptime: 83864 (sec)
Clock stability: 0.000107 (sec)
Clock frequency: 0.000000 (sec)
Peer: 10.168.25.101
flags: (configured)(sys peer)
stratum: 4, version: 3
our mode: client, his mode: server
Subsystem Group PID Status
xntpd tcpip 3342562 active
5.user
/usr/bin/mkgroup -'A' id='1000' adms='root' oinstall
/usr/bin/mkgroup -'A' id='1031' adms='root' dba
/usr/bin/mkgroup -'A' id='1020' adms='root' asmadmin
/usr/bin/mkgroup -'A' id='1021' adms='root' asmdba
/usr/bin/mkuser id='1100' pgrp='oinstall' groups='dba','asmadmin','asmdba' admgroups='system' home='/home/grid' grid
/usr/bin/mkuser id='1101' pgrp='oinstall' groups='dba','asmadmin','asmdba' admgroups='system' home='/home/oracle' oracle
oracle/Ynydxm.2018
grid/Ynydxm.2018
grid
umask 022
export EDITOR=vi
export ORACLE_BASE=/grid/app/grid
export ORACLE_HOME=/grid/app/11.2.0/grid
export ORACLE_SID=+ASM1
export PATH=.:$PATH:$ORACLE_HOME/bin:/bin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/java7_64/jre/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
oracle
umask 022
export EDITOR=vi
export ORACLE_BASE=/oracle/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1
export ORACLE_SID=stu1
export PATH=.:$PATH:$ORACLE_HOME/bin:/bin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/java7_64/jre/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
6.ssh互信
grid oracle互信
7. 创建目录
mkdir -p /grid/app/11.2.0/grid
mkdir /grid/app/grid
chown -R grid:oinstall /grid
chmod -R 775 /grid
mkdir -p /oracle/app/oracle
chown -R oracle:oinstall /oracle
chmod -R 775 /oracle
8. 修改用户capabilities
chuser capabilities=CAP_NUMA_ATTACH,CAP_BYPASS_RAC_VMM,CAP_PROPAGATE grid
chuser capabilities=CAP_NUMA_ATTACH,CAP_BYPASS_RAC_VMM,CAP_PROPAGATE oracle
lsuser -a capabilities oracle
lsuser -a capabilities grid
9. 修改用户limit
#chuser nproc='-1' fsize_hard='-1' data_hard='-1' stack_hard='-1' rss_hard='-1' nofiles_hard='-1' threads_hard='-1' nproc_hard='-1' grid
#chuser nproc='-1' fsize_hard='-1' data_hard='-1' stack_hard='-1' rss_hard='-1' nofiles_hard='-1' threads_hard='-1' nproc_hard='-1' oracle
chuser nproc='-1' cpu'=-1' fsize='-1' stack='-1' data='-1' stack='-1' rss='-1' nofiles='-1' core='2097151' grid
chuser nproc='-1' cpu'=-1' fsize='-1' stack='-1' data='-1' stack='-1' rss='-1' nofiles='-1' core='2097151' oracle
chuser nproc='-1' cpu'=-1' fsize='-1' stack='-1' data='-1' stack='-1' rss='-1' nofiles='-1' core='2097151' root
10.修改系统参数
修改系统参数
no -r -o ipqmaxlen=512
no -p -o rfc1323=1
no -p -o tcp_recvspace=65536
no -p -o tcp_sendspace=65536
no -p -o udp_recvspace=655360
no -p -o udp_sendspace=65536
--no -p -o sb_max=131072
vmo -p -o minperm%=3
vmo -p -o maxperm%=90
vmo -p -o maxclient%=90
vmo -p -o strict_maxclient=1
vmo -p -o strict_maxperm=0
no -p -o tcp_ephemeral_low=9000 -o tcp_ephemeral_high=65500
no -p -o udp_ephemeral_low=9000 -o udp_ephemeral_high=65500
chdev -l sys0 -a maxuproc=16384
11.存储
ntracd02[/]#ls -lrt /dev/hdisk*
brw------- 1 root system 13, 1 Sep 12 03:00 /dev/hdisk0
brw------- 1 root system 13, 2 Sep 12 06:05 /dev/hdisk1
brw------- 1 root system 13, 4 Sep 12 06:06 /dev/hdisk3
brw------- 1 root system 13, 5 Sep 12 06:06 /dev/hdisk4
brw------- 1 root system 13, 6 Sep 12 06:06 /dev/hdisk5
brw------- 1 root system 13, 7 Sep 12 06:06 /dev/hdisk8
brw------- 1 root system 13, 8 Sep 12 06:06 /dev/hdisk6
brw------- 1 root system 13, 9 Sep 12 06:06 /dev/hdisk7
brw------- 1 root system 13, 10 Sep 12 06:06 /dev/hdisk10
brw------- 1 root system 13, 11 Sep 12 06:06 /dev/hdisk9
brw------- 1 root system 13, 3 Sep 12 22:58 /dev/hdisk2
for i in 3 4 5 6 7 8 9 10 11 12 13 14 15
do
bootinfo -s hdisk$i
done
51200
51200
51200
51200
51200
51200
51200
51200
10240
10240
10240
10240
10240
for i in 3 4 5 6 7 8 9 10 11 12 13 14 15
do
lsattr -E -l hdisk$i | grep policy
done
reserve_policy no_reserve Reserve Policy True+
reserve_policy no_reserve Reserve Policy True+
reserve_policy no_reserve Reserve Policy True+
reserve_policy no_reserve Reserve Policy True+
reserve_policy no_reserve Reserve Policy True+
reserve_policy no_reserve Reserve Policy True+
reserve_policy no_reserve Reserve Policy True+
reserve_policy no_reserve Reserve Policy True+
reserve_policy no_reserve Reserve Policy True+
reserve_policy no_reserve Reserve Policy True+
reserve_policy no_reserve Reserve Policy True+
reserve_policy no_reserve Reserve Policy True+
reserve_policy no_reserve Reserve Policy True+
chown grid:asmadmin /dev/rhdisk3
chown grid:asmadmin /dev/rhdisk4
chown grid:asmadmin /dev/rhdisk5
chown grid:asmadmin /dev/rhdisk6
chown grid:asmadmin /dev/rhdisk7
chown grid:asmadmin /dev/rhdisk8
chown grid:asmadmin /dev/rhdisk9
chown grid:asmadmin /dev/rhdisk10
chmod 660 /dev/rhdisk3
chmod 660 /dev/rhdisk4
chmod 660 /dev/rhdisk5
chmod 660 /dev/rhdisk6
chmod 660 /dev/rhdisk7
chmod 660 /dev/rhdisk8
chmod 660 /dev/rhdisk9
chmod 660 /dev/rhdisk10
ntracd01[/oracle]#ls -lrt /dev/rhdisk*
crw------- 2 root system 13, 1 Sep 11 02:33 /dev/rhdisk0
crw------- 1 root system 13, 3 Sep 12 06:40 /dev/rhdisk2
crw-rw---- 1 grid asmadmin 13, 4 Sep 12 06:40 /dev/rhdisk3
crw-rw---- 1 grid asmadmin 13, 5 Sep 12 06:40 /dev/rhdisk6
crw-rw---- 1 grid asmadmin 13, 6 Sep 12 06:40 /dev/rhdisk5
crw-rw---- 1 grid asmadmin 13, 7 Sep 12 06:40 /dev/rhdisk7
crw-rw---- 1 grid asmadmin 13, 9 Sep 12 06:40 /dev/rhdisk8
crw-rw---- 1 grid asmadmin 13, 8 Sep 12 06:40 /dev/rhdisk4
crw-rw---- 1 grid asmadmin 13, 10 Sep 12 06:40 /dev/rhdisk9
crw-rw---- 1 grid asmadmin 13, 11 Sep 12 06:40 /dev/rhdisk10
crw------- 1 root asmadmin 13, 2 Sep 12 22:44 /dev/rhdisk1
12.preinstall
(aix没有unzip命令,要用jar来解压文件)(必须全部检查通过)
jar -xvf p*.zip
root,all node:
chmod +x rootpre.sh
./rootpre.sh
chmod +x runcluvfy.sh
chmod +x install/.oui
chmod +x install/unzip
root:./rootpre.sh
grid:./runcluvfy.sh stage -pre crsinst -n ntracd01,ntracd02 -fixup -verbose
13.crs install
INVENTORY_LOCATION=/grid/app/oraInventory
oracle.install.option=CRS_CONFIG
ORACLE_BASE=/grid/app/grid
ORACLE_HOME=/grid/app/11.2.0/grid
oracle.install.asm.OSDBA=asmdba
oracle.install.asm.OSOPER=asmadmin
oracle.install.asm.OSASM=asmadmin
oracle.install.crs.config.gpnp.scanName=ntracd-scan
oracle.install.crs.config.gpnp.scanPort=1521
oracle.install.crs.config.clusterName=ntracd
oracle.install.crs.config.clusterNodes=ntracd01:ntracd01-vip,ntracd02:ntracd02-vip
oracle.install.crs.config.networkInterfaceList=en0:10.174.26.0:1,en2:77.77.77.0:2
oracle.install.asm.SYSASMPassword=Oracle1234
oracle.install.crs.config.storageOption=ASM_STORAGE
#oracle.install.crs.config.sharedFileSystemStorage.votingDiskLocations=/dev/rhdisk11,/dev/rhdisk12,/dev/rhdisk13
#oracle.install.crs.config.sharedFileSystemStorage.votingDiskRedundancy=NORMAL
#oracle.install.crs.config.sharedFileSystemStorage.ocrLocations=/dev/rhdisk14,/dev/rhdisk15
#oracle.install.crs.config.sharedFileSystemStorage.ocrRedundancy=NORMAL
oracle.install.asm.SYSASMPassword=oracle
#oracle.install.asm.diskGroup.name=data
oracle.install.asm.diskGroup.redundancy=EXTERNAL
#oracle.install.asm.diskGroup.disks=/dev/rhdisk3,/dev/rhdisk4,/dev/rhdisk5,/dev/rhdisk6,/dev/rhdisk7,/dev/rhdisk8,/dev/rhdisk9,/dev/rhdisk10
oracle.install.asm.diskGroup.diskDiscoveryString=/dev/rhdisk*
oracle.install.asm.monitorPassword=Oracle1234
oracle.install.crs.upgrade.clusterNodes=ntracd01,ntracd02
oracle.installer.autoupdates.option=SKIP_UPDATES
chmod +x runInstaller
grid:./runInstaller -responseFile /grid/grid/response/grid_install.rsp -silent -ignorePrereq -showProgress
/grid/app/oraInventory/orainstRoot.sh
/grid/app/11.2.0/grid/root.sh
14:dbinstall
oracle:
/usr/java5/bin/jar -xvf p13390677_112040_AIX64-5L_1of7.zip
/usr/java5/bin/jar -xvf p13390677_112040_AIX64-5L_2of7.zip
grid:./runcluvfy.sh stage -pre dbinst -n ntracd01,ntracd02 -fixup -verbose
chmod -R 775 database
/oracle/soft/database/rootpre.sh
oracle:./runInstaller -responseFile /oracle/soft/database/response/db_install.rsp -silent -ignorePrereq -showProgress
oracle.install.option=INSTALL_DB_SWONLY
UNIX_GROUP_NAME=oinstall
INVENTORY_LOCATION=/oracle/app/oraInventory
ORACLE_HOME=/oracle/app/oracle/product/11.2.0/db_1
ORACLE_BASE=/oracle/app/oracle
oracle.install.db.InstallEdition=EE
oracle.install.db.DBA_GROUP=dba
oracle.install.db.OPER_GROUP=oinstall
oracle.install.db.CLUSTER_NODES=ntracd01,ntracd02
oracle.install.db.isRACOneInstall=false
oracle.install.db.config.starterdb.type=GENERAL_PURPOSE
oracle.install.db.config.starterdb.globalDBName=studydb
oracle.install.db.config.starterdb.characterSet=ZHS16GBK
oracle.install.db.config.starterdb.password.ALL=Oracle1234
oracle.install.db.config.starterdb.storageType=ASM_STORAGE
oracle.install.db.config.asm.diskGroup=ASM_STORAGE
oracle.install.db.config.asm.ASMSNMPPassword=Oracle1234
oracle.install.db.config.starterdb.control=DB_CONTROL
SECURITY_UPDATES_VIA_MYORACLESUPPORT=false
DECLINE_SECURITY_UPDATES=true
oracle.installer.autoupdates.option=SKIP_UPDATES
oracle.install.db.config.starterdb.memoryOption=false
15.
监听:
grid:netca -silent -responsefile /grid/app/11.2.0/grid/assistants/netca/netca.rsp
16.
dbca:
dbca -silent -createDatabase -templateName General_Purpose.dbc -initparams db_create_file_dest='+data' -sysPassword Oracle1234 -systemPassword Oracle1234 -asmsnmpPassword Oracle1234 -diskGroupName 'DATA' -initparams db_create_online_log_dest_1='+data' -gdbname studydb -sid studydb -responseFile NO_VALUE -characterSet ZHS16GBK -nationalCharacterSet AL16UTF16 -memoryPercentage 30 -emConfiguration NONE -storageType ASM -nodeinfo ntracd01,ntracd02
完。