1、ip规划:
xx.xx.xx.xx
2、root密码
root/password
3、操作系统版本
# oslevel -r
6100-08
# bootinfo -y
64
4、内存
# lsps -s
Total Paging Space Percent Used
16384MB 0%
# bootinfo -r
67108864
5、查看cpu
$ 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
6、存储链路
# lsdev | grep Fibre
fcnet0 Defined 0W-08-01 Fibre Channel Network Protocol Device
fcnet1 Defined 0b-08-01 Fibre Channel Network Protocol Device
fcnet2 Defined 0M-08-01 Fibre Channel Network Protocol Device
fcnet3 Defined 0Q-08-01 Fibre Channel Network Protocol Device
fcnet4 Defined 0R-08-01 Fibre Channel Network Protocol Device
fcnet5 Defined 0g-08-01 Fibre Channel Network Protocol Device
fcnet6 Defined 0c-08-01 Fibre Channel Network Protocol Device
fcnet7 Defined 0i-08-01 Fibre Channel Network Protocol Device
sfwcomm0 Available 0i-08-02-FF Fibre Channel Storage Framework Comm
sfwcomm1 Available 0W-08-02-FF Fibre Channel Storage Framework Comm
sfwcomm2 Available 0b-08-02-FF Fibre Channel Storage Framework Comm
sfwcomm3 Available 0Q-08-02-FF Fibre Channel Storage Framework Comm
sfwcomm4 Available 0R-08-02-FF Fibre Channel Storage Framework Comm
sfwcomm5 Available 0g-08-02-FF Fibre Channel Storage Framework Comm
sfwcomm6 Available 0c-08-02-FF Fibre Channel Storage Framework Comm
sfwcomm7 Available 0M-08-02-FF Fibre Channel Storage Framework Comm
7、文件系统
[lbnbua02:root:/] df -g
Filesystem GB blocks Free %Used Iused %Iused Mounted on
/dev/hd4 14.00 2.43 83% 32825 6% /
/dev/hd2 6.50 0.97 86% 91873 29% /usr
/dev/hd9var 5.00 2.71 46% 17298 3% /var
/dev/hd3 10.00 2.66 74% 4109 1% /tmp
/dev/hd1 5.00 2.98 41% 4350 1% /home
/dev/hd11admin 0.50 0.50 1% 5 1% /admin
/proc - - - - - /proc
/dev/hd10opt 26.00 13.94 47% 57298 2% /opt
/dev/livedump 0.50 0.50 1% 4 1% /var/adm/ras/livedump
/dev/toptealv 2.00 1.92 5% 320 1% /toptea
/dev/oracle_lv 40.00 15.08 63% 105481 3% /oracle
/dev/ngboss_lv 12.00 5.82 52% 302 1% /ngboss
/dev/ysjhbaklv 80.00 68.05 15% 2326 1% /ngdata2
/dev/grid_lv 50.00 49.99 1% 4 1% /grid
7 #创建用户
/usr/bin/mkgroup -'A' id='1000' adms='root' oinstall
/usr/bin/mkgroup -'A' id='1100' adms='root' dba
#官方文档Typical Installation中可以把组都设置为oinstall,Advanced Installation会有asmadmin,asmdba等组
/usr/bin/mkuser id='1100' pgrp='oinstall' groups='dba' admgroups='system' home='/home/grid' grid
/usr/bin/mkuser id='1101' pgrp='oinstall' groups='dba' admgroups='system' home='/home/oracle' oracle
grid
umask 022
export EDITOR=vi
export ORACLE_BASE=/grid/app/grid
export ORACLE_HOME=/grid/app/11.2.0/grid
export ORACLE_SID=+ASM
export PATH=.:$PATH:$ORACLE_HOME/bin:/bin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/java7_64/jre/bin:$ORACLE_HOME/OPatch
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=orasid
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
8、编辑/etc/hosts
xx.xx.xx.xx hostname
hosts文件需要加上o+r的others read权限
9、创建目录
mkdir -p /grid/app/11.2.0/grid
chown -R grid:dba /grid
mkdir /oracle/app/oracle
chown oracle:oinstall /oracle/app/oracle
chmod -R 775 /oracle
chmod -R 775 /grid
10、修改用户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
7、修改用户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
11、磁盘
# ls -rtl /dev/hdiskpower*
brw-rw---- 1 root system 41, 2 Jun 04 09:05 /dev/hdiskpower2
brw-rw---- 1 root system 41, 1 Jun 04 09:05 /dev/hdiskpower1
brw-rw---- 1 root system 41, 0 Jun 04 09:05 /dev/hdiskpower0
brw-rw---- 1 root system 41, 9 Jun 04 09:05 /dev/hdiskpower9
brw-rw---- 1 root system 41, 8 Jun 04 09:05 /dev/hdiskpower8
brw-rw---- 1 root system 41, 7 Jun 04 09:05 /dev/hdiskpower7
brw-rw---- 1 root system 41, 6 Jun 04 09:05 /dev/hdiskpower6
...
brw-rw---- 1 root system 41, 65 Jun 04 09:05 /dev/hdiskpower65
brw-rw---- 1 root system 41, 64 Jun 04 09:05 /dev/hdiskpower64
brw-rw---- 1 root system 41, 63 Jun 04 09:05 /dev/hdiskpower63
brw-rw---- 1 root system 41, 62 Jun 04 09:05 /dev/hdiskpower62
brw-rw---- 1 root system 41, 61 Jun 04 09:05 /dev/hdiskpower61
#
for i in {0..70}
> do
> bootinfo -s hdiskpower$i
> done
[lbnbua02:root:/] for i in {0..70}
> do
> bootinfo -s hdiskpower$i
> done
131070
131070
131070
...
131070
131070
131070
131070
131070
131070
磁盘大小相同,就没有额外增加ocr磁盘了
chown grid:oinstall /dev/rhdiskpower*
chmod 660 /dev/hdiskpower*
# ls -rtl /dev/rhdiskpower*
brw-rw---- 1 grid oinstall 41, 70 Jun 04 09:05 /dev/rhdiskpower70
brw-rw---- 1 grid oinstall 41, 69 Jun 04 09:05 /dev/rhdiskpower69
brw-rw---- 1 grid oinstall 41, 68 Jun 04 09:05 /dev/rhdiskpower68
brw-rw---- 1 grid oinstall 41, 67 Jun 04 09:05 /dev/rhdiskpower67
brw-rw---- 1 grid oinstall 41, 66 Jun 04 09:05 /dev/rhdiskpower66
brw-rw---- 1 grid oinstall 41, 65 Jun 04 09:05 /dev/rhdiskpower65
brw-rw---- 1 grid oinstall 41, 64 Jun 04 09:05 /dev/rhdiskpower64
brw-rw---- 1 grid oinstall 41, 63 Jun 04 09:05 /dev/rhdiskpower63
brw-rw---- 1 grid oinstall 41, 62 Jun 04 09:05 /dev/rhdiskpower62
#
12、修改系统参数
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
13、检查
$ ./runcluvfy.sh stage -pre crsinst -n lbnbua02 -fixup verbose
14、静默gi安装(重点是grid_install.rsp的改写)
$ ./runInstaller -responseFile /grid/app/grid/grid_install.rsp -silent -ignorePrereq -showProgress
********************************************************************************
Your platform requires the root user to perform certain pre-installation
OS preparation. The root user should run the shell script 'rootpre.sh' before
you proceed with Oracle installation. rootpre.sh can be found at the top level
of the CD or the stage area.
Answer 'y' if root has run 'rootpre.sh' so you can proceed with Oracle
installation.
Answer 'n' to abort installation and then ask root to run 'rootpre.sh'.
...
Setup files successful.
The installation of Oracle Grid Infrastructure 11g was successful.
Please check '/oracle/oracle/oraInventory/logs/silentInstall2018-06-05_04-02-02PM.log' for more details.
.................................................. 94% Done.
Execute Root Scripts in progress.
As a root user, execute the following script(s):
1. /grid/app/11.2.0/grid/root.sh
.................................................. 100% Done.
Execute Root Scripts successful.
As install user, execute the following script to complete the configuration.
1. /grid/app/11.2.0/grid/cfgtoollogs/configToolAllCommands RESPONSE_FILE=<response_file>
Note:
1. This script must be run on the same host from where installer was run.
2. This script needs a small password properties file for configuration assistants that require passwords (refer to install guide documentation).
Successfully Setup Software.
15、执行脚本
/grid/app/11.2.0/grid/root.sh
/grid/app/11.2.0/grid/cfgtoollogs/configToolAllCommands
16、检查
$ crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
ONLINE ONLINE lbnbua02
ora.ons
OFFLINE OFFLINE lbnbua02
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
1 OFFLINE OFFLINE
ora.diskmon
1 OFFLINE OFFLINE
ora.evmd
1 ONLINE ONLINE lbnbua02
Disk Group CRS created successfully.
17、psu (需要打gi,db,jvm的补丁)
26392168 db
26635834 jvm
26635745 gi
# gi
grid:
/grid/app/11.2.0/grid/OPatch/ocm/bin/emocmrsp -no_banner -output /grid/soft/ocm.rsp
root:
/grid/app/11.2.0/grid/OPatch/opatch auto /grid/soft/26635745 -ocmrf /grid/soft/ocm.rsp
# jvm
opatch prereq CheckConflictAgainstOHWithDetail -ph ./
opatch apply
18、静默安装asm
cd /grid/app/11.2.0/grid/cfgtoollogs
vi cfgrsp.properties
oracle.assistants.asm|S_ASMPASSWORD=oracle
oracle.assistants.asm|S_ASMMONITORPASSWORD=oracle
cd /grid/app/11.2.0/grid/cfgtoollogs
./configToolAllCommands RESPONSE_FILE=./cfgrsp.properties
19.dbca建库
20.检查库环境