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

This article will explain in detail about oracle 11gR2 asm can not start the processing method, the quality of the article content is high, so Xiaobian share for everyone to make a reference, I hope you have a certain understanding of the relevant knowledge after reading this article.

Oracle 11g R2 asm (aix 6.1) database cannot be started due to power failure of the company. The processing process is as follows:

aix1@grid[/oracle11/app/grid/11.2.0]$sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Mon Mar 12 14:22:13 2012

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

Connected to an idle instance.

SQL> startup

ORA-01078: failure in processing system parameters

ORA-29701: unable to connect to Cluster Synchronization Service

To detect the CSS process:

aix1@grid[/home/grid]$crsctl check css

CRS-4639: Could not contact Oracle High Availability Services

CRS-4000: Command Check failed, or completed with errors.

aix1@grid[/home/grid]$ps -ef|grep cssd

grid 135192 225738 0 12:08:39 pts/2 0:00 grep cssd

Detection has process:

aix1@grid[/home/grid]$crsctl check has

CRS-4639: Could not contact Oracle High Availability Services

Description ohasd process is not started, start ohasd process:

# ./ ohasd start

Starting ohasd:

CRS-4123: Oracle High Availability Services has been started.

Check:

aix1@grid[/oracle11/app/grid/11.2.0]$ crsctl stat resource -t -init

--------------------------------------------------------------------------------

NAME TARGET STATE SERVER STATE_DETAILS

--------------------------------------------------------------------------------

Local Resources

--------------------------------------------------------------------------------

ora.DATA2.dg

ONLINE OFFLINE aix1

ora.LISTENER.lsnr

ONLINE OFFLINE aix1

ora.asm

ONLINE OFFLINE aix1

--------------------------------------------------------------------------------

Cluster Resources

--------------------------------------------------------------------------------

ora.cssd

1 ONLINE OFFLINE

ora.db11.db

1 ONLINE OFFLINE

ora.diskmon

1 ONLINE OFFLINE

Start database:

aix1@grid[/oracle11/app/grid/11.2.0]$su - oracle11

oracle11's Password:

aix1@oracle11[/dsg]$sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Mon Mar 12 14:34:34 2012

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

Connected to an idle instance.

SQL> startup

ORACLE instance started.

Total System Global Area 1.3696E+10 bytes

Fixed Size 2219808 bytes

Variable Size 6878658784 bytes

Database Buffers 6777995264 bytes

Redo Buffers 37015552 bytes

Database mounted.

Database opened.

SQL>

OK database started.

Next is to explore why ohasd process is not automatically started at boot time?

The reason is that the lv installed with grid software is not automatically mounted. Therefore, when the server is started, it cannot automatically mount the lv where grid is located, and it cannot automatically start ohasd. If lv is mounted manually, the ohasd service must be started manually.

Modify lv to auto mount:

System Storage Management (Physical & Logical Storage)

-->File Systems

--->Add / Change / Show / Delete File Systems

-->Enhanced Journaled File Systems

-->Change / Show Characteristics of an Enhanced Journaled File System

Select the point you want to mount automatically

Mount AUTOMATICALLY at system restart? Yes -----Change from no to yes

When the data installation is completed, the has process is automatically started. Use the following command to set the automatic start;

aix1@grid[/home/grid]$crsctl enable has --Enable autostart

aix1@grid[/home/grid]$crsctl disable has --turn off autostart

Manual start has:

crsctl start has

crsctl stop has

Check the status of has:

crsctl check has

Crs resources cannot be started until ohasd resources are started.

In 11gR2, ohasd contains crsd, ocssd, evmd.

ohasd is responsible for starting cluster resources in the lower stack, crsd is responsible for starting cluster resources in the upper stack.

About oracle 11gR2 asm can not start the processing method to share here, I hope the above content can be of some help to everyone, you can learn more knowledge. If you think the article is good, you can share it so that more people can see it.

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.