Re: Help: database can not be see from DBCA

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
Received on Wed Oct 31 2007 - 09:58:54 CDT