Re: Shutdown Immediate hangs process

Yes, the shutdown immediate in some cases does not closed the database. I have the same problem on 7.3.3 on Windows NT.

I do a shutdown abort.
And after NET STOP OracleServiceSID and all others Oracle services. It seems to be OK... (I hope)

Another solution :
you run a script which kill all the sessions (except the kernel session) : ALTER SYSTEM KILL SESSION 'xx, yy';
And after you shutdown immediate the database.

Email me that you do, and if the solution runs or not.

TAKE CARE : Do an export full to do a logical backup of the database. 2 backups are better than 1.

davidm_at_s-scape.ca a écrit:

> Oracle 8.0.4 on Windows NT 4 sp3.
>
> Inorder to do a complete backup, I use the shutdown immediate command
> nightly. Every two weeks or so it screws up. The Oracle process is still
> running but didn't shutdown properly. It's left if a state where I can't
> stop it from NT services nor can I connect to the database to issue it any
> stop or start commands. The end result is that I have to kill the process
> from the task manager. Prior to killing it, the oracle process is totally
> dorment. I talked to Oracle support, they where not helpful in providing any
> solutions. They basically said I should upgrade to 8.0.5. I'm not going to
> do that until they have a fix for the 4G file problem on NT.
>
> Any ideas?
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Thu Jan 28 1999 - 15:44:29 CST