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

Did you upload your tracefile to oracle support ? You didn't hit the 942 on any aq$ table ...

Stefan

On Tue, Dec 23, 2008 at 2:52 PM, dba1 mcc <mccdba1_at_yahoo.com> wrote:

> I got answer from ORACLE support and it is sort of bug. This error message
> can be ignore:
>
> =========================================================
> UPDATE
> ======
> Hello
>
> 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