Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: database links
Hi, Millie,
Try this location
ftp://oracle-ftp.oracle.com/server/
HTH
Vadim Gorbounov
Oracle DBA
-----Original Message-----
Sent: Wednesday, April 11, 2001 10:26 AM
To: Multiple recipients of list ORACLE-L
I have set the global_names parameter to false on my mainframe database ORS1
and recycled the data base. When I do a select * from global_name, it show
the name of ORS1. When I do the same on the unix database dw1, it show the
name of DW1.WORLD. When I do select * from dba_db_link on ORS1, it show
other host as dw1.world. How can I change my global_name to be ors1.world?
What should the SERVICE_NAME parameter be? We don't use this parameter, I
tried serveral different names, but it didn't seem to make any difference.
Thanks.
Millie
-----Original Message-----
Sent: Saturday, April 07, 2001 2:00 AM
To: Multiple recipients of list ORACLE-L
Millie,
Check both instances and verify if global_names parameter is switched on.
What is the name of your db link?
select * from global_name;
Is it the same as global_name?
I have a problems creating database links when I have global_names parameter
set to TRUE.
I normally switch global_names=false unless the application uses
global_names.
I create my database link using the connect description from my tnsnames.ora
file for
that instance. It normally works.
eg.
create database link test connect to jdatest identified by jdatest
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = odbms)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = test)
)
)'
;
This normally works for me. DB links are very fussy when it comes to global
names.
Also the name that is given to your db link when global names are used.
HTH
Suhen
Suhen
We are setting up a test Oracle 8i (8.1.7 with OSDI) on our mainframe (os/390 v2.8), we can connect to the database instance (ORS1) from windows NT client, but when we try to connect to it using database links set up from our unix platform,
we get ORA-12154 TNS: Could not resolve service name When we try to link from ors1 I get: ORA-02019 Connection Description For Remote Database Not Found. We created a tar with Oracle and waiting to hear from them. Justwondering if anyone on the list has the same problem?
Millie Chan
Rutgers, The State University of New Jersey
Administrative Computing Services
65 Davidson Road
Piscataway, NJ 08855
Tel: (732)445-5433
EMAIL: mchan_at_acs.rutgers.edu
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Chan, Millie
INET: mchan_at_surfside.rutgers.edu
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).
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)..
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).
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 Wed Apr 11 2001 - 10:55:07 CDT