安裝oracle 11g 使用ASM儲存 詳細

作業系統 suse 11企業版

配置ASMlib，官方文件地址參考

把劃分的四塊盤分割槽

fdisk /dev/sdb ……

fdisk ...

建立使用者 oracle 密碼 oracle

下載asmlib rpm包

執行安裝包

配置ORACLEASM

初始化 ASM

建立ASM 磁碟

檢查磁碟組狀態

檢查磁碟是否掛在到ASM檔案系統

安裝grid軟體，使用ASM儲存必須安裝grid軟體

選擇資料檔案磁碟組

密碼全是oracle

報錯了 手動建立

需要增加swap

其他檢查錯誤

先打補丁重新檢查

打上以下補丁

重新執行 root.sh

執行命令,仍有報錯

執行提示

/home/oracle/app/oracle/product/11.2.0/grid/bin/crsctl start crs

再執行一遍root.sh試試

log位置記錄

安裝資料庫軟體

訪問ASM例項

ASM:~ # ps -ef

UID PID PPID C STIME TTY TIME CMD

root 1 0 0 Jun11 ? 00:00:03 init [5]

root 2 0 0 Jun11 ? 00:00:00 [kthreadd]

root 3 2 0 Jun11 ? 00:00:00 [migration/0]

root 4 2 0 Jun11 ? 00:00:00 [ksoftirqd/0]

root 5 2 0 Jun11 ? 00:00:00 [migration/1]

root 6 2 0 Jun11 ? 00:00:00 [ksoftirqd/1]

root 7 2 0 Jun11 ? 00:00:00 [migration/2]

root 8 2 0 Jun11 ? 00:00:03 [ksoftirqd/2]

root 9 2 0 Jun11 ? 00:00:00 [migration/3]

root 10 2 0 Jun11 ? 00:00:00 [ksoftirqd/3]

root 11 2 0 Jun11 ? 00:00:07 [events/0]

root 12 2 0 Jun11 ? 00:00:07 [events/1]

root 13 2 0 Jun11 ? 00:00:07 [events/2]

root 14 2 0 Jun11 ? 00:00:09 [events/3]

root 15 2 0 Jun11 ? 00:00:00 [cpuset]

root 16 2 0 Jun11 ? 00:00:00 [khelper]

root 17 2 0 Jun11 ? 00:00:00 [netns]

root 18 2 0 Jun11 ? 00:00:00 [async/mgr]

root 19 2 0 Jun11 ? 00:00:00 [pm]

root 20 2 0 Jun11 ? 00:00:00 [sync_supers]

root 21 2 0 Jun11 ? 00:00:00 [bdi-default]

root 22 2 0 Jun11 ? 00:00:00 [kintegrityd/0]

root 23 2 0 Jun11 ? 00:00:00 [kintegrityd/1]

root 24 2 0 Jun11 ? 00:00:00 [kintegrityd/2]

root 25 2 0 Jun11 ? 00:00:00 [kintegrityd/3]

root 26 2 0 Jun11 ? 00:00:00 [kblockd/0]

root 27 2 0 Jun11 ? 00:00:00 [kblockd/1]

root 28 2 0 Jun11 ? 00:00:00 [kblockd/2]

root 29 2 0 Jun11 ? 00:00:00 [kblockd/3]

root 30 2 0 Jun11 ? 00:00:00 [kacpid]

root 31 2 0 Jun11 ? 00:00:00 [kacpi_notify]

root 32 2 0 Jun11 ? 00:00:00 [kacpi_hotplug]

root 33 2 0 Jun11 ? 00:00:00 [kseriod]

root 38 2 0 Jun11 ? 00:00:00 [kondemand/0]

root 39 2 0 Jun11 ? 00:00:00 [kondemand/1]

root 40 2 0 Jun11 ? 00:00:00 [kondemand/2]

root 41 2 0 Jun11 ? 00:00:00 [kondemand/3]

root 42 2 0 Jun11 ? 00:00:00 [khungtaskd]

root 43 2 0 Jun11 ? 00:00:03 [kswapd0]

root 44 2 0 Jun11 ? 00:00:00 [ksmd]

