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

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