Re: Unable to manually create RAC database

On 15 Dec, 12:59, DA Morgan <damor..._at_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..._at_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. Received on Sat Dec 15 2007 - 07:31:47 CST