Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 16374 invoked from network); 12 Dec 2007 22:00:18 -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; 12 Dec 2007 22:00:18 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6D6B27D8652; Wed, 12 Dec 2007 23:00:19 -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 12801-09; Wed, 12 Dec 2007 23:00:19 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id CECE57D861B; Wed, 12 Dec 2007 23:00:18 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 12 Dec 2007 22:12:54 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2D34D7D8D9B for ; Wed, 12 Dec 2007 22:12:54 -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 06062-05 for ; Wed, 12 Dec 2007 22:12:54 -0500 (EST) Received: from web35413.mail.mud.yahoo.com (web35413.mail.mud.yahoo.com [66.163.179.122]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id 0AD8C7D8D64 for ; Wed, 12 Dec 2007 22:12:48 -0500 (EST) Received: (qmail 7665 invoked by uid 60001); 13 Dec 2007 03:12:44 -0000 X-YMail-OSG: IxJEnVMVM1noDZwDMdTBULgg_pez2iebs8fCLkFYZU5uEZablo2GIrVI1EbWjhearj__nkdbZp.fs5_FcRgcUSypN0mAzA263KdLyQ_l6DEIAVF_X1EJMUNMBYC_hA-- Received: from [64.53.237.191] by web35413.mail.mud.yahoo.com via HTTP; Wed, 12 Dec 2007 19:12:44 PST Date: Wed, 12 Dec 2007 19:12:44 -0800 (PST) From: Dan Norris Subject: Re: separate owner/ORACLE_HOME for crs, ASM, and database in RAC environment To: Li Li Cc: William Wagman , finn.oracledba@gmail.com, oracle-l MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-673652717-1197515564=:6959" Message-ID: <115017.6959.qm@web35413.mail.mud.yahoo.com> X-archive-position: 3907 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: dannorris@dannorris.com Precedence: normal Reply-to: dannorris@dannorris.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 --0-673652717-1197515564=:6959 Content-Type: text/plain; charset=us-ascii Hi Li, If you haven't already, I'd check the ASM instance logs, the DBCA trace output (I don't remember how, but there's an env var or a mod to the dbca start script that enables DBCA tracing), or the listener log to determine how far your DBCA is getting the process before failing. I'd also probably try creating an instance by hand (without DBCA) to see if it's a DBCA issue or a core RDBMS/ASM issue. One of those locations is bound to yield some useful log information to get you closer to finding the root cause of the issue. For the record, I'm not guessing...the issue going to be shown in one of those places for sure. I'm a card-carrying BAAG member ;). Until you responded, I was hoping that you used a different OSASM group and that would be your issue. Hopes dashed...:( Dan P.S. I don't know how Oracle Support does it--solving issues with no access to see the issue and having to ask 1000's of questions to get the info they need. I still think they could do better, but it's threads like this one that remind me why I don't do phone support! ----- Original Message ---- From: Li Li To: Dan Norris Cc: William Wagman ; finn.oracledba@gmail.com; oracle-l Sent: Wednesday, December 12, 2007 8:50:42 PM Subject: Re: separate owner/ORACLE_HOME for crs, ASM, and database in RAC environment Hi, Dan, my OSASM group is "dba" also, I know this defeats some of the separation, but I just wanted to test this out. It's very strange to me that I have this issue because in my case both oracle and oraclex have "oinstall" as primary group and "dba" as second group, and oracle's RDBMS home and oraclex's RDBMS home all have 775 permission. I am trying to get some other eyes on this issue to see what I am missing :( Thank you all for your time to reply! -Li On Dec 12, 2007 7:20 PM, Dan Norris wrote: In my experiences with this, the oraclex user (the RDBMS owner) will have to be in the OSASM group. This defeats some of the separation, but as I understand it, the Oracle developers know that the separation isn't quite complete yet and someone told me that we should expect "true" separation in a future release (probably 11g R2). If your OSASM group is also dba, then I'm not sure I know why you're having issues. I tried the same thing and had three users: 1) a clusterware owner, 2) an ASM owner, and 3) an RDBMS owner. I found that the clusterware can be separated pretty cleanly from the other two, but the ASM and RDBMS owners essentially have power over each others' domains since the RDBMS user must be in the OSASM group and I think the ASM owner may have had to be in the OSDBA. I don't have access to my test systems for this any longer, so my memory may be a little off. It's also possible that things have changed slightly since my testing which was done with 11gR1-beta5. Dan ----- Original Message ---- From: Li Li < litanli@gmail.com> To: William Wagman Cc: finn.oracledba@gmail.com ; oracle-l Sent: Wednesday, December 12, 2007 5:51:26 PM Subject: Re: separate owner/ORACLE_HOME for crs, ASM, and database in RAC environment Hi, Bill, I don't use asmlib because its dependency on linux kernel. I just create ASM diskgroups using RAW devices. when I login as oracle and start dbca, ASM disks are all look/work fine. On Dec 12, 2007 5:14 PM, William Wagman wrote: Greetings, The thinking is to separate CRS, ASM and RDBMS for ease of maintenance. This is also the Oracle suggestion that each be in a separate home. It makes patching and upgrading easier. As to the disk issues. First are you using ASMLIB? Make sure if you are it is configured correctly and the disks have been created. Also look at the status of this disks as described in v$asm_disk. They status must be either provisioned or candidate. I have encountered this situation before where the status was unknown and that caused me problems. Also, are you using multipathing? If so make sure you have scanorder and scanexclude set correctly in the oracleasm file as that can affect things. There was a thread about this a while ago. I apologize for not being more specific but I still don't have a good enough understanding of how things work. A lot of what I have done is through trial and error and can give you things to look at but that's about it at this point. Bill Wagman Univ. of California at Davis IET Campus Data Center wjwagman@ucdavis.edu (530) 754-6208 From: oracle-l-bounce@freelists.org [mailto: oracle-l-bounce@freelists.org ] On Behalf Of Finn Jorgensen Sent: Wednesday, December 12, 2007 2:09 PM To: litanli@gmail.com Cc: oracle-l Subject: Re: separate owner/ORACLE_HOME for crs, ASM, and database in RAC environment Before trying to figure this one out, I'm trying to wrap my brain around why you would do that. What's the thinking behind this setup? Finn On 12/12/07, 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 --0-673652717-1197515564=:6959 Content-Type: text/html; charset=us-ascii
Hi Li,

If you haven't already, I'd check the ASM instance logs, the DBCA trace output (I don't remember how, but there's an env var or a mod to the dbca start script that enables DBCA tracing), or the listener log to determine how far your DBCA is getting the process before failing.

I'd also probably try creating an instance by hand (without DBCA) to see if it's a DBCA issue or a core RDBMS/ASM issue.

One of those locations is bound to yield some useful log information to get you closer to finding the root cause of the issue. For the record, I'm not guessing...the issue going to be shown in one of those places for sure. I'm a card-carrying BAAG member ;).

