首页 >

手动创建Oracle 10g ASM磁盘组

数据库|mysql教程手动创建Oracle 10g ASM磁盘组
Oracle教程,手动创建Oracle 10g ASM磁盘组
数据库-mysql教程
投稿系统源码,vscode 设置为英文,ubuntu不usb,tomcat 添加文件访问,爬虫拓扑,php 去标签,浙江新款seo价格信息,挪车网站源码,蓝色asp网站模板源码lzw
准备环境:Oracle 10g 联机文档、已经配置10g数据库软件的主机、oracleasm library rpm包、2块5GB硬盘1、 查看本机磁盘信息[roo
会锁屏源码,ubuntu下搭建php,tomcat的常见报错,什么爬虫亲人,php项目责任描述,石河子seo 网络推广联系方式lzw
56视频源码,vscode写后台,ubuntu哈希校验怎么学,tomcat集群状态,sqlite获取blob数据,圆形进度条插件下载,前端采用主流框架技术,推特爬虫github,php 父类的父类方法,seo jin a,在哪些网站下载源代码,易语言网页填表框架,免费软件模板下载网站,wordpress 淘宝客页面,jquery网站后台管理系统导航,论坛网站程序下载lzw

准备环境:

Oracle 10g 联机文档、已经配置10g数据库软件的主机、oracleasm library rpm包、2块5GB硬盘

1、 查看本机磁盘信息

[root@shiyueasm~]# fdisk -l

Disk/dev/sda: 16.1 GB, 16106127360 bytes

255 heads,63 sectors/track, 1958 cylinders

Units =cylinders of 16065 * 512 = 8225280 bytes

Device Boot Start End Blocks Id System

/dev/sda1 * 307 1958 13269690 83 Linux

/dev/sda2 1 306 2457913+ 82 Linux swap

Partitiontable entries are not in disk order

Disk/dev/sdb: 10.7 GB, 10737418240 bytes

255heads, 63 sectors/track, 1305 cylinders

Units =cylinders of 16065 * 512 = 8225280 bytes

Device Boot Start End Blocks Id System

/dev/sdb1 * 1 1305 10482381 83 Linux

Disk/dev/sdc: 5368 MB, 5368709120 bytes

255heads, 63 sectors/track, 652 cylinders

Units =cylinders of 16065 * 512 = 8225280 bytes

Disk/dev/sdc doesn’t contain a valid partition table

Disk/dev/sdd: 5368 MB, 5368709120 bytes

255heads, 63 sectors/track, 652 cylinders

Units =cylinders of 16065 * 512 = 8225280 bytes

Disk /dev/sdd doesn’t contain a validpartition table

2、 对新添加的2块磁盘进行分区

[root@shiyueasm~]# fdisk /dev/sdc

Devicecontains neither a valid DOS partition table, nor Sun, SGI or OSF disklabel

Buildinga new DOS disklabel. Changes will remain in memory only,

until youdecide to write them. After that, of course, the previous

contentwon’t be recoverable.

Warning:invalid flag 0x0000 of partition table 4 will be corrected by w(rite)

Command(m for help): n

Commandaction

e extended

p primary partition (1-4)

p

Partitionnumber (1-4): 1

Firstcylinder (1-652, default 1):

Usingdefault value 1

Lastcylinder or +size or +sizeM or +sizeK (1-652, default 652):

Usingdefault value 652

Command(m for help): w

Thepartition table has been altered!

Callingioctl() to re-read partition table.

Syncingdisks.

[root@shiyueasm~]# fdisk /dev/sdd

Devicecontains neither a valid DOS partition table, nor Sun, SGI or OSF disklabel

Buildinga new DOS disklabel. Changes will remain in memory only,

until youdecide to write them. After that, of course, the previous

contentwon’t be recoverable.

Warning:invalid flag 0x0000 of partition table 4 will be corrected by w(rite)

Command(m for help): n

Commandaction

e extended

p primary partition (1-4)

p

Partitionnumber (1-4): 1

Firstcylinder (1-652, default 1):

Usingdefault value 1

Lastcylinder or +size or +sizeM or +sizeK (1-652, default 652):

Usingdefault value 652

Command(m for help): w

Thepartition table has been altered!

Callingioctl() to re-read partition table.

Syncing disks.

3、 上传 oracle asmlibrary rpm包并对上传的包进行安装

[root@shiyueasmu01]# cd asm\ rpm\ for\ rhel4.0/

[root@shiyueasmasm rpm for rhel4.0]# ll

total 236

-rw-r–r– 1 root root 129218 Apr 29 2010oracleasm-2.6.9-42.ELsmp-2.0.3-1.i686.rpm

-rw-r–r– 1 root root 13105 Apr 29 2010oracleasmlib-2.0.4-1.el4.i386.rpm

-rw-r–r– 1 root root 82542 Apr 29 2010oracleasm-support-2.1.3-1.el4.i386.rpm

[root@shiyueasmasm rpm for rhel4.0]# rpm -ivh *

warning:oracleasmlib-2.0.4-1.el4.i386.rpm: V3 DSA signature: NOKEY, key ID b38a8516

Preparing… ########################################### [100%]

1:oracleasm-support ########################################### [ 33%]

2:oracleasm-2.6.9-42.ELsm########################################### [67%]

3:oracleasmlib ########################################### [100%]

4、 配置ASM驱动

[root@shiyueasm~]# /etc/init.d/oracleasm configure

Configuringthe Oracle ASM library driver.

This willconfigure the on-boot properties of the Oracle ASM library

driver. The following questions will determinewhether the driver is

loaded onboot and what permissions it will have. The current values

will beshown in brackets (‘[]’). Hitting without typing an

answerwill keep that current value. Ctrl-Cwill abort.

Defaultuser to own the driver interface []: oracle

Defaultgroup to own the driver interface []: oinstall

StartOracle ASM library driver on boot (y/n) [n]: y

Scan forOracle ASM disks on boot (y/n) [y]:

WritingOracle ASM library driver configuration: done

Initializingthe Oracle ASMLib driver: [ OK ]

Scanning the system for Oracle ASMLibdisks: [ OK ]

5、 创建ASM磁盘组

[root@shiyueasm~]# /etc/init.d/oracleasm createdisk VOL01 ‘/dev/sdc1’

Markingdisk “VOL02” as an ASM disk: [ OK ]

[root@shiyueasm~]# /etc/init.d/oracleasm createdisk VOL02 ‘/dev/sdd1’

Marking disk “VOL01” as anASM disk: [ OK ]

6、 手动创建磁盘组参数文件

[oracle@shiyueasm~]$ cd $ORACLE_HOME/dbs

[oracle@shiyueasmdbs]$ ll

total 48

-rw-r–r– 1 oracle oinstall 934 May 26 10:52 db.sql

-rw-rw—- 1 oracle oinstall 1544 May 26 10:32 hc_shiyue.dat

-rw-r—– 1 oracle oinstall 12920 May 3 2001initdw.ora

-rw-r—– 1 oracle oinstall 8385 Sep 11 1998 init.ora

-rw-r–r– 1 oracle oinstall 996 May 26 10:31 initshiyue.ora

-rw-rw—- 1 oracle oinstall 24 May 26 10:52 lkSHIYUE

-rw-r—– 1 oracle oinstall 1536 May 26 10:32 orapwshiyue

[oracle@shiyueasm dbs]$ viinit+ASM.ora

asm_diskstring=”

background_dump_dest=/u01/admin/shiyueasm/bdump

core_dump_dest=/u01/admin/shiyueasm/cdump

user_dump_dest=/u01/admin/shiyueasm/udump

instance_type=’asm’

large_pool_size=20m

remote_login_passwordfile=’shared’

7、 创建相关目录

[oracle@shiyueasm~]$ mkdir -p /u01/admin/shiyueasm/bdump

[oracle@shiyueasm~]$ mkdir -p /u01/admin/shiyueasm/cdump

[oracle@shiyueasm ~]$ mkdir -p/u01/admin/shiyueasm/udump

8、 切换至ASM实例

[oracle@shiyueasm ~]$ export ORACLE_SID=+ASM


手动创建Oracle 10g ASM磁盘组
  • Oracle-01861 文字与格式字符串不匹配
  • Oracle-01861 文字与格式字符串不匹配 | Oracle-01861 文字与格式字符串不匹配 ...

    手动创建Oracle 10g ASM磁盘组
  • Oracle的NLS设置
  • Oracle的NLS设置 | Oracle的NLS设置 ...

    手动创建Oracle 10g ASM磁盘组
  • Linux下安装Oracle参数自动初始化脚本
  • Linux下安装Oracle参数自动初始化脚本 | Linux下安装Oracle参数自动初始化脚本 ...