Hi Pete, Start dbca as oracle showed ASM works fine, but start dbca as oraclex (in a different oracle home) cannot see the ASM instance. like I said, the reason to have separate owner is to separate the responsibilities, and I think this is oracle's direction too, as in 11g, there's a new privilege "sysasm". On Dec 12, 2007 4:58 PM, Pete Sharman <peter.sharman@xxxxxxxxxx> wrote: > Li Li > > > > If you want to check this is a permissions thing, probably the easiest way > is to start DBCA as oracle, not oraclex. > > > > One thing you didn't mention directly is WHICH dbca you were using. Is it > the one in ASM home or the database home? > > > > Personally, I'm yet to be convinced that there really is a valid reason > for having two separate user ID's for this sort of configuration. It's an > argument I've seen used many times and I really think it only causes grief > somewhere along the line. Separate ORACLE_HOMES I can see as sensible, but > still not convinced about separate user ID's owning them. > > > > Pete > > > > "Controlling developers is like herding cats." > > Kevin Loney, Oracle DBA Handbook > > > > "Oh no, it's not, it's much harder than that!" > > Bruce Pihlamae, long term Oracle DBA > ------------------------------ > > *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto: > oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Li Li > *Sent:* Thursday, 13 December 2007 8:52 AM > *To:* oracle-l > *Subject:* separate owner/ORACLE_HOME for crs, ASM, and database in RAC > environment > > > > Hi, List, > > > > I am testing to setup a 2-node RAC environment with separate > owner/ORACLE_HOME for crs, ASM, and database, it's 10gR2 on Redhat AS 4. > > > > 2 users are created: oracle and oraclex, oracle owns clusterware home and > ASM home, oraclex owns database home. > > > > first, I login as oracle and installed clusterware and database software > (in 2 different oracle home of course), configured and started ASM instance, > everything worked fine. > > > > second, I login as oraclex and installed database software, then I tried > to create a database using dbca, but I ran into error when I chose ASM as my > database storage, the error is: > > "DBCA could not startup the ASM instance configured on this node. To > proceed with database creation using ASM you need the ASM instance to be up > and running. Do you want to recreate the ASM instance on this node?" > > > > But the ASM instance IS already running. I am guessing this must be > because of some permission issue but I am not sure what I am missing. I have > oracle and oraclex both have "oinstall" as primary group and "dba" as second > group. > > > > I googled but cannot find any useful information. Can anybody give me some > suggestion? Any comment would be greatly appreciated! > > > > Thanks, > > -Li > > > > >