Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help: database can not be see from DBCA
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 Received on Wed Oct 31 2007 - 10:37:35 CDT