搭建測試環境exadata一體機 (vm虛擬機器redhat上配置)

Michael_DD發表於2015-01-22
搭建測試環境exadata一體機 (vm虛擬機器redhat上配置)



環境:
cell節點:
192.168.9.245
redhat5.4  64

DB節點:
192.168.9.246
redhat5.4  64





cell節點:

1. 安裝cell

[root@cell tmp]# unzip V33693-01.zip
[root@cell tmp]# tar -pxvf cellImageMaker_11.2.3.2.0_LINUX.X64_120713-1.x86_64.tar



[root@cell tmp]# cd dl180/boot/cellbits/
[root@cell cellbits]# unzip cell.bin
Archive:  cell.bin
warning [cell.bin]:  6408 extra bytes at beginning or within zipfile
  (attempting to process anyway)
  inflating: cell-11.2.3.2.0_LINUX.X64_120713-1.x86_64.rpm  
  inflating: jdk-1_5_0_15-linux-amd64.rpm  
[root@cell cellbits]# ll
total 1692256
-rw-rw-r-- 1 root root       716 Jul 14  2012 c7rpms.tbz
-rw-r--r-- 1 root root 207051389 Jul 14  2012 cell-11.2.3.2.0_LINUX.X64_120713-1.x86_64.rpm
-rwxrwxr-x 1 root root 245118813 Jul 14  2012 cell.bin
-rw-rw-r-- 1 root root  12704742 Jul 14  2012 cellboot.tbz
-rw-rw-r-- 1 root root 140810602 Jul 14  2012 cellfw.tbz
-rw-rw-r-- 1 root root 141804661 Jul 14  2012 cellrpms.tbz
-rw-rw-r-- 1 root root 164829961 Jul 14  2012 commonos.tbz
-rw-rw-r-- 1 root root 377243862 Jul 14  2012 debugos.tbz
-rw-rw-r-- 1 root root  42948608 Jul 14  2012 diag.iso
-rw-rw-r-- 1 root root  55704927 Jul 14  2012 doclib.zip
-rw-rw-r-- 1 root root 199480899 Jul 14  2012 exaos.tbz
-rw-rw-r-- 1 root root  18177500 Jul 14  2012 hputils.tbz
-r--r--r-- 1 root root  43175156 Jul 14  2012 jdk-1_5_0_15-linux-amd64.rpm
-rw-rw-r-- 1 root root  53367136 Jul 14  2012 kernel.tbz
-rw-rw-r-- 1 root root  16165584 Jul 14  2012 ofed.tbz
-rw-rw-r-- 1 root root  12476276 Jul 14  2012 sunutils.tbz
[root@cell cellbits]#



2. 安裝解壓所得的兩個rpm包
先安裝jdk:
[root@cell cellbits]# rpm -ivh jdk-1_5_0_15-linux-amd64.rpm
[root@cell cellbits]# rpm -ivh cell-11.2.3.2.0_LINUX.X64_120713-1.x86_64.rpm



3. 提示N多條件無法滿足安裝
建立目錄:
[root@cell cellbits]# mkdir -p /var/log/oracle
[root@cell cellbits]# chmod -R 755 /var/log/oracle/
[root@cell cellbits]#
[root@cell cellbits]# rpm -ivh cell-11.2.3.2.0_LINUX.X64_120713-1.x86_64.rpm
Preparing...                ########################################### [100%]
Pre Installation steps in progress ...
   1:cell                   ########################################### [100%]
Post Installation steps in progress ...
Set cellusers group for /opt/oracle/cell11.2.3.2.0_LINUX.X64_120713/cellsrv/deploy/log directory
Set 775 permissions for /opt/oracle/cell11.2.3.2.0_LINUX.X64_120713/cellsrv/deploy/log directory
/
/
Installation SUCCESSFUL.
Starting RS and MS... as user celladmin
Done. Please Login as user celladmin and create cell to startup CELLSRV to complete cell configuration.
WARNING: Using the current shell as root to restart cell services.
Restart the cell services using a new shell.
[root@cell cellbits]#


4. 在cell虛擬機器中建立對應的虛擬的磁碟和閃盤

[root@cell oracle]# mkdir -p /opt/oracle/cell/disks/raw
[root@cell oracle]# cd /opt/oracle/cell/disks/raw/
[root@cell raw]# vi dd.sh
dd if=/dev/zero of=disk01 bs=1M count=1000
dd if=/dev/zero of=disk02 bs=1M count=1000
dd if=/dev/zero of=disk03 bs=1M count=1000
dd if=/dev/zero of=disk04 bs=1M count=1000
dd if=/dev/zero of=disk05 bs=1M count=1000
dd if=/dev/zero of=disk06 bs=1M count=1000
dd if=/dev/zero of=disk07 bs=1M count=1000
dd if=/dev/zero of=disk08 bs=1M count=1000
dd if=/dev/zero of=disk09 bs=1M count=1000
dd if=/dev/zero of=disk10 bs=1M count=1000
dd if=/dev/zero of=disk11 bs=1M count=1000
dd if=/dev/zero of=disk12 bs=1M count=1000
dd if=/dev/zero of=FLASH01 bs=1M count=1000
dd if=/dev/zero of=FLASH02 bs=1M count=1000
dd if=/dev/zero of=FLASH03 bs=1M count=1000
dd if=/dev/zero of=FLASH04 bs=1M count=1000
~
~
~

~
~
~
~
"dd.sh" [New] 16L, 692C written
[root@cell raw]# cat dd.sh
dd if=/dev/zero of=disk01 bs=1M count=1000
dd if=/dev/zero of=disk02 bs=1M count=1000
dd if=/dev/zero of=disk03 bs=1M count=1000
dd if=/dev/zero of=disk04 bs=1M count=1000
dd if=/dev/zero of=disk05 bs=1M count=1000
dd if=/dev/zero of=disk06 bs=1M count=1000
dd if=/dev/zero of=disk07 bs=1M count=1000
dd if=/dev/zero of=disk08 bs=1M count=1000
dd if=/dev/zero of=disk09 bs=1M count=1000
dd if=/dev/zero of=disk10 bs=1M count=1000
dd if=/dev/zero of=disk11 bs=1M count=1000
dd if=/dev/zero of=disk12 bs=1M count=1000
dd if=/dev/zero of=FLASH01 bs=1M count=1000
dd if=/dev/zero of=FLASH02 bs=1M count=1000
dd if=/dev/zero of=FLASH03 bs=1M count=1000
dd if=/dev/zero of=FLASH04 bs=1M count=1000
[root@cell raw]#


