Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Unable to manually create RAC database

Unable to manually create RAC database

From: trub3101 <michael_at_bassline01.wanadoo.co.uk>
Date: Sat, 15 Dec 2007 04:24:57 -0800 (PST)
Message-ID: <d09a1798-720c-4d3c-8f91-469f2c40f044@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>



----init.ora



more init<new_RAC_db>11.ora


spfile=/opt/app/oracle/oradata/<new_RAC_db>/spfile<new_RAC_db>.ora



more init<new_RAC_db>12.ora


spfile=/opt/app/oracle/oradata/<new_RAC_db>/spfile<new_RAC_db>.ora



strings /opt/app/oracle/oradata/<new_RAC_db>/spfile<new_RAC_db>.ora


*.aq_tm_processes=1

*.background_dump_dest='/opt/app/oracle/admin/<new_RAC_db>/bdump'

*.cluster_database_instances=4

*.cluster_database=TRUE

*.compatible='9.2.0.0.0'

*.control_files='/opt/app/oracle/oradata/<new_RAC_db>/control01.ctl','/

opt/app/oracle/oradata/<new_RAC_db>/control02.ctl','/opt/app/oracle/
oradata/<new_RAC_db>/control03.ctl'


*.core_dump_dest='/opt/app/oracle/db/admin/<new_RAC_db>/cdump'

*.cursor_sharing='EXACT'

*.db_2k_cache_size=67108864

*.db_block_size=16384

*.db_cache_size=786432000

*.db_domain='bbc.co.uk'

*.db_file_multiblock_read_count=16

*.db_keep_cache_size=167772160

*.db_name='<new_RAC_db>'

*.fast_start_mttr_target=300

*.global_names=true

*.hash_join_enabled=TRUE


<new_RAC_db>1.instance_name='<new_RAC_db>1'
<new_RAC_db>2.instance_name='<new_RAC_db>2'
<new_RAC_db>1.instance_number=1
<new_RAC_db>2.instance_number=2


*.java_pool_size=115343360

*.job_queue_processes=10



*.large_pool_size=50331648

*.log_archive_dest_1='location=/opt/app/oracle/oradata/<new_RAC_db>/

archive/'


<new_RAC_db>2.log_archive_format='<new_RAC_db>2_%t_%s.dbf'
<new_RAC_db>1.log_archive_format='<new_RAC_db>1_%t_%s.dbf'


*.log_archive_start=TRUE

*.open_cursors=300

*.pga_aggregate_target=262144000

*.processes=400

*.query_rewrite_enabled='FALSE'

*.remote_listener='LISTENERS_<test_RAC_db>1'

*.remote_login_passwordfile='exclusive'

*.shared_pool_size=524288000

*.sort_area_size=512000

*.star_transformation_enabled='FALSE'



<new_RAC_db>1.thread=1


<new_RAC_db>2.thread=2


*.timed_statistics=TRUE

*.undo_management='AUTO'

*.undo_retention=10800

*.undo_suppress_errors=TRUE



<new_RAC_db>1.undo_tablespace='UNDO1'


<new_RAC_db>2.undo_tablespace='UNDO2'


*.user_dump_dest='/opt/app/oracle/admin/<new_RAC_db>/udump'

*.utl_file_dir='/opt/app/oracle/oradata/radiotimes/data/MISC'







LISTENERS_<test_RAC_db>1 =


  (ADDRESS_LIST =



    (ADDRESS = (PROTOCOL = TCP)(HOST = node1)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = node2)(PORT = 1521))
  )



<test_RAC_db>11 =


  (DESCRIPTION =



    (ADDRESS_LIST =



      (ADDRESS = (PROTOCOL = TCP)(HOST = node1)(PORT = 1521))
    )


    (CONNECT_DATA =



      (SERVICE_NAME = <test_RAC_db>1)


    )


  )



<test_RAC_db>1 =


  (DESCRIPTION =



        (LOAD_BALANCE = yes)


    (ADDRESS_LIST =


      (ADDRESS = (PROTOCOL = TCP)(HOST = node1)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = node2)(PORT = 1521))


    )


    (CONNECT_DATA =



      (SERVICE_NAME = <test_RAC_db>1)


    )


  )



<test_RAC_db>12 =


  (DESCRIPTION =



    (ADDRESS_LIST =



      (ADDRESS = (PROTOCOL = TCP)(HOST = node2)(PORT = 1521))
    )


    (CONNECT_DATA =



      (SERVICE_NAME = <test_RAC_db>1)


    )


  )



<new_RAC_db>1 =


  (DESCRIPTION =



    (ADDRESS_LIST =



      (ADDRESS = (PROTOCOL = TCP)(HOST = node1)(PORT = 1521))
    )


    (CONNECT_DATA =



      (SERVICE_NAME = <new_RAC_db>)


    )


  )



<new_RAC_db> =


  (DESCRIPTION =



        (LOAD_BALANCE = yes)


    (ADDRESS_LIST =


      (ADDRESS = (PROTOCOL = TCP)(HOST = node1)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = node2)(PORT = 1521))


    )


    (CONNECT_DATA =



      (SERVICE_NAME = <new_RAC_db>)


    )


  )



<new_RAC_db>2 =


  (DESCRIPTION =



    (ADDRESS_LIST =



      (ADDRESS = (PROTOCOL = TCP)(HOST = node2)(PORT = 1521))
    )


    (CONNECT_DATA =



      (SERVICE_NAME = <new_RAC_db>)


    )


  )




more listener.ora


# LISTENER.ORA.node1.<domain>01.COM Network Configuration File: /opt/
app/oracle/product/9.2.0/db/network/admin/
listener.ora.node1.<domain>01


.com


# Generated by Oracle configuration tools.



SID_LIST_LISTENER_node1 =


  (SID_LIST =



    (SID_DESC =


      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /opt/app/oracle/product/9.2.0/db)
      (PROGRAM = extproc)




    )


  )



LISTENER_node1 =


  (DESCRIPTION_LIST =



    (DESCRIPTION =


      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = node1.<domain>01.com)(PORT
= 1521))
      )




    )


  )



more listener.ora


# LISTENER.ORA.node2.<domain>01.COM Network Configuration File: /opt/
app/oracle/product/9.2.0/db/network/admin/
listener.ora.node2.<domain>01


.com


# Generated by Oracle configuration tools.



SID_LIST_LISTENER_node2 =


  (SID_LIST =



    (SID_DESC =


      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /opt/app/oracle/product/9.2.0/db)
      (PROGRAM = extproc)




    )


  )



LISTENER_node2 =


  (DESCRIPTION_LIST =



    (DESCRIPTION =


      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = node2.<domain>01.com)(PORT
= 1521))
      )




    )


  )
Received on Sat Dec 15 2007 - 06:24:57 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US