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

Solaris 10 (x86) to build Oracle 11gR2 RAC-- configure system environment (1)

System environment:

Operating system: Solaris 10 (x86-64)

Cluster: Oracle GRID 11.2.0

Oracle: Oracle 11.2.0.1.0

As shown in the figure: RAC system architecture

For Oracle 11G to build RAC, we first need to build the architecture of GI (Grid Infrastructure).

The second edition of Oracle 11g has a great improvement over the first edition in terms of new functions. Here we briefly introduce the new features used in this installation, mainly integrating Clusterware clusterware into Grid grid components, and adding Grid Naming Service (GNS) grid name service to provide name translation, so that the virtual IP addresses (VIP) of the two RAC nodes can be obtained automatically through DHCP, without the need to specify them manually. This is a big change.

There is also Cluster Time Synchronization Service (CTSS) cluster time synchronization service, which ensures that the time of all RAC nodes is the same when there is no NTP service. ASM can install Oracle Cluster Registry (OCR) and Voting disks on ASM disk as unified storage, eliminating the need to install cluster file system separately, and 11g second version no longer supports bare devices (previously, cluster components can be installed on bare devices)

There is also an interesting feature, SCAN (Single Client Access Name), that is, the single client access name, and this function includes the Failover failover function. Only one SCAN name can be written in the access cluster, and there is no need to write the VIP of all nodes in the application configuration file, which greatly facilitates the client program's access to the RAC system, but this function requires the support of the DNS server. This feature will be highlighted in this article because I am an application programmer and feel that this is the best new feature, and it is also very convenient when connecting RAC systems with the Spring framework. There are also some new features such as

Automatic Storage Management Cluster File System (ACFS) ASM cluster file system and Intelligent Platform. Management Interface (IPMI) integration and so on.

In this case, through the Solairs 10 (x86-64) system, the RAC; shared storage of Oracle 11g is managed by RAW+ASM.

1. System environment configuration (in all node)

1. Operating system:

[root@node1:/] # uname-aSunOS node1 5.10 Generic_142910-17 i86pc i386 i86pc [root@node1:/] # isainfo-kv64-bit amd64 kernel modules

2. Network configuration:

[root@node1:/] # cat / etc/hosts## Internet host table#::1 localhost 127.0.0.1 localhost 192.168.11 node1 loghost192.168.8.13 node1-vip10.10.10.11 node1-priv192.168.8.12 node2192.168.8.14 node2-vip10.10.10.12 node2-priv192.168.8.15 scan-ip--- this case is a test environment and DNS Server is not configured For SCAN ip, use hosts file to parse the network card configuration information: [root@node1:/] # ifconfig-alo0: flags=2001000849 mtu 8232 index 1 inet 127.0.0.1 netmask ff000000 e1000g0: flags=1000843 mtu 1500 index 2 inet 192.168.11 netmask ffffff00 broadcast 192.168.255 ether 8:0:27:e9:13:c7 e1000g0:1: flags=1000843 mtu 1500 index 2 inet 192.168.13 netmask ffffff00 broadcast 192.168.8. 255e1000g1: flags=1000843 mtu 1500 index 3 inet 10.10.10.11 netmask ffffff00 broadcast 10.10.10.255 ether 8:0:27:54:d5:2c [root@node2:/] # ifconfig-alo0: flags=2001000849 mtu 8232 index 1 inet 127.0.0.1 netmask ff000000 e1000g0: flags=1000843 mtu 1500 index 2 inet 192.168.12 netmask ffffff00 broadcast 192.168.255 ether 8:0:27:9f:cd:76 E1000g0:1: flags=1000843 mtu 1500 index 2 inet 192.168.8.14 netmask ffffff00 broadcast 192.168.8.255e1000g1: flags=1000843 mtu 1500 index 3 inet 10.10.10.12 netmask ffffff00 broadcast 10.10.10.255 ether 8:0:27:3c:6d:ce

3. Establish oracle and grid users and groups:

[root@node1:/] # cat mkusr.shgroupadd-g 200 oinstallgroupadd-g 201 dbagroupadd-g 202 opergroupadd-g 203 asmadmingroupadd-g 204asmopergroupadd-g 205 asmdbauseradd-u 200-g oinstall-G dba,asmdba,oper-d / export/home/oracle-m-s / usr/bin/bash oracleuseradd-u 201-g oinstall-G asmadmin,asmdba,asmoper,oper Dba-d / export/home/grid-m-s / usr/bin/bash grid [root@node1:/] # id-an oracleuid=200 (oracle) gid=200 (oinstall) groups=201 (dba), 202 (oper), 205 (asmdba) [root@node1:/] # id-a griduid=201 (grid) gid=200 (oinstall) groups=201 (dba), 202 (oper), 203 (asmadmin), 204 (asmoper), 205 (asmdba)

4. Set up the corresponding installation directory:

