Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> dblink / global names explanation please
8.1.6 on NT
I have java installed and a java email package on instance A on a server.
One the same server on instance B with global names set to false I created a
public database link to instance A, then created a public synonym javamail
for my email routine at A. This worked. On a third instance ( C ) on this
same server with gobal names set to true (do you see where this is going) I
did the same thing as I had done on instance B - but I couldn't use a short
name - I had to use the full A.moto.com. Then I created a public synonym for
the javamail_at_A.moto.com. This kept returning an error - couldn't find class
com/moto/utils/mail - this is a home grown java class in the database A.
I could not find anything different between the two setups other than one
had global names set to false and the other had global names set to true
(after many hours of looking and head banging) - so I just tried setting
global names to false on instance C and bounced the database - went back and
created a new short named public database link and then created the public
synonym. It now worked ????? WHY ?? can any one tell why this works or
doesn't as the case may be?
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw John-P55297 INET: john.shaw_at_motorola.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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-LReceived on Sat Jun 29 2002 - 13:03:20 CDT
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
![]() |
![]() |