프린트 하기

실습환경

오라클 리눅스 7.2 + Oracle Grid Infrastructure 12c R1 P2 + Oracle 데이터베이스 12c R1 P2 


오류

12c asm 이 올라가지 않음


[root@abc ~]# su - grid

Last login: Wed Dec 28 15:02:34 KST 2016

[grid@abc~]$ sqlplus / as sysasm


SQL*Plus: Release 12.1.0.2.0 Production on Wed Dec 28 15:05:04 2016


Copyright (c) 1982, 2014, 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


해결방법

[grid@abc ~]$ srvctl start asm

[grid@abc ~]$ crsctl stat res -t

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

Name           Target  State        Server                   State details       

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

Local Resources

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

ora.DATA.dg

              ONLINE  ONLINE       oracle50                 STABLE

ora.FRA.dg

              ONLINE  ONLINE       oracle50                 STABLE

ora.LISTENER.lsnr

              ONLINE  ONLINE       oracle50                 STABLE

ora.asm

              ONLINE  ONLINE       oracle50                 Started,STABLE

ora.ons

              OFFLINE OFFLINE      oracle50                 STABLE

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

Cluster Resources

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

ora.cdb01.db

     1        OFFLINE OFFLINE                               Instance Shutdown,ST

                                                            ABLE

ora.cssd

     1        ONLINE  ONLINE       oracle50                 STABLE

ora.diskmon

     1        OFFLINE OFFLINE                               STABLE

ora.evmd

     1        ONLINE  ONLINE       oracle50                 STABLE

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

[grid@abc ~]$ sqlplus / as sysasm


SQL*Plus: Release 12.1.0.2.0 Production on Wed Dec 28 15:06:46 2016


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



Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Automatic Storage Management option


SQL> startup

ORA-01081: cannot start already-running ORACLE - shut it down first


이렇게 해도 안되면

[grid@abc~]$ crsctl start resource ora.cssd


참조

http://salmandba.blogspot.kr/2015/06/ora-29701-unable-to-connect-to-cluster.html


본 글은 개인적인 경험과 견해를 바탕으로 작성된 것이며,
제가 현재 또는 과거에 재직했던 기업의 공식 입장이나 의견을 대변하지 않습니다.
궁금하신 점은 언제든지 댓글이나 메일로 남겨 주세요. 확인 후 답변드리겠습니다.
감사합니다.