Shulou(Shulou.com)06/01 Report--

Oracle Study-AIX6.1 Construction Oracle 10gR2 RAC (3)

I. configure shared storage

[oracle@aix203 ~] $lsdev-c disk

Hdisk0 Available 1S-08-00-8 Other SCSI Disk Drive 0

Hdisk1 Available 1D-08-02 Other FC SCSI Disk Drive

[root@aix204 /] # lsdev-c disk

Hdisk0 Available 1S-08-00-8pm 0 16 Bit LVD SCSI Disk Drive

Hdisk1 Available 1D-08-02 Other FC SCSI Disk Drive

Create a volume group (concurrent volume group) on aix203

[root@aix203 /] # lspv

Hdisk0 000681aa6c0502a7 rootvg active

Hdisk1 0008570c15134e9d rac10_vg

Activate the volume group and view the volume group information:

[root@aix203 /] # varyonvg rac10_vg

[root@aix203 /] # lsvg rac10_vg

VOLUME GROUP: rac10_vg VG IDENTIFIER: 000681aa00004c00000001537b5134d2VG STATE: active PP SIZE: 128megabyte (s) VG PERMISSION: read/write TOTAL PPs: 20480 megabytes) MAX LVs: 256FREE PPs: 160 (20480 megabytes) LVs: 0 USED PPs: 0 (0 megabytes) OPEN LVs: 0 QUORUM: 2 (Enabled) TOTAL PVs: 1 VG DESCRIPTORS: 2STALE PVs: 0 STALE PPs: 0ACTIVE PVs: 1 AUTO ON: noConcurrent: Enhanced-Capable Auto-Concurrent: DisabledVG Mode: Non-Concurrent MAX PPs per VG: 32512 MAX PPs per PV: 1016 MAX PVs: 32LTG size (Dynamic): 256kilobyte (s) AUTO SYNC: NoHOT SPARE: no BB POLICY: relocatable PV RESTRICTION: none INFINITE RETRY: noDISK BLOCK SIZE: 512

Create a logical volume:

[root@aix203 /] # cat mklv.sh

Mklv-y 'rac_ocr'-t' raw' rac10_vg 1mklv-y 'rac_vote'-t' raw' rac10_vg 1mklv-y 'system'-t' raw' rac10_vg 10mklv-y 'sysaux'-t' raw' rac10_vg 5mklv-y 'users'-t' raw' rac10_vg 5mklv-y 'undotbs1'-t' raw' rac10_vg 5mklv-y 'undotbs2'-t' raw' rac10_vg 5mklv-y 'temp' -t 'raw' rac10_vg 5mklv-y' control1_1'-t 'raw' rac10_vg 1mklv-y' control2_2'-t 'raw' rac10_vg 1mklv-y' control3_3'-t 'raw' rac10_vg 1mklv-y' spfile'-t 'raw' rac10_vg 1mklv-y' redo1_1'-t 'raw' rac10_vg 1mklv-y' redo1_2'-t 'raw' rac10_vg 1mklv-y' Redo2_1'-t 'raw' rac10_vg 1mklv-y' redo2_2'-t 'raw' rac10_vg 1mklv-y' example'-t 'raw' rac10_vg 5mklv-y' index'-t 'raw' rac10_vg 5

View logical volume information:

[root@aix203 /] # lsvg-l rac10_vg

Rac10_vg:LV NAME TYPE LPs PPs PVs LV STATE MOUNT POINTrac_ocr raw 1 1 1 closed/syncd N/Arac_vote raw 1 1 1 closed/syncd N/Asystem raw 10 10 1 closed/syncd N/Asysaux raw 5 5 1 closed/syncd N/Ausers raw 5 5 1 closed/syncd N/Aundotbs1 raw 5 5 1 closed/syncd N/Aundotbs2 raw 5 5 1 closed/syncd N/Atemp raw 5 5 1 closed/syncd N/Acontrol1_1 Raw 1 1 1 closed/syncd N/Acontrol2_2 raw 1 1 1 closed/syncd N/Acontrol3_3 raw 1 1 1 closed/syncd N/Aspfile raw 1 1 1 closed/syncd N/Aredo1_1 raw 1 1 1 closed/syncd N/Aredo1_2 raw 1 1 1 closed/syncd N/Aredo2_1 raw 1 1 1 closed/syncd N/Aredo2_2 raw 1 1 1 closed/syncd N/Aexample raw 5 5 1 closed/syncd N/Aindex Raw 5 5 1 closed/syncd N/A

Import volume group information in another node:

[root@aix204 /] # varyonvg rac10_vg

