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 15:45:50 -0000
Message-ID: <1193845550.757492.7380@d55g2000hsg.googlegroups.com>


On Oct 31, 11:37 am, emdproduct..._at_hotmail.com wrote:
> On Oct 31, 10:58 am, emdproduct..._at_hotmail.com wrote:
>
>
>
> > Steve,
>
> > Thanks very much for your help.
>
> > Yes, i am on VMWARE. As both our Hardware and Software will come in
> > next few month. I am just doing this to get ready.
>
> > What do you mean by "No dbca output, you'll have to trust me :)", did
> > you see the database testrac from your DBCA?
>
> > Thanks
>
> > I did not quite understand your testing.
>
> > > 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
>
> Steve,
> Just want to double check.
>
> What do you mean by "and it worked for me"?
>
> Did you mean you do not see the problem that I have, or did you mean
> you can reproduce my problem?
>
> I guess you meant by the 1st, but just want to double check.
>
> So you think VMware is the reason? Can not wait for the hardware to
> come and test it again
>
> Thanks

Yes, I could see the testrac database in dbca *after* removing it with srvctl and then adding it back in.

I'm not sure if vmware is the problem, but when you get a CSI and read Oracle's support position on it, you'll see it is sketchy at best. Received on Wed Oct 31 2007 - 10:45:50 CDT

Original text of this message

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