실습환경
오라클 리눅스 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
'ORACLE > Trouble Shooting' 카테고리의 다른 글
| ORA-39142: incompatible version number 4.1 in dump file with IMPDP (0) | 2017.01.12 |
|---|---|
| ORA-25153 Temporary Tablespace is Empty Error in Oracle (0) | 2017.01.11 |
| ORA-27100: shared memory realm already exists (0) | 2016.12.12 |
| ORA-00845: MEMORY_TARGET not supported on this system 해결 (0) | 2016.12.12 |
| ORA-65096: invalid common user or role name (0) | 2016.11.24 |