This discussion is archived
2 Replies Latest reply: Nov 14, 2012 10:40 AM by user489552 RSS

how to check database is created in 2 node RAC database

user489552 Newbie
Currently Being Moderated
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

Legend

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