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 [EMAIL PROTECTED] 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).