Q
Problem solve Get help with specific problems with your technologies, process and projects.

Installing Oracle 9i and SQL Server 2000 on the same hard disk

Is it possible to install Oracle 9i and SQL Server 2000 on the same hard disk? I am running Windows 2000 Pro on a desktop, and I want to know if it is possible to have both, and if there are any gotchas.

Yes, it is possible to install Oracle RDBMS and MS SQL Server on the same server and even on the same hard disk. When you install these two products, you'll need to make sure that you install the software in their own subdirectories. I'd also keep the database disk files in separate locations as well. As for gotchas... Make sure that you have enough memory on your server. Database systems can require a lot of memory. You want to ensure that you are not using more physical memory than is available on your server to avoid paging (performance killers for any database). Also, if you only have one hard drive, then you may experience disk contention as both databases systems try to read, or write, data on the disk. Multiple hard drives may be warranted.


Eli Leiba adds:

Yes, it is possible and I did it myself.

If you have enough disk space and enough memory on the server, both database servers can be installed and "live" side-by-side. Both have separate services that run on the machine and also have separate folders in disk:

c:oracleora90.... for 9i
c:program filesmicrosoft sql server.... for SQL Server 2000

For More Information

  • What do you think about this answer? E-mail the editors at editor@searchDatabase.com with your feedback.
  • The Best Oracle Web Links: tips, tutorials, scripts, and more.
  • Have an Oracle or SQL tip to offer your fellow DBAs and developers? The best tips submitted will receive a cool prize. Submit your tip today!
  • Ask your technical Oracle and SQL questions -- or help out your peers by answering them -- in our live discussion forums.
  • Ask the Experts yourself: Our SQL, database design, Oracle, SQL Server, DB2, metadata, object-oriented and data warehousing gurus are waiting to answer your toughest questions.

Dig Deeper on Oracle database installation, upgrades and patches

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close