Re: Strange problem 7.3.4 / NT4 SP3

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Fri, 25 Jun 1999 15:24:34 -0700
Message-ID: <377401A2.4121C000@exesolutions.com>

> 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.

Welcome to Windows NT. You could, of course, change to a real operating system but I suspect that's not possible.

Have your backup script check to see if the databases is shut down. If not, have it wait some number of minutes, check again, and if necessary execute a shutdown immeidate.

If the problem is caused by users still being connected you might want to write a profile so that all connections are broken after some amount of inactivity.

Daniel A. Morgan Received on Fri Jun 25 1999 - 17:24:34 CDT