Until you responded, I was hoping that you used a different OSASM group and that would be your issue. Hopes dashed...:(

Dan

P.S. I don't know how Oracle Support does it--solving issues with no access to see the issue and having to ask 1000's of questions to get the info they need. I still think they could do better, but it's threads like this one that remind me why I don't do phone support!

----- Original Message ----
From: Li Li <litanli@gmail.com>
To: Dan Norris <dannorris@dannorris.com>
Cc: William Wagman <wjwagman@ucdavis.edu>; finn.oracledba@gmail.com; oracle-l <oracle-l@freelists.org>
Sent: Wednesday, December 12, 2007 8:50:42 PM
Subject: Re: separate owner/ORACLE_HOME for crs, ASM, and database in RAC environment

Hi, Dan,

my OSASM group is "dba" also, I know this defeats some of the separation, but I just wanted to test this out. It's very strange to me that I have this issue because in my case both oracle and oraclex have "oinstall" as primary group and "dba" as second group, and oracle's RDBMS home and oraclex's RDBMS home all have 775 permission. I am trying to get some other eyes on this issue to see what I am missing :(

Thank you all for your time to reply!
-Li

On Dec 12, 2007 7:20 PM, Dan Norris <dannorris@dannorris.com> wrote:
In my experiences with this, the oraclex user (the RDBMS owner) will have to be in the OSASM group. This defeats some of the separation, but as I understand it, the Oracle developers know that the separation isn't quite complete yet and someone told me that we should expect "true" separation in a future release (probably 11g R2). If your OSASM group is also dba, then I'm not sure I know why you're having issues. I tried the same thing and had three users: 1) a clusterware owner, 2) an ASM owner, and 3) an RDBMS owner. I found that the clusterware can be separated pretty cleanly from the other two, but the ASM and RDBMS owners essentially have power over each others' domains since the RDBMS user must be in the OSASM group and I think the ASM owner may have had to be in the OSDBA. I don't have access to my test systems for this any longer, so my memory may be a little off. It's also possible that things have changed slightly since my testing which was done with 11gR1-beta5.

Dan


----- Original Message ----
From: Li Li < litanli@gmail.com>
To: William Wagman <wjwagman@ucdavis.edu>
Cc: finn.oracledba@gmail.com ; oracle-l <oracle-l@freelists.org>
Sent: Wednesday, December 12, 2007 5:51:26 PM
Subject: Re: separate owner/ORACLE_HOME for crs, ASM, and database in RAC environment

Hi, Bill,
 
I don't use asmlib because its dependency on linux kernel. I just create ASM diskgroups using RAW devices. when I login as oracle and start dbca, ASM disks are all look/work fine.

 
On Dec 12, 2007 5:14 PM, William Wagman <wjwagman@ucdavis.edu> wrote:
Greetings,
 
The thinking is to separate CRS, ASM and RDBMS for ease of maintenance. This is also the Oracle suggestion that each be in a separate home. It makes patching and upgrading easier.
 
As to the disk issues. First are you using ASMLIB? Make sure if you are it is configured correctly and the disks have been created.
 
Also look at the status of this disks as described in v$asm_disk. They status must be either provisioned or candidate. I have encountered this situation before where the status was unknown and that caused me problems.
 
Also, are you using multipathing? If so make sure you have scanorder and scanexclude set correctly in the oracleasm file as that can affect things. There was a thread about this a while ago.
 
I apologize for not being more specific but I still don't have a good enough understanding of how things work. A lot of what I have done is through trial and error and can give you things to look at but that's about it at this point.
 

Bill Wagman
Univ. of California at Davis
IET Campus Data Center
wjwagman@ucdavis.edu
(530) 754-6208

 

From: oracle-l-bounce@freelists.org [mailto: oracle-l-bounce@freelists.org ] On Behalf Of Finn Jorgensen
Sent: Wednesday, December 12, 2007 2:09 PM
To: litanli@gmail.com
Cc: oracle-l
Subject: Re: separate owner/ORACLE_HOME for crs, ASM, and database in RAC environment

Before trying to figure this one out, I'm trying to wrap my brain around why you would do that. What's the thinking behind this setup?
 
Finn

 
On 12/12/07, 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
 
 





--0-673652717-1197515564=:6959-- -- http://www.freelists.org/webpage/oracle-l