5. 執行dd.sh建立對應的磁碟和閃盤:其中磁碟12塊,每塊大小為1GB,閃盤4塊,沒塊大小也是1GB。

[root@cell raw]# sh dd.sh
1000+0 records in
1000+0 records out
1048576000 bytes (1.0 GB) copied, 3.83828 seconds, 273 MB/s
1000+0 records in
1000+0 records out
1048576000 bytes (1.0 GB) copied, 7.65106 seconds, 137 MB/s
1000+0 records in
1000+0 records out
1048576000 bytes (1.0 GB) copied, 10.0758 seconds, 104 MB/s
1000+0 records in
1000+0 records out
1048576000 bytes (1.0 GB) copied, 9.43671 seconds, 111 MB/s
1000+0 records in
1000+0 records out
1048576000 bytes (1.0 GB) copied, 11.8433 seconds, 88.5 MB/s
1000+0 records in
1000+0 records out
1048576000 bytes (1.0 GB) copied, 4.57079 seconds, 229 MB/s
1000+0 records in
1000+0 records out
1048576000 bytes (1.0 GB) copied, 10.744 seconds, 97.6 MB/s
1000+0 records in
1000+0 records out
1048576000 bytes (1.0 GB) copied, 10.7691 seconds, 97.4 MB/s
1000+0 records in
1000+0 records out
1048576000 bytes (1.0 GB) copied, 13.8926 seconds, 75.5 MB/s
1000+0 records in
1000+0 records out
1048576000 bytes (1.0 GB) copied, 11.3874 seconds, 92.1 MB/s
1000+0 records in
1000+0 records out
1048576000 bytes (1.0 GB) copied, 12.5219 seconds, 83.7 MB/s
1000+0 records in
1000+0 records out
1048576000 bytes (1.0 GB) copied, 11.068 seconds, 94.7 MB/s
1000+0 records in
1000+0 records out
1048576000 bytes (1.0 GB) copied, 5.9232 seconds, 177 MB/s
1000+0 records in
1000+0 records out
1048576000 bytes (1.0 GB) copied, 11.9895 seconds, 87.5 MB/s
1000+0 records in
1000+0 records out
1048576000 bytes (1.0 GB) copied, 12.8567 seconds, 81.6 MB/s
1000+0 records in
1000+0 records out
1048576000 bytes (1.0 GB) copied, 9.128 seconds, 115 MB/s

[root@cell raw]# ll -ctrl
total 16400068
-rw-rw---- 1 root root        692 Jan 20 18:24 dd.sh
-rw-r--r-- 1 root root 1048576000 Jan 20 18:24 disk01
-rw-r--r-- 1 root root 1048576000 Jan 20 18:24 disk02
-rw-r--r-- 1 root root 1048576000 Jan 20 18:25 disk03
-rw-r--r-- 1 root root 1048576000 Jan 20 18:25 disk04
-rw-r--r-- 1 root root 1048576000 Jan 20 18:25 disk05
-rw-r--r-- 1 root root 1048576000 Jan 20 18:25 disk06
-rw-r--r-- 1 root root 1048576000 Jan 20 18:25 disk07
-rw-r--r-- 1 root root 1048576000 Jan 20 18:25 disk08
-rw-r--r-- 1 root root 1048576000 Jan 20 18:26 disk09
-rw-r--r-- 1 root root 1048576000 Jan 20 18:26 disk10
-rw-r--r-- 1 root root 1048576000 Jan 20 18:26 disk11
-rw-r--r-- 1 root root 1048576000 Jan 20 18:26 disk12
-rw-r--r-- 1 root root 1048576000 Jan 20 18:26 FLASH01
-rw-r--r-- 1 root root 1048576000 Jan 20 18:27 FLASH02
-rw-r--r-- 1 root root 1048576000 Jan 20 18:27 FLASH03
-rw-r--r-- 1 root root 1048576000 Jan 20 18:27 FLASH04
[root@cell raw]# chmod 660 *
[root@cell raw]# ll -ctrl
total 16400068
-rw-rw---- 1 root root 1048576000 Jan 20 18:27 FLASH04
-rw-rw---- 1 root root 1048576000 Jan 20 18:27 FLASH03
-rw-rw---- 1 root root 1048576000 Jan 20 18:27 FLASH02
-rw-rw---- 1 root root 1048576000 Jan 20 18:27 FLASH01
-rw-rw---- 1 root root 1048576000 Jan 20 18:27 disk12
-rw-rw---- 1 root root 1048576000 Jan 20 18:27 disk11
-rw-rw---- 1 root root 1048576000 Jan 20 18:27 disk10
-rw-rw---- 1 root root 1048576000 Jan 20 18:27 disk09
-rw-rw---- 1 root root 1048576000 Jan 20 18:27 disk08
-rw-rw---- 1 root root 1048576000 Jan 20 18:27 disk07
-rw-rw---- 1 root root 1048576000 Jan 20 18:27 disk06
-rw-rw---- 1 root root 1048576000 Jan 20 18:27 disk05
-rw-rw---- 1 root root 1048576000 Jan 20 18:27 disk04
-rw-rw---- 1 root root 1048576000 Jan 20 18:27 disk03
-rw-rw---- 1 root root 1048576000 Jan 20 18:27 disk02
-rw-rw---- 1 root root 1048576000 Jan 20 18:27 disk01
-rw-rw---- 1 root root        692 Jan 20 18:27 dd.sh
[root@cell raw]#



6. 切換到celladmin使用者,重新啟動celld服務
[root@cell raw]# su - celladmin
[celladmin@cell trace]$ cellcli -e alter cell restart services all

Stopping the RS, CELLSRV, and MS services...
The SHUTDOWN of services was successful.
Starting the RS, CELLSRV, and MS services...
Getting the state of RS services...  running
Starting CELLSRV services...
The STARTUP of CELLSRV services was not successful.
CELL-01547: CELLSRV startup failed due to unknown reasons.
Starting MS services...
The STARTUP of MS services was successful.
[celladmin@cell trace]$