[root@aix204 /] # lsvg-l rac10_vg

Rac10_vg:LV NAME TYPE LPs PPs PVs LV STATE MOUNT POINTrac_ocr raw 1 1 1 closed/syncd N/Arac_vote raw 1 1 1 closed/syncd N/Asystem raw 10 10 1 closed/syncd N/Asysaux raw 5 5 1 closed/syncd N/Ausers raw 5 5 1 closed/syncd N/Aundotbs1 raw 5 5 1 closed/syncd N/Aundotbs2 raw 5 5 1 closed/syncd N/Atemp raw 5 5 1 closed/syncd N/Acontrol1_1 Raw 1 1 1 closed/syncd N/Acontrol2_2 raw 1 1 1 closed/syncd N/Acontrol3_3 raw 1 1 1 closed/syncd N/Aspfile raw 1 1 1 closed/syncd N/Aredo1_1 raw 1 1 1 closed/syncd N/Aredo1_2 raw 1 1 1 closed/syncd N/Aredo2_1 raw 1 1 1 closed/syncd N/Aredo2_2 raw 1 1 1 closed/syncd N/Aexample raw 5 5 1 closed/syncd N/Aindex Raw 5 5 1 closed/syncd N/A

2. Install and configure HACMP

HACMP Software version 6.1

The following software (AIX system disk) needs to be installed in advance:

1) install hacmp

MISSING REQUISITES: The following filesets are required by one or more of the selected filesets listed above. They are not currently installed and could not be found on the installation media. Bos.adt.syscalls 5.3.7.0 # Base Level Fileset bos.data 5.1.0.0 # Base Level Fileset bos.data 5.3.0.0 # Base Level Fileset bos.net.nfs.server 5.3.7.0 # Base Level Fileset [root@aix203 soft1] # lslpp-l | | grep bos.adt.sys bos.adt.syscalls 6.1.9.0 COMMITTED System Calls Application [root@aix203 soft1] # lslpp-l | grep bos.data bos.data 6.1.6.15 COMMITTED Base Operating System Data [root@aix203 soft1] # lslpp-l | grep bos.net.nfs bos.net.nfs.adt 6.1.9.0 COMMITTED Network File System bos.net.nfs.cachefs 6.1.9 | . 0 COMMITTED CacheFS File System bos.net.nfs.client 6.1.9.0 COMMITTED Network File System Client bos.net.nfs.server 6.1.8.0 COMMITTED Network File System Server bos.net.nfs.cachefs 6.1.9.0 COMMITTED CacheFS File System bos.net.nfs.client 6.1.9.0 COMMITTED Network File System Client

Install the hacmp software through smit:

[root@aix203 soft1] # lslpp-l | grep cluster

