1 2 Previous Next 17 Replies Latest reply: Apr 25, 2013 12:21 AM by vasuoracledba Go to original post RSS
      • 15. Re: Manual creation of Oracle RAC Database
        vasuoracledba
        I created the SPfile in dbfile diskgroup.

        ASMCMD [+DBFILE/FINANCE/PARAMETERFILE] > pwd
        +DBFILE/FINANCE/PARAMETERFILE
        ASMCMD [+DBFILE/FINANCE/PARAMETERFILE] > ls
        spfile.262.813625005

        I bounced the database.

        SQL> startup force
        ORACLE instance started.

        Total System Global Area 233861120 bytes
        Fixed Size 2212088 bytes
        Variable Size 176164616 bytes
        Database Buffers 50331648 bytes
        Redo Buffers 5152768 bytes
        Database mounted.
        Database opened.

        SQL> show parameter spfile;

        NAME TYPE VALUE
        ------------------------------------ ----------- ------------------------------
        spfile string

        Output of $GRID_HOME/bin/crsctl stat res -t

        --------------------------------------------------------------------------------
        NAME TARGET STATE SERVER STATE_DETAILS
        --------------------------------------------------------------------------------
        Local Resources
        --------------------------------------------------------------------------------
        ora.ARCLOG.dg
        ONLINE OFFLINE rac-node1
        ONLINE OFFLINE rac-node2
        ora.CTRL.dg
        ONLINE OFFLINE rac-node1
        ONLINE OFFLINE rac-node2
        ora.DBFILE.dg
        ONLINE OFFLINE rac-node1
        ONLINE OFFLINE rac-node2
        ora.FRA.dg
        ONLINE OFFLINE rac-node1
        ONLINE OFFLINE rac-node2
        ora.REDO1.dg
        ONLINE OFFLINE rac-node1
        ONLINE OFFLINE rac-node2
        ora.REDO2.dg
        ONLINE OFFLINE rac-node1
        ONLINE OFFLINE rac-node2
        ora.VOTE.dg
        ONLINE OFFLINE rac-node1
        ONLINE OFFLINE rac-node2
        ora.asm
        ONLINE ONLINE rac-node1 Startup Initiated
        ONLINE ONLINE rac-node2 Started
        ora.eons
        ONLINE OFFLINE rac-node1
        ONLINE ONLINE rac-node2
        ora.gsd
        OFFLINE OFFLINE rac-node1
        OFFLINE OFFLINE rac-node2
        ora.net1.network
        ONLINE ONLINE rac-node1
        ONLINE ONLINE rac-node2
        ora.ons
        ONLINE ONLINE rac-node1
        ONLINE ONLINE rac-node2
        ora.registry.acfs
        ONLINE ONLINE rac-node1
        ONLINE ONLINE rac-node2
        --------------------------------------------------------------------------------
        Cluster Resources
        --------------------------------------------------------------------------------
        ora.LISTENER_SCAN1.lsnr
        1 ONLINE ONLINE rac-node2
        ora.finance.db
        1 ONLINE OFFLINE
        2 ONLINE OFFLINE
        ora.oc4j
        1 OFFLINE OFFLINE
        ora.rac-node1.vip
        1 ONLINE ONLINE rac-node1
        ora.rac-node2.vip
        1 ONLINE ONLINE rac-node2
        ora.scan1.vip
        1 ONLINE ONLINE rac-node2
        • 16. Re: Manual creation of Oracle RAC Database
          Levi Pereira
          Q: Manual creation of Oracle RAC Database
          Anwser:
          P. Forstmann wrote:
          To create manually a RAC database is not recommended if you are new to RAC: I would recommend to drop your existing database and recreate it from scratch with DBCA because DBCA will do all the work for RAC by default (especially creating cluster resource which are maybe not OK in your case).
          • 17. Re: Manual creation of Oracle RAC Database
            vasuoracledba
            [10:47 AM root@RAC-NODE1.vod.com grid_home]# /grid1/app/11.2.0/grid_home/bin/crsctl stat res -t
            --------------------------------------------------------------------------------
            NAME TARGET STATE SERVER STATE_DETAILS
            --------------------------------------------------------------------------------
            Local Resources
            --------------------------------------------------------------------------------
            ora.ARCLOG.dg
            ONLINE OFFLINE rac-node1
            ONLINE OFFLINE rac-node2
            ora.CTRL.dg
            ONLINE OFFLINE rac-node1
            ONLINE OFFLINE rac-node2
            ora.DBFILE.dg
            ONLINE OFFLINE rac-node1
            ONLINE OFFLINE rac-node2
            ora.FRA.dg
            ONLINE OFFLINE rac-node1
            ONLINE OFFLINE rac-node2
            ora.REDO1.dg
            ONLINE OFFLINE rac-node1
            ONLINE OFFLINE rac-node2
            ora.REDO2.dg
            ONLINE OFFLINE rac-node1
            ONLINE OFFLINE rac-node2
            ora.VOTE.dg
            ONLINE OFFLINE rac-node1
            ONLINE OFFLINE rac-node2
            ora.asm
            ONLINE ONLINE rac-node1 Startup Initiated
            ONLINE ONLINE rac-node2 Started
            ora.eons
            ONLINE OFFLINE rac-node1
            ONLINE ONLINE rac-node2
            ora.gsd
            OFFLINE OFFLINE rac-node1
            OFFLINE OFFLINE rac-node2
            ora.net1.network
            ONLINE ONLINE rac-node1
            ONLINE ONLINE rac-node2
            ora.ons
            ONLINE ONLINE rac-node1
            ONLINE ONLINE rac-node2
            ora.registry.acfs
            ONLINE ONLINE rac-node1
            ONLINE ONLINE rac-node2
            --------------------------------------------------------------------------------
            Cluster Resources
            --------------------------------------------------------------------------------
            ora.LISTENER_SCAN1.lsnr
            1 ONLINE ONLINE rac-node2
            ora.finance.db
            1 ONLINE OFFLINE
            2 ONLINE OFFLINE
            ora.oc4j
            1 OFFLINE OFFLINE
            ora.rac-node1.vip
            1 ONLINE ONLINE rac-node1
            ora.rac-node2.vip
            1 ONLINE ONLINE rac-node2
            ora.scan1.vip
            1 ONLINE ONLINE rac-node2
            1 2 Previous Next