Re: Unable to manually create RAC database

"trub3101" <michael_at_bassline01.wanadoo.co.uk> wrote in message news:d09a1798-720c-4d3c-8f91-469f2c40f044_at_x69g2000hsx.googlegroups.com...
> 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
>
> I have managed to manually create a single instance database (on
> another server) using the script listed (without the RAC thread 2
> prerequisites!)
> Hopefully, I have provided enough information for someone to point me
> in the right direction.
>
> Many thanks in advance
>
> tb3101
>
>
> ---Architecture.
>
> Two nodes
> Linux node1.domain01.com 2.6.9-67.ELsmp #1 SMP Wed Nov 7 13:56:44 EST
> 2007 x86_64 x86_64 x86_64 GNU/Linux
> Linux node2.domain01.com 2.6.9-67.ELsmp #1 SMP Wed Nov 7 13:56:44 EST
> 2007 x86_64 x86_64 x86_64 GNU/Linux
>
> Oracle9i Enterprise Edition Release 9.2.0.7.0 - 64bit Production
> With the Partitioning, Real Application Clusters, OLAP and Oracle Data
> Mining options
> JServer Release 9.2.0.7.0 - Production
>
>
>
> ---Build RAC Database (used on node1 only)
>
> ORACLE_SID=<new_RAC_db>11
> export ORACLE_SID
>
> sqlplus /nolog<<EOF
> connect sys/<password> as sysdba
> Connected to an idle instance.
> SQL> startup nomount pfile=$ORACLE_HOME/dbs/init<new_RAC_db>11.ora
>
> 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
> default temporary tablespace temp tempfile '/opt/app/oracle/oradata/
> <new_RAC_db>/tmp/temp01.dbf' SIZE 1000M reuse autoextend on next 640k
> maxsize unlimited
> undo tablespace "UNDO1" datafile '/opt/app/oracle/oradata/<new_RAC_db>/
> undo/undo1_01.dbf' size 500m reuse autoextend on next 5120k maxsize
> unlimited extent management local
> logfile
> '/opt/app/oracle/oradata/<new_RAC_db>/rdo/log01a.dbf'
> SIZE 50M,
> '/opt/app/oracle/oradata/<new_RAC_db>/rdo/log02a.dbf'
> SIZE 50M,
> '/opt/app/oracle/oradata/<new_RAC_db>/rdo/log03a.dbf'
> SIZE 50M
> alter database mount
> create undo tablespace "UNDO2" datafile '/opt/app/oracle/oradata/
> <new_RAC_db>/undo/undo2_01.dbf' size 500m autoextend on next 5120k
> maxsize unlimited extent management local
> alter database add logfile thread 2
> group 1 SIZE 50m,
> group 2 SIZE 50m,
> group 3 size 50m
>
> alter database enable public thread 2
>
> spool off
>>>EOF
>
>
> ORACLE instance started.
>
> Total System Global Area 1813482504 bytes
> Fixed Size 744456 bytes
> Variable Size 788529152 bytes
> Database Buffers 1023410176 bytes
> Redo Buffers 798720 bytes
> SQL> SQL> 2 3 4 5 6 7 8 9 10 11 12 13
> 14 15 16 17 18 19 20 21 SQL> 2 SQL> SQL>
> SQL> /
> create database "<new_RAC_db>"
> *
> ERROR at line 1:
> ORA-01092: ORACLE instance terminated. Disconnection forced
>
>
> SQL>
>

Try running just the CREATE DATABASE statement alone and see if it is successful. Do you have enough space in /opt? If I were you, I would not put datafiles in /opt. Received on Sat Dec 15 2007 - 13:38:15 CST