Re: dblink / global names explanation please

global_names enforcing db_links to be named service_name.domain. The workaround it to change it for your session: alter session set global_names=false.

Shaw John-P55297 wrote:
>
> 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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Suzy Vordos
  INET: lvordos_at_qwest.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).