Re: Windows ASM and DBCA in 10g

"Howard J. Rogers" <hjr_at_dizwell.com> wrote in message news:40e1742c$0$16104$afc38c87_at_news.optusnet.com.au...

[snip]

> 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*Plus: Release 10.1.0.2.0 - Production on Wed Jun 30 00:23:15 2004
> Copyright (c) 1982, 2004, Oracle. All rights reserved.
> Connected to an idle instance.
>
> 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
I meant to add, Chris, that I am sure you are right (apart from Connor suggesting it might not be the whole issue), but that I don't see on Windows at least how to control the instance name capitalisation... besides which, I don't believe it is documented anywhere that you *must* call your ASM instances +ASM, so for there to be a surreptitious requirement to do so (as seems, however, to be the case) is tantamount to a bug in my book.

I'm intrigued as to why this hasn't (apparently) been brought up earlier by Windows users, though (and there are some!!). It must mean, I think, that few people are using ASM. I wonder why that would be?

Regards
HJR Received on Tue Jun 29 2004 - 09:00:02 CDT