Re: asm and multiple databases

From: helter skelter <helterskelter_at_gmail.com>
Date: Wed, 04 Feb 2009 09:33:27 +0100
Message-ID: <gmbkap$m0c$1_at_mx1.internetia.pl>



Vladimir M. Zakharychev pisze:
>> And answer for this  rhetorical question is ...? :)

>
> Yes, because ASM file numbers will be different for different database
> files, even though they all will go under the same +dg/ORCL/
> "directory". But why didn't you change the db names from their
> default? Not enough challenges? ;)
>
> Regards,
> Vladimir M. Zakharychev
> N-Networks, makers of Dynamic PSP(tm)
> http://www.dynamicpsp.com

I wrote "ORCL" for example, it's not their real name :) Anyway, it was not my idea to have the same name for all databases :/

I'v made a simple test. I have started clustered ASM on nodes: rac1, rac2, rac3 with one disk group. Then, I started clustered database with db_name "ORCL" on nodes: rac1 and rac2. Then I tried to install single instance database on node rac3 (with db_name "ORCL") on the same diskgroup. When installer stated copying data file I've got "ORA-00304 requested INSTANCE NUMBER is busy". So now I'm not sure it's possible :/

When I've changed db_name to ORCL everything was fine. Received on Wed Feb 04 2009 - 02:33:27 CST

Original text of this message