[root@node1:/] # cat mkdir.shmkdir-p / export/home/oraInventorychown-R grid:oinstall / export/home/oraInventory/chmod-R 775 / export/home/oraInventory/mkdir-p / export/home/11.2.0/gridchown-R grid:oinstall / export/home/11.2.0/grid/chmod-R 775 / export/home/11.2.0/grid/mkdir-p / export/home/ora11mkdir-p / export/home/ora11/cfgtoollogsmkdir-p / export/home/ora11 / product/11.2.0/db_1chown-R oracle:oinstall / export/home/ora11chmod-R 775 / export/home/ora11 [root@node1:/] # ls-l / export/hometotal 26drwxr-xr-x 3 root root 512 Jan 22 16:18 11.2.0drwxr-xr-x 2 grid oinstall 512 Jan 22 16:10 griddrwx- 2 root root 8192 Oct 15 2013 lost+founddrwxrwxr-x 4 oracle oinstall 512 Jan 22 16:18 ora11drwxrwxr-x 2 grid oinstall 512 Jan 22 16:18 oraInventorydrwxr-xr-x 2 oracle oinstall 512 Jan 22 16:11 oracle

5. Establish oracle and grid user environment variables:

[oracle@node1:/export/home/oracle] $cat .profileexport EDITOR=viexport ORACLE_SID=prod1;; ORACLE_SID=prod2 (node2) export ORACLE_BASE=/export/home/ora11export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1export LD_LIBRARY_PATH=$ORACLE_HOME/libexport PATH=$ORACLE_HOME/bin:/bin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/X11R6/binumask 022 [grid@node1:/export/home/grid] $cat .profileexport EDITOR=viexport ORACLE_SID=+ASM1 ORACLE_SID=+ASM2 (node2) export ORACLE_BASE=/export/home/ora11export ORACLE_HOME=/export/home/11.2.0/gridexport GRID_HOME=/export/home/11.2.0/gridexport LD_LIBRARY_PATH=$ORACLE_HOME/libexport THREADS_FLAG=nativeexport PATH=$ORACLE_HOME/bin:/bin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/X11R6/binumask 022

6. Configure network parameters (for cache fusion)

Check the network parameters: [root@node1:/] # / usr/sbin/ndd / dev/tcp tcp_smallest_anon_port tcp_largest_anon_ port3276865535 [root @ node1:/] # cat mknet.sh/usr/sbin/ndd-set / dev/tcp tcp_smallest_anon_port 9000/usr/sbin/ndd-set / dev/tcp tcp_largest_anon_port 65500/usr/sbin/ndd-set / dev/udp udp_smallest_anon_port 9000/usr/sbin/ndd-set / dev/udp udp_largest_anon_port 65500 [root@node1:/] # / usr/sbin/ndd / dev/tcp tcp_smallest_anon_port tcp_largest_anon_port900065500

7. Modify kernel parameters:

[root@node2:/] # cat / etc/systemset noexec_user_stack=1set semsys:seminfo_semmni=100set semsys:seminfo_semmns=1024set semsys:seminfo_semmsl=256set semsys:seminfo_semvmx=32767set shmsys:shminfo_shmmax=4294967295set shmsys:shminfo_shmmni=100

8. Configure shell resource access:

[root@node1:/] # cat / etc/profileulimit-t unlimitedulimit-f unlimitedulimit-d unlimitedulimit-s unlimitedulimit-n unlimitedulimit-v unlimited

Second, configure shared storage

For Oracle 11g RAC, OCR and VOTE disks in shared storage can no longer be used as bare devices, but are managed through ASM disk groups. OCR and VOTE disks: (create ASM NORMAL REDUNDANCY) OCR_VOTE DISK1 / dev/rdsk/c0t2d0s0 OCR_VOTE DISK1 / dev/rdsk/c0t2d0s1 OCR_VOTE DISK1 / dev/rdsk/c0t2d0s3 DataBase disks: (create ASM NORMAL REDUNDANCY) ASM_DATA1 / dev/rdsk/c0t2d0s4 ASM_DATA2 / dev/rdsk/c0t2d0s5 RECOVERY AREA: (establishing ASM NORMAL REDUNDANCY) ASM_RCY1 / dev/rdsk/c0t2d0s6 ASM_RCY1 / dev/rdsk/c0t2d0s7

1. Create a disk partition (raw) (in node1)

Note:

When partitioning, you can't start with Cylinder 0. Instead, you should start with Cylinder 1, partition and set up raw devices.