root 45 2 0 Jun11 ? 00:00:00 [aio/0]

root 46 2 0 Jun11 ? 00:00:00 [aio/1]

root 47 2 0 Jun11 ? 00:00:00 [aio/2]

root 48 2 0 Jun11 ? 00:00:00 [aio/3]

root 49 2 0 Jun11 ? 00:00:00 [crypto/0]

root 50 2 0 Jun11 ? 00:00:00 [crypto/1]

root 51 2 0 Jun11 ? 00:00:00 [crypto/2]

root 52 2 0 Jun11 ? 00:00:00 [crypto/3]

root 54 2 0 Jun11 ? 00:00:00 [kpsmoused]

root 106 2 0 Jun11 ? 00:00:01 [mpt_poll_0]

root 107 2 0 Jun11 ? 00:00:00 [mpt/0]

root 108 2 0 Jun11 ? 00:00:00 [scsi_eh_0]

root 116 2 0 Jun11 ? 00:00:00 [ata/0]

root 117 2 0 Jun11 ? 00:00:00 [ata/1]

root 118 2 0 Jun11 ? 00:00:00 [ata/2]

root 119 2 0 Jun11 ? 00:00:24 [ata/3]

root 120 2 0 Jun11 ? 00:00:00 [ata_aux]

root 125 2 0 Jun11 ? 00:00:00 [scsi_eh_1]

root 126 2 0 Jun11 ? 00:00:00 [scsi_eh_2]

root 1066 2 0 Jun11 ? 00:00:05 [kjournald]

root 1072 2 0 Jun11 ? 00:00:05 [flush-8:0]

root 1142 1 0 Jun11 ? 00:00:00 /sbin/udevd --daemon

root 2172 2 0 Jun11 ? 00:00:00 [kauditd]

root 2187 2 0 Jun11 ? 00:00:00 [kstriped]

root 2765 1 0 Jun11 ? 00:00:00 /sbin/acpid

100 2780 1 0 Jun11 ? 00:00:01 /bin/dbus-daemon --system

root 2798 1 0 Jun11 ? 00:00:00 /sbin/syslog-ng

root 2801 1 0 Jun11 ? 00:00:00 /sbin/klogd -c 1 -x

101 2926 1 0 Jun11 ? 00:00:01 /usr/sbin/hald --daemon=yes

root 2929 1 0 Jun11 ? 00:00:00 /usr/sbin/console-kit-daemon

root 2930 2926 0 Jun11 ? 00:00:00 hald-runner

root 3025 2930 0 Jun11 ? 00:00:00 hald-addon-input: Listening on /dev/input/event0 /dev/input/event2 /dev/in

root 3055 2930 0 Jun11 ? 00:00:46 hald-addon-storage: polling /dev/sr0 (every 2 sec)

root 3059 2930 0 Jun11 ? 00:00:03 hald-addon-storage: no polling on /dev/fd0 because it is explicitly disabl

101 3062 2930 0 Jun11 ? 00:00:00 hald-addon-acpi: listening on acpid socket /var/run/acpid.socket

root 3502 1 0 Jun11 ? 00:00:00 /sbin/auditd -s disable

root 3504 3502 0 Jun11 ? 00:00:00 /sbin/audispd

root 3531 1 0 Jun11 ? 00:00:00 /sbin/rpcbind

root 3842 1 0 Jun11 ? 00:00:00 /usr/sbin/sfcbd -d

root 3846 3842 0 Jun11 ? 00:00:00 /usr/sbin/sfcbd -d

root 3847 3842 0 Jun11 ? 00:00:00 /usr/sbin/sfcbd -d

root 3848 1 0 Jun11 ? 00:00:00 /usr/sbin/sshd -o PidFile=/var/run/sshd.init.pid

root 3862 1 0 Jun11 ? 00:00:00 /usr/sbin/cupsd

root 3880 1 0 Jun11 ? 00:00:20 /usr/sbin/irqbalance

root 3895 1 0 Jun11 ? 00:00:03 /usr/sbin/nscd

root 3957 3842 0 Jun11 ? 00:00:00 /usr/sbin/sfcbd -d

