Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 7757 invoked from network); 14 Dec 2007 12:57:32 -0600 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by static-ip-69-64-49-119.inaddr.intergenia.de with SMTP; 14 Dec 2007 12:57:32 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E4D3F7D9414; Fri, 14 Dec 2007 13:57:31 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 25659-09-2; Fri, 14 Dec 2007 13:57:31 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4B0177D9524; Fri, 14 Dec 2007 13:57:31 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 14 Dec 2007 13:10:05 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9988B7D92A0 for ; Fri, 14 Dec 2007 13:10:05 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 17046-06 for ; Fri, 14 Dec 2007 13:10:05 -0500 (EST) Received: from rv-out-0910.google.com (rv-out-0910.google.com [209.85.198.187]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 15E9F7D9209 for ; Fri, 14 Dec 2007 13:10:04 -0500 (EST) Received: by rv-out-0910.google.com with SMTP id b22so964052rvf.46 for ; Fri, 14 Dec 2007 10:10:04 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; bh=8it6D3++oMG7wF9lYdXNzNmiT1IiaQ70gy5PAyajg5E=; b=PcpGPLyDjb6gXMGR+9w6IVJ8jIrfQCgOAlKTLbdG0R+IGc38VeTE61tVRn4uUVkIMo4F+RD1od/BOYlanmZDG6id6VVLhUueOu4tg8cbDQJrqxZDGRUDu3uQCTBneKJReWH27YASXGbs8GGB1myc6md1vDYrCXy1c47glLTrSZ4= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=fTeJpljXUBjGeGwBaBPrcMIv2iRkmY8DQxTzULvyIC1IvxCWWCAnqCxA4CK/fA0j/0TeBOT0/qQ58lsVZSCntYiWR/UKjdcXea40SgoW0fxIcPFX5QJq0XKZ02S6aPuaUPa13ATTCuE13tDjjKKm6DBJl9FBM4GRgtEja9NeAX0= Received: by 10.140.133.16 with SMTP id g16mr2059769rvd.231.1197655804046; Fri, 14 Dec 2007 10:10:04 -0800 (PST) Received: by 10.35.61.4 with HTTP; Fri, 14 Dec 2007 10:10:03 -0800 (PST) Message-ID: <2ba656800712141010u62319463qf124e95a9aa23115@mail.gmail.com> Date: Fri, 14 Dec 2007 13:10:03 -0500 From: "Rajeev Prabhakar" To: "Li Li" Subject: Re: separate owner/ORACLE_HOME for crs, ASM, and database in RAC environment Cc: oracle-l In-Reply-To: <5f35c2320712130935g250e9da8ib0ebcf6282a253c3@mail.gmail.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_1923_17524086.1197655803957" References: <5f35c2320712121351t319a3662ie7bc03d83ffcbf4b@mail.gmail.com> <2ba656800712130313t4a3d1064tecaf1682ea4d5b25@mail.gmail.com> <5f35c2320712130935g250e9da8ib0ebcf6282a253c3@mail.gmail.com> X-archive-position: 3941 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: rprabha01@gmail.com Precedence: normal Reply-to: rprabha01@gmail.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l X-Virus-Scanned: Debian amavisd-new at localhost.localdomain ------=_Part_1923_17524086.1197655803957 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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 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 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 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 > > > > > > > > > > > > > > ------=_Part_1923_17524086.1197655803957 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline
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@gmail.com> 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@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@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
 
 



------=_Part_1923_17524086.1197655803957-- -- http://www.freelists.org/webpage/oracle-l