I recommended for many of startup company clients as it comes free and over the period they make enough profit and the database grows, then they can go for Enterprise Edition to pay license.

Other day, I was talking to someone in a users meeting, that they can not use the LAMP architecture for Small and Commercial Companies which are selling products online as they use MySQL for DB part and the limitations of MySQL especially point-in-time recovery and reliability on recovery etc. For such companies, XE would be best solution with the LAMP combination.

One of the draw back with the XE is that it not supported in 64bit.[That does not stop you from installing and trying it]  Other than that, XE would be best option for starting the reliable DB for free.

The limitations:

• Max CPU                 - 1
• Max Memory            - 1GB
• Max DB Size            - 4GB
• Max DB per Box       - 1
• Non availability        - 64 bit support
• No support for         - XML
• Multithread            - Not available

If you are ok with this limitation, it would be best to go for this, when you want to save on license cost.

The comparison chart with other Editions:

http://www.oracle.com/database/product_editions.html

 Also you would find this article by Lewis interesting who wants to know more about Oracle XE

Comments (7)

	1. 01-16-2008 16:35
	Will it be possible to take RMAN backup?   I could not see anywhere it can be possible. Registered

JDUX

	2. 01-16-2008 17:08
	No. RMAN backup is not possible. But you can have hot backup after running in archivelog mode. Also for a 4 GB DB the hot backup should not take more than 30 minute with 1GB SGA. http://psadmin.org Registered

PSADMIN

	3. 01-22-2008 19:40
	As per the documents, we need to have root access to install XE in unix. There is not much left for configuration. Is that right? Guest

Guhan

	4. 01-23-2008 15:37
	Yes, The installation is very simple.    # rpm -ivh oracle-xe-univ-10.2.0.1-1.0.i386.rpm  Preparing... ########################################### [100%]  1:oracle-xe-univ ########################################### [100%]  Executing Post-install steps...    You must run '/etc/init.d/oracle-xe configure' as the root user to  configure the database.    # /etc/init.d/oracle-xe configure    Oracle Database 10g Express Edition Configuration  -------------------------------------------------  This will configure on-boot properties of Oracle Database 10g Express  Edition. The following questions will determine whether the database should  be starting upon system boot, the ports it will use, and the passwords that  will be used for database accounts. Press to accept the defaults.  Ctrl-C will abort.    Specify the HTTP port that will be used for Oracle Application Express [8080]:50  00    Specify a port that will be used for the database listener [1521]:4900  - http://psadmin.org Registered

PSADMIN

	5. 01-23-2008 17:28
	After the installation you can go to $ORACLE_HOME and change the configuration in init file or login to the database and change the parameters.    Also start/stop the database commands are simple: [Remember only one instance allowed. But you can have multiple schema]    You start and stop with any of these commands:    /etc/init.d/oracle-xe start/stop    or    service oracle-xe start/stop Guest

PSADMIN

	6. 01-24-2008 16:21
	Good. Thanks Guest

Guhan

	7. 01-25-2008 16:24
	After the MySql take over by Sun Micro, switchover from MySql to Oracle XE would be more, I understand.     It looks like a good product to try out. Guest

Kim

Write Comment

Thankyou for your comments. Feel free to comment if there are any mistake in the postings also. If you have a Blog or website, feel free to provide the link. We will take a peak. Just ensure to *Refresh* your browser for a new security code to be displayed prior to clicking on the 'Send' button. Keep in mind that the above process only applies if you simply entered the wrong security code.
Name:
Homepage
BBCode:
Comment:
Code:*
	I wish to be contacted by email regarding additional comments

Copy Right: AKOComments v.1.4.6