Shulou(Shulou.com)06/01 Report--

Oracle DataBase single instance uses ASM case (2)-- Construction of Oracle 11g Library

System environment:

Operating system: RedHat EL5 (64)

Oracle software: Oracle 11gR2, Oracle GI

For Oracle 11g to use ASM as a storage system, you must build an environment for Oracle GI.

Configure the ASM environment (grid) through ASMCA:

Initial configuration information

[root@bjsrv ~] # cd / u01/app/oracle

[root@bjsrv oracle] # cd admin

[root@bjsrv admin] # ls-l

Drwxr-x--- 5 oracle oinstall 4096 May 26 03:12 prod

[root@bjsrv admin] # mkdir + ASM

[root@bjsrv admin] # chown-R grid:oinstall + ASM

[root@bjsrv admin] # ls-l

Drwxr-xr-x 3 grid oinstall 4096 May 26 06:02 + ASM

Drwxr-x--- 5 oracle oinstall 4096 May 26 03:12 prod

Configure ASM

ASM configured successfully

Establish an ASM disk group

ASM disk group established successfully, ASMCA completed

Check ASM Instance and Diskgroup

SQL > show parameter name

NAME TYPE VALUE

-

Db_unique_name string + ASM

Instance_name string + ASM

Lock_name_space string

Service_names string + ASM

[grid@bjsrv ~] $sqlplus'/ as sysdba'

SQL*Plus: Release 11.2.0.1.0 Production on Mon May 26 06:05:34 2014

Copyright (c) 1982, 2009, Oracle. All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-Production

With the Automatic Storage Management option

SQL > select name, state from v$asm_diskgroup

NAME STATE

RCY1 MOUNTED

DG1 MOUNTED

Install Oracle 11g data software (abbreviated):

Set up a database through DBCA (oracle users):

Select ASM storage when building the database

Manage the database through OMF

Build recover area on the ASM disk group (you can establish the diversification of controlfile and redo logfile)

@ so far, the whole use of ASM in Oracle 11g single-instance environment is complete. The functionality of ASM in Oracle 11g has been enhanced, but the use has also increased complexity.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.