Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

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

2025-01-18 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

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

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

System environment:

Operating system: Solaris 10 (x86-64)

Cluster: Oracle CRS 10.2.0.1.0

Oracle: Oracle 10.2.0.1.0

As shown in the figure: RAC system architecture

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

I. operating system environment

[root@node1:/] # uname-a

SunOS node1 5.10 Generic_142910-17 i86pc i386 i86pc

[root@node1:/] # isainfo-kv

64-bit amd64 kernel modules

1. Network configuration (on all nodes)

[root@node1:/] # cat / etc/inet/ipnodes # # Internet host table#::1 localhost 127.0.0.1 localhost 192.168.8.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-priv

Network configuration:

Configure vip network (node1): [root@node1:/] # ifconfig e1000g0:1 plumb up [root@node1:/] # ifconfig e1000g0:1 192.168.13 netmask 255.255.255.0 [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:28:b1 : 8C e1000g0:1: flags=4001000842 mtu 1500 index 2 inet 192.168.8.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:6e:16:1 configuration vip network (node2): [root@node2:/] # ifconfig e1000g0:1 plumb up [root@node2:/] # ifconfig e1000g0:1 192.168.14 netmask 255.255.255.0 [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:1f:bf:4c 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:a5:2c:db

2. Shared disk configuration (on all nodes)

For Oracle 10g RAC,OCR and VOTE DISK, DataBase must be built on shared storage devices; OCR and VOTE DISK must be managed by raw, and disks stored in DataBase must be managed by ASM.

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

The establishment of raw under Solaris should pay attention to the following: Use the fdisk command to create a Solaris partition on the disk if one does not already exist.Solaris fdisk partitions must start at cylinder 1, not cylinder 0. If you create an fdisk partition, then you must label the disk before continuing.Enter the partition command, followed by the print command to display the partition table for the disk that you want to use.If necessary, create a single whole-disk slice, starting at cylinder 1.Note:To prevent Automatic Storage Management from overwriting the partition table, you cannot use slices that start at cylinder 0 (for example, slice 2). Note: when establishing disk partitions, you must start with cylinder 1, not cylinder 0! Create a disk partition [root@node1:/] # 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] 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 > fdisk No 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.yformat > pPARTITION MENU: 0-change `0' partition 1-change `1' partition 2-change `2' partition 3-change `3' partition 4-change `4' partition 5-change `5' partition 6-change `6' partition 7-change `7' partition select-select a Predefined table modify-modify a predefined partition table name-name the current table print-display the current table label-write partition map and label to the disk!-execute Then return quitpartition > pCurrent partition table (original): Total disk cylinders available: 2607 + 2 (reserved cylinders) Part Tag Flag Cylinders Size Blocks 0 unassigned wm 0 0 (0 unassigned wm 0) 0 1 unassigned wm 0 0 (0 bank 0) 0 2 backup wu 0 -2606 19.97GB (2607-0-0) 41881455 3 unassigned wm 0 0 (0 unassigned wm 0) 0 4 unassigned wm 0 0 (0 unassigned wm 0) 0 5 unassigned wm 0 0 (0 unassigned 0) 06 unassigned Wm 0 0 (0 unassigned wm 0) 0 7 boot wu 0 0) 0 8 boot wu 0-0 7.84MB (1-0-0) 16065 9 unassigned wm 0 0 (0 / 0) 0partition > 0Part Tag Flag Cylinders Size Blocks 0 unassigned wm 0-16 133.35MB (17-0-0) 273105Enter partition id tag [unassigned]: Enter partition permission flags [wm]: Enter new starting cyl [0]: 1Enter partition size [273105b 17c, 17e, 133.35mb, 0.13gb]: 128mbpartition > 1Part Tag Flag Cylinders Size Blocks 1 unassigned wm 0-16 133.35MB (17-0-0) 273105Enter partition id tag [unassigned]: Enter partition permission flags [wm]: Enter new starting cyl [0]: 18Enter partition size [273105b, 17c, 34e, 133.35mb 0.13gb]: 128mbpartition > 3Part Tag Flag Cylinders Size Blocks 3 unassigned wm 0-652 5.00GB (653-0-0) 10490445Enter partition id tag [unassigned]: Enter partition permission flags [wm]: Enter new starting cyl [0]: 35Enter partition size [10490445b, 653c, 687e, 5122.29mb 5.00gb]: 5gbpartition > 4Part Tag Flag Cylinders Size Blocks 4 unassigned wm 0-652 5.00GB (653-0-0) 10490445Enter partition id tag [unassigned]: Enter partition permission flags [wm]: Enter new starting cyl [0]: 688Enter partition size [10490445b, 653c, 1340e, 5122.29mb 5.00gb]: 5gbpartition > 6Part Tag Flag Cylinders Size Blocks 6 unassigned wm 0-522 4.01GB (523-0-0) 8401995Enter partition id tag [unassigned]: Enter partition permission flags [wm]: Enter new starting cyl [0]: 689Enter partition size [8401995b, 523c, 1211e, 4102.54mb 4.01gb]: 4gbpartition > 7Part Tag Flag Cylinders Size Blocks 7 unassigned wm 0-522 4.01GB (523-0-0) 8401995Enter partition id tag [unassigned]: Enter partition permission flags [wm]: Enter new starting cyl [0]: 1212Enter partition size [8401995b, 523c, 1734e, 4102.54mb 4.01gb]: 4gbpartition > pCurrent partition table (unnamed): Total disk cylinders available: 2607 + 2 (reserved cylinders) Part Tag Flag Cylinders Size Blocks 0 unassigned wm 1-17 133.35MB (17-0-0) 273105 1 unassigned wm 18-34 133.35MB (17-0-0) 273105 2 backup wu 0-2606 19.97GB ( 2607-0-0) 41881455 3 unassigned wm 35-687 5.00GB (653-0-0) 10490445 4 unassigned wm 688-1340 5.00GB (653-0-0) 10490445 5 unassigned wm 00 (0 bank 0) 0 6 unassigned wm 689-1211 4.01GB (523-0-0) 840 1995 7 Unassigned wm 1212-1734 4.01GB (523-0-0) 8401995 8 boot wu 0-0 7.84MB (1-0-0) 16065 9 unassigned wm 0 0 (0 unassigned wm 0) 0partition > labelReady to label disk Continue? Ypartition > partition > quitformat > verifyPrimary label contents:Volume name =

