"accidentally" solved : Fwd: "Unable to connect to Cluster Manager" from the RDBMS O_H

  • From: Hemant K Chitale <hkchital@xxxxxxxxxxxxxx>
  • To: Recipient list suppressed:;
  • Date: Sat, 30 Aug 2008 15:30:44 +0800

Gus, Rajeev,  Ravi,  Oracle-L,

My apologies for not reverting with how I   [accidentally ?]  "solved" this.


I had tried re-registering the Oracle_Homes (ASM and RDBMS in different sequences) in the shared inventory [detachHome.sh, attachHome.sh] , reinstalling them, rerunning localconfig from both homes etc.

I then kept the issue aside for a few weeks, and ....

I finally deleted my central inventory, re-registered my RDBMS Home, installed the ASM Home and was up and running again after that.

================================================================================
Along the way, while testing "localconfig", here is something I'd noted : [both the Homes are patched to 10.2.0.4] :

My RDBMS home is /oracle_fs/ora10204/product/10.2.0.4,  owned by "ora10204:dba"

My ASM home is /home/oracleasm/product/10.2.0/asm,  owned by "oracleasm:dba"

If I run localconfig from the ASM home, CSS starts up properly but the RDBMS account cannot see it.

If I run "localconfig reset /home/oracleasm/product/10.2.0/asm" from the RDBMS home, a. The ASM Home/data/local.ocr ownership gets chowned to "ora10204:ora10204" (not "ora10204:dba" !) b. The ASM Home log and all files below it gets chowned to "ora10204:ora10204"
  c.  CSS fails to startup

After that I if chown all the files back to "oracleasm:dba", CSS does startup, but again "ora10204" cannot see it !

Also, localconfig has a hard-coded "CSS_ORACLE_OWNER=" with the "CSS_ORACLE_HOME=" while /etc/init.d/init.ccsd has "ORACLE_USER=", "ORA_CRS_HOME=" and "ORACLE_HOME=$ORA_CRS_HOME"
variables.
I can see how "CSS_ORACLE_OWNER" changed oracleasm files to ora10204 but haven't bothered to see how
the group got changed from "dba" to "ora10204" !!
================================================================================


Anyway, deleting the inventory and re-registering the RDBMS Home (using attachHome.sh) and then installing ASM did "solve" it. I do not know how !

In the end, I don't have a "solution"  in the proper sense of the term.

I know have an ASM environment (actually running on filesystem using Jeff Hunter's notes on idevelopment.info http://www.idevelopment.info/cgi/ORACLE_dba_tips.cgi#Automatic_Storage_Management ) to test ASM co-existing with extfs3 on Linux.

Hemant K Chitale

Date: Sat, 09 Aug 2008 15:18:17 +0800
To: oracle-l@xxxxxxxxxxxxx
From: Hemant K Chitale <hkchital@xxxxxxxxxxxxxx>
Subject: "Unable to connect to Cluster Manager" from the RDBMS O_H


I have a pre-existing x64 Linux 10.2.0.4 RDBMS Oracle_Home with a running database.

I installed an ASM only Oracle_Home under a different account (in the "dba") group and successfully configured cssd, raw devices and an ASM instance. I can see the two disk groups that I have manually configured in the ASM instance. I can stop and restart cssd and the ASM instance successfully. I understand the dependency (ie cssd must start *before* the ASM instance).

However, when I try to add a tablespace in the RDBMS Oracle_Home database, using the "+DG_1" specification, I get
ORA-29701 "unable to connect to Cluster Manager".

What do I have to do to get the RDBMS Oracle_Home to see cssd running from the ASM Oracle_Home ?


Hemant K Chitale
http://hemantoracledba.blogspot.com


Hemant K Chitale

http://hemantoracledba.blogspot.com


--
//www.freelists.org/webpage/oracle-l


Other related posts:

  • » "accidentally" solved : Fwd: "Unable to connect to Cluster Manager" from the RDBMS O_H