Saturday, May 30, 2015

Manually Configure Grid Infrastructure on standalone server

Error:

SQL> startup
ORA-01078: failure in processing system parameters
ORA-29701: unable to connect to Cluster Synchronization Service

Solution:

root@vm34:/u01/app/grid/crs/install =>perl roothas.pl
Using configuration parameter file: ./crsconfig_params
Creating trace directory
User ignored Prerequisites during installation
LOCAL ADD MODE
Creating OCR keys for user 'oracle', privgrp 'oinstall'..
Operation successful.
LOCAL ONLY MODE
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'system'..
Operation successful.
CRS-4664: Node vm34 successfully pinned.
Adding Clusterware entries to inittab
vm34 2015/05/25 01:30:30 /u01/app/grid/cdata/vm34/backup_20150525_013030.olr
Successfully configured Oracle Grid Infrastructure for a Standalone Server


[oracle@vm34]:../bin>crsctl start resource ora.cssd
CRS-2672: Attempting to start 'ora.cssd' on 'vm34'
CRS-2672: Attempting to start 'ora.diskmon' on 'vm34'
CRS-2676: Start of 'ora.diskmon' on 'vm34' succeeded
CRS-2676: Start of 'ora.cssd' on 'vm34' succeeded


Now we can start the asm instance
sqlplus "/as sysasm"
startup

No comments: