Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Usenet -> c.d.o.server -> Re: Unable to manually create RAC database

Re: Unable to manually create RAC database

From: The Boss <usenet_at_No.Spam.Please.invalid>
Date: Sat, 15 Dec 2007 20:31:25 +0100
Message-ID: <47642b8f$0$85782$>

DA Morgan wrote:

> trub3101 wrote:
>> On 15 Dec, 12:59, DA Morgan <> 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
>>> (replace x with u to respond)
>>> Puget Sound Oracle Users 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.
> 8K is the correct block size for Linux. Creating a 16K blocksize will
> likely gain you precisely nothing but extra work. Look up how to
> choose a block size on Howard Roger's site:

Can you provide a more precise pointer to Howard's site where he states "8K is the correct block size for Linux"?
Please read his article which seems to be far more balanced than such a simplistic "silver bullet" advice.

Received on Sat Dec 15 2007 - 13:31:25 CST

Original text of this message