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, 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 dg2dg1: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 testracRemove the database testrac? (y/[n]) y
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 dg2dg1:oracle:testrac1:/home/oracle>srvctl add database -d testrac -o $ORACLE_HOME
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 OFFLINEdg1:oracle:testrac1:/home/oracle>srvctl start service -d testrac -s test_fan
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 dg2dg1: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