Re: Unable to manually create RAC database

From: DA Morgan <damorgan_at_psoug.org>
Date: Sat, 15 Dec 2007 08:33:12 -0800
Message-ID: <1197736377.72967@bubbleator.drizzle.com>

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.

As I stated earlier, the chances of you being successful with a build script are vanishingly small. Even if you have to purchase a plane ticket use dbca.

-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Sat Dec 15 2007 - 10:33:12 CST