< >

Ascii name = pcyl = 2609ncyl = 2607acyl = 2bcyl = 0nhead = 255nsect = 63Part Tag Flag Cylinders Size Blocks 0 unassigned wm 1-17 133.35MB (17-0-0) 273105 1 unassigned wm 18-34 133.35MB (17-0-0) 273105 2 backup wu 0 -2606 19.97GB (2607-0-0) 41881455 3 unassigned wm 35-687 5.00GB (653-0-0) 10490445 4 unassigned wm 688-1340 5.00GB (653-0-0) 10490445 5 unassigned wm 00 06 unassigned wm 689-1211 4.01GB (523-0-0) 8401995 7 unassigned wm 1212-1734 4.01GB (523-0-0) 8401995 8 boot wu 0-0 7.84MB (1-0-0) 16065 9 unassigned wm 0 0) 0format > savePlease name this partition type before saving itformat > quit View raw device: [root@ Node1:/] # ls-l / dev/rdsk/c0t2d0s*lrwxrwxrwx 1 root root 51 Jan 20 15:18 / dev/rdsk/c0t2d0s0->.. / devices/pci@0,0/pci8086,2829@d/disk@2,0:a Rawlrwxrwxrwx 1 root root 51 Jan 20 15:18 / dev/rdsk/c0t2d0s1->.. /.. / devices/pci@0,0/pci8086,2829@d/disk@2,0:b,rawlrwxrwxrwx 1 root root 51 Jan 20 15:18 / dev/rdsk/c0t2d0s2->.. /.. / devices/pci@0,0/pci8086,2829@d/disk@2,0:c Rawlrwxrwxrwx 1 root root 51 Jan 20 15:18 / dev/rdsk/c0t2d0s3->.. /.. / devices/pci@0,0/pci8086,2829@d/disk@2,0:d,rawlrwxrwxrwx 1 root root 51 Jan 20 15:18 / dev/rdsk/c0t2d0s4->.. /.. / devices/pci@0,0/pci8086,2829@d/disk@2,0:e Rawlrwxrwxrwx 1 root root 51 Jan 20 15:18 / dev/rdsk/c0t2d0s5->.. /.. / devices/pci@0,0/pci8086,2829@d/disk@2,0:f,rawlrwxrwxrwx 1 root root 51 Jan 20 15:18 / dev/rdsk/c0t2d0s6->.. /.. / devices/pci@0,0/pci8086,2829@d/disk@2,0:g Rawlrwxrwxrwx 1 root root 51 Jan 20 15:18 / dev/rdsk/c0t2d0s7->.. / devices/pci@0,0/pci8086,2829@d/disk@2,0:h,raw. Check out [root@node2:/] # formatSearching for disks...doneAVAILABLE DISK SELECTIONS: 0 on node2. 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-17 133.35MB (17-0-0) 273105 1 unassigned wm 18-34 133.35MB (17-0-0) 273105 2 backup wu 0-2606 19.97GB (2607-0-0) 41881455 3 unassigned wm 35-687 5.00GB (653-0-0) 10490445 4 unassigned wm 688-1340 5.00GB (653-0-0) 10490445 5 unassigned wm 0 0 (unassigned wm 0 boot wu 0) 06 unassigned wm 689-1211 4.01GB (523-0-0) 8401995 7 unassigned wm 1212-1734 4.01GB (523-0-0) 8401995 8 boot wu 0-0 7.84MB (1-0-0) 16065 9 unassigned wm 0 0 (0thumb 0) 0

