Re: separate owner/ORACLE_HOME for crs, ASM, and database in RAC environment

Rajeev,

Thank you very much for your detailed information! I tried your step 1, 2, 3 and dbca generated a lot of information, from the output on the screen I couldn't find any information that's very obvious. where is the trace file located? I looked around but couldn't find it :( I also tried step 4 without luck. it gave me this information after I chose ASM as my storage:

Error when starting ASM instance on node racnode1: PRKS-1009: Failed to start ASM instance "+ASM1" on node "racnode1", [CRS_0233: Resource or relatives are currently involved with another operation.]] after I clicked "OK", I gave me the same error in my first email. Thanks everybody who took the time to reply, I really appreciate it! -Li

On Dec 13, 2007 5:13 AM, Rajeev Prabhakar <rprabha01_at_gmail.com> wrote:

> Hello Li
>
> Could you please try the following and see if it helps ?
>
> 1) make a copy of dbca file (saved version).
>
> 2) add -DDEBUG keyword to dbca script.
>
> e.g.
>
> $JRE_DIR/bin/java -Dsun.java2d.font.DisableAlgorithmicStyles=true -DDEBUG
> -DORACLE_HOME=$OH -DDISPLAY=$DISPLAY -DJDBC_PROTOCOL=thin -mx128m -classpath
> $CLASSPATH oracle.sysman.assistants.dbca.Dbca $ARGUMENTS
>
> 3) Once you run the modified dbca, the debug messages should get written
> to a log file. Look at the log file and see if you find anything worth
> investigating.
>
> In case you find "No endpoint found for the Listener", make sure that
> listener name mentioned in listener.ora is the one registered with OCR.
>
> 4) Another thing which you could try OR verify is that oratab has entry
> for node specific ASM instance. If it has correct entries, shutdown ASM
> instance
> manually, then launch DBCA and let is start ASM instance on that node by
> itself.
>
> HTH
> Rajeev
> On Dec 12, 2007 4:51 PM, Li Li <litanli_at_gmail.com> wrote:
>
> > 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
> >
> >
> >
>
>

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