Running SVRMGR23 from Visual Basic

I am running Oracle's SVRMGR23.EXE from Visual Basic to shutdown the database prior to backup. Unfortunately, sometimes the SVRMGR23 window does not close after the instance is shutdown.

I use the CreateProcess() API to call SVRMGR23 as follows

iResult = CreateProcess(vbNullString, "svrmgr23.exe @" & psScriptFile, .......

the script that SVRMGR23 runs is:

connect internal/manager
shutdown immediate
exit

If the SVRMGR23 program hangs after the database is shutdown, nothing can be typed in the window, but it can be manually closed. After the program is closed, the Visual Basic program continues and starts the backup.

Anyone have an Ideal on my the SVRMGR23 window does not close after the script is finished?

Thanks,

Brian Grosheim Received on Thu Jun 11 1998 - 11:01:36 CDT