Step-by-step Install Oracle 10g RAC

oldunix

硬件环境：
Sun V490两台
网卡：ce0/1/2/3（4 card）   集成ce4/5
ce0/1  公网
ce4/5  私网

    SCSI 卡
Sun StorEdge3320 一台 (10.77.77.10)
        在划分阵列3310时，将10块盘中的8块，做两两RAID 1，另外2块作为Hot Spare盘；将底层的5个RAID 1映射为1个条带化的逻辑硬盘（RAID10）；

软件环境：
Sun Solaris10  06/06
EIS-CD 060425
Oracle 10r2.01
Oracle patch 10gr2.02

oldunix

一、安装操作系统Solaris 10 06/06
二、打操作系统的EIS补丁程序

oldunix

三、安装前的准备工作

配置主机网络

RAC1

vi /etc/hosts
#
# Internet host table
#
127.0.0.1       localhost
10.0.9.11       rac1    loghost a.b
10.0.9.12       rac2
100.100.100.11  rac1-priv
100.100.100.12  rac2-priv
10.0.9.13       rac1-vip
10.0.9.14       rac2-vip

vi /etc/hostname.ce4
rac1-priv

vi /etc/inet/netmasks
10.0.9.0        255.255.255.0
100.100.100.0   255.255.255.0
~
vi /etc/defaultrouter

10.0.9.254


--------------------------------------------------------------------
rac2

vi /etc/hosts

root@rac2 # cat /etc/hosts
#
# Internet host table
#
127.0.0.1       localhost      
10.0.9.12       rac2    loghost a.b
10.0.9.11       rac1
100.100.100.11  rac1-priv
100.100.100.12  rac2-priv
10.0.9.13       rac1-vip        
10.0.9.14       rac2-vip


vi /etc/hostname.ce4

rac2-priv


root@rac1 # vi /etc/inet/netmasks
10.0.9.0        255.255.255.0
100.100.100.0   255.255.255.0


vi /etc/defaultrouter
10.0.9.254

oldunix

修改内核参数
vi /etc/system
set noexec_user_stack=1
set shmsys:shminfo_shmmax=8589934592
set semsys:seminfo_semmap=1024
set semsys:seminfo_semmni=2048
set semsys:seminfo_semmns=2048
set semsys:seminfo_semmsl=2048
set semsys:seminfo_semmnu=2048
set semsys:seminfo_semume=200
set shmsys:shminfo_shmmin=200
set shmsys:shminfo_shmmni=200
set shmsys:shminfo_shmseg=200
set semsys:seminfo_semvmx=32767

oldunix

创建用户组、用户及环境文件
/usr/sbin/groupadd oinstall
/usr/sbin/groupadd dba
/usr/sbin/useradd -g oinstall -G dba  -d /users/oracle -m oracle

$passwd  oracle

oldunix

设置环境变量

编辑文件~oracle/.profile
vi .profile
PATH=/usr/sbin:/usr/bin:/usr/ccs/bin:/usr/openwin/bin:/usr/dt/bin:/usr/platform/SUNW,Sun-Fire-V490/sbin:/opt/sun/bin:/opt/SUNWexplo/bin:/opt/SUNWsneep/bin
export PATH

ORACLE_BASE=/opt/app
export ORACLE_BASE

ORACLE_HOME=/opt/app/crs
#ORACLE_HOME=/opt/app/oracle
#ORACLE_HOME=/opt/app/client
export ORACLE_HOME

#ORACLE_SID=wgdb1
#export ORACLE_SID
#ORACLE_SID=wgdb2
#export ORACLE_SID


MY_CRS=/opt/app/crs
export MY_CRS
MY_ORACLE=/opt/app/oracle
export MY_ORACLE
MY_CLIENT=/opt/app/client
export MY_CLIENT

PATH=$PATH:$MY_CLIENT/bin:$MY_CRS/bin:$MY_ORACLE/bin
export PATH

oldunix

创建目录：

mkdir -p /opt/app
chown oracleinstall  /opt/app

使用BSD r命令方式进行远程认证

vi /etc/hosts.equiv
+rac1
+rac2

vi /etc/hosts.equiv
+rac1
+rac2

su – oracle
$
vi .rhosts
rac1
rac2

oldunix

四、准备共享磁盘
Sun StorEdge3310
        在划分阵列3310时，将10块盘中的8块，做两两RAID 1，另外2块作为Hot Spare盘；将底层的5个RAID 1映射为1个条带化的逻辑硬盘（RAID10）； 1个310M的逻辑盘，1个320M的逻辑盘，1个200GB，另外1个占有剩余的空间。

double controller（双控制器）
pid sid
5        na
5        na

root@rac1 #
vi  /kernel/drv/sd.conf
name="sd" class="scsi" class_prop="atapi" target=5 lun=0;
name="sd" class="scsi" class_prop="atapi" target=5 lun=1;
name="sd" class="scsi" class_prop="atapi" target=5 lun=2;
name="sd" class="scsi" class_prop="atapi" target=5 lun=3;

