> Hello Alan,
>
> Thanks for your reply.
>
> Alan wrote:
>
> >I don't see why this is an error. You are blocked from dropping
> the db if you are connected elsewhere.
> >The first connection is SYSDBA so it is not going to get booted off.
> >
> >
> But the connection in ISQL is lost at the time I shutdown the database
> in the second command prompt. I thought this is what the force option of
> gfix is all about? It seems I am wrong. How would you make sure that a
> backup is created after every connection has been closed/killed and
> no-one can connect any more, Alan?
>
> Salut,
> Mathias

your previous message didn't say the first SYSDBA connection was lost. It shouldn't be. Only non-SYSDBA, users will be prevented from re-connect. And they will also be disconnected afte rthe timeout. Their open transactions will be rolled back.

For this procedure to work as you expect, make the first connection a non SYSDBA connection

Alan