Re: Strange problem OE 7.3.4 with NT4 SP3

> I've got a strange problem.
> Oracle Enterprise Edition 7.3.4 on a Compaq ProLiant 1500 NT4 SP3.
> Sometimes when I shut down the Oracle service, the DB hangs in a undefined
> mode. The service shuts faster than the DB.
>
> Sometimes it works fine; first Oracle then the service...
> We use this to do cold backups at night.The stop service command is issued
> by the ADSM preschedule procedure command. ADSM works fine. After the backup
> ADSM issues the start service command. Because the shutdown hasn't
> completed, the start command doesn't work. I don't always want to start
> using the startup force command. It's like using a hammer... ;)

I too have had this and have never found a good solution. Sometimes it is users that didn't log off and left a cartesian join running. It is always good to make sure that no-one can stay logged on indefinitely. But this is not always the cause.

What I would suggest is that you issue your normal shudown. Wait some reasonable period of time and then issue a shutdown immediate. Then wait a reasonable amount of time and issue a shutdown abort just before beginning the backup processes.

With any luck at all the shutdown immediate and shutdown abort will serve no useful purpose. But when they are needed they will do the job.

Now whether you want to deal with any possible problems in the morning is another question.

Daniel A. Morgan Received on Mon Jul 05 1999 - 23:41:59 CEST