root 3979 1 0 Jun11 ? 00:00:00 /usr/lib/postfix/master

root 4014 1 0 Jun11 ? 00:00:01 /usr/sbin/gdm

root 4033 1 0 Jun11 ? 00:00:00 /usr/sbin/cron

root 4047 4014 0 Jun11 ? 00:00:00 /usr/lib/gdm/gdm-simple-slave --display-id /org/gnome/DisplayManager/Displ

root 4050 4047 0 Jun11 tty7 00:00:09 /usr/bin/X :0 -br -verbose -auth /var/run/gdm/auth-for-gdm-N6Aydu/database

root 4076 1 0 Jun11 tty1 00:00:00 /sbin/mingetty --noclear tty1

root 4077 1 0 Jun11 tty2 00:00:00 /sbin/mingetty tty2

root 4078 1 0 Jun11 tty3 00:00:00 /sbin/mingetty tty3

root 4079 1 0 Jun11 tty4 00:00:00 /sbin/mingetty tty4

root 4080 1 0 Jun11 tty5 00:00:00 /sbin/mingetty tty5

root 4081 1 0 Jun11 tty6 00:00:00 /sbin/mingetty tty6

root 4190 3842 0 Jun11 ? 00:00:00 /usr/sbin/sfcbd -d

gdm 4215 1 0 Jun11 ? 00:00:00 /usr/bin/dbus-launch --exit-with-session

root 4241 3842 0 Jun11 ? 00:00:00 /usr/sbin/sfcbd -d

root 4244 3842 0 Jun11 ? 00:00:00 /usr/sbin/sfcbd -d

root 4285 4047 0 Jun11 ? 00:00:00 /usr/lib/gdm/gdm-session-worker

root 4311 4285 0 Jun11 ? 00:00:00 /usr/bin/gnome-session

root 4394 4311 0 Jun11 ? 00:00:06 /usr/bin/gpg-agent --sh --daemon --write-env-file /root/.gnupg/agent.info

root 4400 1 0 Jun11 ? 00:00:00 dbus-launch --exit-with-session /usr/bin/gnome-session

root 4401 1 0 Jun11 ? 00:00:00 /bin/dbus-daemon --fork --print-pid 5 --print-address 9 --session

root 4404 1 0 Jun11 ? 00:00:01 /usr/lib/GConf/2/gconfd-2

root 4409 1 0 Jun11 ? 00:00:09 /usr/lib/gnome-settings-daemon/gnome-settings-daemon

root 4412 1 0 Jun11 ? 00:00:00 gnome-keyring-daemon --start

root 4416 1 0 Jun11 ? 00:00:00 /usr/lib64/gvfs/gvfsd

root 4421 1 0 Jun11 ? 00:00:00 /usr/lib64/gvfs//gvfs-fuse-daemon /root/.gvfs

root 4427 4311 0 Jun11 ? 00:00:01 /usr/bin/metacity

root 4433 4311 0 Jun11 ? 00:00:09 gnome-panel

root 4434 4311 0 Jun11 ? 00:02:21 nautilus

root 4436 1 0 Jun11 ? 00:00:00 /usr/lib/bonobo/bonobo-activation-server --ac-activate --ior-output-fd=18

root 4446 1 0 Jun11 ? 00:00:21 /usr/lib64/gnome-main-menu/main-menu --oaf-activate-iid=OAFIID:GNOME_MainM

root 4448 1 0 Jun11 ? 00:00:02 /usr/lib64/gvfs/gvfsd-trash --spawner :1.7 /org/gtk/gvfs/exec_spaw/0

root 4450 1 0 Jun11 ? 00:00:00 /usr/lib64/gvfs/gvfs-hal-volume-monitor

root 4452 1 0 Jun11 ? 00:00:00 /usr/lib64/gvfs/gvfs-gphoto2-volume-monitor

root 4469 4311 0 Jun11 ? 00:00:00 gnome-volume-control-applet

root 4474 4311 0 Jun11 ? 00:00:00 python /usr/lib64/python2.6/site-packages/system-config-printer/applet.py

root 4480 1 0 Jun11 ? 00:00:01 gnome-power-manager

