Oracle 11g RAC Production environment Deployment details
Tian Yi ([email protected])
Basic planning
Equipment selection
1, server: Dell R620 two units. CPU 8 core, Memory 64g,600g 15000-turn SAS hard drive, dual power supply, HBA card piece, connect storage cable (connect HBA card and shared storage).
2, Storage: Dell MD3200 one. Dual controller, 12 600G 15000-turn SAS hard drive. For maximum availability, the RAID level used is RAID10.
3, switch: Huawei 3com two units, the model is H3C s5048e. Note: The network port is preferably full gigabit.
4, network cable: 2-3 meters mechanism 6 types of line number root. --had encountered the network cable is not enough, asked IDC room to the root of the network to do the six class line, the quality is not good, resulting in the heartbeat between the RAC node when the bad.
5, auxiliary equipment: VPN and KVM over IP each one
(1) Small simple VPN,DI-8200 internet Behavior Management authentication router. Prices are many, cheap and stable. Very suitable for use with VPN, for logging into the system, to manage each server.
(2) The KVM Overip model is Aten cn8000. When the system is not able to log in remotely, call the IDC technician, let them connect the device to the fault machine, and then through the browser for various processing, such as reloading the system, viewing screen information, CTRL + ALT + DEL Restart and so on. This is directly to the computer room with a monitor and keyboard is the same effect. I dare to guarantee, take a taxi to the machine room on-site treatment, there must be no phone to IDC room, let people to connect this device fast.
Network planning
1, network card binding: 2 network cards bundled together, the server's four network cards, just all use. The use of bandwidth effectively, but also enhance the availability.
2, IP address assignment: The Application Connection network address is 172.16.208.0/24, the heartbeat network address between nodes is 192.168.208.0/24.
3. Network Connection and Management
(1) The heartbeat network is physically separated from the application network, one switch after another.
(2) The server does not have a public address and must be dialed via VPN for system login management.
System and required tools
1, server operating system: CentOS 5.9 64-bit, Custom installation system, options include Xwindow and Gnome. A good choice is vncserver because of the graphical user interface required to install Oracle. Before you make a formal deployment, it's a good idea to make sure that Vncserver is installed. The partitioning of a custom-made system is:
[[email protected] ~]# df-h filesystem size used Avail use% mounted on /dev/sda6 29G 16G 12G 60%/ /dev/sda9 362G 215G 129G 63%/u01 /dev/sda8 15G 165M 14G 2%/tmp /dev/sda7 19G 15G 3.9G 79%/home< /span> /dev/sda5 29G 2.5G 25G 10%/usr / Dev/sda3 29G 321M 27G 2%/var /dev/sda1 99M 19M 75M 21%/boot Span style= "font-size:9pt" >tmpfs 32G 18G 15G 55%/dev/shm |
2. Oracle Software:
(1) Cluster management software linux.x64_11gR2_grid.zip, download from Oracle website (need to register for overseas e-mail)
(2) database software linux.x64_11gr2_database, download from Oracle website (need to register for overseas e-mail)
(3) Storage management software Mdstoragemanager, obtain CD from supplier or download from Dell's website
(4) Oracle ASM related software: oracleasm-2.6.18-308.el5-2.0.5-1.el5.x86_64.rpm, oracleasmlib-2.0.4-1.el5.x86_64.rpm, oracleasm-support-2.1.7-1.el5.x86_64.rpm. These three software, must be consistent with the operating system kernel version, or you can not do behind the operation.
Partition usage and file system
1, Oracle database and cluster software installed on the local hard disk/u01 partition.
(1) Cluster software path/u01/app/grid
(2) database software path/u01/app/oracle/product/11.2.0
(3) The cluster software and database software base path are all/u01/app/oracle. Because the Software installation path (Oracle_home) cannot be the same directory as base, it is a bit confusing and even awkward. Fortunately, this confusing setup works as well. Hope that the future projects, can be in advance to the planning of such a set more normative. Open an installed environment and enter the Oracle_base directory with the following sub-directories:
[[email protected" oracle]# ll total drwxr-x---3 oracle oinstall 4096 Mar 2 23:52 admin drwxr-x---6 oracle oinstall 4096 Mar 2 23:52 cfgtoollogs drwxr-xr-x 2 Oracle Oinstall 4096 Mar 2 23:20 checkpoints drwxrwxr-x 5 Oracle Oinstall 4096 Mar 2 23:52 diag drwxr-xr-x 3 Oracle Oinstall 4096 Mar 2 23:12 product |
Again into the directory diag, there are three subdirectories present:
[email protected] diag]# LL Total 12 Drwxr-x---3 oracle oinstall 4096 Mar 2 21:50 ASM Drwxr-x---3 oracle oinstall 4096 Mar 2 23:52 RDBMS Drwxr-xr-x 3 Oracle Oinstall 4096 Mar 2 21:53 Tnslsnr |
Look, the ASM file system, database, and listener alarm logs can be found here. such as ASM alarm log/u01/app/oracle/diag/asm/+asm/+asm2/alert/log.xml.
2, data storage using Oracle Home ASM (Automatic storage Management), divided into three ASM disk groups: OCR, FLASH, data (OCR occupies a minimum of approximately the allocation of space 500m;flash second, the allocation of about 300G, the rest is allocated to DATA). which
OCR Storage Cluster Registration information
asmcmd> pwd +ocr/db1-scan Asmcmd> ls asmparameterfile/ ocrfile/ |
Flash storage Archive log and Rman default backup set
asmcmd> cd FLASH asmcmd> ls zyzf/ asmcmd> cd zyzf |