啟動報錯,檢視啟動日誌
[celladmin@cell trace]$ pwd
/opt/oracle/cell11.2.3.2.0_LINUX.X64_120713/log/diag/asm/cell/cell/trace
[celladmin@cell trace]$ ll
total 3300
-rw-rw---- 1 root celladmin    3746 Jan 20 18:34 alert.log
-rw-r--r-- 1 root celladmin  279510 Jan 20 18:35 ms-odl.log
-rw-r--r-- 1 root celladmin  279510 Jan 20 18:35 ms-odl.trc
-rw-rw---- 1 root celladmin    4262 Jan 20 18:34 rstrc_5331_0.trc
-rw-rw---- 1 root celladmin     683 Jan 20 18:34 rstrc_5331_0.trm
-rw-rw---- 1 root celladmin    2836 Jan 20 18:33 rstrc_5331_3.trc
-rw-rw---- 1 root celladmin     896 Jan 20 18:33 rstrc_5331_3.trm
-rw-rw---- 1 root celladmin 2352658 Jan 20 18:33 rstrc_5331_4.trc
-rw-rw---- 1 root celladmin  288116 Jan 20 18:33 rstrc_5331_4.trm
-rw-rw---- 1 root celladmin   22859 Jan 20 18:33 rstrc_5331_5.trc
-rw-rw---- 1 root celladmin    5356 Jan 20 18:33 rstrc_5331_5.trm
-rw-rw---- 1 root celladmin     869 Jan 20 18:34 rstrc_5331_6.trc
-rw-rw---- 1 root celladmin     358 Jan 20 18:34 rstrc_5331_6.trm
-rw-rw---- 1 root celladmin    3450 Jan 20 18:33 rstrc_5340_1.trc
-rw-rw---- 1 root celladmin     526 Jan 20 18:33 rstrc_5340_1.trm
-rw-rw---- 1 root celladmin    1456 Jan 20 18:34 rstrc_5340_2.trc
-rw-rw---- 1 root celladmin     396 Jan 20 18:34 rstrc_5340_2.trm
-rw-rw---- 1 root celladmin    1561 Jan 20 18:34 rstrc_6681_0.trc
-rw-rw---- 1 root celladmin     255 Jan 20 18:34 rstrc_6681_0.trm
-rw-rw---- 1 root celladmin     815 Jan 20 18:34 rstrc_6681_3.trc
-rw-rw---- 1 root celladmin     325 Jan 20 18:34 rstrc_6681_3.trm
-rw-rw---- 1 root celladmin    4346 Jan 20 18:34 rstrc_6681_4.trc
-rw-rw---- 1 root celladmin    1491 Jan 20 18:34 rstrc_6681_4.trm
-rw-rw---- 1 root celladmin    9667 Jan 20 18:34 rstrc_6681_5.trc
-rw-rw---- 1 root celladmin    3244 Jan 20 18:34 rstrc_6681_5.trm
-rw-rw---- 1 root celladmin     771 Jan 20 18:34 rstrc_6681_6.trc
-rw-rw---- 1 root celladmin     190 Jan 20 18:34 rstrc_6681_6.trm
-rw-rw---- 1 root celladmin    1429 Jan 20 18:34 rstrc_6689_1.trc
-rw-rw---- 1 root celladmin     254 Jan 20 18:34 rstrc_6689_1.trm
-rw-rw---- 1 root celladmin     513 Jan 20 18:34 rstrc_6689_2.trc
-rw-rw---- 1 root celladmin     169 Jan 20 18:34 rstrc_6689_2.trm
[celladmin@cell trace]$ cat alert.log
Tue Jan 20 18:12:16 2015
RS version=11.2.3.2.0,label=OSS_11.2.3.2.0_LINUX.X64_120713,Fri_Jul_13_12:37:13_PDT_2012
[RS] Started Service RS_MAIN with pid 5331
[RS] Kill previous monitoring processes for backup RS, MS and Cellsrv
Tue Jan 20 18:12:16 2015
[RS] Started monitoring process /opt/oracle/cell11.2.3.2.0_LINUX.X64_120713/cellsrv/bin/cellrsbmt with pid 5339
Tue Jan 20 18:12:16 2015
RSBK version=11.2.3.2.0,label=OSS_11.2.3.2.0_LINUX.X64_120713,Fri_Jul_13_12:37:13_PDT_2012
[RS] Started Service RS_BACKUP with pid 5340
[RS] Kill previous monitoring process for core RS
Tue Jan 20 18:12:16 2015
[RS] Started monitoring process /opt/oracle/cell11.2.3.2.0_LINUX.X64_120713/cellsrv/bin/cellrssmt with pid 5344
Tue Jan 20 18:12:17 2015
[RS] Started monitoring process /opt/oracle/cell11.2.3.2.0_LINUX.X64_120713/cellsrv/bin/cellrsmmt with pid 5376
[RS] Started Service MS with pid 5377
Tue Jan 20 18:33:51 2015
[RS] Process /opt/oracle/cell11.2.3.2.0_LINUX.X64_120713/cellsrv/bin/cellrsmmt (pid: 5376) received clean shutdown signal from pid: 5331, uid: 0
Tue Jan 20 18:33:58 2015
[RS] Stopped Service MS with pid 5377
Tue Jan 20 18:33:58 2015
[RS] Process /opt/oracle/cell11.2.3.2.0_LINUX.X64_120713/cellsrv/bin/cellrsbmt (pid: 5339) received clean shutdown signal from pid: 5331, uid: 0
[RS] Stopped Service RS_BACKUP
[RS] Stopped Service RS_MAIN
Tue Jan 20 18:33:59 2015
[RS] Process /opt/oracle/cell11.2.3.2.0_LINUX.X64_120713/cellsrv/bin/cellrsbkm (pid: 5340) received clean shutdown signal from pid: 5331, uid: 0
Tue Jan 20 18:34:00 2015
[RS] Process /opt/oracle/cell11.2.3.2.0_LINUX.X64_120713/cellsrv/bin/cellrssmt (pid: 5344) received clean shutdown signal from pid: 5331, uid: 0
Tue Jan 20 18:34:01 2015
[RS] Process /opt/oracle/cell11.2.3.2.0_LINUX.X64_120713/cellsrv/bin/cellrssrm (pid: 5331) received clean shutdown signal from pid: 5331, uid: 0
Tue Jan 20 18:34:02 2015
RS version=11.2.3.2.0,label=OSS_11.2.3.2.0_LINUX.X64_120713,Fri_Jul_13_12:37:13_PDT_2012
[RS] Started Service RS_MAIN with pid 6681
[RS] Kill previous monitoring processes for backup RS, MS and Cellsrv
Tue Jan 20 18:34:02 2015
[RS] Started monitoring process /opt/oracle/cell11.2.3.2.0_LINUX.X64_120713/cellsrv/bin/cellrsbmt with pid 6688
Tue Jan 20 18:34:02 2015
[RS] Started monitoring process /opt/oracle/cell11.2.3.2.0_LINUX.X64_120713/cellsrv/bin/cellrsmmt with pid 6690
Tue Jan 20 18:34:02 2015
[RS] Started monitoring process /opt/oracle/cell11.2.3.2.0_LINUX.X64_120713/cellsrv/bin/cellrsomt with pid 6691
[RS] Required IP parameters not configured in cellinit.ora. Err: 36
Tue Jan 20 18:34:02 2015
RSBK version=11.2.3.2.0,label=OSS_11.2.3.2.0_LINUX.X64_120713,Fri_Jul_13_12:37:13_PDT_2012
[RS] Started Service RS_BACKUP with pid 6689
[RS] Kill previous monitoring process for core RS
Tue Jan 20 18:34:02 2015
[RS] Started monitoring process /opt/oracle/cell11.2.3.2.0_LINUX.X64_120713/cellsrv/bin/cellrssmt with pid 6696
Errors in file /opt/oracle/cell11.2.3.2.0_LINUX.X64_120713/log/diag/asm/cell/cell/trace/rstrc_6681_4.trc  (incident=1):
RS-7445 [Required IP parameters missing] [Check cellinit.ora] [] [] [] [] [] [] [] [] [] []
Incident details in: /opt/oracle/cell11.2.3.2.0_LINUX.X64_120713/log/diag/asm/cell/cell/incident/incdir_1/rstrc_6681_4_i1.trc
Sweep [inc][1]: completed
[RS] Required IP parameters not configured in cellinit.ora. Err: 36
OS Hugepage status:
   Total/free hugepages available=1/1; hugepage size=2048KB
