Re: Oracle And Sybase

From: Charles J. Fisher <cfisher_at_rhadmin.org>
Date: Sat, 10 Nov 2001 00:16:05 GMT
Message-ID: <Pine.LNX.4.33.0111091812460.6698-100000@galt.rhadmin.org>

On Mon, 29 Oct 2001, Simon Taylor wrote:

> What (if any) would be the issues about running BOTH an Oracle and a Sybase
> databse server on the same host. (Not my idea)

The most important point is to make sure that the Oracle listener ports do not conflict with the ports that Sybase is listening on.

Generally, you should configure Sybase at 1433, for maximum MS SQL Server compatibility.

The Sybase listener configuration is in $SYBASE/interfaces. The Oracle listener configuration is in

	$ORACLE_HOME/network/admin/listener.ora 
		(also see tnsnames.ora, sqlnet.ora)

Sybase 11.0.3.3 didn't have anything like ONAMES, afaik.

   / Charles J. Fisher              | "A fanatic is one who can't change his /
  /  cfisher_at_rhadmin.org            |  mind and won't change the subject."  /
 /   http://rhadmin.org:81          |                 -- Winston Churchill /
---------------------------------------------------------------------------

Received on Fri Nov 09 2001 - 18:16:05 CST