root 4492 1 0 Jun11 ? 00:00:01 gnome-screensaver

root 4494 1 0 Jun11 ? 00:00:00 /usr/lib64/gvfs/gvfsd-burn --spawner :1.7 /org/gtk/gvfs/exec_spaw/1

root 4496 1 0 Jun11 ? 00:00:00 /usr/bin/gnome-terminal -x /bin/sh -c cd '/root/Desktop' && exec $SHELL -l

root 4497 4496 0 Jun11 ? 00:00:00 gnome-pty-helper

root 4498 4496 0 Jun11 pts/0 00:00:00 /bin/bash -l

root 4709 4498 0 Jun11 pts/0 00:00:00 /bin/bash /sbin/yast2

root 4738 4709 0 Jun11 pts/0 00:00:05 /usr/lib/YaST2/bin/y2controlcenter-gnome

root 4740 1 0 Jun11 pts/0 00:00:00 gnomesu -- /sbin/yast2 sw_single

root 4741 4740 0 Jun11 pts/0 00:00:00 /usr/lib/libgnomesu/gnomesu-pam-backend 6 5 root /sbin/yast2 sw_single

root 4748 4741 0 Jun11 pts/0 00:00:00 /bin/bash /sbin/yast2 sw_single

root 5164 4014 0 Jun11 ? 00:00:00 /usr/lib/gdm/gdm-simple-slave --display-id /org/gnome/DisplayManager/Displ

gdm 5182 1 0 Jun11 ? 00:00:00 /usr/bin/dbus-launch --exit-with-session

root 5209 5164 0 Jun11 ? 00:00:00 /usr/lib/gdm/gdm-session-worker

root 5219 5209 0 Jun11 ? 00:00:00 /usr/bin/gnome-session

root 5301 1 0 Jun11 ? 00:00:00 dbus-launch --exit-with-session /usr/bin/gnome-session

root 5302 1 0 Jun11 ? 00:00:00 /bin/dbus-daemon --fork --print-pid 5 --print-address 9 --session

root 5305 1 0 Jun11 ? 00:00:01 /usr/lib/GConf/2/gconfd-2

root 5310 1 0 Jun11 ? 00:00:07 /usr/lib/gnome-settings-daemon/gnome-settings-daemon

root 5311 1 0 Jun11 ? 00:00:00 gnome-keyring-daemon --start

root 5317 1 0 Jun11 ? 00:00:00 /usr/lib64/gvfs/gvfsd

root 5326 5219 0 Jun11 ? 00:00:02 /usr/bin/metacity

root 5332 5219 0 Jun11 ? 00:00:12 gnome-panel

root 5334 5219 0 Jun11 ? 00:02:41 nautilus

root 5336 1 0 Jun11 ? 00:00:00 /usr/lib/bonobo/bonobo-activation-server --ac-activate --ior-output-fd=18

root 5345 1 0 Jun11 ? 00:00:20 /usr/lib64/gnome-main-menu/main-menu --oaf-activate-iid=OAFIID:GNOME_MainM

root 5347 1 0 Jun11 ? 00:00:02 /usr/lib64/gvfs/gvfsd-trash --spawner :1.7 /org/gtk/gvfs/exec_spaw/0

root 5351 1 0 Jun11 ? 00:00:00 /usr/lib64/gvfs/gvfs-hal-volume-monitor

root 5355 1 0 Jun11 ? 00:00:00 /usr/lib64/gvfs/gvfs-gphoto2-volume-monitor

root 5365 5219 0 Jun11 ? 00:00:00 gnome-volume-control-applet

root 5370 5219 0 Jun11 ? 00:00:00 python /usr/lib64/python2.6/site-packages/system-config-printer/applet.py

root 5378 1 0 Jun11 ? 00:00:01 gnome-power-manager

root 5379 1 0 Jun11 ? 00:00:00 gnome-screensaver

root 5384 1 0 Jun11 ? 00:00:00 /usr/lib64/gvfs/gvfsd-burn --spawner :1.7 /org/gtk/gvfs/exec_spaw/1

