Thursday, March 10, 2011

Oracle 10g Express: How to set up Oracle XE?

  Oracle XE is a Oracle Express edition Oracle software provided by Oracle. This software allows developers to install Oracle in their computer and practice Oracle and PL/SQL.

Steps for Installation:
1. Download the Oracle Database 10g Express Edition software fromOracle XE.
2. Install the software just like any windows software.
3. During Installation, it will ask you for password. Remember the credentials. The username is SYS.

 Once the installation is through:
1. Open your browser and type:  http://localhost:8080/apex
2. The login screen will appear.
3. Type the username and password which you had provided during installation.
4. Click on the SQL option, and then the 'SQL Commands' option.

  You have reached the SQL session where you can now do all the Oracle studies or practice.

Cygwin Users:
   Cygwin users, who wish to access this Oracle database from your cygwin terminal, its pretty easy. Do the following:

1. Find out the path where the Oracle XE is installed in your PC. Say, in my case it is: C:\oraclexe\app\oracle\product\10.2.0\server\BIN
2. Since the installation is in C drive, finding the mapping drive of C: in cygwin. This can be done by:
$ df | grep 'C:' | awk '{print $NF}'
 3. Update the PATH variable accordingly in your profile file:
export PATH=$PATH:"/cygdrive/c/oraclexe/app/oracle/product/10.2.0/server/BIN"
4. Now try to login to your sqlplus prompt:
sqlplus  sys/password@xe as sysdba
  Note: The 'password' for above will be the password provided during the installation.

  You have successfully logged in to your sqlplus session.

No comments:

Post a Comment