oracle 11g R2 单实例 ASM 启动：ORA-mysql教程-PHP中文网

首页

数据库

mysql教程

oracle 11g R2 单实例 ASM 启动：ORA

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jun 07, 2016 pm 03:50 PM

asmoracle启动实例

今天启动之前安装好的 oracle 11g R2 单实例 ASM的时候，连接启动ASM实例时，报错： SQL startup ORA-01078: failure in processing system parameters ORA-29701: unable to connect to Cluster Synchronization Service 从报错说.应该是CSS服务没有启动起

今天启动之前安装好的 oracle 11g R2 单实例 ASM的时候，连接启动ASM实例时，报错：

SQL> startup

ORA-01078: failure in processing system parameters

ORA-29701: unable to connect to Cluster Synchronization Service

从报错说.应该是CSS服务没有启动起来，查看CSS服务情况

[grid@linusfay-up ~]$ sudo crs_stat -t
[sudo] password for grid:
Name           Type           Target    State     Host
------------------------------------------------------------
ora.BACKUP.dg ora....up.type OFFLINE   OFFLINE
ora.DATA.dg    ora....up.type OFFLINE   OFFLINE
ora....EMDG.dg ora....up.type OFFLINE   OFFLINE
ora.asm        ora.asm.type   OFFLINE   OFFLINE
ora.cssd       ora.cssd.type ONLINE    OFFLINE
ora.diskmon    ora....on.type OFFLINE   OFFLINE
ora.evmd       ora.evm.type   ONLINE    OFFLINE
ora.ons        ora.ons.type   OFFLINE   OFFLINE
ora.orcl.db    ora....se.type OFFLINE   OFFLINE

尝试手动启动css

[grid@linusfay-up ~]$ sudo crs_start ora.cssd
Attempting to start `ora.cssd` on member `linusfay-up`
Attempting to start `ora.diskmon` on member `linusfay-up`
Start of `ora.diskmon` on member `linusfay-up` succeeded.
Start of `ora.cssd` on member `linusfay-up` succeeded.

启动成功

尝试连接启动ASM实例

[grid@linusfay-up ~]$ sqlplus / as sysasm

SQL*Plus: Release 11.2.0.3.0 Production on Sat Oct 26 15:47:40 2013

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

Connected to an idle instance.

SQL> startup
ASM instance started

Total System Global Area 283930624 bytes
Fixed Size                  2227664 bytes
Variable Size             256537136 bytes
ASM Cache                  25165824 bytes
ASM diskgroups mounted

连接启动成功！

为什么在主机重启后，CSS服务没有随着主机重启而restart呢

查看设置：

[grid@linusfay-up ~]$ sudo crs_stat -p ora.cssd
NAME=ora.cssd
TYPE=ora.cssd.type
ACTION_SCRIPT=
ACTIVE_PLACEMENT=0
AUTO_START=never
CHECK_INTERVAL=30
DESCRIPTION="Resource type for CSSD"
FAILOVER_DELAY=0
FAILURE_INTERVAL=3
FAILURE_THRESHOLD=5
HOSTING_MEMBERS=
PLACEMENT=balanced
RESTART_ATTEMPTS=5
SCRIPT_TIMEOUT=600
START_TIMEOUT=600
STOP_TIMEOUT=900
UPTIME_THRESHOLD=1m

下面将AUTO_START属性的可选值列以下：

AUTO_START

Indicates whether Oracle Clusterware automatically starts a resource after a cluster server restart.Valid AUTO_START values are:

always: Restarts the resource when the server restarts regardless of the state of the resource when the server stopped.--始终restart
restore: Restores the resource to the same state that it was in when the server stopped.Oracle Clusterware attempts to restart the resource if the value of TARGET was ONLINE before the server stopped. --根据关闭前一次状态是否选择启动
never: Oracle Clusterware never restarts the resource regardless of the state of the resource when the server stopped.

可以将auto_start设置为 always，就可以随着主机启动一直保持启动了。

tips

      1)默认情况下HAS(High Availability Service)是自动启动的.通过如下命令可以取消和启用自动启动
        crsctl disable has
        crsctl enable has
      2)HAS手动启动和停止
        crsctl start has
        crsctl stop has
      3)查看HAS的状态
        crsctl check has
      4)如果想让ora.css和ora.diskmon服务随着HAS的启动而自动启动，那么你可以这两个服务的AUTO_START属性
        crsctl modify resource "ora.cssd" -attr "AUTO_START=1"
        or
        crsctl modify resource "ora.diskmon" -attr "AUTO_START=1"
      5)如果想取消ora.css和ora.diskmon的Auto start
        crsctl modify resource "ora.cssd" -attr "AUTO_START=never"
        crsctl modify resource "ora.diskmon" -attr "AUTO_START=never"