2 Replies Latest reply: Mar 13, 2013 7:10 AM by EdStevens RSS

    Installation of Oracle Database 11g Express Edition on Ubuntu 12.10

    996567
      hi ,
      I am intalled the Oracle database have followed this steps link .


      1.Downloaded 11g express edition

      2.Created a new user 'oracle' under the group dba. Following steps are executed using this.

      3.unzip oracle-xe-11.2.0-1.0.x86_64.rpm.zip and then Converted the rpm to the Ubuntu package

      sudo alien --scripts -d oracle-xe-11.2.0-1.0.x86_64.rpm

      4.Created /sbin/chkconfig file and added the entries as specified here

      5.Created /etc/sysctl.d/60-oracle.conf and added the entries as specified in same link as above.

      6.Below steps:

      ln -s /usr/bin/awk /bin/awk
      mkdir /var/lock/subsys
      touch /var/lock/subsys/listener

      7.sudo dpkg --install oracle-xe_11.2.0-2_amd64.deb (.deb generated in step 3)

      8.sudo /etc/init.d/oracle-xe configure (left the default values as it is)

      9.Set the following env variables in ~/.bashrc file

      export ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe
      export ORACLE_SID=XE
      export NLS_LANG=`$ORACLE_HOME/bin/nls_lang.sh`
      export ORACLE_BASE=/u01/app/oracle
      export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
      export PATH=$ORACLE_HOME/bin:$PATH

      10.Below steps:

      chown -R oracle:dba /var/tmp/.oracle
      chmod -R 755 /var/tmp/.oracle
      chown -R oracle:dba /tmp/.oracle
      chmod -R 755 /tmp/.oracle

      11.sudo service oracle-xe start (I didn't see any issues in this step)

      12 . sqlplus / as sysdba and got the following



      SQL*Plus: Release 11.2.0.2.0 Production on Thu Jan 3 09:41:58 2013

      Copyright (c) 1982, 2011, Oracle. All rights reserved.

      Connected to an idle instance.

      Now when exectute any SQL statements on SQLplus, i end up with the following error

      SQL> select * from dual;
      select * from dual
      *
      ERROR at line 1:
      ORA-01034: ORACLE not available
      Process ID: 0
      Session ID: 0 Serial number: 0

      I have increased the swap memory as specified in [here |http://meandmyubuntulinux.blogspot.in/2011/09/installing-1-gb-swap-without.html]

      free -m



      total used free shared buffers cached
      Mem: 3901 3428 473 0 182 1988
      -/+ buffers/cache: 1258 2643
      Swap: 5066 0 5066
        • 1. Re: Installation of Oracle Database 11g Express Edition on Ubuntu 12.10
          EdStevens
          993564 wrote:
          hi ,
          I am intalled the Oracle database have followed this steps link .
          Please cite the quotation from the official Installation Guide (found [url http://docs.oracle.com/cd/E11882_01/install.112/e24321/toc.htm]here) that states that Ubuntu is a supported platform.

          >
          1.Downloaded 11g express edition

          2.Created a new user 'oracle' under the group dba. Following steps are executed using this.

          3.unzip oracle-xe-11.2.0-1.0.x86_64.rpm.zip and then Converted the rpm to the Ubuntu package

          sudo alien --scripts -d oracle-xe-11.2.0-1.0.x86_64.rpm

          4.Created /sbin/chkconfig file and added the entries as specified here

          5.Created /etc/sysctl.d/60-oracle.conf and added the entries as specified in same link as above.

          6.Below steps:

          ln -s /usr/bin/awk /bin/awk
          mkdir /var/lock/subsys
          touch /var/lock/subsys/listener

          7.sudo dpkg --install oracle-xe_11.2.0-2_amd64.deb (.deb generated in step 3)

          8.sudo /etc/init.d/oracle-xe configure (left the default values as it is)

          9.Set the following env variables in ~/.bashrc file

          export ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe
          export ORACLE_SID=XE
          export NLS_LANG=`$ORACLE_HOME/bin/nls_lang.sh`
          export ORACLE_BASE=/u01/app/oracle
          export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
          export PATH=$ORACLE_HOME/bin:$PATH

          10.Below steps:

          chown -R oracle:dba /var/tmp/.oracle
          chmod -R 755 /var/tmp/.oracle
          chown -R oracle:dba /tmp/.oracle
          chmod -R 755 /tmp/.oracle

          11.sudo service oracle-xe start (I didn't see any issues in this step)

          12 . sqlplus / as sysdba and got the following



          SQL*Plus: Release 11.2.0.2.0 Production on Thu Jan 3 09:41:58 2013

          Copyright (c) 1982, 2011, Oracle. All rights reserved.

          Connected to an idle instance.

          Now when exectute any SQL statements on SQLplus, i end up with the following error

          SQL> select * from dual;
          select * from dual
          *
          ERROR at line 1:
          ORA-01034: ORACLE not available
          Process ID: 0
          Session ID: 0 Serial number: 0

          I have increased the swap memory as specified in [here |http://meandmyubuntulinux.blogspot.in/2011/09/installing-1-gb-swap-without.html]

          free -m



          total used free shared buffers cached
          Mem: 3901 3428 473 0 182 1988
          -/+ buffers/cache: 1258 2643
          Swap: 5066 0 5066
          Edited by: EdStevens on Mar 13, 2013 7:08 AM
          • 2. Re: Installation of Oracle Database 11g Express Edition on Ubuntu 12.10
            EdStevens
            [url https://forums.oracle.com/forums/thread.jspa?threadID=2511076&tstart=0]duplicate post