My db listener doesn't restart when my server boots up or is rebooted? Does anyone know what the problem could be?
I had a batch file set up as a scheduled task to do it for a while, but has mysteriously stopped working. Would really like to get the core problem sorted.
At the moment my db is off line. Not good!!
When I try to connect to the DB I get the error -
ORA-01034: Oracle Not available
ORA-27101: Shared memory realm does not exist
I also get an error when the server starts saying that a service failed to start and to check the event log. On inspection there are two - [list=1][*]The OracleOraHome81HTTPServer service terminated unexpectedly. It has done this 1 time(s). The following corrective action will be taken in 0 milliseconds: No action.[*]The OracleOraHome81HTTPServer service hung on starting[/list=1]
Dapi, Crickey! Your're a busy bee. Thanks for all the pointers will give them a go on Tue
Anandkl, Thanks for the suggestion will also try that out.
I managed to get the db back up recreating the service using oraDim and took a back up of the data. I then rebooted the server so see whether the problem was sorted sinc then I've been unable to get the db up again and the oraDim option doesn't work any more.
So will try your suggestions in earnest on Tue. No that I've got the data off as a last resort I'll blow the whole thing away and start again.