Re: Windows ASM and DBCA in 10g

"Victor Oosterbaan" <voosterbaan_at_desyde.nl> wrote in message news:92f6cf14.0406290336.4de9fda2_at_posting.google.com... > "Howard J. Rogers" <hjr_at_dizwell.com> wrote in message news:<40e0721c$0$16107$afc38c87_at_news.optusnet.com.au>...
> > "Chris" <christian.antognini_at_trivadis.com> wrote in message
> > news:c283720b.0406280523.3047cf22_at_posting.google.com...
> > > Hi Howard
> > >
> > > Which name did you use for the ASM instance?
> > > Many tools, like DBCA and Grid Control, support only "+ASM". Yes, you
> > > should really put the "+" in it :-(
> > >
> > > Chris
> >
> > A quick update... it makes no difference.
> >
> > SQL> startup force
> > ASM instance started
> >
> > Total System Global Area 100663296 bytes
> > Fixed Size 787648 bytes
> > Variable Size 99875648 bytes
> > Database Buffers 0 bytes
> > Redo Buffers 0 bytes
> > ASM diskgroups mounted
> > SQL> create spfile from pfile;
> >
> > File created.
> >
> > SQL> select instance_name from v$instance;
> >
> > INSTANCE_NAME
> > ----------------
> > +asm
> >
> > And with all of that running, DBCA still reports: "There are no ASM
> > instances running on this machine".
> >
> > Can I ask where you heard about the naming issue, so I can read around
on
> > the topic? It certainly sounds like a plausible candidate for the cause
of
> > my woes, and perhaps there's only a couple of other things I need to
change
> > to get it working!!
> >
> > Regards
> > HJR

>
> Maybe a stupid remark, but he stated the name should be "+ASM".
> the quotes around it suggest it's case-sensitive, and your instance is
> in lower-case.

No, it's not a stupid remark, because I thought the same thing. But you can't force the issue with Windows. The instance gets its name from the ORACLE_SID environment variable. That was set to +ASM1, upper case. I also specified +ASM1 when creating the service with oradim. Clearly, it got resolved down to a lower-case version, but I know of no way of forcing the use of uppercase (try putting quotes around the name when using Oradim, and it goes beserk).

> sounds weird, but hey, better then nothing, right?
> When I get some free space on my laptop, i'm going to try it myself
> too.
> (read: when i finally decide to remove my 9i-db and replace it with a
> 10g one.)

I actually like ASM very much. And I have no problems using a manually-created ASM instance for a manually-created database; nor a DBCA-created ASM instance for a DBCA-created database. I just can't get the two 'modes' of operation to talk to each other... though Connor reports it's possible, so it must be. It's probably just the nylon underwear I'm wearing.

Regards
HJR Received on Tue Jun 29 2004 - 07:17:09 CDT