Re: Database links

From: K Stahl <BlueSax_at_Unforgettable.com>
Date: Tue, 22 Feb 2000 13:45:22 -0500
Message-ID: <38B2D942.59B0E538@Unforgettable.com>

Frank wrote:
>
> Is xyz_link the sid of your database? It doesn't look like it and I
> believe this needs to be the case. Try renaming/creating your link as
> mysid.
>
> Good luck,
> Frank
>

There doesn't seem to be any indication in the Oracle documentation that the name of the link must coincide with the name of the sid. In fact, it would appear that the link can have any name as long as the the value provided to USING is a valid entry in tnsnames.ora.

Has anyone else enountered this problem?

I will mention this - the listener I have set up on the machine where the database exists in which I am creating the link does have both TCP and IPC listeners and I have MTS set up for both tcp and ipc - however, that shouldn't even enter into the picture since the only listener involved would be the one on the machine which has the database I am trying to access via the database link. Received on Tue Feb 22 2000 - 12:45:22 CST