Oracle单实例+ASM启动与关闭

来源:这里教程网 时间:2026-03-03 16:02:23 作者:

启动关闭注意顺序启动顺序: CSS,HAS => ASM => DB 停止顺序:  DB  = ASM  => CSS,HAS 启动:一 启动ASM 之前应该确保css,has 服务已经启动检查CSS 服务是否启动:[grid@node1 ~]$ crsctl check css检查HAS 服务是否启动:[grid@ node1~]$ crsctl check hasora.cssd和ora.diskmon这2个服务是依赖于HAS维护的.       进一步查看各资源的状态    [grid@ node1~]$ crsctl stat res -t检查ora.cssd 和ora.diskmon 的属性[grid@ node1~]$ crs_stat -p ora.cssd...AUTO_START=never...[grid@ node1~]$ crs_stat -p ora.diskmon... AUTO_START=never ...可以看到这两个资源的AUTO_START属性默认都设置为never,也就是说他们不会随着HAS服务的启动而自动启动的,尽管默认情况下HAS服务是开机自动启动的.手动启动[grid@ node1~]$ crsctl start resource ora.cssd 注:ora.cssd和ora.diskmon这两个服务是有依赖关系的,启动哪个都会把两个都起来. 其他操作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"或者#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" 启动ASM 实例 [grid@ node1 ~]$echo $ORACLE_SID +ASM[grid@ node1~]$ sqlplus / as sysasm

SQL>  startup;
SQL>  select instance_name,status from v$instance;

INSTANCE_NAME       STATUS---------------------  ---------------+ASM                             STARTED 最后,启动数据库 [oracle@ node1 ~]$ echo $ORACLE_SID prod1[oracle@ node1~]$ sqlplus / as sysdba

SQL>  startup;
SQL>  select instance_name,status from v$instance;

INSTANCE_NAME       STATUS--------------------     ---------------prod1                            OPEN 关闭顺序:关闭数据库[oracle@ node1~]$ sqlplus / as sysdbaSQL> shutdown immediate 关闭ASM[root@ node1~]# su - grid[grid@ node1~]$ sqlplus / as sysasmSQL> shutdown immediate 关闭HAS crsctl stop has   ###################################

如果顺序反了, 关闭ASM,会报错

例如:

1 关闭ASM

[root@ node1~]# su - grid

[grid@ node1~]$ sqlplus / as sysasm

SQL> shutdown immediate

ORA-15097: cannot SHUTDOWN ASM instance with connected client (process 7322)

一 启动时,如果顺序有问题,没有启动ASM就打开数据库, 会报错 [oracle@node1 ~]$ sqlplus / as sysdbaSQL> startupORA-01078: failure in processing system parametersORA-01565: error in identifying file '+CRS/prod1/spfileprod1.ora'ORA-17503: ksfdopn:2 Failed to open file +CRS/prod1/spfileprod1.oraORA-15077: could not locate ASM instance serving a required diskgroup   SQL> shutdown immediate ASM diskgroups dismounted ASM instance shutdown   2 启动数据库报错 [oracle@ogg1 ~]$ sqlplus / as sysdba   SQL> startup ORA-01078: failure in processing system parameters ORA-01565: error in identifying file '+SYSTEDG/prod1/spfileprod1.ora' ORA-17503: ksfdopn:2 Failed to open file +SYSTEDG/prod1/spfileprod1.ora ORA-15077: could not locate ASM instance serving a required diskgroup     正确的顺序是

相关推荐