Re: Windows ASM and DBCA in 10g

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Tue, 29 Jun 2004 23:53:12 +1000
Message-ID: <40e1742c$0$16104$afc38c87@news.optusnet.com.au>

"Chris" <christian.antognini_at_trivadis.com> wrote in message news:c283720b.0406290541.2089f6a2_at_posting.google.com...
> Hi Howard
>
> > INSTANCE_NAME
> > ----------------
> > +asm
>
> Must be "+ASM" not "+asm". I just tested it on my linux laptop.

This is Windows, for starters. And as I replied elsewhere tonight, I carefully supplied uppercase versions of that name wherever it was required (such as ORACLE_SID, and when creating the service with oradim. The lowercase version you see displayed here is not of my making!

> > 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!!
>
> The information comes from a 2-days seminar about 10g that has been
> written from some colleagues and I (I work for Trivadis, a company
> specialized in consulting and training). In fact, when a new release
> comes, we spend some month testing the new features and documenting
> not only how it should work but also how it really works!
> With ASM we noticed that when the instance is not called +ASM some
> tools, like DBCA, don't recognize it.
>
> Chris

Fair enough. But as I say:

C:\>dir \oracle\10g\database\init+*
Volume in drive C is W2K
Volume Serial Number is 084A-E281

Directory of C:\oracle\10g\database

30/06/2004  12:19a                  17 init+ASM.ora                  (note

+ASM in the file name)

C:\>oradim -NEW -SID +ASM -STARTMODE auto                (note +ASM in the

command)
Instance created.

C:\>set ORACLE_SID=+ASM                                             (note

+ASM in the SID name)

C:\>sqlplus / as sysdba

SQL> startup
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

ORA-15110: no diskgroups mounted

SQL> select instance_name from v$instance;

INSTANCE_NAME

+asm
(er....)

...I used uppercase everywhere, and the result is a lowercase instance name.

Besides which, we have Connor reporting success in getting DBCA to recognise a manually-created ASM instance, despite it not being called +ASM at all!

It all seems a bit of a mess to me.
Regards
HJR Received on Tue Jun 29 2004 - 08:53:12 CDT