Path: text.usenetserver.com!out03b.usenetserver.com!news.usenetserver.com!in02.usenetserver.com!news.usenetserver.com!postnews.google.com!a35g2000prf.googlegroups.com!not-for-mail
From: trub3101 <michael@bassline01.wanadoo.co.uk>
Newsgroups: comp.databases.oracle.server
Subject: Re: Unable to manually create RAC database
Date: Sat, 15 Dec 2007 05:31:47 -0800 (PST)
Organization: http://groups.google.com
Lines: 62
Message-ID: <6a98a9d3-eef3-4316-81b8-3ca6ac6c160d@a35g2000prf.googlegroups.com>
References: <d09a1798-720c-4d3c-8f91-469f2c40f044@x69g2000hsx.googlegroups.com> 
 <1197723526.691076@bubbleator.drizzle.com>
NNTP-Posting-Host: 132.185.144.123
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Trace: posting.google.com 1197725508 1298 127.0.0.1 (15 Dec 2007 13:31:48 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Sat, 15 Dec 2007 13:31:48 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: a35g2000prf.googlegroups.com; posting-host=132.185.144.123; 
 posting-account=RS0lkAoAAAB2-ppbLV8AIz8M0B5IV7QC
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET 
 CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30),gzip(gfe),gzip(gfe)
X-HTTP-Via: 1.1 webgw3-rth.mh.bbc.co.uk:80 (squid/2.6.STABLE13)
Xref: usenetserver.com comp.databases.oracle.server:439145
X-Received-Date: Sat, 15 Dec 2007 08:31:48 EST (text.usenetserver.com)

On 15 Dec, 12:59, DA Morgan <damor...@psoug.org> wrote:
> trub3101 wrote:
> > Hi Guru's,
>
> > I am hoping that someone (anyone!) will be able to provide me with
> > some assistance with this as my RAC experience is very limited.
> > I have been trying to manually create a new RAC database <new_RAC_db>
> > but I keep getting this error message:
>
> > create database "<new_RAC_db>"
> > *
> > ERROR at line 1:
> > ORA-01092: ORACLE instance terminated. Disconnection forced
>
> > The servers (hosted) came online yesterday with <test_RAC_db> running
> > (no db build script provided!)however, because of the db_block_size
> > (too small) this
> > is of no use to our business needs
>
> What is the operating system?
> What block size did it come with?
> What block size do you need and why?
>
> > create database "<new_RAC_db>"
> >         maxinstances 10
> >         maxlogfiles 20
> >         maxdatafiles 100
> >         maxlogmembers 5
> >         character set "UTF8"
> >         datafile '/opt/app/oracle/oradata/<new_RAC_db>/system/
> > system01.dbf' size 250M
> > <balance snipped>
>
> I have never seen anyone successfully build a RAC cluster using this
> method. I am sure someone has but why put yourself through so much pain
> with no gain.
>
> Use DBCA.
> --
> Daniel A. Morgan
> Oracle Ace Director & Instructor
> University of Washington
> damor...@x.washington.edu (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org- Hide quoted text -
>
> - Show quoted text -

Hi Daniel,

Thanks for your quick reply.

The OS is Red Hat Enterprise Linux AS 4
The block size for <new_RAC_db> is 8192
The current requirement is 16384 which when created will be populate
by an export dmp.
All our tablespaces for the database being migrated across has a 16k
blocksize.

Forgive my ignorance but I have to admit I am not clear on how to call
up DBCA as the servers are being hosted by an outside company.

Thanks again for you reply.