RE: dblink problem on two verion of ORACLE DB

Set your TNS_ADMIN director to a single place with valid TNSNames and SQLNET.ora files or,  

You could always hardcode the connect descriptor in the link thus removing TNS as an issue.

This gets confusing late at night if not noted primarily because altering the TNS has no effect on hard coded links. :-)  

Syntax:

create public database link TNSBYPASS

   connect to system identified by manager42

   using
'(DESCRIPTION=(ADDRESS=(HOST=YOURMACHINE.COM)(PROTOCOL=TCP)(PORT=1521))(CONN ECT_DATA=(SERVICE_NAME=YOURSERVICE.NAME.COM)))'   Obviously there are security issues with this approach as well.  

Also I've run 8.1.7.4, 9.2.0.4, 9.2.0.7, 10.1.0.4, 10.2.0.2 and 10.2.0.3 listeners simultaneously on the same machine.

It's not fun, but it was for testing various issues between systems.

Main issue we had was with auto registration and crashing listeners when 9 and 10 local_listeners were not set and 8.1.7.4 listener was defaulted to 1521.  

-Ted
             

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of David Sharples
Sent: Monday, August 13, 2007 2:21 PM
To: mccdba1_at_yahoo.com
Cc: Niall Litchfield; oracle-l_at_freelists.org Subject: Re: dblink problem on two verion of ORACLE DB  

its NOTHING to do with your listener and EVERYTHING to do with your tnsnames setup

On 13/08/07, dba1 mcc <mccdba1_at_yahoo.com> wrote:

I knew that is problem, but based on ORACLE say you can Only turn on one listener which is highest version of ORACLE.

--

http://www.freelists.org/webpage/oracle-l Received on Mon Aug 13 2007 - 15:25:09 CDT