Re: Windows ASM and DBCA in 10g

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Tue, 29 Jun 2004 19:05:26 +0800
Message-ID: <40E14CF6.6F2C@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...

created asm service

oradim.exe -new -asmsid +am1 -startmode manual -spfile

(I chose +am1 just because of the other posts on the thread)

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

hth
connor

-- 
Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
ISBN: 1590592174

web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com

Coming Soon! "Oracle Insight - Tales of the OakTable"

"GIVE a man a fish and he will eat for a day. But TEACH him how to fish,
and...he will sit in a boat and drink beer all day"

------------------------------------------------------------

Received on Tue Jun 29 2004 - 06:05:26 CDT