[root@node1:/] # format Searching for disks...doneAVAILABLE DISK SELECTIONS: 0. C0t0d0 / pci@0,0/pci8086,2829@d/disk@0,0 1. C0t2d0 / pci@0,0/pci8086,2829@d/disk@2,0Specify disk (enter its number): 1selecting c0t2d0 [disk formatted] format > pWARNING-This disk may be in use by an application that has modified the fdisk table. Ensure that this disk is not currently in use before proceeding to use fdisk.format > fdiskNo fdisk table exists. The default partition for the disk is: a 100% "SOLARIS System" partitionType "y" to accept the default partition, otherwise type "n" to edit the partition table.ypartition > 0Part Tag Flag Cylinders Size Blocks 0 unassigned wm 00 0Enter partition id tag [unassigned]: Enter partition permission flags [wm]: Enter new starting cyl [0]: 1Enter partition size [0b, 0c, 1e, 0.00mb 0.00gb]: 1024mbpartition > 1Part Tag Flag Cylinders Size Blocks 1 unassigned wm 00 (0 unassigned) 0Enter partition id tag [unassigned]: Enter partition permission flags [wm]: Enter new starting cyl [0]: 132Enter partition size [0b, 0c, 132e, 0.00mb 0.00gb]: 1024mbpartition > 3Part Tag Flag Cylinders Size Blocks 3 unassigned wm 00 (0 unassigned) 0Enter partition id tag [unassigned]: Enter partition permission flags [wm]: Enter new starting cyl [0]: 263Enter partition size [0b, 0c, 263e, 0.00mb 0.00gb]: 1024mbpartition > 4Part Tag Flag Cylinders Size Blocks 4 unassigned wm 00 (0 unassigned) 0Enter partition id tag [unassigned]: Enter partition permission flags [wm]: Enter new starting cyl [0]: 394Enter partition size [0b, 0c, 394e, 0.00mb 0.00gb]: 5gbpartition > 5Part Tag Flag Cylinders Size Blocks 5 unassigned wm 00 (0 unassigned) 0Enter partition id tag [unassigned]: Enter partition permission flags [wm]: Enter new starting cyl [0]: 1047 Enter partition size [0b, 0c, 1047e, 0.00mb 0.00gb]: 5gbpartition > 5Part Tag Flag Cylinders Size Blocks 5 unassigned wm 00 (0 unassigned) 0Enter partition id tag [unassigned]: Enter partition permission flags [wm]: Enter new starting cyl [0]: 1047 Enter partition size [0b, 0c, 1047e, 0.00mb 0.00gb]: 5gbpartition > 6Part Tag Flag Cylinders Size Blocks 6 unassigned wm 00 (0 unassigned) 0Enter partition id tag [unassigned]: Enter partition permission flags [wm]: Enter new starting cyl [0]: 1700Enter partition size [0b, 0c, 1700e, 0.00mb 0.00gb]: 3gbpartition > 7Part Tag Flag Cylinders Size Blocks 7 unassigned wm 00 (0 unassigned) 0Enter partition id tag [unassigned]: Enter partition permission flags [wm]: Enter new starting cyl [0]: 2092Enter partition size [0b, 0c, 2092e, 0.00mb 0.00gb]: 3gbpartition > pCurrent partition table (unnamed): Total disk cylinders available: 2607 + 2 (reserved cylinders) Part Tag Flag Cylinders Size Blocks 0 unassigned wm 1-1311.00GB (131-0-0) 2104515 1 unassigned wm 13262 1.00GB (131-0-0) 2104515 2 backup wu 0-2606 19.97GB ( 2607-0-0) 41881455 3 unassigned wm 263-3931.00GB (131-0-0) 2104515 4 unassigned wm 394-1046 5.00GB (653-0-0) 10490445 5 unassigned wm 1047-1699 5.00GB (653-0-0) 10490445 6 unassigned wm 17002091 3.00GB (392-0-0) 6297480 7 unassigned wm 20922483 3.00GB (392-0-0) 6297480 8 boot wu 0-0 7.84MB (1-0-0) 16065 9 unassigned wm 00 (0 Unip 0) 0partition > labelReady to label disk Continue? Ypartition > quit to view disk partition information in node2: [root@node2:/] # formatSearching for disks...doneAVAILABLE DISK SELECTIONS: 0. C0t0d0 / pci@0,0/pci8086,2829@d/disk@0,0 1. C0t2d0 / pci@0,0/pci8086,2829@d/disk@2,0Specify disk (enter its number): 1selecting c0t2d0 [disk formatted] .partition > pCurrent partition table (original): Total disk cylinders available: 2607 + 2 (reserved cylinders) Part Tag Flag Cylinders Size Blocks 0 unassigned wm 1-1311.00GB 2104515 1 unassigned wm 132-262 1.00GB (131-0-0) 2104515 2 backup wu 0-2606 19.97GB (2607-0-0) 41881455 3 unassigned wm 263-393 1.00GB (131-0-0) 2104515 4 unassigned wm 394-1046 5.00GB (653-0-0) 10490445 5 unassigned wm 1047-1699 5.00GB (653-0-0) 10490445 6 unassigned wm 1700-2091 3.00GB (392-0-0) 6297480 7 unassigned wm 2092-2483 3.00GB (392-0-0) 6297480 8 boot wu 0-0 7.84MB (1-0-0) 16065 9 unassigned wm 00 Modify raw device properties (all node): [root@node1:/] # chown grid:asmadmin / dev/rdsk/c0t2d0s* [root@node1:/] # chmod 660 / dev/rdsk/c0t2d0s* [root@node1:/] # ls-l / devices/pci@0,0/pci8086,2829@d/disk@2,0:a Rawcrw-rw---- 1 grid asmadmin 30, 128 Jan 22 17:31 / devices/pci@0,0/pci8086,2829@d/disk@2,0:a,raw

-unfinished to be continued.

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.