ocr disk

chown oracleinstall /dev/rdsk/c2t5d0s6
chmod 775 /dev/rdsk/c2t5d0s2
ls -lL /dev/rdsk/c2t5d0s2


voting disk

chown oracleinstall /dev/rdsk/c2t5d1s6
chmod 775 /dev/rdsk/c2t5d1s2

ls -lL  /dev/rdsk/c2t5d1s6

oldunix

五、安装crs、database、companion等软件

六、创建数据库

七、安装client软件

八、升级crs、database软件到102020，并升级db

九、升级client软件

十、优化数据库

十一、备份恢复调试
使用control file做数据库备份

$  rman target /

Recovery Manager: Release 10.2.0.2.0 - Production on Tue Feb 6 16:23:15 2007

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

connected to target database: WGDB (DBID=3244815177)

RMAN>  show all;

using target database control file instead of recovery catalog
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/opt/app/oracle/dbs/snapcf_wgdb1.f'; # default

RMAN>  CONFIGURE CONTROLFILE AUTOBACKUP on;

new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters are successfully stored

RMAN>
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/orabak/backup/controfilebackup/%F';

new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/orabak/backup/controfilebackup/%F';
new RMAN configuration parameters are successfully stored

RMAN> run{
backup format '/orabak/backup/db_%u_%d_%s'  database;
}

RMAN> run{
sql 'alter system archive log current';
backup format '/orabak/backup/ar_%t_%s_%p'  archivelog all delete all input;
}
RMAN> exit

oldunix

创建solaris zone

root@rac1 # cd /orabak
root@rac1 # mkdir zone
root@rac1 # cd zone/
root@rac1 # mkdir orabktest
root@rac1 # ls
orabktest
root@rac1 # pwd
/orabak/zone
root@rac1 # ls
orabktest
root@rac1 # chmod 700 orabktest
root@rac1 #

root@rac1 # zonecfg -z orabktest
orabktest: No such zone configured
Use 'create' to begin configuring a new zone.
zonecfgrabktest> create
zonecfgrabktest> set zonepath=/orabak/zone/orabktest
zonecfgrabktest> set autoboot=true
zonecfgrabktest> add net
zonecfgrabktest:net> set address=10.0.9.15
zonecfgrabktest:net> set physical=ce0
zonecfgrabktest:net> end
zonecfgrabktest>
zonecfgrabktest> info
zonepath: /orabak/zone/orabktest
autoboot: true
pool:
inherit-pkg-dir:
        dir: /lib
inherit-pkg-dir:
        dir: /platform
inherit-pkg-dir:
        dir: /sbin
inherit-pkg-dir:
        dir: /usr
net:
        address: 10.0.9.15
        physical: ce0
zonecfgrabktest> verify
zonecfgrabktest> commit
zonecfgrabktest> ^D
root@rac1 #
root@rac1 # zoneadm -z orabktest install
root@rac1 # zoneadm -z orabktest list -v
  ID NAME             STATUS         PATH                          
   - orabktest        installed      /orabak/zone/orabktest        
root@rac1 # zoneadm -z orabktest boot
root@rac1 # zoneadm -z orabktest list -v
  ID NAME             STATUS         PATH                          
   1 orabktest        running        /orabak/zone/orabktest        



root@rac1 # zlogin -C orabktest
[Connected to zone 'orabktest' console]
104/104

Select a Language

  0. English
  1. Simplified Chinese
  2. Traditional Chinese

Please make a choice (0 - 2), or press h or ? for help: 0
What type of terminal are you using?
1) ANSI Standard CRT
2) DEC VT52
3) DEC VT100
4) Heathkit 19
5) Lear Siegler ADM31
6) PC Console
7) Sun Command Tool
8) Sun Workstation
9) Televideo 910
10) Televideo 925
11) Wyse Model 50
12) X Terminal Emulator (xterms)
13) CDE Terminal Emulator (dtterm)
14) Other
Type the number of your choice and press Return: 3
q Host Name for ce0:2 qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq

  Enter the host name which identifies this system on the network.  The name
  must be unique within your domain; creating a duplicate host name will cause
  problems on the network after you install Solaris.

  A host name must have at least one character; it can contain letters,
  digits, and minus signs (-).


Host name for ce0:2 orabktest                       




设置共享目录

root@rac1 # zonecfg -z orabktest
zonecfgrabktest> add fs
zonecfgrabktest:fs> set dir=/orabak/backup
zonecfgrabktest:fs> set special=/orabak/backup
zonecfgrabktest:fs> set type=lofs
zonecfgrabktest:fs> end
zonecfgrabktest> commit
zonecfgrabktest>
root@rac1 #
root@rac1 #