Re: Windows ASM and DBCA in 10g

"Connor McDonald" <connor_mcdonald_at_yahoo.com> wrote in message news:40E14CF6.6F2C_at_yahoo.com...
> Howard J. Rogers wrote:
> >
> > "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
> >
> > Er, "ASM". No plus. Bugger. I will test this and let you know how I get
on!
> >
> > I found no reference to a name requirement at all in any of the
> > documentation...
> >
> > Is there an emoticon for 'gritting one's teeth whilst maintaining a
> > steely-eyed look of grim determination'??
> >
> > Cheers
> > HJR
>
> I've just tried the following...
>
> a) created asm service
>
> oradim.exe -new -asmsid +am1 -startmode manual -spfile
>
> (I chose +am1 just because of the other posts on the thread)

Connor: the only thing you've done here which I haven't, unless I'm much mistaken, is to call your instance +AM1 (Ay Em One?). I wonder why you picked that name, since the earlier post said that DBCA was hard-wired to look for an instance called +ASM?

>
> b) created pfile
>
> background_dump_dest=C:\oracle\admin\+am1\bdump
> core_dump_dest=C:\oracle\admin\+am1\cdump
> user_dump_dest=C:\oracle\admin\+am1\udump
> compatible=10.1.0.2.0
> large_pool_size=8388608
> shared_pool_size=64m
> remote_login_passwordfile=EXCLUSIVE
> instance_type = asm
> large_pool_size = 12m
>
> (nothing particularly special here - just started with a previous v10
> init.ora and stripped out stuff)
>
> c) started services OracleCSService, Oracle10TNSListener
>
> ( only because I have them set as manual normally so they don't chew up
> my laptop resources)
>
> d) started ASM instance
>
> SQL> startup pfile=c:\oracle\admin\+am1\scripts\init.ora
> ASM instance started
>
> Total System Global Area 134217728 bytes
> Fixed Size 787808 bytes
> Variable Size 133429920 bytes
> Database Buffers 0 bytes
> Redo Buffers 0 bytes
> ORA-15110: no diskgroups mounted
>
> e) then fired up DBCA. Obviously I don't have any disk groups, but the
> DBCA did let me get to picking from the (empty) list of disk groups,
> whereas before steps (a)=>(d) above had been done, it told me there was
> no ASM instance

Dare I ask what happened if you create the disk groups manually, and *then* fire up DBCA? Perhaps that is what I'm doing wrong: trying to do too much manually.
The lack of documentation on the subject is driving me nuts, frankly.

Regards
HJR Received on Tue Jun 29 2004 - 06:33:35 CDT