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@xxxxxxxxx> 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@xxxxxxxxx> wrote: > > > From: Stefan Knecht <knecht.stefan@xxxxxxxxx> > > Subject: Re: Create database on 11.0.1.7 have ORA-00942 message??? > > To: mccdba1@xxxxxxxxx > > Cc: "oracle-l" <oracle-l@xxxxxxxxxxxxx> > > 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@xxxxxxxxx> 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@xxxxxxxxx> wrote: > > > > > > > From: Stefan Knecht > > <knecht.stefan@xxxxxxxxx> > > > > Subject: Re: Create database on 11.0.1.7 have > > ORA-00942 message??? > > > > To: mccdba1@xxxxxxxxx > > > > Cc: "oracle-l" > > <oracle-l@xxxxxxxxxxxxx> > > > > 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@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 > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >