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
-none-

-none-

2005-02-17       - By -not available-

Reply:     <<     261     262     263     264     265     266     267     268     269     270     >>  

If you do not specify the domain name in the link then Oracle attempts to
provide it. Redefine the link as database_name.domain to avoid problems
like this. Remember that in the old days Oracle defaulted the domain name
to world. Now that is not true any longer so you should always specify it.

HTH -- Mark D Powell --

-- --Original Message-- --
From: oracle-l-bounce@(protected)
[mailto:oracle-l-bounce@(protected)]On Behalf Of John Dunn
Sent: Thursday, February 17, 2005 8:33 AM
To: Oracle-L@(protected)
Cc: rjamya@(protected); ntilbury@(protected)
Subject: RE: Advanced queuing : dequeing from remote database


I have identified the error as :

connection description for remote database not found

The address being used in add_subscriber is
OPD4678.NEW_JOB_MESSAGE_QUEUE@(protected)

where VAN9 is my database link

but the entry on the queue seems to trying to use

OPD4678.NEW_JOB_MESSAGE_QUEUE@(protected)

Is this the problem?

Why is it trying to use VAN9.US.ORACLE.COM ???


The entry in tnsnames.ora is simply named VAN9.




From:    John Dunn [mailto:jdunn@(protected)]
Sent:   17 February 2005 10:46
To:    'Oracle-L@(protected) '
Subject:   Advanced queuing : dequeing from remote database

I am experimenting with advanced queueing in Oracle 9i and am able to
enqueue and dequeue messages within the same database.

However I would like to dequeue messages on a remote database via a database
link.

I am confused as to what I need to set up on the remote server in order to
dequeue the message.

I have set up the database link that points back to the enqueueing database,
The database link works OK.

I am then trying to dequeue the message on the remote database using the
following code(which is the same I use when doing this all on the same
database except for the references to the database link). I get the error :

message opd4678.new_job_message@(protected);
*
ERROR at line 6:
ORA-06550 (See ORA-06550.ora-code.com): line 6, column 34:
PLS-00331: illegal reference to OPD4678.NEW_JOB_MESSAGE@(protected)

Any ideas what I have done wrong?

John


-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---
-- ---- --


set serveroutput on

declare

dequeue_options dbms_aq.dequeue_options_t;
message_properties dbms_aq.message_properties_t;
message_handle RAW(16);
message opd4678.new_job_message@(protected);
--message opd4678.new_job_message;

BEGIN

dequeue_options.CONSUMER_NAME := NULL;
dequeue_options.DEQUEUE_MODE := DBMS_AQ.REMOVE;
dequeue_options.NAVIGATION := DBMS_AQ.NEXT_MESSAGE;
dequeue_options.VISIBILITY := DBMS_AQ.IMMEDIATE;
dequeue_options.WAIT := DBMS_AQ.FOREVER;
dequeue_options.MSGID := null;
dequeue_options.CORRELATION := 'TEST MESSAGE ';

DBMS_AQ.DEQUEUE (
queue_name = > 'opd4678.new_job_message_queue@(protected) ',
dequeue_options = > dequeue_options,
message_properties = > message_properties,
payload = > message,
msgid = > message_handle
);



dbms_output.put_line( '+-- ---- ---- ----+ ');
dbms_output.put_line( '| New Job | ');
dbms_output.put_line( '+-- ---- ---- ----+ ');
dbms_output.put_line( '- Message ID := ' || message.message_id);
dbms_output.put_line( '- Filename := ' || message.host_file_name);


COMMIT;

-- -- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --

END;
/



--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l