unable to start oracle database

[George_Dodds]

Scenario

ito using oracle database in a service gaurd cluster.

I am unable to start ito as there seems to be a problem starting oracle.

In the package log it says that it could not connect to the database ov_net.

Allthough earlier in the log it shows that it goes into svrmgr and starts the database.

The only other major error is that 1 of the dbf file needs a media recovery, I know about this bit and ito has started before with this error.

Help! I know nowt about oracle

Cheers

George

[Helen French]

Hi George,

Not sure about your error, but check this out, it may help you:

http://us-support.external.hp.com/cki/bin/doc.pl/sid=09a1e00a0e3892379c/screen=ckiDisplayDocument?docId=200000042773768

HTH,
Shiju

[Carlos Fernandez Riera]

You should contact a DBA.

Eve so,

see you package script to know how to start oracle.

Search srvmgr and before the startup intruction

do:

startup mount
recover database;

If it say database recovered
you can do

alter database open.


But, once more, You should contact a DBA.

[George_Dodds]

DBA whats one of those then? :)

We dont have a dba, or many other necessities for that matter.
Just fun trying to figure things out when they go bang!

Did find the following post which shed a bit more light, but not much.

http://forums.itrc.hp.com/cm/QuestionAnswer/1,,0x6084b47b9a27d6118ff40090279cd0f9,00.html

I can manually start oracle allthough it's complains about the dbf file, then start the listener.

Then i run opc but still receive - cant connect to database ov_net.

tnsping ov_net from oracle responds ok.

[George_Dodds]

wrong link, it's been a long day!

http://bizforums.itrc.hp.com/cm/QuestionAnswer/0,,0x8d53a22831ebd5118ff40090279cd0f9,00.html

[Helen French]

Hi George,

Check these links too:

http://us-support2.external.hp.com/cki/bin/doc.pl/sid=fbd1f066015b2227b2/screen=ckiDisplayDocument?docId=200000043976442

http://us-support2.external.hp.com/cki/bin/doc.pl/sid=fbd1f066015b2227b2/screen=ckiDisplayDocument?docId=200000051956359

btw, the thread which you posted now is the same one which u listed above !

HTH,
Shiju

[George_Dodds]

Siju the link below that one is the link i meant to paste in, i was having a daft half hour!