AIX5300-08 HACMP5.4.1 ORACLE10204 RAC 安装（7）
1.http://space.itpub.net/8242091/viewspace-591195
2.http://space.itpub.net/8242091/viewspace-591198
3.http://space.itpub.net/8242091/viewspace-591199
4.http://space.itpub.net/8242091/viewspace-591200
5.http://space.itpub.net/8242091/viewspace-591201
6.http://space.itpub.net/8242091/viewspace-591202
下面按照数据库软件，10203，10204的步骤安装数据库软件
安装完成后，建立监听
然后创建数据库，一切正常，如果操作系统的包，补丁打够了，是不会出问题的
归档，备份配置
配置NFS
bash-3.00# lssrc -g nfs
Subsystem Group PID Status
biod nfs 262284 active
rpc.statd nfs 344180 active
rpc.lockd nfs 295122 active
nfsd nfs inoperative
rpc.mountd nfs inoperative
nfsrgyd nfs inoperative
gssd nfs inoperative
bash-3.00# startsrc -g nfs
0513-029 The biod Subsystem is already active.
Multiple instances are not supported.
0513-059 The nfsd Subsystem has been started. Subsystem PID is 565480.
0513-059 The rpc.mountd Subsystem has been started. Subsystem PID is 598204.
0513-059 The nfsrgyd Subsystem has been started. Subsystem PID is 577692.
0513-059 The gssd Subsystem has been started. Subsystem PID is 593936.
0513-029 The rpc.lockd Subsystem is already active.
Multiple instances are not supported.
0513-029 The rpc.statd Subsystem is already active.
Multiple instances are not supported.
bash-3.00# lssrc -g nfs
Subsystem Group PID Status
biod nfs 262284 active
rpc.statd nfs 344180 active
rpc.lockd nfs 295122 active
nfsd nfs 565480 active
rpc.mountd nfs 598204 active
nfsrgyd nfs inoperative
gssd nfs inoperative
bash-3.00# cat /etc/exports （P61A）
/u01/arch1 -sec=sys:krb5p:krb5i:krb5:dh:none,rw,access=P61B
bash-3.00# cat /etc/exports （P61B）
/u01/arch2 -sec=sys:krb5p:krb5i:krb5:dh:none,rw,access=P61A
bash-3.00# /usr/sbin/exportfs -a （P61A）
bash-3.00# /usr/sbin/exportfs
/u01/arch1 -sec=sys:krb5p:krb5i:krb5:dh:none,rw,access=P61A
bash-3.00# /usr/sbin/exportfs -a （P61B）
bash-3.00# /usr/sbin/exportfs
/u01/arch2 -sec=sys:krb5p:krb5i:krb5:dh:none,rw,access=P61A
bash-3.00# showmount -e P61A
export list for P61A:
/u01/arch1 P61B
bash-3.00# showmount -e P61B
export list for P61B:
/u01/arch2 P61A
bash-3.00# lssrc -s portmap （P61A）
Subsystem Group PID Status
portmap portmap 188576 active
bash-3.00# lssrc -s portmap （P61B）
Subsystem Group PID Status
portmap portmap 184482 active
bash-3.00# cat /etc/filesystems |tail -n 8 （P61A）
/u01/arch2:
dev = /u01/arch2
vfs = nfs
nodename = P61B
mount = false
type = nfs3
options = soft,intr,retry=2,rsize=32768,wsize=32768,timeo=300,proto=tcp
account = false
bash-3.00# cat /etc/filesystems |tail -n 8 （P61B）
dev = /u01/arch1
vfs = nfs
nodename = P61A
mount = false
type = nfs3
options = soft,intr,retry=2,rsize=32768,wsize=32768,timeo=300,proto=tcp
account = false
bash-3.00# /usr/bin/rpcinfo -u P61A mount
program 100005 version 1 ready and waiting
program 100005 version 2 ready and waiting
program 100005 version 3 ready and waiting
bash-3.00# /usr/bin/rpcinfo -u P61B mount
program 100005 version 1 ready and waiting
program 100005 version 2 ready and waiting
program 100005 version 3 ready and waiting
bash-3.00# /usr/bin/rpcinfo -u P61A portmap
program 100000 version 2 ready and waiting
program 100000 version 3 ready and waiting
program 100000 version 4 ready and waiting
bash-3.00# /usr/bin/rpcinfo -u P61B portmap
program 100000 version 2 ready and waiting
program 100000 version 3 ready and waiting
program 100000 version 4 ready and waiting
bash-3.00# /usr/bin/rpcinfo -u P61A nfs
program 100003 version 2 ready and waiting
program 100003 version 3 ready and waiting
bash-3.00# /usr/bin/rpcinfo -u P61B nfs
program 100003 version 2 ready and waiting
program 100003 version 3 ready and waiting
bash-3.00# mount /u01/arch2 （P61A）
bash-3.00# df -m
Filesystem MB blocks Free %Used Iused %Iused Mounted on
/dev/hd4 1024.00 970.32 6% 4373 2% /
/dev/hd2 6144.00 4582.88 26% 36672 4% /usr
/dev/hd9var 1024.00 932.92 9% 718 1% /var
/dev/hd3 2048.00 1852.37 10% 612 1% /tmp
/dev/hd1 1024.00 1023.51 1% 5 1% /home
/proc - - - - - /proc
/dev/hd10opt 1024.00 910.00 12% 3286 2% /opt
/dev/fslv00 20224.00 9050.27 56% 40315 2% /u01
P61B:/u01/arch2 20480.00 9264.73 55% 40939 2% /u01/arch2
bash-3.00# mount /u01/arch1 （P61B）
bash-3.00# df -m
Filesystem MB blocks Free %Used Iused %Iused Mounted on
/dev/hd4 1024.00 972.93 5% 4348 2% /
/dev/hd2 6144.00 4582.88 26% 36670 4% /usr
/dev/hd9var 1024.00 963.19 6% 685 1% /var
/dev/hd3 2048.00 1374.85 33% 1765 1% /tmp
/dev/hd1 1024.00 1023.51 1% 5 1% /home
/proc - - - - - /proc
/dev/hd10opt 1024.00 910.00 12% 3286 2% /opt
/dev/fslv00 20480.00 9264.73 55% 40939 2% /u01
P61A:/u01/arch1 20224.00 9050.27 56% 40315 2% /u01/arch1
配置归档
SQL> alter system set cluster_database=false scope=spfile sid='rac1';
System altered.
SQL> alter system set log_archive_dest_1='LOCATION=/u01/arch1 MANDATORY REOPEN' scope=spfile sid='rac1';
System altered.
SQL> alter system set log_archive_dest_1='LOCATION=/u01/arch2 MANDATORY REOPEN' scope=spfile sid='rac2';
System altered.
SQL> alter system set LOG_ARCHIVE_FORMAT='%t_%s_%r' scope=spfile sid='*';
System altered.
-------------------------------------------------------------------
[oracle@P61A:/u01]$srvctl stop database -d rac
-------------------------------------------------------------------
SQL> startup mount
ORACLE instance started.
Total System Global Area 293601280 bytes
Fixed Size 2083536 bytes
Variable Size 113247536 bytes
Database Buffers 171966464 bytes
Redo Buffers 6303744 bytes
Database mounted.
SQL> alter database archivelog;
Database altered.
SQL> alter system set cluster_database=true scope=spfile sid='*';
System altered.
SQL> shutdown immediate
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 293601280 bytes
Fixed Size 2083536 bytes
Variable Size 113247536 bytes
Database Buffers 171966464 bytes
Redo Buffers 6303744 bytes
Database mounted.
Database opened.
-------------------------------------------------------------------
节点2启动报错
SQL> startup
ORA-29707: inconsistent value 2 for initialization parameter cluster_database_instances with other instances
SQL> show parameter cluster 参数没有修改成功
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
cluster_database boolean FALSE
cluster_database_instances integer 1
cluster_interconnects string
SQL> alter system set cluster_database=true scope=spfile sid='rac1';
System altered.
SQL> alter system set cluster_database_instances=2 scope=spfile sid='rac1';
System altered.
把节点1关闭，重启
-------------------------------------------------------------------
P61A
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u01/arch1
Oldest online log sequence 4
Next log sequence to archive 5
Current log sequence 5
P61B
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u01/arch2
Oldest online log sequence 1
Next log sequence to archive 1
Current log sequence 1
SQL> alter system archive log current ;
System altered.
[oracle@P61B:/u01]$ls -l arch*
arch1:
total 109232
-rw-r----- 1 oracle oinstall 55926272 Apr 30 20:49 1_5_685561534
arch2:
total 14352
-rw-r----- 1 oracle oinstall 7347200 Apr 30 20:49 2_1_685561534
[oracle@P61A:/u01]$ls -l arch*
arch1:
total 109232
-rw-r----- 1 oracle oinstall 55926272 Apr 30 20:49 1_5_685561534
arch2:
total 14352
-rw-r----- 1 oracle oinstall 7347200 Apr 30 20:49 2_1_685561534
完结，过段时间把9i的安装也总结下
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/8242091/viewspace-592406/ ，如需转载，请注明出处，否则将追究法律责任。
