启动ASM实例失败ORA-29701

点击(此处)折叠或打开

1. [grid@songasm Desktop]$ sqlplus / as sysasm
   
2. 
   
3. SQL*Plus: Release 11.2.0.4.0 Production on Tue Sep 6 17:10:21 2016
   
4. 
   
5. Copyright (c) 1982, 2013, Oracle. All rights reserved.
   
6. 
   
7. Connected to an idle instance.
   
8. 
   
9. SQL> startup
   
10. ORA-01078: failure in processing system parameters
    
11. ORA-29701: unable to connect to Cluster Synchronization Service
    
12. SQL> !crsctl check css
    
13. CRS-4530: Communications failure contacting Cluster Synchronization Services daemon
    
14. 
    
15. SQL> !ps -ef | grep cssd | grep -v grep
    
16. 
    
17. SQL> !crsctl check has
    
18. CRS-4638: Oracle High Availability Services is online
    
19. 
    
20. SQL> !ps -ef | grep d.bin | grep -v grep
    
21. grid 2385 1 0 16:21 ? 00:00:20 /u01/app/grid/product/11.2.0/gihome_1/bin/ohasd.bin reboot
    
22. grid 2672 1 0 16:22 ? 00:00:00 /u01/app/grid/product/11.2.0/gihome_1/bin/evmd.bin
    
23. 
    
24. SQL> !crsctl status resource -t
    
25. --------------------------------------------------------------------------------
    
26. NAME TARGET STATE SERVER STATE_DETAILS
    
27. --------------------------------------------------------------------------------
    
28. Local Resources
    
29. --------------------------------------------------------------------------------
    
30. ora.DATAGROUP.dg
    
31.                OFFLINE OFFLINE songasm
    
32. ora.GRIDGROUP.dg
    
33.                OFFLINE OFFLINE songasm
    
34. ora.LISTENER.lsnr
    
35.                ONLINE ONLINE songasm
    
36. ora.asm
    
37.                OFFLINE OFFLINE songasm Instance Shutdown
    
38. ora.ons
    
39.                OFFLINE OFFLINE songasm
    
40. --------------------------------------------------------------------------------
    
41. Cluster Resources
    
42. --------------------------------------------------------------------------------
    
43. ora.cssd
    
44.       1 ONLINE OFFLINE
    
45. ora.diskmon
    
46.       1 OFFLINE OFFLINE
    
47. ora.evmd
    
48.       1 ONLINE ONLINE songasm
    
49. 
    
50. SQL> !crs_stat -p ora.cssd | grep AUTO
    
51. AUTO_START=never
    
52. 
    
53. SQL> !crs_stat -p ora.diskmon | grep AUTO
    
54. AUTO_START=never
    
55. 
    
56. SQL> !crsctl start resource ora.cssd
    
57. CRS-2672: Attempting to start 'ora.cssd' on 'songasm'
    
58. CRS-2672: Attempting to start 'ora.diskmon' on 'songasm'
    
59. CRS-2676: Start of 'ora.diskmon' on 'songasm' succeeded
    
60. CRS-2676: Start of 'ora.cssd' on 'songasm' succeeded
    
61. 
    
62. SQL> !crs_stat -t
    
63. Name Type Target State Host
    
64. ------------------------------------------------------------
    
65. ora....ROUP.dg ora....up.type OFFLINE OFFLINE
    
66. ora....ROUP.dg ora....up.type OFFLINE OFFLINE
    
67. ora....ER.lsnr ora....er.type ONLINE ONLINE songasm
    
68. ora.asm ora.asm.type OFFLINE OFFLINE
    
69. ora.cssd ora.cssd.type ONLINE ONLINE songasm
    
70. ora.diskmon ora....on.type OFFLINE OFFLINE
    
71. ora.evmd ora.evm.type ONLINE ONLINE songasm
    
72. ora.ons ora.ons.type OFFLINE OFFLINE
    
73. 
    
74. SQL> startup
    
75. ASM instance started
    
76. 
    
77. Total System Global Area 1135747072 bytes
    
78. Fixed Size         2260728 bytes
    
79. Variable Size         1108320520 bytes
    
80. ASM Cache         25165824 bytes
    
81. ASM diskgroups mounted
    
82. SQL> !crs_stat -t
    
83. Name Type Target State Host
    
84. ------------------------------------------------------------
    
85. ora....ROUP.dg ora....up.type ONLINE ONLINE songasm
    
86. ora....ROUP.dg ora....up.type ONLINE ONLINE songasm
    
87. ora....ER.lsnr ora....er.type ONLINE ONLINE songasm
    
88. ora.asm ora.asm.type ONLINE ONLINE songasm
    
89. ora.cssd ora.cssd.type ONLINE ONLINE songasm
    
90. ora.diskmon ora....on.type OFFLINE OFFLINE
    
91. ora.evmd ora.evm.type ONLINE ONLINE songasm
    
92. ora.ons ora.ons.type OFFLINE OFFLINE
    
93. 
    
94. SQL>

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26066458/viewspace-2124599/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26066458/viewspace-2124599/