Re: Unable to manually create RAC database

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 Received on Sun Dec 16 2007 - 17:23:45 CST