[RS] Start service CELLSRV failed with error: -74.
Tue Jan 20 18:34:03 2015
Could not connect to MS socket. Communication with MS may be degraded. errno=115
[RS] monitoring process /opt/oracle/cell11.2.3.2.0_LINUX.X64_120713/cellsrv/bin/cellrsomt (pid: 0) returned with error: 124
[RS] Started Service MS with pid 6692
[celladmin@cell trace]$



啟動報錯,可以在trc檔案17行中檢視到詳細報錯資訊
Flood ctrl function: Curtime: 1421751436, triggertime: 1421747836
[celladmin@cell trace]$ vi /opt/oracle/cell11.2.3.2.0_LINUX.X64_120713/log/diag/asm/cell/cell/trace/rstrc_8377_4.trc
  1 Trace file /opt/oracle/cell11.2.3.2.0_LINUX.X64_120713/log/diag/asm/cell/cell/trace/rstrc_8377_4.tr    c
  2 ORACLE_HOME = /opt/oracle/cell11.2.3.2.0_LINUX.X64_120713
  3 System name:    Linux
  4 Node name:      cell
  5 Release:        2.6.18-164.el5
  6 Version:        #1 SMP Tue Aug 18 15:51:48 EDT 2009
  7 Machine:        x86_64
  8 CELL SW Version:        OSS_11.2.3.2.0_LINUX.X64_120713
  9
 10 *** 2015-01-20 18:57:16.190
 11 RSMain: skgznp_create on pid 8377 returned 0
 12 serv_status - 1, exit_status - 0, cur_inc_num - 0, prev_inc_num - 0
 13 service CELLSRV already has status 1, modify to 1
 14 Started monitoring process /opt/oracle/cell11.2.3.2.0_LINUX.X64_120713/cellsrv/bin/cellrsomt with p    id 8387
 15 RSOMT: skgznp_create returned 0
 16 RSOMT: skgznp_set_fasync returned 0
 17 Required IP parameters not configured in cellinit.ora. Err: 36
 18 Required IP parameters missing Check cellinit.ora
 19 -------------------------------------------------------------------------------
 20 Trace Bucket Dump Begin: default trace bucket
 21 TIME(*=approx):SEQ: DATA
 22 -------------------------------------------------------------------------------
 23 2015-01-20 18:57:16.191617 :0000000A: serv_status - 1, exit_status - 0, cur_inc_num - 0, prev_inc_n    um - 0
 24 2015-01-20 18:57:16.191685 :0000000B: service CELLSRV already has status 1, modify to 1
 25 2015-01-20 18:57:16.192110 :0000000C: Started monitoring process /opt/oracle/cell11.2.3.2.0_LINUX.X    64_120713/cellsrv/bin/cellrsomt with pid 8387
 26 2015-01-20 18:57:16.194326 :0000000D: Required IP parameters not configured in cellinit.ora. Err: 3    6
 27 2015-01-20 18:57:16.194348 :0000000E: Required IP parameters missing Check cellinit.ora
 28 -------------------------------------------------------------------------------
 29 Trace Bucket Dump End: default trace bucket
 30 DDE: Flood control is not active
@
:set nu      


17 Required IP parameters not configured in cellinit.ora. Err: 36    儲存告警

修改系統開啟檔案引數
原來只能開啟 1024個檔案
[root@cell ~]# ulimit -a
core file size          (blocks, -c) 0
data seg size           (kbytes, -d) unlimited
scheduling priority             (-e) 0
file size               (blocks, -f) unlimited
pending signals                 (-i) 16736
max locked memory       (kbytes, -l) 32
max memory size         (kbytes, -m) unlimited
open files                      (-n) 1024
pipe size            (512 bytes, -p) 8
POSIX message queues     (bytes, -q) 819200
real-time priority              (-r) 0
stack size              (kbytes, -s) 10240
cpu time               (seconds, -t) unlimited
max user processes              (-u) 16736
virtual memory          (kbytes, -v) unlimited
file locks                      (-x) unlimited
[root@cell ~]#

