Re: ORA-03113 while exec DBMS_AQADM.CREATE_QUEUE_TABLE

Hello,

I have had the same problem. It seems to happen when you apply a server patch and do not run afterwards the $ORACLE_HOME/rdbms/admin/catpatch.sql on the DB instances e.g.:

I had the following installing sequence:

1-. Oracle server.          (succ)
2-. Patchset 9.2.0.4.       (succ)
3-. Create the DB instance  (succ)
4-. Install Oracle Workflow (failed with

    the same error as you have now, some     required queues were not being created)

I the ran $ORACLE_HOME/rdbms/admin/catpatch.sql and then WFL installed successfully.

HTH, Best Regards,
Giovanni

"Vadim Grepan" <_RMV_IT_kezal_at_mail.ru> wrote in message news:bujb12$fl9$1_at_n6.co.ru...
> Hello All!
>
> There is problem with creating queue tables, Oracle 9.2.0.4 (Win32)
> Is anybode overcome this very painful error? Metalink doesn't keep any
> useful info :(
>
> Alert.log doesn't keep anything useful..
>
> === cut ===
> CREATE TYPE TMP_MESSAGE_T AS OBJECT
> (OPERATION VARCHAR2(1),
> TEXT VARCHAR2(2000));
> /
>
> BEGIN
> DBMS_AQADM.CREATE_QUEUE_TABLE(
> QUEUE_TABLE => 'QT_1',
> MULTIPLE_CONSUMERS => TRUE,
> AUTO_COMMIT => TRUE,
> QUEUE_PAYLOAD_TYPE => 'TMP_MESSAGE_T');
> END;
> /
>
> ERROR at line 1:
> ORA-03113: end-of-file on communication channel
> === cut ===
>
> Rgds, Vadim
> --
> Moscow, Russia
>
Received on Tue Jan 20 2004 - 07:47:45 CST