Re: Heteregenous connections client ==> oracle database ==> sqlserver

On Fri, 20 Jun 2008 09:57:13 -0700, Mark D Powell wrote:

> Chris, if you have both database versions 8.1.x and 9.x running on the
> same server I would just use the 9.x listener to listen for all
> databases. We have always just used the highest version listener to
> handle all databases on the server so unless you have a really old
> database that the newest listener does not work with I would use just
> one listener, one tnsnames.ora, one listener.ora, and one sqlnet.ora.

I've recently put my first 11g database in production on RHES 4.4 and the listener can seamlessly manage Oracle 9i on the same box. So yes, it's one listener to rule them all, one listener to connect them, one listener to find them all...

-- 
http://mgogala.freehostia.com