修改:
引數fs.file-max大小
[root@cell ~]# vi /etc/sysctl.conf
fs.file-max = 655363
生效:
[root@cell ~]# sysctl -p


open files大小修改:
[root@cell ~]# vi /etc/security/limits.conf
檔案末尾加上:
* soft nofile 65536
* hard nofile 65536

該引數修改,必須重啟才可以生效!!

檢視
[root@cell ~]# ulimit -a
core file size          (blocks, -c) 0
data seg size           (kbytes, -d) unlimited
scheduling priority             (-e) 0
file size               (blocks, -f) unlimited
pending signals                 (-i) 16736
max locked memory       (kbytes, -l) 32
max memory size         (kbytes, -m) unlimited
open files                      (-n) 65536
pipe size            (512 bytes, -p) 8
POSIX message queues     (bytes, -q) 819200
real-time priority              (-r) 0
stack size              (kbytes, -s) 10240
cpu time               (seconds, -t) unlimited
max user processes              (-u) 16736
virtual memory          (kbytes, -v) unlimited
file locks                      (-x) unlimited
[root@cell ~]#

修改成功!!!



再次重新啟動celld服務
[celladmin@cell ~]$ cellcli
CellCLI: Release 11.2.3.2.0 - Production on Tue Jan 20 20:57:50 CST 2015

Copyright (c) 2007, 2012, Oracle.  All rights reserved.
Cell Efficiency Ratio: 1

CellCLI>

CellCLI> alter cell restart services all    

Stopping the RS, CELLSRV, and MS services...
CELL-01509: Restart Server (RS) not responding.
Starting the RS, CELLSRV, and MS services...
Getting the state of RS services...  running
Starting CELLSRV services...
The STARTUP of CELLSRV services was successful.
Starting MS services...
The STARTUP of MS services was successful.

CellCLI>

RS, CELLSRV, and MS 服務全部啟動成功!!



7. 在cellinit.ora中新增網路卡的資訊

/opt/oracle/cell11.2.3.2.0_LINUX.X64_120713/cellsrv/deploy/config/cellinit.ora

[celladmin@cell ~]$ cellcli -e create cell cell1 interconnect1=eth0
CELL-01518: Stop CELLSRV. Create Cell cannot continue with CELLSRV running.
報錯,先關閉 CELLSRV 程式

[celladmin@cell ~]$ cellcli
CellCLI: Release 11.2.3.2.0 - Production on Tue Jan 20 22:14:40 CST 2015

Copyright (c) 2007, 2012, Oracle.  All rights reserved.
Cell Efficiency Ratio: 1

CellCLI> alter cell shutdown services cellsrv

Stopping CELLSRV services...
The SHUTDOWN of CELLSRV services was successful.

CellCLI> exit
quitting

[celladmin@cell ~]$ cellcli -e create cell cell1 interconnect1=eth0
Cell cell1 successfully created
Starting CELLSRV services...
The STARTUP of CELLSRV services was successful.
Flash cell disks, FlashCache, and FlashLog will be created...
CellDisk FD_00_cell1 successfully created
CellDisk FD_01_cell1 successfully created
CellDisk FD_02_cell1 successfully created
CellDisk FD_03_cell1 successfully created
Flash log cell1_FLASHLOG successfully created
Flash cache cell1_FLASHCACHE successfully created
[celladmin@cell ~]$

停啟程式語法:
ALTER CELL { SHUTDOWN | RESTART | STARTUP } SERVICES { RS | MS | CELLSRV | ALL}

看到cellinit.ora檔案中新增了一行ipaddress1=192.168.9.245/24類似的資訊
[celladmin@cell ~]$ cat /opt/oracle/cell11.2.3.2.0_LINUX.X64_120713/cellsrv/deploy/config/cellinit.ora
#CELL Initialization Parameters
version=0.0
HTTP_PORT=8888
bbuChargeThreshold=800
SSL_PORT=23943
RMI_PORT=23791
ipaddress1=192.168.9.245/24
bbuTempThreshold=60
DEPLOYED=TRUE
JMS_PORT=9127
BMC_SNMP_PORT=162
[celladmin@cell ~]$



8. 建立celldisk, griddisk, flashcache, flashlog

[celladmin@cell ~]$ cellcli
CellCLI: Release 11.2.3.2.0 - Production on Tue Jan 20 22:22:45 CST 2015

Copyright (c) 2007, 2012, Oracle.  All rights reserved.
Cell Efficiency Ratio: 1

CellCLI> alter cell restart services all

Stopping the RS, CELLSRV, and MS services...
The SHUTDOWN of services was successful.
Starting the RS, CELLSRV, and MS services...
Getting the state of RS services...  running
Starting CELLSRV services...
The STARTUP of CELLSRV services was successful.
Starting MS services...
The STARTUP of MS services was successful.

CellCLI> create celldisk all
CellDisk CD_disk01_cell1 successfully created
CellDisk CD_disk02_cell1 successfully created
CellDisk CD_disk03_cell1 successfully created
CellDisk CD_disk04_cell1 successfully created
CellDisk CD_disk05_cell1 successfully created
CellDisk CD_disk06_cell1 successfully created
CellDisk CD_disk07_cell1 successfully created
CellDisk CD_disk08_cell1 successfully created
CellDisk CD_disk09_cell1 successfully created
CellDisk CD_disk10_cell1 successfully created
CellDisk CD_disk11_cell1 successfully created
CellDisk CD_disk12_cell1 successfully created

CellCLI> create flashcache all size=2G

CELL-02645: Flash cache already exists.

