"trub3101" <michael_at_bassline01.wanadoo.co.uk> wrote in message
news:39f0842f-8199-4b8a-85f4-9f697e066762_at_s19g2000prg.googlegroups.com...
> On 16 Dec, 00:00, "Bob Jones" <em..._at_me.not> wrote:
>> "trub3101" <mich..._at_bassline01.wanadoo.co.uk> wrote in message
>>
>> news:6522b0fb-d411-4539-bb45-5f6344432ffb_at_e67g2000hsc.googlegroups.com...
>>
>>
>>
>>
>>
>> > On 15 Dec, 19:38, "Bob Jones" <em..._at_me.not> wrote:
>> >> "trub3101" <mich..._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.- Hide quoted text -
>>
>> >> - Show quoted text -
>>
>> > Thanks for your reply Bob.
>>
>> > I tried just running the CREATE DATABASE statement earlier.
>> > Unfortunately it returns with an 'ORA-01034: ORACLE not available'
>> > error message.
>>
>> > Point taken regarding /opt howevver, this particular filesystem /opt/
>> > app/oracle/oradata appears to sit on SAN and not the server HDD.
>>
>> > Thanks again Bob.
>>
>> STARTUP NOMOUNT
>> then run CREATE DATABASE.- Hide quoted text -
>>
>> - Show quoted text -
>
> Whoops! Of course! Silly me.
>
> However, I am now getting ;
> create database "<new_RAC_db>"
> *
> ERROR at line 1:
> ORA-01092: ORACLE instance terminated. Disconnection forced
>
> Thanks
>
> tb3101
>
What does it say in the alert log?
Received on Sat Dec 15 2007 - 18:51:12 CST
