Home » Other » General » Free version of the Oracle DB - Express Edition
Free version of the Oracle DB - Express Edition [message #144984] Sun, 30 October 2005 15:06 Go to next message
Frank Naude
Messages: 4590
Registered: April 1998
Senior Member
Oracle recently bought InnoDB (part of the MySQL DB) and just released a freebie version of their database - Oracle XE (eXpress Edition).

XE is a free, downloadable version of the Oracle database server. It can only be used to manage up to 4 GB of user data on a single processor machine, with a maximum instance memory allocation of 1 GB. ISVs can embed XE in 3rd party products and redistribute it freely.

More info here - http://www.oracle.com/technology/products/database/xe/index.html

Best regards.

Frank

Report message to a moderator

Re: Free version of the Oracle DB - Express Edition [message #145392 is a reply to message #144984] Wed, 02 November 2005 17:24 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
This is a 'must have' piece of software. It has HTML_DB built-in, including the demos.

David

Report message to a moderator

Re: Free version of the Oracle DB - Express Edition [message #145740 is a reply to message #144984] Sat, 05 November 2005 10:59 Go to previous messageGo to next message
Steve Callan
Messages: 44
Registered: January 2004
Member
XE is not based on InnoDB. Acquiring InnoDB is a related, but separate storyline.

Report message to a moderator

Re: Free version of the Oracle DB - Express Edition [message #160853 is a reply to message #145740] Tue, 28 February 2006 13:19 Go to previous messageGo to next message
Frank Naude
Messages: 4590
Registered: April 1998
Senior Member
"Oracle Announces General Availability of Oracle(R) Database 10g Express Edition" - http://biz.yahoo.com/prnews/060228/sftu085.html?.v=50

Report message to a moderator

Re: Free version of the Oracle DB - Express Edition [message #160876 is a reply to message #160853] Tue, 28 February 2006 20:22 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
More information about Zend http://www.regdeveloper.co.uk/2006/02/28/zend_oracle_database_php/

David

Yes - I know I put this information into the other thread.

Report message to a moderator

Re: Free version of the Oracle DB - Express Edition [message #163140 is a reply to message #160876] Wed, 15 March 2006 01:06 Go to previous messageGo to next message
rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Any recommendations on machine specs for XE? I've found that the regular server edition crushes anything with less than 1Gb mem making it useless on most home PCs.

Report message to a moderator

Re: Free version of the Oracle DB - Express Edition [message #163166 is a reply to message #163140] Wed, 15 March 2006 04:44 Go to previous messageGo to next message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
Ross, in order to get it running correctly on Windows XP you need to install it as Administrator. Not a local administrator but the true built-in Administrator account. I've had some trouble with it the first time I installed the production version. The Beta didn't suffer from the problem. Another point of attention is the rename of htmldb to Application express. The start page of the database is no longer http://yourhost:yourport/htmldb but http://yourhost:yourport/apex

It runs on my 2 laptops without any problems, and one of them only has 512MB of RAM. It installs in 10 minutes.
One thing I modified was making the services manual. I don't want the db to start up automatically every time I boot.

MHE

Report message to a moderator

Re: Free version of the Oracle DB - Express Edition [message #163260 is a reply to message #163166] Wed, 15 March 2006 16:07 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
I run a 3GHz P4 with 512Meg of memory.

I also have the database starting manually and it takes about 20 seconds to get the start-up to run. After that it takes a further 20-30 seconds to 'get going' once I sign on, after that the response times are EXTREMELY acceptable.

David

Report message to a moderator

Re: Free version of the Oracle DB - Express Edition [message #163261 is a reply to message #163260] Wed, 15 March 2006 16:20 Go to previous messageGo to next message
rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Hmmm. My 256Mb RAM 1.4GHz P3 word-processor at home may be the acid test. Besides which, if I install it, I'll no longer have that "I don't have Oracle here" excuse for not checking my syntax. Thinking music please.....

Thanks for the responses.
_____________
Ross Leishman

Report message to a moderator

Re: Free version of the Oracle DB - Express Edition [message #163311 is a reply to message #163261] Thu, 16 March 2006 03:03 Go to previous messageGo to next message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
rleishman wrote on Wed, 15 March 2006 23:20

I'll no longer have that "I don't have Oracle here" excuse for not checking my syntax.
You never had: sign up for a free workspace at http://htmldb.oracle.com like I did. Now you have an Oracle available at all times (provided you have an internet connection) Wink.

MHE

[Updated on: Thu, 16 March 2006 03:03]

Report message to a moderator

Re: Free version of the Oracle DB - Express Edition [message #163679 is a reply to message #163311] Fri, 17 March 2006 19:19 Go to previous messageGo to next message
rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Actually I already had one, but:
- I never connected the dots in my head that I could use it to test SQL for this forum at home.
- I actually like using the excuse (shhhh)

Report message to a moderator

Re: Free version of the Oracle DB - Express Edition [message #177579 is a reply to message #144984] Thu, 15 June 2006 10:22 Go to previous message
ndeb1408
Messages: 1
Registered: June 2006
Junior Member
One additional 'limitation' that is not directly documented is that 10g xe is basically equivalent to a Standard Edition. So don't expect to get all functionnality for free (bitmap indexes, partitionning, ...)!

Report message to a moderator

Previous Topic: caused an ORA 600
Next Topic: What is SCM?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Feb 13 06:22:57 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.