[NTLUG:Discuss] Oracle on Intel

[Stephen Davidson]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Greetings.

Sorry for the delayed reply.  Current contract, two of the Dev platforms
were SuSE (10.0 & 10.1).  Oracle XE 10g installed on both, minimal
problems (unless you want a DB bigger that about 3.5GB, or running on
more than one CPU).  One piece of advice, do NOT try changing any
default ports.  Enough stuff in Oracle is hardcoded that if you try to
change, say, the http listen port, the whole thing will crash.  IF you
have a port conflict, you would be better off to change the JBoss port
(the primary cause, usually).  And it has a maximum of 4GB for the
Database tables, including the system areas.

One of our applications, we do use Stored Procedures, and just about
everything else you can think of.  Changes table structures, views,
indices, constraints, you name it (upgrades Database from one version of
the Software package to another.).  No problems, and any deploy issues
we had were not caused by scripting or database issues.

Regards,
Steve

Chris Albertson wrote:
> Guys,
> 
> You're exactly right about the problems you'll have trying to run Oracle 
> database server on a platform other than Redhat Enterprise. However, if 
> you're in a pilot phase and want to see how your app will work with 
> Oracle running on Linux, but don't want to buy Redhat... take a look at 
> Oracle DB Express Edition (XE).
> I've installed this thing on Debian and it was an absolute breeze. (By 
> comparison, I've gotten full Oracle DB to run on Debian, and it was a 
> serious pain.) They have RPM's and DEB's.
> The install of Oracle XE is really a single instance of oracle DB server 
> with preset configuration, and a very simplified enterprise manager web 
> interface replacement. But, under the covers, it's a single DB instance 
> of oracle. I've not tried to run stored procs or any other of the more 
> advanced features of oracle, but I believe you can do pretty much 
> everything if you can stay under 1gig RAM (Allocated to the DB, not on 
> the box), and 5GIG storage.
> 
> Chris
> 
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (GNU/Linux)
Comment: Using GnuPG with SUSE - http://enigmail.mozdev.org

iD8DBQFF/bPoPtiPEDq7o8YRAiVVAJ0VakRtfpIleSQywpwCyYFZYmMXxACeKDbo
1C/UEMcJ9zPRa1cthMt2SLw=
=ERZi
-----END PGP SIGNATURE-----