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

  • From: "Rajeev Prabhakar" <rprabha01@xxxxxxxxx>
  • To: "Li Li" <litanli@xxxxxxxxx>
  • Date: Fri, 14 Dec 2007 13:10:03 -0500

Hello Li

I researched this further and per metalink, it is a bug,
take a look at this article (*Note:365428.1).*

Hopefully, it should help ? Let us know how it goes.

-Rajeev


On Dec 13, 2007 12:35 PM, Li Li <litanli@xxxxxxxxx> wrote:

> 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@xxxxxxxxx> 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@xxxxxxxxx> 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
> > >
> > >
> > >
> >
> >
>

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 12-2007