Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Why doesn't this simple DATABASE LINK work? Must be something very basic and stupid.

Re: Why doesn't this simple DATABASE LINK work? Must be something very basic and stupid.

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Tue, 20 Jul 2004 22:24:45 -0700
Message-ID: <1090387509.485169@yasure>


J.W. wrote:

>
>
> SQL> !tnsping D82
>
> TNS Ping Utility for HPUX: Version 9.2.0.4.0 - Production on
> 20-JUL-2004 16:28:42
>
> Copyright (c) 1997 Oracle Corporation. All rights reserved.
>
> Used parameter files:
> /oracle/D82/920_64/network/admin/sqlnet.ora
>
>
> Used TNSNAMES adapter to resolve the alias
> Attempting to contact (DESCRIPTION = (SDU = 32783) (ADDRESS_LIST =
> (ADDRESS = (COMMUNITY = SAP.WORLD) (PROTOCOL = TCP) (HOST = srv002)
> (PORT = 1582))) (CONNECT_DATA = (SID = D82) (GLOBAL_NAME =
> D82.WORLD)))
> OK (0 msec)
>
> SQL> create database link xyz using 'D82';
>
> Database link created.
>
> SQL> select * from dual_at_xyz;
> SP2-0042: unknown command "xyz" - rest of line ignored.
>
>

A tnsping of 0 msec doesn't mean it connected.

What is the setting for the GLOBAL_NAMES parameter?

Daniel Morgan Received on Wed Jul 21 2004 - 00:24:45 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US