Saturday, March 17, 2012

ORA-29701: unable to connect to Cluster Manager


Needs an ASM Bounce for this Issue as resolution with a small change as below
[asm@dev123~]$ sqlplus "/as sysdba"
SQL*Plus: Release 11.1.0.7.0 - Production on Thu Jan 6 01:23:24 2011
Copyright (c) 1982, 2008, Oracle.  All rights reserved.
Connected to an idle instance.

SQL> startup
ORA-29701: unable to connect to Cluster Manager

SQL> exit

Resolution:
As root User,
[user1@dev123~]$ sudo su -

[root@dev123 ~]# cd /u06/app/oracle/product/11.1.0/asm/bin ßASM Home

[root@dev123 bin]# ./localconfig delete
Stopping Cluster Synchronization Services.
Unable to communicate with the Cluster Synchronization Services daemon.
Shutdown has begun. The daemons should exit soon.
Cleaning up Network socket directories

[root@ddev123 bin]#

[root@dev123 bin]# ./localconfig add
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
Configuration for local CSS has been initialized
Cleaning up Network socket directories
Setting up Network socket directories
Adding to inittab
Startup will be queued to init within 30 seconds.
Checking the status of new Oracle init process...
Expecting the CRS daemons to be up within 600 seconds.
Cluster Synchronization Services is active on these nodes.
        dev123
Cluster Synchronization Services is active on all the nodes.
Oracle CSS service is installed and running under init(1M)
[root@dev123 bin]#
[root@dev123 bin]# ps -ef|grep css
root     16699     1  0 01:27 ?        00:00:00 /bin/sh /etc/init.d/init.cssd run
root     16974 16699  0 01:27 ?        00:00:00 /bin/sh /etc/init.d/init.cssd daemon
asm      17164 16974  0 01:27 ?        00:00:00 /u06/app/oracle/product/11.1.0/asm/bin/ocssd.bin
root     17170 16699  0 01:27 ?        00:00:00 /bin/sh /etc/init.d/init.cssd diskmon
root     17475 15609  0 01:27 pts/5    00:00:00 grep css
[root@dev123 bin]#exit

As asm User,


[user1@dev123 ~]$ sudo su - asm
[asm@dev123~]$ sqlplus "/ as sysdba"
SQL*Plus: Release 11.1.0.7.0 - Production on Thu Jan 6 01:28:31 2011
Copyright (c) 1982, 2008, Oracle.  All rights reserved.
Connected to an idle instance.
SQL> startup
ASM instance started
Total System Global Area  175382528 bytes
Fixed Size                  2157904 bytes
Variable Size             148058800 bytes
ASM Cache                  25165824 bytes
ASM diskgroups mounted
SQL> exit

No comments:

Post a Comment