jeudi 6 décembre 2012

ORACLE XE 10g for Linux

Salamu'alykom warahmatu lahi wa barakatuh :) 

how to install ORACLE XE 10g  in UBUNTU (Linux);

      packages to install 

              1) Download and install the following packages
                                 1 -> oracle-xe-universal_10.2.0.1-1.1_i386.deb  
                                 2 -> oracle-xe-client_10.2.0.1-1.2_i386.deb

                                 use : $ dpkg -i "name_of_package" 

              2) execute those cmds in a terminal 
                                   $ aptitude install libaio1 bc  //(some dependances to install with oracle xe10g)
                                   $ apt-get install rlwrap  //(it will help us in sqlplus )

       we will configure some parameters and some linux environement variables

              1) excute this cmd  " /etc/init.d/oracle-xe configure " (as root) and follow the steps that gives you

              2) add the following lignes in a terminal and in your file profile  " ~/.profile "   (or /etc/profile 
                  for everyone )

                           export ORACLE_SID=XE
                           export ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
                           export PATH=$PATH:$ORACLE_HOME/bin
                           export ORACLE_BASE=/usr/lib/oracle/xe

              3) add the following ligne in this file -> "$ORACLE_HOME/sqlplus/admin/glogin.sql" 

                           DEFINE _EDITOR = "/usr/bin/gedit" (or an other text editor that you want ) 

              4)type in a terminal the following alias and  add it  to your list of aliases , here(~/.bashrc)

                           alias sqlplus='rlwrap sqlplus'


               1) open your browser and type this (http://localhost:8080/apex) 
                         Login : system
                         pass : you already configured it when you did the 1st step in configuration
               2) enable the user HR ( in administration  )

               3) to connect from sqlplus run this cmd in the terminal

                        $ sqlplus hr/hr@xe
               4) enjoy ! :)

               i hope that tutorial allowed you to install and configure Oracle on your UBUNTU ,

thank you for reading :)