CellCLI> create griddisk all harddisk prefix=data
GridDisk data_CD_disk01_cell1 successfully created
GridDisk data_CD_disk02_cell1 successfully created
GridDisk data_CD_disk03_cell1 successfully created
GridDisk data_CD_disk04_cell1 successfully created
GridDisk data_CD_disk05_cell1 successfully created
GridDisk data_CD_disk06_cell1 successfully created
GridDisk data_CD_disk07_cell1 successfully created
GridDisk data_CD_disk08_cell1 successfully created
GridDisk data_CD_disk09_cell1 successfully created
GridDisk data_CD_disk10_cell1 successfully created
GridDisk data_CD_disk11_cell1 successfully created
GridDisk data_CD_disk12_cell1 successfully created

CellCLI> create flashlog all

CELL-02722: Flash log already exists.

CellCLI> list flashcache detail
         name:                   cell1_FLASHCACHE
         cellDisk:               FD_01_cell1,FD_02_cell1,FD_00_cell1,FD_03_cell1
         creationTime:           2015-01-20T22:15:22+08:00
         degradedCelldisks:      
         effectiveCacheSize:     3.1875G
         id:                     a97a7329-9169-4534-aac4-c28fac01a819
         size:                   3.1875G
         status:                 normal

CellCLI> list flashlog detail  
         name:                   cell1_FLASHLOG
         cellDisk:               FD_02_cell1,FD_01_cell1,FD_00_cell1,FD_03_cell1
         creationTime:           2015-01-20T22:15:20+08:00
         degradedCelldisks:      
         effectiveSize:          512M
         efficiency:             100.0
         id:                     f4957f27-d1b6-463e-8d54-b1497cf90305
         size:                   512M
         status:                 normal

CellCLI> list cell
         cell1   online

CellCLI> list celldisk
         CD_disk01_cell1         normal
         CD_disk02_cell1         normal
         CD_disk03_cell1         normal
         CD_disk04_cell1         normal
         CD_disk05_cell1         normal
         CD_disk06_cell1         normal
         CD_disk07_cell1         normal
         CD_disk08_cell1         normal
         CD_disk09_cell1         normal
         CD_disk10_cell1         normal
         CD_disk11_cell1         normal
         CD_disk12_cell1         normal
         FD_00_cell1             normal
         FD_01_cell1             normal
         FD_02_cell1             normal
         FD_03_cell1             normal

CellCLI> list griddisk
         data_CD_disk01_cell1    active
         data_CD_disk02_cell1    active
         data_CD_disk03_cell1    active
         data_CD_disk04_cell1    active
         data_CD_disk05_cell1    active
         data_CD_disk06_cell1    active
         data_CD_disk07_cell1    active
         data_CD_disk08_cell1    active
         data_CD_disk09_cell1    active
         data_CD_disk10_cell1    active
         data_CD_disk11_cell1    active
         data_CD_disk12_cell1    active

CellCLI> list celldisk CD_disk01_cell1 detail
         name:                   CD_disk01_cell1
         comment:                
         creationTime:           2015-01-20T22:52:22+08:00
         deviceName:             /opt/oracle/cell11.2.3.2.0_LINUX.X64_120713/disks/raw/disk01
         devicePartition:        /opt/oracle/cell11.2.3.2.0_LINUX.X64_120713/disks/raw/disk01
         diskType:               HardDisk
         errorCount:             0
         freeSpace:              0
         id:                     572530b2-bed4-432d-8d46-093990067df8
         interleaving:           none
         lun:                    /opt/oracle/cell11.2.3.2.0_LINUX.X64_120713/disks/raw/disk01
         physicalDisk:           /opt/oracle/cell11.2.3.2.0_LINUX.X64_120713/disks/raw/disk01
         raidLevel:              "RAID 0"
         size:                   992M
         status:                 normal

CellCLI> list celldisk FD_00_cell1 detail    
         name:                   FD_00_cell1
         comment:                
         creationTime:           2015-01-20T22:15:19+08:00
         deviceName:             /opt/oracle/cell11.2.3.2.0_LINUX.X64_120713/disks/raw/FLASH01
         devicePartition:        /opt/oracle/cell11.2.3.2.0_LINUX.X64_120713/disks/raw/FLASH01
         diskType:               FlashDisk
         errorCount:             0
         freeSpace:              0
         id:                     d6346116-54fb-4501-bb44-dce5a8ad19c6
         interleaving:           none
         lun:                    /opt/oracle/cell11.2.3.2.0_LINUX.X64_120713/disks/raw/FLASH01
         physicalDisk:           /opt/oracle/cell11.2.3.2.0_LINUX.X64_120713/disks/raw/FLASH01
         raidLevel:              "RAID 0"
         size:                   992M
         status:                 normal

CellCLI> list griddisk data_CD_disk01_cell1 detail
         name:                   data_CD_disk01_cell1
         availableTo:            
         cachingPolicy:          default
         cellDisk:               CD_disk01_cell1
         comment:                
         creationTime:           2015-01-20T22:54:39+08:00
         diskType:               HardDisk
         errorCount:             0
         id:                     5cfecc67-f540-41e1-bcab-36a64303abc2
         offset:                 48M
         size:                   944M
         status:                 active

CellCLI>

cell節點建立完成!!!


