Re: Unable to manually create RAC database

On Dec 15, 6:24 pm, trub3101 <mich..._at_bassline01.wanadoo.co.uk> wrote:
> 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 -
> 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.

Right - First to get 16k blocks out Solaris would take some pretty specialized work. IOW I dont believe it. That would requite some proof : >

Secondly how the HEY can you install RAC "successfully" if you cannot even get dbca to run remotely..?

Rethink your approach or better yet, hire a consultant! Received on Sat Dec 15 2007 - 21:10:50 CST