Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Why Error-04063 in Queue Table QS.WS_ORDERS_SQTAB?

Re: Why Error-04063 in Queue Table QS.WS_ORDERS_SQTAB?

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Tue, 17 May 2005 16:28:56 +0200
Message-ID: <d6cuqt$l97$2@news2.zwoll1.ov.home.nl>


basis_consultant_at_hotmail.com wrote:
> Hi,
>
> We installed a standard 9.2.0.6 database on Windows 2000. It
> was a standard installation, with the possible exception that
> the demo tables were installed.
>
> However, when we tried exporting some schemas yesterday, the
> export terminated on the following error;
>
> Error 4063 in queue table QS.QS_ORDERS_SQTAB
> followed by ORA-00447, ORA-00604, etc...
>
> After searching on metalink for awhile, we solved the
> problem by running 'catpatch.sql'.
>
> However, I am not sure why the problem occured in the
> first place; We did not use the demo databases, advanced
> queueing, etc.. After all, I have previously installed many
> 8i and 9i databases without running into this issue.
>
> I do not remember 'catpatch.sql' being one of the standard
> scripts executed after a database is created, although I
> suppose that it should be.
>
> When would one execute 'catpatch.sql'? When does this ORA-04063
> issue occur?
>
>
> Thanks,
> BASIS Consultant
>

9.2.0.6 is *not* a standard install by any means, it's a patched base line install.
How did you get it to be 9.2.0.6?!?

-- 
Regards,
Frank van Bortel
Received on Tue May 17 2005 - 09:28:56 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US