Bos.cluster.rte 6.1.9.0 COMMITTED Cluster Aware AIX cluster.adt.es.client.include cluster.adt.es.client.samples.clinfo cluster.adt.es.client.samples.clstat cluster.adt.es.client.samples.libcl cluster.adt.es.java.demo.monitor cluster.doc.en_US.assist.db2.html cluster.doc.en_US.assist.db2.pdf cluster.doc.en_US.assist.oracle.html cluster.doc.en_ US.assist.oracle.pdf cluster.doc.en_US.assist.websphere.html cluster.doc.en_US.assist.websphere.pdf cluster.doc.en_US.es.html 6.1.0.0 COMMITTED HAES Web-based HTML cluster.doc.en_US.es.pdf 6.1.0.0 COMMITTED HAES PDF Documentation-room.cluster.es.assist.common 6.1.0.0 COMMITTED HACMP Smart Assist Common cluster.es.assist.db2 6.1.0 . 0 COMMITTED HACMP Smart Assist for DB2 cluster.es.assist.oracle 6.1.0.0 COMMITTED HACMP Smart Assist for Oracle cluster.es.assist.sap 6.1.0.0 COMMITTED HACMP Smart Assist for SAP cluster.es.assist.websphere cluster.es.cfs.rte 6.1.0.0 COMMITTED ES Cluster File System Support cluster.es.client.clcomd 6.1.0.0 COMMITTED ES Cluster Communication cluster.es.client.lib 6.1.0.0 COMMITTED ES Client Libraries cluster.es.client.rte 6.1.0.0 COMMITTED ES Client Runtime cluster.es.client.utils 6.1.0.0 COMMITTED ES Client Utilities cluster.es.client.wsm 6.1.0.0 COMMITTED Web based Smit cluster.es.cspoc.cmds 6.1.0.0 COMMITTED ES CSPOC Commands cluster.es.cspoc.dsh 6.1.0.0 COMMITTED ES CSPOC dsh cluster.es.cspoc.rte 6.1.0.0 COMMITTED ES CSPOC Runtime Commands cluster.es.nfs.rte 6.1.0.0 COMMITTED ES NFS Support cluster.es.plugins.dhcp 6.1.0.0 COMMITTED ES Plugins-dhcp cluster.es.plugins.dns 6.1.0.0 COMMITTED ES Plugins-Name Server cluster.es.plugins.printserver cluster.es.server.cfgast 6.1.0.0 COMMITTED ES Two-Node Configuration cluster.es.server.diag 6.1.0.0 COMMITTED ES Server Diags cluster.es.server .events 6.1.0.0 COMMITTED ES Server Events cluster.es.server.rte 6.1.0.0 COMMITTED ES Base Server Runtime cluster.es.server.testtool cluster.es.server.utils 6.1.0.0 COMMITTED ES Server Utilities cluster.es.worksheets 6.1.0.0 COMMITTED Online Planning Worksheets cluster.license 6.1.0.0 COMMITTED HACMP Electronic License mcr.rte 6.1.9.0 COMMITTED Metacluster Checkpoint And bos.cluster.rte 6.1.9.0 COMMITTED Cluster Aware AIX cluster.es.assist.db2 6.1.0.0 COMMITTED HACMP Smart Assist for DB2 cluster.es.assist.oracle 6.1.0.0 COMMITTED HACMP Smart Assist for Oracle cluster.es.assist.sap 6.1.0.0 COMMITTED HACMP Smart Assist for SAP cluster.es.assist.websphere cluster.es.client.clcomd 6.1.0.0 COMMITTED ES Cluster Communication cluster.es.client. Lib 6.1.0.0 COMMITTED ES Client Libraries cluster.es.client.rte 6.1.0.0 COMMITTED ES Client Runtime cluster.es.client.wsm 6.1.0.0 COMMITTED Web based Smit cluster.es.cspoc.rte 6.1.0.0 COMMITTED ES CSPOC Runtime Commands cluster.es.nfs.rte 6.1.0.0 COMMITTED ES NFS Support cluster.es.server.diag 6.1.0.0 COMMITTED ES Server Diags cluster. Es.server.events 6.1.0.0 COMMITTED ES Server Events cluster.es.server.rte 6.1.0.0 COMMITTED ES Base Server Runtime cluster.es.server.utils 6.1.0.0 COMMITTED ES Server Utilities mcr.rte 6.1.9.0 COMMITTED Metacluster Checkpoint and cluster.man.en_US.assist.data cluster.man.en_US.es.data 6.1.0.0 COMMITTED ES Man Pages-room.English

2) configure hacmp

1. Configure cluster to add node

Configure the Cluster network:

Configure the network communication interface:

Modify network properties:

Start the service on node:

[root@aix203 /] # / usr/bin/startsrc-s clcomdES

[root@aix204 /] # / usr/bin/startsrc-s clcomdES

Configure network parameters on both node for synchronization:

[root@aix203 /] # cat / usr/es/sbin/cluster/etc/rhosts

192.168.8.203

192.168.8.204

192.168.8.251

192.168.8.252

10.10.10.203

10.10.10.204

[root@aix203 /] # cat / usr/sbin/cluster/netmon.cf

192.168.8.203

192.168.8.204

192.168.8.251

192.168.8.252

10.10.10.203

10.10.10.204

Configure hacmp synchronization:

Configure hacmp resource groups:

Add a concurrent volume group to a resource group:

Synchronize the hacmp configuration again!

Start the hacmp service:

View the hacmp service:

[root@aix203 soft1] # lumped cards c-a | grep cl

Clcomd caa 5046426 active

ClcomdES clcomdES 5767410 active

ClstrmgrES cluster 3801194 active

Gsclvmd 6488150 active

Clconfd caa inoperative

Nimsh nimclient inoperative

3. Check the concurrency status of volume groups

[root@aix203 soft1] # lspv

Hdisk0 000681aa6c0502a7 rootvg active

Hdisk1 0008570c15134e9d rac10_vg concurrent

[root@aix203 soft1] # lsvg-l rac10_vg