root 5386 1 0 Jun11 ? 00:00:03 /usr/bin/gnome-terminal -x /bin/sh -c cd '/root/Desktop' && exec $SHELL -l

root 5387 5386 0 Jun11 ? 00:00:00 gnome-pty-helper

root 5388 5386 0 Jun11 pts/2 00:00:00 /bin/bash -l

root 5426 5388 0 Jun11 pts/2 00:00:00 su - oracle

oracle 5427 5426 0 Jun11 pts/2 00:00:00 -bash

oracle 5479 5427 0 Jun11 pts/2 00:00:00 bash

root 6906 4748 0 Jun11 pts/0 00:00:00 /usr/bin/zenity --title=Error --text-info --filename=/tmp/yast2-err-38PTBf

root 11288 4014 0 16:15 ? 00:00:00 /usr/lib/gdm/gdm-simple-slave --display-id /org/gnome/DisplayManager/Displ

gdm 11305 1 0 16:15 ? 00:00:00 /usr/bin/dbus-launch --exit-with-session

root 11333 11288 0 16:15 ? 00:00:00 /usr/lib/gdm/gdm-session-worker

root 11344 11333 0 16:15 ? 00:00:00 /usr/bin/gnome-session

root 11425 1 0 16:15 ? 00:00:00 dbus-launch --exit-with-session /usr/bin/gnome-session

root 11426 1 0 16:15 ? 00:00:00 /bin/dbus-daemon --fork --print-pid 5 --print-address 9 --session

root 11429 1 0 16:15 ? 00:00:00 /usr/lib/GConf/2/gconfd-2

root 11434 1 0 16:15 ? 00:00:00 /usr/lib/gnome-settings-daemon/gnome-settings-daemon

root 11438 1 0 16:16 ? 00:00:00 /usr/lib64/gvfs/gvfsd

root 11442 1 0 16:16 ? 00:00:00 gnome-keyring-daemon --start

root 11450 11344 0 16:16 ? 00:00:00 /usr/bin/metacity

root 11456 11344 0 16:16 ? 00:00:01 gnome-panel

root 11458 11344 0 16:16 ? 00:00:07 nautilus

root 11460 1 0 16:16 ? 00:00:00 /usr/lib/bonobo/bonobo-activation-server --ac-activate --ior-output-fd=18

root 11463 1 0 16:16 ? 00:00:00 /usr/lib64/gvfs/gvfsd-trash --spawner :1.6 /org/gtk/gvfs/exec_spaw/0

root 11471 1 0 16:16 ? 00:00:01 /usr/lib64/gnome-main-menu/main-menu --oaf-activate-iid=OAFIID:GNOME_MainM

root 11473 1 0 16:16 ? 00:00:00 /usr/lib64/gvfs/gvfs-hal-volume-monitor

root 11477 1 0 16:16 ? 00:00:00 /usr/lib64/gvfs/gvfs-gphoto2-volume-monitor

root 11484 11344 0 16:16 ? 00:00:00 gnome-volume-control-applet

root 11488 11344 0 16:16 ? 00:00:00 python /usr/lib64/python2.6/site-packages/system-config-printer/applet.py

root 11495 1 0 16:16 ? 00:00:00 /usr/bin/pulseaudio --start

root 11500 1 0 16:16 ? 00:00:00 gnome-power-manager

root 11502 1 0 16:16 ? 00:00:00 gnome-screensaver

root 11509 1 0 16:16 ? 00:00:00 /usr/lib64/gvfs/gvfsd-burn --spawner :1.6 /org/gtk/gvfs/exec_spaw/1

root 11511 1 0 16:16 ? 00:00:07 /usr/bin/gnome-terminal -x /bin/sh -c cd '/root/Desktop' && exec $SHELL -l

root 11512 11511 0 16:16 ? 00:00:00 gnome-pty-helper

root 11513 11511 0 16:16 pts/1 00:00:00 /bin/bash -l

root 11620 11513 0 16:22 pts/1 00:00:00 su - oracle

oracle 11621 11620 0 16:22 pts/1 00:00:00 -bash

root 11713 3848 0 16:42 ? 00:00:00 sshd: root@pts/3,pts/4

