Discussion Locked

Oracle8i & SQL7.0 DB Svr on same system

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi,
1. Can I run both Oracle 8i (6 databases) & SQL 7.0 (3 databases) Database Servers on the same NT Server 4.0 (SP6a) system. Would there be any conflict issue ? What hardware config do I need (like mulit processor, ram, SCSI HDD etc) ?
2. How do I backup Oracle / SQL databases live using NT Backup or do I need any third party software ?
Akash

5 replies

by erikdr

1. *CAN* I'm not absolutely certain about, though I tend to expect No.
*SHOULD* is, hence, No. Defitely both platforms design with the claim of exclusive access to all SQL traffic to and from that server. You might try to avoid this by using different protocols on top of TCP/IP in both, e.g. Named Pipes for MSSQL and propietary SQLNet for Oracle - but then probably further down the road it will clash, e.g. in the NT settings both platforms require.
2. Probably not with the free NT backup. Veritas BackupExec (the superset of NT Backup) offers (paid) plugins for these two DBMS's, but competitors like CA ArcServeIT do too.

Have fun,

- The Netherlands

by pezzz

I would think that you could use both on the same server, but you would want to make sure that they are listining on different ports. As far as having 9 databases on the same machine it depends on the size of them for how much hardware you need. Iwould say get as much hardware as you can afford.

For backing up the databases live using NT backup this should be possible. Within SQL Server and Oracle set it so that it exports the databases night and then script NT Backup to backup those exported files.

This discussion is closed to new replies.