Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Help: database can not be see from DBCA

Re: Help: database can not be see from DBCA

From: Steve Howard <stevedhoward_at_gmail.com>
Date: Wed, 31 Oct 2007 14:09:10 -0000
Message-ID: <1193839750.647688.122270@y42g2000hsy.googlegroups.com>


On Oct 31, 8:45 am, emdproduct..._at_hotmail.com wrote:
> > If you have a reproducible test case ( sorry kind of confused here
> > since you posted something similar a couple of weeks ago ) that fails
> > with current maintenance levels ( 10.2.0.3 for example or 9.2.0.8 )
> > then you should probably file a service request with oracle.
>
> > They can work at getting a bug filed as well as getting a documented
> > workaround. That way the information can be made available to other
> > people.
>
> Thanks for the advice.
>
> We have not bought the RAC license yet, the budget has not been
> approved yet, so I can not open a TAR. It is something I will do as
> soon as I got CSI# if I can not get this solved here.
>
> It may not be a bug, maybe it is just one more command that needs to
> be run after we run
> "$srvctl add database -d dbnam -o OH_HOME"
>
> It should be something like
> $dbca -silent -adddb dbname(but only the the registry,not create the
> database)
>
> I just can not figure it out.

Helma,

I just tested it on a throwaway test cluster we have, and it worked for me. Below is the screen printout...

dg1:oracle:testrac1:/home/oracle>crsstat

HA Resource                                   Target     State
-----------                                   ------     -----
ora.dg1.ASM1.asm                              ONLINE     ONLINE on dg1
ora.dg1.LISTENER_DG1.lsnr                     ONLINE     ONLINE on dg1
ora.dg1.gsd                                   ONLINE     ONLINE on dg1
ora.dg1.ons                                   ONLINE     ONLINE on dg1
ora.dg1.vip                                   ONLINE     ONLINE on dg1
ora.dg2.ASM2.asm                              ONLINE     ONLINE on dg2
ora.dg2.LISTENER_DG2.lsnr                     ONLINE     ONLINE on dg2
ora.dg2.gsd                                   ONLINE     ONLINE on dg2
ora.dg2.ons                                   ONLINE     ONLINE on dg2
ora.dg2.vip                                   ONLINE     ONLINE on dg2
ora.testrac.db                                ONLINE     ONLINE on dg1
ora.testrac.testrac1.inst                     ONLINE     ONLINE on dg1
ora.testrac.testrac2.inst                     ONLINE     ONLINE on dg2
ora.testrac.test_fan.cs                       ONLINE     ONLINE on dg2
ora.testrac.test_fan.testrac1.srv             ONLINE     ONLINE on dg1
ora.testrac.test_fan.testrac2.srv             ONLINE     ONLINE on dg2
dg1:oracle:testrac1:/home/oracle>srvctl remove database -d testrac Remove the database testrac? (y/[n]) y
PRKP-1022 : The database testrac is still running.
dg1:oracle:testrac1:/home/oracle>srvctl stop database -d testrac
dg1:oracle:testrac1:/home/oracle>srvctl remove database -d testrac
Remove the database testrac? (y/[n]) y
dg1:oracle:testrac1:/home/oracle>crsstat
HA Resource                                   Target     State
-----------                                   ------     -----
ora.dg1.ASM1.asm                              ONLINE     ONLINE on dg1
ora.dg1.LISTENER_DG1.lsnr                     ONLINE     ONLINE on dg1
ora.dg1.gsd                                   ONLINE     ONLINE on dg1
ora.dg1.ons                                   ONLINE     ONLINE on dg1
ora.dg1.vip                                   ONLINE     ONLINE on dg1
ora.dg2.ASM2.asm                              ONLINE     ONLINE on dg2
ora.dg2.LISTENER_DG2.lsnr                     ONLINE     ONLINE on dg2
ora.dg2.gsd                                   ONLINE     ONLINE on dg2
ora.dg2.ons                                   ONLINE     ONLINE on dg2
ora.dg2.vip                                   ONLINE     ONLINE on dg2
dg1:oracle:testrac1:/home/oracle>srvctl add database -d testrac -o $ORACLE_HOME
dg1:oracle:testrac1:/home/oracle>srvctl add instance -d testrac -i testrac1 -n dg1
dg1:oracle:testrac1:/home/oracle>srvctl add instance -d testrac -i testrac2 -n dg2
dg1:oracle:testrac1:/home/oracle>srvctl add service -d testrac -s test_fan -r testrac1,testrac2
dg1:oracle:testrac1:/home/oracle>crsstat
HA Resource                                   Target     State
-----------                                   ------     -----
ora.dg1.ASM1.asm                              ONLINE     ONLINE on dg1
ora.dg1.LISTENER_DG1.lsnr                     ONLINE     ONLINE on dg1
ora.dg1.gsd                                   ONLINE     ONLINE on dg1
ora.dg1.ons                                   ONLINE     ONLINE on dg1
ora.dg1.vip                                   ONLINE     ONLINE on dg1
ora.dg2.ASM2.asm                              ONLINE     ONLINE on dg2
ora.dg2.LISTENER_DG2.lsnr                     ONLINE     ONLINE on dg2
ora.dg2.gsd                                   ONLINE     ONLINE on dg2
ora.dg2.ons                                   ONLINE     ONLINE on dg2
ora.dg2.vip                                   ONLINE     ONLINE on dg2
ora.testrac.db                                OFFLINE    OFFLINE
ora.testrac.testrac1.inst                     OFFLINE    OFFLINE
ora.testrac.testrac2.inst                     OFFLINE    OFFLINE
ora.testrac.test_fan.cs                       OFFLINE    OFFLINE
ora.testrac.test_fan.testrac1.srv             OFFLINE    OFFLINE
ora.testrac.test_fan.testrac2.srv             OFFLINE    OFFLINE
dg1:oracle:testrac1:/home/oracle>srvctl start service -d testrac -s test_fan
dg1:oracle:testrac1:/home/oracle>crsstat
HA Resource                                   Target     State
-----------                                   ------     -----
ora.dg1.ASM1.asm                              ONLINE     ONLINE on dg1
ora.dg1.LISTENER_DG1.lsnr                     ONLINE     ONLINE on dg1
ora.dg1.gsd                                   ONLINE     ONLINE on dg1
ora.dg1.ons                                   ONLINE     ONLINE on dg1
ora.dg1.vip                                   ONLINE     ONLINE on dg1
ora.dg2.ASM2.asm                              ONLINE     ONLINE on dg2
ora.dg2.LISTENER_DG2.lsnr                     ONLINE     ONLINE on dg2
ora.dg2.gsd                                   ONLINE     ONLINE on dg2
ora.dg2.ons                                   ONLINE     ONLINE on dg2
ora.dg2.vip                                   ONLINE     ONLINE on dg2
ora.testrac.db                                ONLINE     ONLINE on dg1
ora.testrac.testrac1.inst                     ONLINE     ONLINE on dg1
ora.testrac.testrac2.inst                     ONLINE     ONLINE on dg2
ora.testrac.test_fan.cs                       ONLINE     ONLINE on dg1
ora.testrac.test_fan.testrac1.srv             ONLINE     ONLINE on dg1
ora.testrac.test_fan.testrac2.srv             ONLINE     ONLINE on dg2
dg1:oracle:testrac1:/home/oracle>dbca

No dbca output, you'll have to trust me :)

Are you on vmware?

HTH, Steve Received on Wed Oct 31 2007 - 09:09:10 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US