Rac10_vg:LV NAME TYPE LPs PPs PVs LV STATE MOUNT POINTrac_ocr raw 1 1 1 closed/syncd N/Arac_vote raw 1 1 1 closed/syncd N/Asystem raw 10 10 1 closed/syncd N/Asysaux raw 5 5 1 closed/syncd N/Ausers raw 5 5 1 closed/syncd N/Aundotbs1 raw 5 5 1 closed/syncd N/Aundotbs2 raw 5 5 1 closed/syncd N/Atemp raw 5 5 1 closed/syncd N/Acontrol1_1 Raw 1 1 1 closed/syncd N/Acontrol2_2 raw 1 1 1 closed/syncd N/Acontrol3_3 raw 1 1 1 closed/syncd N/Aspfile raw 1 1 1 closed/syncd N/Aredo1_1 raw 1 1 1 closed/syncd N/Aredo1_2 raw 1 1 1 closed/syncd N/Aredo2_1 raw 1 1 1 closed/syncd N/Aredo2_2 raw 1 1 1 closed/syncd N/Aexample raw 5 5 1 closed/syncd N/Aindex Raw 5 5 1 closed/syncd N/A

[root@aix204 /] # lspv

Hdisk0 0003504af4d8495b rootvg active

Hdisk1 0008570c15134e9d rac10_vg concurrent

-after the volume group is in a concurrent state, the hacmp configuration is successful!

Modify logical volume properties:

[root@aix204 /] # cat chlv.sh

Chown oracle:dba / dev/rac_ocrchown oracle:dba / dev/rac_votechown oracle:dba / dev/systemchown oracle:dba / dev/sysauxchown oracle:dba / dev/userschown oracle:dba / dev/undotbs1chown oracle:dba / dev/undotbs2chown oracle:dba / dev/tempchown oracle:dba / dev/control1_1chown oracle:dba / dev/control2_2chown oracle:dba / dev/control3_3chown oracle:dba / dev/spfilechown oracle:dba / dev/redo1_1chown oracle:dba / dev/redo1_2chown oracle:dba / dev/redo2 _ 1chown oracle:dba / dev/redo2_2chown oracle:dba / dev/examplechown oracle:dba / dev/indexchown oracle:dba / dev/rrac_ocrchown oracle:dba / dev/rrac_votechown oracle:dba / dev/rsystemchown oracle:dba / dev/rsysauxchown oracle:dba / dev/ruserschown oracle:dba / dev/rundotbs1chown oracle:dba / dev/rundotbs2chown oracle:dba / dev/rtempchown oracle:dba / dev/rcontrol1_1chown oracle:dba / dev/rcontrol2_2chown oracle:dba / dev/rcontrol3_3chown oracle:dba / dev/rspfilechown oracle : dba / dev/rredo1_1chown oracle:dba / dev/rredo1_2chown oracle:dba / dev/rredo2_1chown oracle:dba / dev/rredo2_2chown oracle:dba / dev/rexamplechown oracle:dba / dev/rindexchmod 660 / dev/rac_ocrchmod 660 / dev/rac_votechmod 660 / dev/systemchmod 660 / dev/sysauxchmod 660 / dev/userschmod 660 / dev/undotbs1chmod 660 / dev/undotbs2chmod 660 / dev/tempchmod 660 / dev/control1_1chmod 660 / dev/control2_2chmod 660 / dev/control3_3chmod 660 / dev/spfilechmod 660 / dev/redo1_1chmod 660 / dev/redo1_2chmod 660 / dev/redo2_1chmod 660 / dev/redo2_2chmod 660 / dev/examplechmod 660 / dev/indexchmod 660 / dev/rrac_ocrchmod 660 / dev/rrac_votechmod 660 / dev/rsystemchmod 660 / dev/rsysauxchmod 660 / dev/ruserschmod 660 / dev/rundotbs1chmod 660 / dev/rundotbs2chmod 660 / dev/rtempchmod 660 / dev/rcontrol1_1chmod 660 / dev/rcontrol2_2chmod 660 / dev/rcontrol3_3chmod 660 / dev/rspfilechmod 660 / dev/rredo1_1chmod 660 / dev/rredo1_ 2chmod 660 / dev/rredo2_1chmod 660 / dev/rredo2_2chmod 660 / dev/rexamplechmod 660 / dev/rindex

[root@aix204 /] # sh chlv.sh

[root@aix204 /] # ls-l / dev | grep ocr

Brw-rw---- 1 oracle dba 88, 1 Mar 15 16:01 rac_ocr

Crw-rw---- 1 oracle dba 88, 1 Mar 15 16:08 rrac_ocr

[root@aix204 /] # ls-l / dev | grep vote

Brw-rw---- 1 oracle dba 88, 2 Mar 15 16:01 rac_vote

Crw-rw---- 1 oracle dba 88, 2 Mar 15 16:08 rrac_vote

[root@aix204 /] #

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.