Re: asm and multiple databases

From: gazzag <gareth_at_jamms.org>
Date: Wed, 4 Feb 2009 04:40:27 -0800 (PST)
Message-ID: <cb386b85-e468-4ad1-b579-8b248b123f0e_at_z28g2000prd.googlegroups.com>



On 4 Feb, 11:20, helter skelter <helterskel..._at_gmail.com> wrote:
> helter skelter pisze:
>
>
>
>
>
> > 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 ORCL2 everything was fine.
>
> OK, I know whats going on.
> I can't use the same SID from clustered oracle_home, when it's used on
> another node, even when it's used from another home but in the same cluster.
> When I've installed another single ORACLE_HOME I can store database with
> the same name on this disk group.
> But could it be a reason for any troubles in the future ?- Hide quoted text -
>

Change the name of one of the databases, PLEASE. Databases have names for a reason.

HTH -g Received on Wed Feb 04 2009 - 06:40:27 CST

Original text of this message