This discussion is archived
1 2 Previous Next 17 Replies Latest reply: Apr 24, 2013 10:21 PM by vasuoracledba Go to original post RSS
  • 15. Re: Manual creation of Oracle RAC Database
    vasuoracledba Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    [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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points