Re: Unable to manually create RAC database

On 16 Dec, 01:03, DA Morgan <damor..._at_psoug.org> wrote:
> trub3101 wrote:
> > 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 -
>
> > Silly me!
>
> > Thanks Bob. However, I now get this message:
>
> > create database "<new_RAC_db>"
> > *
> > ERROR at line 1:
> > ORA-01092: ORACLE instance terminated. Disconnection forced
>
> > Thanks again
>
> > tb3101
>
> What I think Bob is missing is that this is RAC. And that the RAC
> install MUST push the binaries to both servers and know what to do with
> a lot of other moving pieces. While you are only creating one database
> you must support multiple instances. Even after the binaries are
> installed it isn't vanilla. What are you using for a file system? The
> correct answer is likely ASM have you built an ASM instance on each
> node? Did you do it without using dbca? Or perhaps OCFS, OCFS2, or
> NFS, again no indication from your script.
>
> Have installed and validated the Oracle clusterware with the cluster
> verify tool?
>
> You can play with this and inflict as much pain and suffering as you
> wish ... but if you fire up dbca ... the installer handles it all for you.
>
> In my lab we build clusters in far less time than you've spent trying
> to hurt yourself: From operating system to failover testing for a 2 node
> cluster takes less than 6 hours.
> --
> 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,

These are very valid points which have crossed my mind whilst since I started all this.
However, without access to DBCA I fear I have no choice but to plough on and see how far I
can get with a manual install.

I truly appreciate your contributions to this thread and I am by no means dismissing your
valuable advice. Being the first time I have had anything to do with Oracle RAC I was expecting
a steep learning curve.

Thanks again Daniel. Received on Sat Dec 15 2007 - 20:24:04 CST