7 Replies Latest reply: Sep 23, 2013 7:38 AM by Fran RSS

    Single Instance To RAC Conversion "DBCA"

    User374733

      Single Instance Database

      • Platform: RHEL 4u7
      • DB: 11.2.0.1
      • OH: /u01/app/oracle/product/11.2.0/db_1

       

      Grid infrastructure (/u01/ora/11.2.0/grid) and RAC Database software (/u01/app/ora/product/11.2.0/db_1) has been deployed. Single instance database has been moved from file system to ASM. Now trying to convert single instance database to RAC using DBCA but getting below error while doing step:

      • Use DBCA to Create an Image of the Single-Instance Database

       

      ORA-01078: failure in processing system parameters

      ORA-01034: oracle not available

       

      $ lsnrctl status

      LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 23-SEP-2013 15:17:03

      Copyright (c) 1991, 2009, Oracle.  All rights reserved.

      Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1525)))
      STATUS of the LISTENER
      ------------------------
      Alias                     LISTENER
      Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production
      Start Date                23-SEP-2013 13:47:04
      Uptime                    0 days 1 hr. 29 min. 59 sec
      Trace Level               off
      Security                  ON: Local OS Authentication
      SNMP                      OFF
      Listener Parameter File   /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
      Listener Log File         /u01/app/oracle/diag/tnslsnr/linux1/listener/alert/log.xml
      Listening Endpoints Summary...
        (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1525)))
        (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=linux1.umair.pk)(PORT=1525)))
      Services Summary...
      Service "ORCL" has 1 instance(s).
        Instance "ORCL", status UNKNOWN, has 1 handler(s) for this service...
      The command completed successfully
      [oracle@linux1 orcl]$

       

      $ sqlplus / as sysdba

      SQL*Plus: Release 11.2.0.1.0 Production on Mon Sep 23 15:17:16 2013

      Copyright (c) 1982, 2009, Oracle.  All rights reserved.


      Connected to:
      Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
      With the Partitioning, Automatic Storage Management, OLAP, Data Mining
      and Real Application Testing options

      SQL> select open_mode from v$database;

      OPEN_MODE
      --------------------
      READ WRITE

      SQL> sho parameter name

      NAME                                 TYPE        VALUE
      ------------------------------------ ----------- ------------------------------
      db_file_name_convert                 string
      db_name                              string      orcl
      db_unique_name                       string      orcl
      global_names                         boolean     FALSE
      instance_name                        string      ORCL
      lock_name_space                      string
      log_file_name_convert                string
      service_names                        string      orcl.umair.pk
      SQL>

       

      $ cat /etc/oratab

      +ASM1:/u01/ora/11.2.0/grid:N            # line added by Agent

      orcl:/u01/app/ora/product/11.2.0/db_1:N         # line added by Agent

      ORCL:/u01/app/oracle/product/11.2.0/db_1:N              # line added by Agent

        • 2. Re: Single Instance To RAC Conversion "DBCA"
          User374733

          The step I mentioned:

          Use DBCA to Create an Image of the Single-Instance Database

          is from the same document. Thanks.

          • 3. Re: Single Instance To RAC Conversion "DBCA"
            Fran

            No, "Use DBCA to Create an Image of the Single-Instance Database" isn't in that document.

             

            From the document:

            Before you use DBCA to convert a single-instance database to an Oracle RAC or an Oracle RAC One Node database, ensure that your system meets the following conditions:

            • It is a supported hardware and operating system software configuration.
            • It has shared storage: either Oracle Cluster File System or Oracle ASM is available and accessible from all nodes. On Linux on POWER systems, ensure that GPFS is available and accessible from all nodes.
            • Your applications have no design characteristics that preclude their use with cluster database processing

             

            After check this conditions:

            C.2.3 Converting Single Instance on a Cluster to Oracle RAC Using DBCA

            • 4. Re: Single Instance To RAC Conversion "DBCA"
              User374733

              I am following this document:

              http://docs.oracle.com/cd/E11882_01/install.112/e18069/cvrt2rac.htm#BABDEBBI

               

               

              Step "Use DBCA to Create an Image of the Single-Instance Database" of the above mentioned note has different name "Back Up the Original Single-Instance Database" in your suggested document.

              • 5. Re: Single Instance To RAC Conversion "DBCA"
                Fran

                You are following the wrong document:

                Oracle® Real Application Clusters Installation Guide
                11g Release 2 (11.2) for Microsoft Windows x64 (64-Bit)


                And your OS are Unix:

                Single Instance Database

                • Platform: RHEL 4u7
                • DB: 11.2.0.1
                • OH: /u01/app/oracle/product/11.2.0/db_1



                Also you can follow this post:

                Welcome to the database wizard!: Migrating single instance Oracle 11g database to Oracle 11gR2 RAC and ASM

                • 6. Re: Single Instance To RAC Conversion "DBCA"
                  User374733

                  Manual conversion has already been done. I just restored my servers to the previous state and now doing the conversion through dbca.

                   

                  Agreed on your identified mistake on document selection but still the step is same in both documents.

                   

                  Anyhow, now I am starting the procedure from scratch. Thanks.

                  • 7. Re: Single Instance To RAC Conversion "DBCA"
                    Fran

                    basically to do the conversion:

                     

                    1) backup full database

                    run {

                    allocate channel c1 type disk;

                    backup  database format '/backup/rman/bkp_%d_t%t_s%s_p%p.bkp'; --change to your path

                    sql "alter system archive log current";

                    backup archivelog all delete input format '/backup/rman/arc_%d_t%t_s%s_p%p.bkp'; --change to your path

                    release channel c1;

                    }

                    2) clusterwave installation (if not installed before)

                    3) copy fulll backup to node1 of your RAC

                    4) duplicate database

                    RMAN> connect target / --From single instance

                    connect auxiliary sys/xxxxxxx@RAC --target RAC database

                    run{

                    allocate channel c1 device type disk '/backup/rman/';

                    ##If you want your datafile in other place add:

                    set newname for datafile 1 to '/../../../datafile1.dbf';

                    set newname for datafile 2 to '/../../../datafile2.dbf';

                    set newname for datafile 3 to '/../../../datafile3.dbf';

                    set newname for datafile 4 to '/../../../datafile4.dbf';

                    set newname for datafile 5 to '/../../../datafile5.dbf';

                    set newname for datafile 6 to '/../../../datafile6.dbf';

                    *

                    *

                    *

                    ## if you want in the same path, avoid this step

                    duplicate target database to RAC

                    pfile=/../../../../../init.ora

                    logfile

                    group 1 ('+DATA','+FRA') SIZE 50M reuse, --Change ASM diskgroups name

                    group 2 ('+DATA','+FRA') SIZE 50M reuse; --Add more groups if you have more

                    release channel c1;

                    }

                     

                    5) Modify pfile, adding :

                    *.cluster_database_instances=2

                    *.cluster_database=true

                    *.remote_listener='<scan:port>’

                    ORANode1.instance_number=1

                    ORANode2.instance_number=2

                    ORANode1.thread=1

                    ORANode2.thread=2

                    ORANode1.undo_tablespace='UNDOTBS1'

                    ORANode2.undo_tablespace='UNDOTBS2'

                    #update the actual controlfile path

                    *.control_files='+DATA/../../../current.256.666342941','+FRA/../../current.256.662312941'

                    6) Now register database with CRS

                    $ srvctl add database -d RAC -o <ORACLE_HOME>

                    $ srvctl add instance -d RAC-i <instance Name node1> -n <node_name1>

                    $ srvctl add instance -d RAC-i <instance Name node2> -n <node_name2>

                     

                    7) now you have your rac. You can start/stop it:

                    srvctl stop database -d RAC

                    srvctl start database -d RAC