DA Morgan wrote:
> trub3101 wrote:
>> 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.
>
> 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: www.dizwell.com.
>
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 http://www.dizwell.com/prod/node/58 which seems to
be far more balanced than such a simplistic "silver bullet" advice.
--
Jeroen
Received on Sat Dec 15 2007 - 13:31:25 CST
