Re: forcing personal oracle 7 shutdown (re-post)

From: <chiappa_at_my-deja.com>
Date: Fri, 12 Jan 2001 17:08:51 GMT
Message-ID: <93ndmp$lim$1@nnrp1.deja.com>

No, no : to shutdown the database the right executable to use is svrmgr23.exe, conecting with the internal user. You can write a shellscript (i.e., a .BAT file), called from your app, doing something like :

svrmgr23
connect internal
shutdown immediate
exit

To more info, check the Oracle docs, mainly the Oracle Concepts

Bye.

Chiappa

In article <93mear$4vk$1_at_fe2.cs.interbusiness.it>, "ilkaos" <ilkaos_at_trae.no> wrote:
> I have a VB5 project that access a PO7 db with Oracle Objects for
Ole. I
> want to shutdown the PO7 db at the end of the project , and I do this
with
> the Ostop73.exe command. The proble is that I receive a message that
there
> are active connections. I really tried EVERYTHING with my code to
close and
> set to nothing every single reference to any oracle session, object ,
> database or whatever related to Oracle before running the ostop73
command
> but it does not work. So I am looking for a way to force the shutdown
in a
> way that the user does not to receive the "open session" advise.
> Does anyobody know what to do?
> Thanks in advance.
>
>

Sent via Deja.com
http://www.deja.com/ Received on Fri Jan 12 2001 - 11:08:51 CST