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 startupAfter 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_HI 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 getORA-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