root 11716 11713 0 16:42 pts/3 00:00:00 -bash

root 11847 11716 0 16:47 pts/3 00:00:00 su - oracle

oracle 11848 11847 0 16:47 pts/3 00:00:00 -bash

postfix 12092 3979 0 17:56 ? 00:00:00 pickup -l -t fifo -u

oracle 12418 11621 3 18:21 pts/1 00:00:12 /home/oracle/app/oracle/product/11.2.0/grid/jdk/jre/bin/java -DORACLE_HOME

oracle 12508 12418 0 18:21 pts/1 00:00:00 /home/oracle/app/oracle/product/11.2.0/grid/bin/sqlplus -S -N

oracle 12511 12508 0 18:21 ? 00:00:00 oracle+ASM (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))

root 12523 11713 0 18:26 pts/4 00:00:00 -bash

root 12563 12523 0 18:28 pts/4 00:00:00 ps -ef

root 13267 1 0 Jun11 ? 00:00:00 /bin/sh /etc/init.d/init.ohasd run

oracle 13294 1 0 Jun11 ? 00:05:23 /home/oracle/app/oracle/product/11.2.0/grid/bin/ohasd.bin reboot

oracle 13619 1 0 Jun11 ? 00:07:05 /home/oracle/app/oracle/product/11.2.0/grid/bin/oraagent.bin

oracle 13634 1 0 Jun11 ? 00:00:13 /home/oracle/app/oracle/product/11.2.0/grid/bin/tnslsnr LISTENER -inherit

oracle 13795 1 0 Jun11 ? 00:00:56 /home/oracle/app/oracle/product/11.2.0/grid/bin/cssdagent

oracle 13797 1 0 Jun11 ? 00:00:30 /home/oracle/app/oracle/product/11.2.0/grid/bin/orarootagent.bin

oracle 13813 1 0 Jun11 ? 00:08:24 /home/oracle/app/oracle/product/11.2.0/grid/bin/ocssd.bin

oracle 13826 1 0 Jun11 ? 00:02:42 /home/oracle/app/oracle/product/11.2.0/grid/bin/diskmon.bin -d -f

oracle 14004 1 0 Jun11 ? 00:00:20 asm_pmon_+ASM

oracle 14006 1 0 Jun11 ? 00:01:34 asm_vktm_+ASM

oracle 14010 1 0 Jun11 ? 00:00:04 asm_gen0_+ASM

oracle 14012 1 0 Jun11 ? 00:00:06 asm_diag_+ASM

oracle 14014 1 0 Jun11 ? 00:00:04 asm_psp0_+ASM

oracle 14016 1 0 Jun11 ? 00:00:58 asm_dia0_+ASM

oracle 14018 1 0 Jun11 ? 00:00:04 asm_mman_+ASM

oracle 14020 1 0 Jun11 ? 00:00:04 asm_dbw0_+ASM

oracle 14022 1 0 Jun11 ? 00:00:04 asm_lgwr_+ASM

oracle 14024 1 0 Jun11 ? 00:00:06 asm_ckpt_+ASM

oracle 14026 1 0 Jun11 ? 00:00:03 asm_smon_+ASM

oracle 14028 1 0 Jun11 ? 00:00:10 asm_rbal_+ASM

oracle 14030 1 0 Jun11 ? 00:00:23 asm_gmon_+ASM

oracle 14032 1 0 Jun11 ? 00:00:09 asm_mmon_+ASM

oracle 14034 1 0 Jun11 ? 00:00:22 asm_mmnl_+ASM

oracle 14262 1 1 Jun11 pts/2 00:33:21 /tmp/OraInstall2013-06-11_08-50-48PM/jdk/jre/bin/java -Doracle.installer.l

postfix 15372 3979 0 Jun11 ? 00:00:00 qmgr -l -t fifo -u

ASM:~ #

重啟ASM例項

使用以下命令

重啟作業系統後

啟動DBCA

啟動ASMCA

配置FRA 磁碟組

安裝DB軟體

DBCA建立資料庫

密碼為oracle

oracle

快速恢復區

SYS、SYSTEM、HR、OE四個賬戶密碼均為oracle

安裝完成。