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

I got answer from ORACLE support and it is sort of bug. This error message can be ignore:

From <bug:7349612> the error ORA-00604 and ORA-00942 is because the tables sys.aq$_sche dules and sys.aq$_queue_table_affinities tables are not loaded during database c reating time.

You can ignore this error since the fix for <bug:7349612> (in 11gR2) would supress these errors and would not write to the alert.log since it is expected in certain cases in the Oracle Source Code and and it not a bug.

• On Mon, 12/22/08, Stefan Knecht <knecht.stefan_at_gmail.com> wrote:

> From: Stefan Knecht <knecht.stefan_at_gmail.com>
> Subject: Re: Create database on 11.0.1.7 have ORA-00942 message???
> To: mccdba1_at_yahoo.com
> Cc: "oracle-l" <oracle-l_at_freelists.org>
> Date: Monday, December 22, 2008, 1:20 PM
> Interesting ... This is part of Oracle Flashback archive
> (Total Recall). It
> is definitely safe to ignore.
>
> Cheers
>
> Stefan
>
>
>
> On Mon, Dec 22, 2008 at 5:22 PM, dba1 mcc
> <mccdba1_at_yahoo.com> wrote:
>
> > Thank you for help.
> >
> > I set trace for ORA-00942 and trace file show:
> >
> > ----- Error Stack Dump -----
> > ----- Current SQL Statement for this session
> (sql_id=9smyv3uv3zvxm) -----
> > select ROWID from SYS_MFBA_STAGE_RID where ROWNUM = 1
> >
> >
> > any ideal???
> >
> >
> > --- On Fri, 12/19/08, Stefan Knecht
> <knecht.stefan_at_gmail.com> wrote:
> >
> > > From: Stefan Knecht
> <knecht.stefan_at_gmail.com>
> > > Subject: Re: Create database on 11.0.1.7 have
> ORA-00942 message???
> > > To: mccdba1_at_yahoo.com
> > > Cc: "oracle-l"
> <oracle-l_at_freelists.org>
> > > Date: Friday, December 19, 2008, 10:11 AM
> > > 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_at_yahoo.com> 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
> > > >
> > > >
> > > >
> > > > --
> > > > http://www.freelists.org/webpage/oracle-l
> > > >
> > > >
> > > >
> >
> >
> >
> >
      

--
http://www.freelists.org/webpage/oracle-l