当前位置:Gxlcms > mysql > oracle11gR2单实例ASM启动:ORA

oracle11gR2单实例ASM启动:ORA

时间:2021-07-01 10:21:17 帮助过:97人阅读

今天启动之前安装好的 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"

人气教程排行