Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Streams Demo Error
Hi All,
I am trying to setup/explore Streams (En-queue/De-queue) in Windows OS using Oracle Ver 9.2.0.4
The example used given below
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96571/messagedemo.htm#133
But I am getting "ORA-03113: end-of-file on communication channel" error. No error message listed in alertlog or trace file.
Searched metalink but no luck.
SQL> CONNECT strmadmin/strmadminpw_at_devdb
Connected.
SQL> BEGIN
2 DBMS_STREAMS_ADM.SET_UP_QUEUE(queue_table => 'oe_queue_table',queue_name => 'oe_queue');
3 END;
4 /
BEGIN
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
SQL> Any help would be really appreciated.
Thanks
Jay
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: jaysingh1_at_optonline.net
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Sun Jan 11 2004 - 19:14:26 CST
![]() |
![]() |