2. Modify raw device properties (all node)

Modify the raw attribute (all node): [root@node1:/] # chown oracle:dba / dev/rdsk/c0t2d0s* [root@node1:/] # chmod 660 / dev/rdsk/c0t2d0s* [root@node1:/] # ls-l / devices/pci@0,0/pci8086,2829@d/disk@2,0:e,rawcrw-rw---- 1 oracle dba 30,132 Jan 21 10:35 / devices/pci@0,0/pci8086,2829@d/disk@2,0:e Raw [root@node1:/] # establish OCR and VOTE disk links (all node): [root@node1:/] # mkdir / oracle [root@node1:/] # chown oracle:dba / oracle [root@node1:/] # su-oracleOracle Corporation SunOS 5.10 Generic Patch January 2005 [oracle@node1:/export/home/oracle] $cd / oracle [oracle@node1:/oracle] $ln-s / devices/pci@0,0/pci8086,2829@d/disk@2,0:a Raw ocr [oracle@node1:/oracle] $ln-s / devices/pci@0,0/pci8086,2829@d/disk@2,0:b,raw vote [oracle@node1:/oracle] $ls-ltotal 4lrwxrwxrwx 1 oracle oinstall 46 Jan 21 11:11 ocr-> / devices/pci@0,0/pci8086,2829@d/disk@2,0:a,rawlrwxrwxrwx 1 oracle oinstall 46 Jan 21 11:11 vote-> / devices/pci@0,0/pci8086,2829@d/disk@2,0:b,raw

3. Establish Oracle users and groups (all node):

[root@node1:/] # groupadd-g 200 oinstall [root@node1:/] # groupadd-g 205 dba [root@node1:/] # useradd-u 200-g oinstall-G dba-d / export/home/oracle-m-s / usr/bin/bash oracle64 blocks [root@node1:/] # id oracleuid=200 (oracle) gid=200 (oinstall) [root@node1:/] # su-oracleOracle Corporation SunOS 5.10 Generic Patch January 2005 [oracle@node1:/export/home/oracle] $ Pwd / export/home/oracle [root@node1:/] # passwd oraclepasswd: password successfully changed for oracle establishes CRS and Oracle software installation directory: [root@node1:/] # mkdir / export/home/ora10 [root@node1:/] # chown-R oracle:dba / export/home/ora10 [root@node1:/] # mkdir-p / export/home/crs_1 [root@node1:/] # chown-R oracle:dba / export/home/crs_1 configure Oracle user environment variables : [oracle@node1:/export/home/oracle] $cat .profile # This is the default standard profile provided to a user.# They are expected to edit it to meet their own needs.MAIL=/usr/mail/$ {LOGNAME:?} ORACLE_BASE=/export/home/ora10ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1ORACLE_CRS_HOME=/export/home/crs_1ORACLE_SID=prod1 ; ORACLE_SID=prod2 (node2) PATH=$PATH:/usr/ccs/bin:/usr/local/bin:/usr/local/sbin:$ORACLE_HOME/binexport ORACLE_BASE ORACLE_HOME ORACLE_SID PATH ORACLE_CRS_HOME confirms nobody user: [root@node1:/] # id nobodyuid=60001 (nobody) gid=60001 (nobody)