DB節點:(參考rac安裝博文http://blog.itpub.net/29500582/viewspace-1341453/)

1. 安裝oracle資料庫的基本步驟:
1.1 yum包安裝
yum -y install binutils
yum -y install compat-libstdc++-33
yum -y install elfutils-libelf
yum -y install glibc
yum -y install glibc-common
yum -y install ksh
yum -y install libaio
yum -y install libgcc
yum -y install libstdc++
yum -y install make
yum -y install elfutils-libelf-devel
yum -y install glibc-headers
yum -y install glibc-devel
yum -y install gcc
yum -y install libstdc++-devel
yum -y install gcc-c++
yum -y install libaio-devel
yum -y install sysstat
yum -y install unixODBC
yum -y install unixODBC-devel


2.  系統初始化
2.1 配置系統引數
vi /etc/sysctl.conf
新增
kernel.shmall = 4294967296
kernel.shmmax = 68719476736
kernel.shmmni = 4096
kernel.sem = 310 32000 100 128
fs.file-max = 6815744
fs.aio-max-nr = 1048576
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576

生效
sysctl -p

2.2 建立使用者
groupadd -g 500 oinstall
groupadd -g 501 dba
groupadd -g 502 oper
groupadd -g 503 asmdba
groupadd -g 504 asmadmin
groupadd -g 505 asmoper
useradd -u 500 -g oinstall -G dba,oper,asmdba oracle
useradd -u 501 -g oinstall -G dba,oper,asmdba,asmadmin,asmoper grid
passwd oracle
passwd grid

[root@rac1 tmp]# id oracle
uid=500(oracle) gid=500(oinstall) groups=500(oinstall),501(dba),502(oper),503(asmdba)
[root@rac1 tmp]# id grid
uid=501(grid) gid=500(oinstall) groups=500(oinstall),501(dba),502(oper),503(asmdba),504(asmadmin),505(asmoper)

2.3 建立密碼不過期
chage -M 99999 oracle
chage -M 99999 grid

2.4 建立目錄給許可權
mkdir -p /app/grid
mkdir -p /app/oracle
mkdir -p /app/oraInventory
mkdir -p /app/soft
mkdir -p /app/soft/grid
mkdir -p /app/soft/oracle
mkdir -p /app/soft/asmlib
mkdir -p /backup
mkdir -p /arch

chown -R oracle:oinstall /app
chown -R oracle:oinstall /arch
chown -R oracle:oinstall /backup
chown -R grid:oinstall /app/grid
chown -R oracle:oinstall /app/oracle
chown -R grid:oinstall /app/oraInventory
chown -R grid:oinstall /app/soft/grid
chown -R oracle:oinstall /app/soft/oracle
chmod -R 755 /app


2.5 修改Oracle使用者shell許可權
vi /etc/security/limits.conf
新增:
* soft nproc 2047
* hard nproc 16384
* soft nofile 1024
* hard nofile 65536

2.6 修改配置檔案vi /etc/profile
if [ $USER = "oracle" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -u 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
fi

2.7 關閉selinux
vi /etc/sysconfig/selinux
#modify by lcs for oracle
#old SELINUX=enforcing
SELINUX=disabled

2.8 關閉防火牆
service iptables stop
chkconfig iptables off

2.9 使用者限制,登入
vi /etc/pam.d/login
新增:
session required pam_limits.so


3. 建立兩個Exadata所需的配置檔案。Exadata所需要的配置檔案有兩個一個是cellinit.ora,此檔案中填入DB節點的ip地址和子網掩碼。
  另外一個是cellip.ora, 此檔案填入Cell節點的ip地址

[root@exadata ~]# mkdir -p    /etc/oracle/cell/network-config
[root@exadata ~]# chown -R grid:oinstall  /etc/oracle/cell/network-config
[root@exadata ~]# chmod -R 775 /etc/oracle/cell/network-config
[root@exadata ~]# vi /etc/oracle/cell/network-config/cellinit.ora
ipaddress1=192.168.9.246/24
~
~
~
"/etc/oracle/cell/network-config/cellinit.ora" [New] 1L, 28C written
[root@exadata ~]# vi /etc/oracle/cell/network-config/cellip.ora
cell="192.168.9.245"
~
~
~
~
"/etc/oracle/cell/network-config/cellip.ora" [New] 1L, 21C written
[root@exadata ~]#


4.  安裝asm管理

下載地址:

下載時注意版本核心
[root@rac1 yum.repos.d]# uname -a
Linux rac1 2.6.18-164.el5 #1 SMP Tue Aug 18 15:51:48 EDT 2009 x86_64 x86_64 x86_64 GNU/Linux
[root@rac1 yum.repos.d]# cat /etc/redhat-release
Red Hat Enterprise Linux Server release 5.4 (Tikanga)
[root@rac1 yum.repos.d]#

核心引數: 2.6.18-164.el5

[root@rac1 oracleasm]# cd /tmp/oracleasm/
[root@rac1 oracleasm]# ll
total 536
-rw-r--r-- 1 root root 136910 Nov 19 13:51 oracleasm-2.6.18-164.el5-2.0.5-1.el5.x86_64.rpm
-rw-r--r-- 1 root root 138539 Nov 19 13:51 oracleasm-2.6.18-164.el5debug-2.0.5-1.el5.x86_64.rpm
-rw-r--r-- 1 root root   2807 Nov 19 13:51 oracleasm-2.6.18-164.el5-debuginfo-2.0.5-1.el5.x86_64.rpm
-rw-r--r-- 1 root root 136839 Nov 19 13:51 oracleasm-2.6.18-164.el5xen-2.0.5-1.el5.x86_64.rpm
-rw-r--r-- 1 root root  14176 Nov 19 13:51 oracleasmlib-2.0.4-1.el5.x86_64.rpm
-rw-r--r-- 1 root root  90225 Nov 19 13:51 oracleasm-support-2.1.8-1.el5.x86_64.rpm



直接rpm包的安裝
rpm -ivh oracleasm-support-2.1.8-1.el5.x86_64.rpm
rpm -ivh oracleasm-2.6.18-164.el5-2.0.5-1.el5.x86_64.rpm
rpm -ivh oracleasmlib-2.0.4-1.el5.x86_64.rpm


初始化 asmlib,在所有節點執行;
[root@rac1 ~]# /usr/sbin/oracleasm configure -i
Configuring the Oracle ASM library driver.

This will configure the on-boot properties of the Oracle ASM library
driver.  The following questions will determine whether the driver is
loaded on boot and what permissions it will have.  The current values
will be shown in brackets ('[]').  Hitting without typing an
answer will keep that current value.  Ctrl-C will abort.

Default user to own the driver interface []: grid
Default group to own the driver interface []: asmadmin
Start Oracle ASM library driver on boot (y/n) [n]: y
Scan for Oracle ASM disks on boot (y/n) [y]: y
Writing Oracle ASM library driver configuration: done
[root@rac1 ~]#

ASMlib 載入到核心,在所有節點執行;
[root@rac1 ~]# /usr/sbin/oracleasm init
Creating /dev/oracleasm mount point: /dev/oracleasm
Loading module "oracleasm": oracleasm
Mounting ASMlib driver filesystem: /dev/oracleasm
[root@rac1 ~]#



5. 配置oracle使用者,grid使用者環境變數


6. 安裝grid軟體

先配一些普通的裸盤(raw disk)做asm


這些以o/開頭的ASM磁碟就是Exadata Cell端建立的griddisk。
當然在安裝的時候可以選擇普通的裸盤(raw disk)而非griddisk作為磁碟組,
到Grid Infrastructure安裝完畢以後透過asmca來新增/新建新的磁碟組

7. 安裝oracle軟體

8. 安裝oracle資料庫

9. 配監聽等等

10. 簡單驗證操作
[grid@exadata ~]:+ASM> asmcmd
ASMCMD> lsdg
State    Type    Rebal  Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name
MOUNTED  EXTERN  N         512   4096  4194304     10236    10156                0           10156              0             N  BACK/
MOUNTED  EXTERN  N         512   4096  4194304       944      864                0             864              0             N  CELL1/
MOUNTED  EXTERN  N         512   4096  4194304      8496     6460                0            6460              0             N  CELLDATA/
MOUNTED  EXTERN  N         512   4096  1048576     15358    15299                0           15299              0             N  DATA/
MOUNTED  NORMAL  N         512   4096  4194304     10224    10064                0            5032              0             N  OCR/
ASMCMD> lsattr -l -G data
Name                     Value       
access_control.enabled   FALSE       
access_control.umask     066         
au_size                  1048576     
cell.smart_scan_capable  FALSE       
compatible.asm           11.2.0.0.0  
compatible.rdbms         10.1.0.0.0  
disk_repair_time         3.6h        
sector_size              512         
ASMCMD> lsdsk -G data
Path
ORCL:DATA_VOL1
ASMCMD> lsdsk -G celldata
Path
o/192.168.9.245/data_CD_disk02_cell1
o/192.168.9.245/data_CD_disk03_cell1
o/192.168.9.245/data_CD_disk04_cell1
o/192.168.9.245/data_CD_disk05_cell1
o/192.168.9.245/data_CD_disk06_cell1
o/192.168.9.245/data_CD_disk07_cell1
o/192.168.9.245/data_CD_disk08_cell1
o/192.168.9.245/data_CD_disk09_cell1
o/192.168.9.245/data_CD_disk10_cell1
ASMCMD>



SQL> select disk_number, name, path from v$asm_disk where path like 'o/%' order by disk_number;

DISK_NUMBER NAME
----------- ------------------------------
PATH
--------------------------------------------------------------------------------
          0 DATA_CD_DISK01_CELL1
o/192.168.9.245/data_CD_disk01_cell1

          0 DATA_CD_DISK02_CELL1
o/192.168.9.245/data_CD_disk02_cell1

          1 DATA_CD_DISK03_CELL1
o/192.168.9.245/data_CD_disk03_cell1


DISK_NUMBER NAME
----------- ------------------------------
PATH
--------------------------------------------------------------------------------
          2 DATA_CD_DISK04_CELL1
o/192.168.9.245/data_CD_disk04_cell1

          3 DATA_CD_DISK05_CELL1
o/192.168.9.245/data_CD_disk05_cell1

          4 DATA_CD_DISK06_CELL1
o/192.168.9.245/data_CD_disk06_cell1


DISK_NUMBER NAME
----------- ------------------------------
PATH
--------------------------------------------------------------------------------
          5 DATA_CD_DISK07_CELL1
o/192.168.9.245/data_CD_disk07_cell1

          6 DATA_CD_DISK08_CELL1
o/192.168.9.245/data_CD_disk08_cell1

          7
o/192.168.9.245/data_CD_disk12_cell1


DISK_NUMBER NAME
----------- ------------------------------
PATH
--------------------------------------------------------------------------------
          7 DATA_CD_DISK09_CELL1
o/192.168.9.245/data_CD_disk09_cell1

          8 DATA_CD_DISK10_CELL1
o/192.168.9.245/data_CD_disk10_cell1

         10
o/192.168.9.245/data_CD_disk11_cell1


12 rows selected.

SQL>

SQL>  select name, path from v$asm_disk;            

NAME
------------------------------
PATH
--------------------------------------------------------------------------------
BACK_VOL1
ORCL:BACK_VOL1

DATA_VOL1
ORCL:DATA_VOL1

OCR_VOL1
ORCL:OCR_VOL1


NAME
------------------------------
PATH
--------------------------------------------------------------------------------
OCR_VOL2
ORCL:OCR_VOL2

DATA_CD_DISK04_CELL1
o/192.168.9.245/data_CD_disk04_cell1

DATA_CD_DISK06_CELL1
o/192.168.9.245/data_CD_disk06_cell1


NAME
------------------------------
PATH
--------------------------------------------------------------------------------
DATA_CD_DISK05_CELL1
o/192.168.9.245/data_CD_disk05_cell1

DATA_CD_DISK03_CELL1
o/192.168.9.245/data_CD_disk03_cell1

DATA_CD_DISK07_CELL1
o/192.168.9.245/data_CD_disk07_cell1


NAME
------------------------------
PATH
--------------------------------------------------------------------------------
DATA_CD_DISK09_CELL1
o/192.168.9.245/data_CD_disk09_cell1

DATA_CD_DISK08_CELL1
o/192.168.9.245/data_CD_disk08_cell1

DATA_CD_DISK02_CELL1
o/192.168.9.245/data_CD_disk02_cell1


NAME
------------------------------
PATH
--------------------------------------------------------------------------------
DATA_CD_DISK01_CELL1
o/192.168.9.245/data_CD_disk01_cell1

DATA_CD_DISK10_CELL1
o/192.168.9.245/data_CD_disk10_cell1


o/192.168.9.245/data_CD_disk11_cell1


NAME
------------------------------
PATH
--------------------------------------------------------------------------------

o/192.168.9.245/data_CD_disk12_cell1


16 rows selected.

SQL>

SQL> select file#, name from v$datafile;

     FILE#
----------
NAME
--------------------------------------------------------------------------------
         1
+CELLDATA/exadata/datafile/system.261.869661803

         2
+CELLDATA/exadata/datafile/sysaux.262.869661811

         3
+CELLDATA/exadata/datafile/undotbs1.263.869661817


     FILE#
----------
NAME
--------------------------------------------------------------------------------
         4
+CELLDATA/exadata/datafile/users.265.869661827


SQL>

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/29500582/viewspace-1410794/,如需轉載,請註明出處,否則將追究法律責任。

相關文章