Re: Create database on 11.0.1.7 have ORA-00942 message???

  • From: "Stefan Knecht" <knecht.stefan@xxxxxxxxx>
  • To: mccdba1@xxxxxxxxx
  • Date: Fri, 19 Dec 2008 16:11:01 +0100

If you want to find out, set event='942 trace name errorstack level 1' in
your parameter file, and create a database.

As soon as the error is hit, you will find a tracefile in
diag/rdbms/db_unique_name/SID/trace showing you the failing SQL statement.

Regards

Stefan

On Fri, Dec 19, 2008 at 3:56 PM, dba1 mcc <mccdba1@xxxxxxxxx> wrote:

> We hace DELL server with Redhat 5.2 X86 installed on it.  I tried to
> created database on ORACLE 11.1.0.7 and have message ORA-00942 in alert.log
> file.  Database look good without problem.  This messages also happen on 64
> bits ORACLE 11.1.0.7.  Does anyine know what it is?
>
>
> ORA-00942: table or view does not exist
> Starting background process QMNC
> Thu Dec 18 14:19:54 2008
> QMNC started with pid=19, OS id=18846
> Error 604 in kwqmnpartition(), aborting txn
> Completed: create database
>
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>

Other related posts: