ORA-604 and ORA-942 on startup 
Author Message
 ORA-604 and ORA-942 on startup

Have you contacted Oracle Support? They may have a fix already for the


> 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.

> France

                                        Rick Wessman
                                        Security and Directory Technologies
                                        Server Technologies
                                        Oracle Corporation

       The statements and opinions expressed here are my own and do not
             necessarily represent those of  Oracle Corporation.

Wed, 18 Jun 1902 08:00:00 GMT
 ORA-604 and ORA-942 on startup

Yes, they first told me to do a shutdown immediate and a new startup after !
But I told them it happened during nightly execution.

After they told me to patch in That's what i'm going to do, but i'm
afraid if the problem occurs again, they will tell me to go to version 8 !

Thanks for your answer.

Wed, 18 Jun 1902 08:00:00 GMT
 [ 2 post ] 

 Relevant Pages 

1. ORA-604 and ORA-942 on startup

2. Can load Forms 3.0, getting ORA 942.

3. ora-942, why?

4. Error ORA-604/1000

5. Help please! ORA-604 Max Cursors Exceeded problem

6. tnsnames.ora, sqlnet.ora, listner.ora

7. Create new DB errors (ORA-01610, ORA-01194, ORA-01110)

8. Error: ORA-01034, ORA-09243, ORA-02042

9. Corrupted ORA-00604, ORA-01578, ORA-01110

10. ORA-00604, ORA-01578, ORA-01110

11. ORA-01115,ORA-01110,ORA-27070,OSD-04006,O/S-Error OS 38

Powered by phpBB® Forum Software