Re: ORA-03113 while exec DBMS_AQADM.CREATE_QUEUE_TABLE

Hello Giovanni!

You are right. Thanks!

Giovanni Azua wrote:

> 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

Rgds, Vadim

--
Moscow, Russia