RE: HELP! - SQL*NET from 8.1.6 to 7.3.4

select * from global_name

I'll bet that it returns 'KMINSTL1.WORLD'. After you rename a database you also need to:

update global_name set global_name='NEW NAME';

EG:

update global_name set global_name='FINQUAL1.KMG.COM';

Even if you have global_name=true, it's still a good idea to update this. (good house cleaning)

HTH
Shawn M Ferris
Oracle DBA - Time Warner Telecom

> -----Original Message-----
> From: Smith, Ron L. [mailto:rlsmith_at_kmg.com]
> Sent: Wednesday, November 08, 2000 1:47 PM
> To: Multiple recipients of list ORACLE-L
> Subject: HELP! - SQL*NET from 8.1.6 to 7.3.4
>
>
> I am trying to connect an 8.1.6 instance to a 7.3.4 instance through a
> database link. I get and error message something like:
> ORA-02085 Database Link FINQUAL1.KMG.COM connects to
> KMINSTL1.WORLD. There
> is no KMINSTL1.world anywhere. The link points to FINQUAL1.
> Can anyone help?
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Smith, Ron L.
> INET: rlsmith_at_kmg.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 Thu Nov 09 2000 - 09:39:35 CST