RE: database links

From: Vadim Gorbounov <vgorbounov_at_simplyengineering.com>
Date: Wed, 11 Apr 2001 08:55:07 -0700
Message-ID: <F001.002E7152.20010411074541@fatcity.com>

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.  Just

wondering 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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Suhen Pather
INET: Suhen.Pather_at_strandbags.com.au

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: 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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Vadim Gorbounov
INET: vgorbounov_at_simplyengineering.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------