Re: connect to a remote Oracle db using PLSQL procedure

Stephan Born <stephan.born_at_beusen.de> writes:

> Daniel Morgan wrote:
> >
>
> [...]
>
> >
> > To connect to the remote machine directly you must have it in your
> > TNSNAMES.ORA and then connect to it in the normal manner.
>
> To be precise: the remote-database has to be in the TNSNAMES.ORA of the
> 'locale' database-server!!! In my case we had the constellation that the
> db-clients had another TNSNAMES.ORA than the db-server had itself
> ( for security reason?? ).
> So, I searched a day or two before I found the solution....
>

Yeh, that can be a problem. We have established an Oracle Names Server (ONS), so we are not constrained by the local tnsnames.ora file and I'd forgotten about some of the limitations if you don't have such a setup.

Tim

--