Testing the use of Message Broker to the database and then
to an object in another database via a database link. They received an
ORA-24777 error. Metalink reveals this note:
Error "ORA-24777: Use Of Non-Migratable
Database Link Not Allowed" Using Oracle XA Datasource When Executing a
Select via Database Link. [ID 879543.1]
Which recommends configuring shared servers for
network connections. To test this, I made the following changes in the spfile
for database db1:
ALTER SYSTEM SET shared_servers=5
SCOPE=BOTH SID='*';
ALTER SYSTEM SET dispatchers='(PROTOCOL=TCP)'
SCOPE=BOTH SID='*';
The listener now shows a shared server listener available
for db1:
oracle@tiger >
lsnrctl services
LSNRCTL for Linux: Version
11.2.0.2.0 - Production on 11-OCT-2011 15:13:31
Copyright (c) 1991, 2010,
Oracle. All rights reserved.
Connecting to
(ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
Services Summary...
..snipped..
Service "db1"
has 1 instance(s).
Instance "db1",
status READY, has 2 handler(s) for this service...
Handler(s):
"D000"
established:592 refused:0 current:9 max:1022 state:ready
DISPATCHER
(ADDRESS=(PROTOCOL=tcp)(HOST=tiger)(PORT=23033))
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
developed a small test using Message Broker
connecting to db1 and referencing an object in db2 via a database link. It
worked. They did not get the ORA-24777 error and they did get the expected
results.
Hope this help. Regards Rupam
