I want to install oracle XE 10g on my windows. I have already installed lot of IBM software like RAD, Websphere, DB2, etc. Do you think installing Oracle will cause any conflict with any of my exisitng software ?
ben oliver wrote:I want to install oracle XE 10g on my windows. I have already installed lot of IBM software like RAD, Websphere, DB2, etc. Do you think installing Oracle will cause any conflict with any of my exisitng software ?
You should not have any issues.I have the same software on my machine. One question though. Why would you want Oracle XE if you already have DB2? Oracle XE is very limited. Look here to compare the two http://freedb2.com/2008/06/19/comparing-free-databases-oracle-xe-vs-db2-express-c/. With the recent acquisition of MySQL by Oracle one really wonders if Oracle XE has any future. It has ot been updated in the last 3 years or so and that is prior to MySQL acquisition. Don't think it si going to be any better now.
Actually Oracle XE is NOT limited. The main limitation is that you cannot create any databases with it greater than 4GB. You can create databases, allocate security, backup and restore databases, create stored procedures, etc. I highly recommend it as a resource to get your hands dirty with Oracle and learn all about PL/SQL. It should not conflict with your existing software, however beware, Oracle XE is a bit of a resource hog. Another words, it consumes a lot of memory. What I do is deselect the auto start property and only start the Oracle Listener and Service when I'm actually using Oracle.
My opinion on MySQL? If you want to go the open source route, then Postgresql totally rocks. It's a far superior database than MySQL. Oracle has bought out MySQL and it's yet to be determined what plans Oracle has for it.