ITPub博客

首页 > Linux操作系统 > Linux操作系统 > AIX5300-08 HACMP5.4.1 ORACLE10204 RAC 安装(7)

AIX5300-08 HACMP5.4.1 ORACLE10204 RAC 安装(7)

原创 Linux操作系统 作者:westzq1984 时间:2009-04-30 21:03:10 0 删除 编辑

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/,如需转载,请注明出处,否则将追究法律责任。

上一篇: BBED学习
下一篇: Asynchronous Commit
请登录后发表评论 登录
全部评论

注册时间:2009-04-06

  • 博文量
    251
  • 访问量
    953631