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 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 &