linux下oracle asmlib的使用
tbtnel
|
1#
tbtnel 发表于 2008-09-10 00:14
linux下oracle asmlib的使用
1、fdisk磁盘
[oracle@CHN-FS-5-546 Disk1]$fdisk /dev/sdb First cylinder (1-239931, default 1): Using default value 1 Last cylinder or +size or +sizeM or +sizeK (1-239931, default 239931): 80000 Command (m for help): p Disk /dev/sdb: 1973.5 GB, 1973503918080 bytes 255 heads, 63 sectors/track, 239931 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Device Boot Start End Blocks Id System /dev/sdb1 1 239931 1927245757 5 Extended /dev/sdb5 1 80000 642599999 83 Linux Command (m for help): n Command action l logical (5 or over) p primary partition (1-4) l First cylinder (80001-239931, default 80001): Using default value 80001 Last cylinder or +size or +sizeM or +sizeK (80001-239931, default 239931): 160000 Command (m for help): n Command action l logical (5 or over) p primary partition (1-4) l First cylinder (160001-239931, default 160001): Using default value 160001 Last cylinder or +size or +sizeM or +sizeK (160001-239931, default 239931): Using default value 239931 Command (m for help): p Disk /dev/sdb: 1973.5 GB, 1973503918080 bytes 255 heads, 63 sectors/track, 239931 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Device Boot Start End Blocks Id System /dev/sdb1 1 239931 1927245757 5 Extended /dev/sdb5 1 80000 642599999 83 Linux /dev/sdb6 80001 160000 642599999+ 83 Linux /dev/sdb7 160001 239931 642045757 83 Linux Command (m for help): w The partition table has been altered! Calling ioctl() to re-read partition table. Syncing disks. [root@CHN-FS-5-544 /]# 2、安装asmlib包 [root@CHN-FS-5-546 ~]# uname -a Linux CHN-FS-5-546 2.6.9-55.ELsmp #1 SMP Fri Apr 20 17:03:35 EDT 2007 i686 i686 i386 GNU/Linux [root@CHN-FS-5-546 ~]# [root@CHN-FS-5-546 asmlib]# rpm -Uvh oracleasm-support-2.0.3-1.i386.rpm oracleasm-2.6.9-55.ELsmp-2.0.3-1.i686.rpm oracleasmlib-2.0.2-1.i386.rpm [root@CHN-FS-5-546 asmlib]# /etc/init.d/oracleasm configure 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 <ENTER> without typing an answer will keep that current value. Ctrl-C will abort. Default user to own the driver interface []: oracle Default group to own the driver interface []: dba Start Oracle ASM library driver on boot (y/n) [n]: y Fix permissions of Oracle ASM disks on boot (y/n) [y]: y Writing Oracle ASM library driver configuration: [ OK ] Creating /dev/oracleasm mount point: [ OK ] Loading module "oracleasm": [ OK ] Mounting ASMlib driver filesystem: [ OK ] Scanning system for ASM disks: [ OK ] [root@CHN-FS-5-546 asmlib]# [root@CHN-FS-5-546 asmlib]# /etc/init.d/oracleasm listdisks [root@CHN-FS-5-546 asmlib]# fdisk -l /dev/sdb Disk /dev/sdb: 1973.5 GB, 1973503918080 bytes 255 heads, 63 sectors/track, 239931 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Device Boot Start End Blocks Id System /dev/sdb1 1 239931 1927245726 5 Extended /dev/sdb5 1 80000 642599937 83 Linux /dev/sdb6 80001 160000 642599968+ 83 Linux /dev/sdb7 160001 239931 642045726 83 Linux [root@CHN-FS-5-546 asmlib]# /etc/init.d/oracleasm createdisk VOL1 /dev/sdb5 Marking disk "/dev/sdb5" as an ASM disk: [ OK ] [root@CHN-FS-5-546 asmlib]# /etc/init.d/oracleasm listdisks VOL1 [root@CHN-FS-5-546 asmlib]# 3、设置linux asm数据库自启动 sh /etc/init.d/init.cssd run & sleep 60 #su - oracle -c '/home/oracle/startup.sh' su - oracle -c 'dbstart' 设置Oracle自启动 方法一、 1、修改/etc/oratab,将$ORACLE_HOME后默认的N改Y [oracle@CHN-FS-5-546 ~]$ more /etc/oratab 。。。。。。 +ASM:/u01/app/oracle/product/10.2.0/db_1:Y logstat1:/u01/app/oracle/product/10.2.0/db_1:Y 2、修改$ORACLE_HOME/bin/dbstart 将ORACLE_HOME_LISTNER赋值为$ORACLE_HOME 3、在rc.local中 添加su - oracle -c 'dbstart' 方法二、 1、添加一个startup脚本 [root@CHN-FS-5-546 oracle]# more startup.sh ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1 ORACLE_SID=+ASM PATH=$ORACLE_HOME/bin export ORACLE_HOME ORACLE_SID PATH sqlplus -S '/as sysdba' <<-EOF spool /home/oracle/startup1.log startup spool off exit; EOF ORACLE_SID=logstat1 PATH=$ORACLE_HOME/bin export ORACLE_SID sqlplus -S '/as sysdba' <<-EOF spool /home/oracle/startup2.log startup spool off exit; EOF [root@CHN-FS-5-544 oracle]# 2、在rc.local中添加 su - oracle -c '/home/oracle/startup.sh' 备注:在调用启动脚本之前应该先启动css服务,否则asm无法启动 sh /etc/init.d/init.cssd run & |