Search code examples
sqloracleubuntuoracleformsdeveloper-tools

Can anyone please give me the step by step installation process of the oracle development suite 10g on ubuntu 16.04?


I already have oracle 11g Enterprise Edition installed on my machine. But now I have to work with Reports and Forms Builder for which it was told to install the Oracle Developer Suite 10g.

I have downloaded the .cpio files from the oracle site https://www.oracle.com/technetwork/developer-tools/developer-suite/downloads/101202linuxsoft-099233.html

Now what should I do with these files? Thank You.


Solution

  • Oracle 10g2? Wow that's kind of oldish, but here it is:

    1. Install libaio1 library:

      sudo apt-get update; 
      sudo apt-get install -y libaio1 bc
      
    2. Download [from Oracle] and install the oracle database package. Make sure you get the correct architecture (takes around 3 minutes on a slow machine):

      sudo dpkg -i oracle-xe-universal_10.2.0.1-1.0_i386.deb
      
    3. Configure Oracle [change password as needed] (takes around 4 minutes on a slow machine):

      sudo /etc/init.d/oracle-xe configure
      

      and respond to each question:

      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 <Enter> to accept the defaults. 
      Ctrl-C will abort.
      
      Specify the HTTP port that will be used for Oracle Application Express [8080]: <Enter>
      
      Specify a port that will be used for the database listener [1521]: <Enter>
      
      Specify a password to be used for database accounts.  Note that the same
      password will be used for SYS and SYSTEM.  Oracle recommends the use of 
      different passwords for each database account.  This can be done after 
      initial configuration: system
      Confirm the password: system
      
      Do you want Oracle Database 10g Express Edition to be started on boot (y/n) [y]: <Enter>
      
      Starting Oracle Net Listener...Done
      Configuring Database...Done
      Starting Oracle Database 10g Express Edition Instance...Done
      Installation Completed Successfully.
      To access the Database Home Page go to "http://127.0.0.1:8080/apex"
      
    4. Set up session environment variables in ~/.bashrc:

      # =====================
      # Oracle database setup
      # =====================
      
      export ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
      export PATH=$PATH:$ORACLE_HOME/bin
      export ORACLE_SID=XE
      
    5. Logout and login again, to load the changes.