Saturday, 10 January 2015

Download, Install, and Test Oracle XE Database

Oracle Database Express Edition (Oracle Database XE) is an entry-level, small-footprint database.  It's free to develop, deploy, and distribute; fast to download; and simple to administer. Follow the instructions mentioned below to download and install Oracle XE Database.

1.       Enter the following address in your browser to download the database:
2.       Accept the License Agreement.
3.       Click on the Oracle Database Express Edition 11g Release 2 for Windows x32 link, (if your PC is running 32 bit Windows operating system) otherwise, select the version compatible with your OS.
4.       Enter your Username and Password. If you don't have an account, sign up for a free Oracle Web account and repeat the download process.
5.       Save the zip file to your computer.
6.       Once downloaded, extract the .zip file, and launch the Setup file from the extracted Disk1 folder to start installation.
7.       Follow the on-screen instructions to complete the installation.



NOTE
During the installation process you are required to enter and confirm SYSTEM user password. Provide a password that you can easily remember – I set it to manager. This account is used underneath to test database connectivity. The final installation screen will show a port number - which is usually 1521. Network request is passed to a database through this port. Note down this number, as it is required in the next section. 

The XE database installation process creates entries in the program group as show in the following figure.



Test your database installation by clicking the Run SQL Command Line option.  On the SQL prompt type: connect system/manager and press enter. If everything went well during the installation process, you’ll see connected message on the subsequent line, which indicates that your database is up and ready to take requests. Type exit and press enter to quit the command line interface.





No comments:

Post a Comment