"trub3101" <trub3101_at_sky.com> wrote in message
news:f12f15f4-ffcd-45d2-b137-555bd200f603_at_s19g2000prg.googlegroups.com...
> On Dec 16, 11:23 pm, trub3101 <trub3..._at_sky.com> wrote:
>> On Dec 16, 4:24 am, "Bob Jones" <em..._at_me.not> wrote:
>>
>>
>>
>>
>>
>> > "trub3101" <mich..._at_bassline01.wanadoo.co.uk> wrote in message
>>
>> >news:582d2d6d-f447-47f8-98b1-b796370f393c_at_c4g2000hsg.googlegroups.com...
>>
>> > > On 16 Dec, 00:51, "Bob Jones" <em..._at_me.not> wrote:
>> > >> "trub3101" <mich..._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?- Hide quoted text -
>>
>> > >> - Show quoted text -
>>
>> > > HI Bob,
>>
>> > > Database now created although I have yet to create the logs for
>> > > thread
>> > > 2 I'll be back should I have anymore problems. After examining the
>> > > alert log and trace files now looks as if the directory for the
>> > > system
>> > > tablespace had not been created so I feel an apology is in order for
>> > > giving everyone the run around your pointers and suggestions have
>> > > been
>> > > very insightful.
>>
>> > > Cheers,
>>
>> > > tb3101
>>
>> > No problem, tb3101. You just need some patience since this is your
>> > first
>> > time. It is absolutely not hard to create a RAC without dbca. I have
>> > done it
>> > plenty of times. Don't get discouraged because someone say you can't do
>> > it.
>> > Feel free to post any questions here.- Hide quoted text -
>>
>> > - Show quoted text -
>>
>> Thanks again for all your help and encouragement Daniel!
>>
>> Nice to know that there are still friendly and considerate souls out
>> there willing to help!
>>
>> tb3101- Hide quoted text -
>>
>> - Show quoted text -
>
> Sorry Bob!
>
> Its been a long day! Thank you again for all your help and
> encouragement in this matter. It would appear as if I now have the two
> instances accessing the database although I would like to do further
> tests and investigations to make sure I have not missed anything.
>
> Cheers,
>
> tb3101
Excellent. I am glad it works for you. Now you can do some others can't.
Received on Sun Dec 16 2007 - 19:25:32 CST
