Links
• Home
• Oracle DBA Forum
Frequent Oracle Errors
•TNS:could not resolve the connect identifier specified
•Backtrace message unwound by exceptions
•invalid identifier
•PL/SQL compilation error
•internal error
•missing expression
•table or view does not exist
•end-of-file on communication channel
•TNS:listener unknown in connect descriptor
•insufficient privileges
•PL/SQL: numeric or value error string
•TNS:protocol adapter error
•ORACLE not available
•target host or object does not exist
•invalid number
•unable to allocate string bytes of shared memory
•resource busy and acquire with NOWAIT specified
•error occurred at recursive SQL level string
•ORACLE initialization or shutdown in progress
•archiver error. Connect internal only, until freed
•snapshot too old
•unable to extend temp segment by string in tablespace
•Credential retrieval failed
•missing or invalid option
•invalid username/password; logon denied
•unable to create INITIAL extent for segment
•out of process memory when trying to allocate string bytes
•shared memory realm does not exist
•cannot insert NULL
•TNS:unable to connect to destination
•remote database not found'>ora-02019
•exception encountered: core dump
•inconsistent datatypes
•no data found
•TNS:operation timed out
•PL/SQL: could not find program
•existing state of packages has been discarded
•maximum number of processes exceeded
•error signaled in parallel query server
•ORACLE instance terminated. Disconnection forced
•TNS:packet writer failure
•see ORA-12699
•missing right parenthesis
•name is already used by an existing object
•cannot identify/lock data file
•invalid file operation
•quoted string not properly terminated
Advanced queuing : dequeing from remote database

Advanced queuing : dequeing from remote database

2005-02-17       - By Sami Seerangan

Reply:     1     2     3     4     5     6     7     8     9     10  

Hi Nick,

As you suggested I tried creating queue based on table that is sitting
on remote db, but I got the error saying that "ORA-24002 (See ORA-24002.ora-code.com): QUEUE_TABLE
USSSD429.OBJMSGS80_QTAB@(protected) does not exist"

-- ---- ---- ---- ---- ---- ---- ---
SQL> EXECUTE DBMS_AQADM.CREATE_QUEUE (queue_name         =>
'msg_queue',queue_table        => 'usssd429.objmsgs80_qtab@(protected)');
BEGIN DBMS_AQADM.CREATE_QUEUE (queue_name         =>
'msg_queue',queue_table        => 'usssd429.objmsgs80_qtab@(protected)');
END;

*
ERROR at line 1:
ORA-24002 (See ORA-24002.ora-code.com): QUEUE_TABLE USSSD429.OBJMSGS80_QTAB@(protected) does not exist
ORA-06512 (See ORA-06512.ora-code.com): at "SYS.DBMS_AQADM_SYS", line 2555
ORA-06512 (See ORA-06512.ora-code.com): at "SYS.DBMS_AQADM", line 119
ORA-06512 (See ORA-06512.ora-code.com): at line 1


SQL> desc USSSD429.OBJMSGS80_QTAB@(protected)
Name                                      Null?    Type
-- ---- ---- ---- ---- ---- ---- ---- --- -- ----- -- ---- ---- ---- ---- -----
Q_NAME                                             VARCHAR2(30)
MSGID                                     NOT NULL RAW(16)
CORRID                                             VARCHAR2(128)
PRIORITY                                           NUMBER
STATE                                              NUMBER
DELAY                                              DATE
EXPIRATION                                         NUMBER
TIME_MANAGER_INFO                                  DATE
LOCAL_ORDER_NO                                     NUMBER
CHAIN_NO                                           NUMBER
CSCN                                               NUMBER
DSCN                                               NUMBER
ENQ_TIME                                           DATE
ENQ_UID                                            NUMBER
ENQ_TID                                            VARCHAR2(30)
DEQ_TIME                                           DATE
DEQ_UID                                            NUMBER
DEQ_TID                                            VARCHAR2(30)
RETRY_COUNT                                        NUMBER
EXCEPTION_QSCHEMA                                  VARCHAR2(30)
EXCEPTION_QUEUE                                    VARCHAR2(30)
STEP_NO                                            NUMBER
RECIPIENT_KEY                                      NUMBER
DEQUEUE_MSGID                                      RAW(16)
SENDER_NAME                                        VARCHAR2(30)
SENDER_ADDRESS                                     VARCHAR2(1024)
SENDER_PROTOCOL                                    NUMBER
USER_DATA                                          MESSAGE_TYP

SQL> EXECUTE DBMS_AQADM.CREATE_QUEUE (queue_name         =>
'msg_queue',queue_table        => 'usssd429.objmsgs80_qtab');

PL/SQL procedure successfully completed.


SQL> create synonym objmsgs80_qtab_r for usssd429.objmsgs80_qtab@(protected);
Synonym created.


On Thu, 17 Feb 2005 11:14:41 -0000, Nick Tilbury @ Northampton
<ntilbury@(protected)> wrote:
> I would suggest you have the enqueue populate to the remote database queue =
> and deal with it locally.
>
> Nick
--
http://www.freelists.org/webpage/oracle-l