Re: ORA-604 and ORA-942 on startup

I have had a similar problem.

I did a shutdown and startup in the same script.

I resolved the problem by splitting the procedure into two script. One for the shutdown, and another for the startup.

Hope this helps.
Gert

PS You can use the 734 server with forms 3.x .

        If you don't know how , ask me ( gert.deneve_at_advalvas.be )

sylvain.vambacas <sylvain.vambacas_at_wanadoo.fr> wrote in message news:7u9a5n$73p$1_at_wanadoo.fr...
> Hello,
>
> We work on two releases : 7.2.3 (because of forms v3) and 7.3.4.
>
> Sometimes, once a month, one of our databases doesn't correctly start
whith
> the two errors in the alert.log.
>
> The database is mounted but when there is an alter database open; then the
> two errors occurs. This happens during a nightly execution after backups
!.
> The message in the log of our jobs is initialization or shutdown in
progress
> !. The morning we just have to do an immediate shutdown and an alter
> database open, then it works !!!
>
> Is this a problem of memory or sga ?
>
> Has everyone pieces of information about this ?
>
> Thanks for your help.
>
> S. VAMBACAS
> TOTALGAZ
> France
>
>
>
>
Received on Sat Oct 16 1999 - 14:30:24 CDT