ORA-01078 & LRM-00109 solutions RAC ASM

Source: Internet
Author: User

I wonder why the ASM instance created with DBCA cannot be started.

Manual start

SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: cocould not open parameter file '/opt/Oracle/product/10.2.0/db_1/dbs/init + ASM. ora

 

/Opt/oracle/product/10.2.0/db_1/dbs/init + ASM. ora

Connect to/opt/oracle/admin/+ asm/pfile/init. ora

Then, the necessary parameters are modified on the Internet and cannot be started.

[Oracle @ node1 pfile] $ cat init. ora
######################################## ######################################
# Copyright (c) 1991,200 1, 2002 by Oracle Corporation
######################################## ######################################
 
######################################## ###
# Miscellaneous
######################################## ###
Instance_type = asm
 
######################################## ###
# Security and Auditing
######################################## ###
Remote_login_passwordfile = 'shared'
 
######################################## ###
# Pools
######################################## ###
Large_pool_size = 12 M
 
######################################## ###
# Cluster Database
######################################## ###
Cluster_database = true
 
######################################## ###
# Diagnostics and Statistics
######################################## ###
Background_dump_dest =/opt/oracle/admin/+ ASM/bdump
Core_dump_dest =/opt/oracle/admin/+ ASM/cdump
User_dump_dest =/opt/oracle/admin/+ ASM/udump
Asm_diskstring = 'orcl: VOL *'
# *. Asm_diskgroups = 'orcl: VOL *'
+ ASM2.instance _ number = 2
+ ASM1.instance _ number = 1


 

The instance name is incorrect.

Export ORACLE_SID = + ASM1

Sqlplus/as sysdba

SQL> startup
ASM instance started

Total System Global Area 92274688 bytes
Fixed Size 1217884 bytes
Variable Size 65890980 bytes
ASM Cache 25165824 bytes
ORA-15110: no diskgroups mounted

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.