Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> dblink / global names explanation please

dblink / global names explanation please

From: Shaw John-P55297 <john.shaw_at_motorola.com>
Date: Sat, 29 Jun 2002 10:03:20 -0800
Message-ID: <F001.0048C1D5.20020629100320@fatcity.com>


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-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 Sat Jun 29 2002 - 13:03:20 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US