4. Configure kernel parameters (all node):

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

5. Check the installation of the package (all node):

1 、 Check the software package required by the system: [root@node2:/] # pkginfo-i SUNWarc SUNWbtool SUNWhea SUNWlibm SUNWlibms SUNWsprot SUNWtoo SUNWi1of SUNWi1cs SUNWi15cs SUNWxwfntsystem SUNWarc Lint Libraries (usr) system SUNWbtool CCS tools bundled with SunOSsystem SUNWhea SunOS Header Filessystem SUNWi1of ISO-8859-1 (Latin-1) Optional Fontssystem SUNWlibm Math & Microtasking Library Headers & Lint Files (Usr) system SUNWlibms Math & Microtasking Libraries (Usr) system SUNWsprot Solaris Bundled toolssystem SUNWtoo Programming Toolssystem SUNWxwfnt X Window System platform required fontsERROR : information for "SUNWi1cs" was not foundERROR: information for "SUNWi15cs" was not found installation package (mount Solaris system disk): [oracle@node1:/export/home/oracle] $su-Password: Oracle Corporation SunOS 5.10 Generic Patch January 2005 [root@node1:/] # ls / cdromcdrom0 sol_10_910_ x86 [root @ node1:/cdrom/sol_10_910_x86/Solaris_10/Product] # pwd / cdrom/sol_10_910 _ x86/Solaris_10/Product installation software: [root@node1:/cdrom/sol_10_910_x86/Solaris_10/Product] # pkgadd-d / cdrom/sol_10_910_x86/Solaris_10/Product SUNWi1csProcessing package instance from X11 ISO8859-1 Codeset Support (i386) 2.0 REV=2004.10.17.15.04Copyright 2004 Sun Microsystems, Inc. All rights reserved.Use is subject to license terms.Using as the package base directory.## Processing package information.## Processing system information. 8 package pathnames are already properly installed.## Verifying package dependencies.## Verifying disk space requirements.## Checking for conflicts with packages already installed.## Checking for setuid/setgid programs.This package contains scripts which will be executed with super-userpermission during the process of installing this package.Do you want to continue with the installation of [y,n,?] YInstalling X11 ISO8859-1 Codeset Support as # # Installing part 1 of 1.232 blocksInstallation of was copyright full.[ root @ node1:/cdrom/sol_10_910_x86/Solaris_10/Product] # pkgadd-d / cdrom/sol_10_910_x86/Solaris_10/Product SUNWi15csProcessing package instance from X11 ISO8859-15 Codeset Support (i386) 2.0 Sun Microsystems Revolutionary October 17.15.04 copyright 2004 Sun Microsystems, Inc. All rights reserved.Use is subject to license terms.Using as the package base directory.## Processing package information.## Processing system information. 6 package pathnames are already properly installed.## Verifying package dependencies.## Verifying disk space requirements.## Checking for conflicts with packages already installed.## Checking for setuid/setgid programs.This package contains scripts which will be executed with super-userpermission during the process of installing this package.Do you want to continue with the installation of [y,n,?] YInstalling X11 ISO8859-15 Codeset Support as # # Installing part 1 of 1.1460 blocksInstallation of was successful. Check the software again: [root@node2:/] # pkginfo-I SUNWi1cs SUNWi15cssystem SUNWi15cs X11 ISO8859-15 Codeset Supportsystem SUNWi1cs X11 ISO8859-1 Codeset Support

-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.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report