2 Replies Latest reply: Nov 14, 2012 12:40 PM by User489552 RSS

    how to check database is created in 2 node RAC database

    User489552
      Hi All,

      Please allow questions maybe too obvious. I am not familiar with RAC and ASM.
      virtual box on (window 7)

      2 nodes built on Linux 6.1 64bit virtual machine.
      11.2.0.3 grid & database software.
      DB Unique name is demo
      node1 (demo1)
      node2 (demo2)


      1. I have installed Grid 11.2.0.3 software and configured ASM with it. The installation seems succeed.

      I am able to use view status using crsctl (please see log)

      2. I installed the database software and want to create a default database(demo). the software go through 95% but the dbca is not able to completed.

      I can see the asm_pmon is running, but not able to see the demo db process. I think at this point, I don't have my database demo created yet.

      So, question
      1: Is the database created?
      2. I attemp to use dbca to create my demo db, but at creation step "Copying database files" - it complaint ORA-03114: not connected to ORACLE
      ???? what??? which oracle server does it try to connect?
      3. If the database is created, how to startup the database, especially it has 2 instances (demo1 and demo2)?

      Please advise!

      Thanks much!




      [grid@demo1 ~]$ crsctl stat res -t
      --------------------------------------------------------------------------------
      NAME TARGET STATE SERVER STATE_DETAILS
      --------------------------------------------------------------------------------
      Local Resources
      --------------------------------------------------------------------------------
      ora.DATA.dg
      ONLINE ONLINE demo1
      ONLINE ONLINE demo2
      ora.LISTENER.lsnr
      ONLINE ONLINE demo1
      ONLINE ONLINE demo2
      ora.asm
      ONLINE ONLINE demo1 Started
      ONLINE ONLINE demo2 Started
      ora.gsd
      OFFLINE OFFLINE demo1
      OFFLINE OFFLINE demo2
      ora.net1.network
      ONLINE ONLINE demo1
      ONLINE ONLINE demo2
      ora.ons
      ONLINE ONLINE demo1
      ONLINE ONLINE demo2
      --------------------------------------------------------------------------------
      Cluster Resources
      --------------------------------------------------------------------------------
      ora.LISTENER_SCAN1.lsnr
      1 ONLINE ONLINE demo1
      ora.demo1.vip
      1 ONLINE ONLINE demo1
      ora.demo2.vip
      1 ONLINE ONLINE demo2
      ora.cvu
      1 ONLINE ONLINE demo1
      ora.oc4j
      1 ONLINE ONLINE demo1
      ora.scan1.vip
      1 ONLINE ONLINE demo1

      Edited by: 969880 on Nov 13, 2012 2:18 PM