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部落格 ” ，連結：http://blog.itpub.net/8242091/viewspace-592406/，如需轉載，請註明出處，否則將追究法律責任。

AIX5300-08 HACMP5.4.1 ORACLE10204 RAC 安裝（7）

歸檔，備份配置

配置NFS

配置歸檔

相關文章