How To Create manually an ASM Instance From Scratch
来源:互联网 发布:青铜5 知乎 编辑:程序博客网 时间:2024/05/29 07:17
This note will explain how to create an ASM instance from scratch instead of using DBCA.
步骤如下:
Before you start, its recommended that ASM instance installed in a separate Oracle home, it is very useful in the case of applying patches and upgrade. For example you can upgrade ASM home from 10.2.0.3 to 10.2.0.4 while database home still on 10.2.0.3.
1) Because CSS must be running before any ASM instance, you have to make sure that CSS service is running:
# crsctl check css
Cluster Synchronization Services appears healthy
If its not running, you should configure CSS process by running $ORACLE_HOME/bin/localconfig script:
# $ORACLE_HOME/bin/localconfig all
/etc/oracle does not exist. Creating it now.
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
Configuration for local CSS has been initialized
Adding to inittab
Startup will be queued to init within 90 seconds.
Checking the status of new Oracle init process...
Expecting the CRS daemons to be up within 600 seconds.
CSS is active on these nodes.
DEV1
CSS is active on all nodes.
Oracle CSS service is installed and running under init(1M)
2) Create the init+ASM.ora file in $ORACLE_HOME/dbs (this ORACLE_HOME being the newly created one).
(Change any of these parameters if needed for your environment)
# Default asm_diskstring values for supported platforms:
# Solaris (32/64 bit) /dev/rdsk/*
# Windows NT/XP //./orcldisk*
# Linux (32/64 bit) /dev/raw/*
# HPUX /dev/rdsk/*
# HPUX(Tru 64) /dev/rdisk/*
# AIX /dev/rhdisk/*
ASM_DISKSTRING=''
INSTANCE_TYPE='ASM'
LARGE_POOL_SIZE=40M
REMOTE_LOGIN_PASSWORDFILE='EXCLUSIVE'
USER_DUMP_DEST=$ORACLE_HOME/admin/+ASM/udump
BACKGROUND_DUMP_DEST=$ORACLE_HOME/admin/+ASM/bdump
CORE_DUMP_DEST=$ORACLE_HOME/admin/+ASM/cdump
3) Creating ADMIN directories:
$ cd $ORACLE_HOME
$ mkdir dbs
$ mkdir admin
$ cd admin
$ mkdir +ASM
$ cd +ASM
$mkdir udump
$mkdir bdump
$mkdir cdump
4) Starting the ASM Instance
For UNIX platforms:
# su - oracle
$ ORACLE_SID=+ASM; export ORACLE_SID
$ sqlplus "/ as sysdba"
SQL> startup
For Microsoft Windows platforms:
C:/> oradim -new -asmsid +ASM -syspwd change_on_install
-pfile D:/oracle/product/10.2.0/admin/+ASM/pfile/init.ora -spfile
-startmode manual -shutmode immediate
Instance created.
C:/> oradim -edit -asmsid +ASM -startmode a
C:/> set oracle_sid=+ASM
C:/> sqlplus "/ as sysdba"
SQL> startup pfile='C:/oracle/product/10.1.0/admin/+ASM/pfile/init.ora';
5) Create SPFILE from PFILE:
SQL> create spfile='+ASM' from pfile;
6) For Unix platform, put an entry in the oratab file for the ASM intance:
+ASM:<ASM Oracle Home>:Y
You may get the following error on first start:
ORA-15110: no diskgroups mounted
This error can be safely ignored, when creating a new diskgroup, the diskgroup name will be added automatically to the asm_diskgroups parameter and you will not get this error again.
From Oracle
-------------------------------------------------------------------------------------------------------
Blog: http://blog.csdn.net/tianlesoftware
Email: dvd.dba@gmail.com
DBA1 群:62697716(满); DBA2 群:62697977(满) DBA3 群:62697850(满)
DBA 超级群:63306533(满); DBA4 群: 83829929 DBA5群: 142216823
聊天 群:40132017 聊天2群:69087192
--加群需要在备注说明Oracle表空间和数据文件的关系,否则拒绝申请
- How To Create manually an ASM Instance From Scratch
- How to create a server from scratch
- How to design an FPGA from scratch-1_FPGA_8_24
- How to design an FPGA from scratch-2_FPGA_8_24
- How to manually remove an infected file from your computer
- How to create Oracle 11g R2 database manually in ASM?
- How to create an EMF model from a Java application ?
- Swift from Scratch: An Introduction to Functions
- How to build FreeNAS from Scratch
- How To Upgrade ASM from 10.2 to 11.1 (single Instance configuration -Non-RAC)
- How To Upgrade ASM from 10.2 to 11.1 (single Instance configuration -Non-RAC)
- ASMCA fails to create 11.2 ASM instance when upgrading from 10.2 [ID 1125053.1]
- How to remove an ASM instance and its corresponding database(s) on WINDOWS
- How to remove an ASM instance and its corresponding database(s) on UNIX
- How To Create An ASM Diskgroup Using XML code Thru ASMCMD [ID 1290550.1]
- How To Create An ASM Diskgroup Using XML code Thru ASMCMD?
- Delete an oracle instance manually
- How to manually create a crash dump file
- 在C/C++中使用lua
- word-break 文字样式
- Android 开发中使用 SQLite 数据库
- metasploit 添加自己的poc
- Android 中自定义控件和属性(attr.xml,declare-styleable,TypedArray)的方法和使用
- How To Create manually an ASM Instance From Scratch
- 二级联动之两种方法实现
- C++链表使用完整代码
- 让Basicexcel完美支持中文且不改变原有接口
- P2P---UDP穿透NAT的原理与实现
- 又见优先级
- 链表学习--双向链表实现
- 链表学习--双向链表实现
- How To Create An SYSASM User On Release 11g