搭建測試環境exadata一體機 (vm虛擬機器redhat上配置)
搭建測試環境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>
環境:
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
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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 虛擬機器配置和環境搭建虛擬機
- 虛擬機器搭建測試環境解決方案虛擬機
- 一、虛擬機器環境配置虛擬機
- 虛擬機器arm虛擬環境搭建虛擬機
- [原創]測試環境搭建虛擬機器工具介紹虛擬機
- 虛擬機器硬體環境搭建問題若干(一)虛擬機
- 虛擬機器環境搭建之vagrant虛擬機
- 虛擬機器快速搭建弱網測試環境 ATC (適合新手)虛擬機
- PHP環境配置-虛擬機器配置及問題解決(VM下的NAT)PHP虛擬機
- 親測好用的虛擬機器軟體:vm虛擬機器 mac中文版虛擬機Mac
- Windows逆向之配置虛擬機器環境Windows虛擬機
- 【RAC】使用VMware虛擬機器搭建RAC環境虛擬機
- Linux環境搭建 | 手把手教你配置Linux虛擬機器Linux虛擬機
- 超好用的mac虛擬機器軟體:VM虛擬機器 mac中文版Mac虛擬機
- 虛擬機器 VM virtualBox && VMware虛擬機
- Esxi下vm虛擬機器命令虛擬機
- 虛擬機器VM跨版本使用虛擬機
- Ubuntu虛擬機器進入虛擬環境的流程Ubuntu虛擬機
- pycharm上的python虛擬環境移到離線機器上PyCharmPython
- VC++檢測VM、VPC虛擬機器程式碼 .C++虛擬機
- VC++檢測VM、VPC虛擬機器程式碼C++虛擬機
- 本地訪問虛擬機器(Vmware)環境下配置的域名虛擬機
- VM虛擬機器 VMware Fusion Pro for Mac虛擬機Mac
- VMware Fusion 13 for Mac(VM虛擬機器)Mac虛擬機
- vm虛擬機器改變硬碟大小虛擬機硬碟
- 虛擬環境搭建
- 學習CDH叢集環境的搭建(虛擬機器可演示)虛擬機
- VMware虛擬機器搭建Linux Oracle 10g ASM環境虛擬機LinuxOracle 10gASM
- 虛擬機器(三)虛擬機器配置靜態Ip虛擬機
- Dr.com環境下VMware虛擬機器和主機共享上網方法虛擬機
- 07、環境-虛擬機器網路設定虛擬機
- 虛擬機器環境下RAC加入節點虛擬機
- VM和Container 虛擬機器和容器AI虛擬機
- VMware Fusion Pro 13(VM虛擬機器) 中文虛擬機
- VMware Fusion Pro for mac(vm虛擬機器13.0.2)Mac虛擬機
- 安裝VM虛擬機器 centos7虛擬機CentOS
- VM虛擬機器Ubuntu下安裝VMTools虛擬機Ubuntu
- LOL虛擬機器 最新測試可玩虛擬機