dbTalk Databases Forums  

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

comp.databases.oracle.server comp.databases.oracle.server


Discuss Re: Heteregenous connections client ==> oracle database ==> sqlserver in the comp.databases.oracle.server forum.



Reply
 
Thread Tools Display Modes
  #31  
Old   
Mladen Gogala
 
Posts: n/a

Default Re: Heteregenous connections client ==> oracle database ==>sqlserver - 06-21-2008 , 01:37 PM






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

Quote:
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


Reply With Quote
  #32  
Old   
Mladen Gogala
 
Posts: n/a

Default Re: Heteregenous connections client ==> oracle database ==>sqlserver - 06-21-2008 , 01:37 PM






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

Quote:
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


Reply With Quote
  #33  
Old   
Mladen Gogala
 
Posts: n/a

Default Re: Heteregenous connections client ==> oracle database ==>sqlserver - 06-21-2008 , 01:37 PM



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

Quote:
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


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.