Installing Oracle 11G on Linux Ubuntu

First of all you have to install these packages:
 
Install the required software packages:
sudo apt-get install libaio1
sudo apt-get install libaio-dev
sudo apt-get install unixODBC
sudo apt-get install unixODBC-dev
sudo apt-get install expat
sudo apt-get install sysstat
sudo apt-get install libelf-dev
sudo apt-get install elfutils
sudo apt-get install lsb-cxx
sudo apt-get install pdksh
sudo apt-get install libstdc++5
sudo apt-get install ia32-libs
sudo apt-get install ksh
sudo apt-get install lesstif2
sudo apt-get install alien
sudo apt-get install gcc
sudo apt-get install gawk
sudo apt-get install binutils
sudo apt-get install gawk
sudo apt-get install x11-utils
sudo apt-get install rpm
sudo apt-get install alien
sudo apt-get install lsb-rpm
sudo apt-get install libmotif3
sudo apt-get install lesstif2
sudo apt-get install openssh-server
 
The Oracle installation expects certain utilities and libraries in different locations:
sudo ln -s /usr/bin/basename /bin/basename
sudo ln -sf /bin/bash /bin/sh
sudo ln -s /usr/bin/rpm /bin/rpm
sudo ln -s /usr/bin/awk /bin/awk
sudo ln -s /usr/lib/x86_64-linux-gnu/libc_nonshared.a /usr/lib64/ 
sudo ln -s /usr/lib/x86_64-linux-gnu/libpthread_nonshared.a /usr/lib64/ 
sudo ln -s /usr/lib/x86_64-linux-gnu/libstdc++.so.6 /usr/lib64/ 
sudo ln -s /lib/x86_64-linux-gnu/libgcc_s.so.1 /lib64
sudo ln -s /usr/lib/i386-linux-gnu/libpthread_nonshared.a /usr/lib/libpthread_nonshared.a
 

Step 1: Downlo ad Oracle Database Express Edition.

https://www.oracle.com/technetwork/database/database-technologies/express-edition/downloads/index.html
 

Step 2: Instructions before install Oracle

  1. Copy the downloaded file and paste it in home directory.

  2. Unzip using the command:

    unzip oracle-xe-11.2.0-1.0.x86_64.rpm.zip 
    
  3. Install required packages using the command:

    sudo apt-get install alien libaio1 unixodbc
    
  4. Enter into the Disk1 folder using command:

    cd Disk1/
    
  5. Convert RPM package format to DEB package format (that is used by Ubuntu) using the command:

    sudo alien --scripts -d oracle-xe-11.2.0-1.0.x86_64.rpm
    
  6. Create the required chkconfig script using the command:

    sudo pico /sbin/chkconfig
    

    The pico text editor is started and the commands are shown at the bottom of the screen. Now copy and paste the following into the file and save:

    #!/bin/bash
    # Oracle 11gR2 XE installer chkconfig hack for Ubuntu
    file=/etc/init.d/oracle-xe
    if [[ ! `tail -n1 $file | grep INIT` ]]; then
        echo >> $file
        echo '### BEGIN INIT INFO' >> $file
        echo '# Provides: OracleXE' >> $file
        echo '# Required-Start: $remote_fs $syslog' >> $file
        echo '# Required-Stop: $remote_fs $syslog' >> $file
        echo '# Default-Start: 2 3 4 5' >> $file
        echo '# Default-Stop: 0 1 6' >> $file
        echo '# Short-Description: Oracle 11g Express Edition' >> $file
        echo '### END INIT INFO' >> $file
    fi
    update-rc.d oracle-xe defaults 80 01
    
  7. Change the permission of the chkconfig file using the command:

    sudo chmod 755 /sbin/chkconfig  
    
  8. Set kernel parameters. Oracle 11gR2 XE requires additional kernel parameters which you need to set using the command:

    sudo pico /etc/sysctl.d/60-oracle.conf
    
  9. Copy the following into the file and save:

    # Oracle 11g XE kernel parameters 
    fs.file-max=6815744  
    net.ipv4.ip_local_port_range=9000 65000  
    kernel.sem=250 32000 100 128 
    kernel.shmmax=536870912 
    
  10. Verify the change using the command:

    sudo cat /etc/sysctl.d/60-oracle.conf 
    
  11. You should see what you entered earlier. Now load the kernel parameters:

    sudo service procps start
    
  12. Verify the new parameters are loaded using:

    sudo sysctl -q fs.file-max
    

    You should see the file-max value that you entered earlier.

  13. Set up /dev/shm mount point for Oracle. Create the following file using the command:

    sudo pico /etc/rc2.d/S01shm_load
    
  14. Copy the following into the file and save.

    #!/bin/sh
    case "$1" in
    start)
        mkdir /var/lock/subsys 2>/dev/null
        touch /var/lock/subsys/listener
        rm /dev/shm 2>/dev/null
        mkdir /dev/shm 2>/dev/null
    *)
        echo error
        exit 1
        ;;
    
    esac 
    
  15. Change the permissions of the file using the command:

    sudo chmod 755 /etc/rc2.d/S01shm_load
    
  16. Now execute the following commands:

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

    Now, Reboot Your System

Step 3: Install Oracle

  1. Install the oracle DBMS using the command:

    sudo dpkg --install oracle-xe_11.2.0-2_amd64.deb
    
  2. Configure Oracle using the command:

    sudo /etc/init.d/oracle-xe configure 
    
  3. 
    		
    Heads-up: Open this link if you get this error "Ora-00845" after configuration:
    https://leandro26.webnode.com/products/ora-00845-memory-target-error-installing-oracle-xe-on-mint-and-ubuntu/
  4. Setup environment variables by editting your .bashrc file:

    pico ~/.bashrc
    
  5. Add the following lines to the end of the 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
    
  6. Load the changes by executing your profile:

    . ~/.profile
    
  7. Start the Oracle 11gR2 XE:

    sudo service oracle-xe start
    
  8. Add user YOURUSERNAME to group dba using the command:

    sudo usermod -a -G dba YOURUSERNAME
    

Step 4: Using the Oracle XE Command Shell

  1. Start the Oracle XE 11gR2 server using the command:

    sudo service oracle-xe start
    
  2. Start command line shell as the system admin using the command:

    sqlplus sys as sysdba
    

    Enter the password that you gave while configuring Oracle earlier. You will now be placed in a SQL environment that only understands SQL commands.

  3. Create a regular user account in Oracle using the SQL command:

    create user USERNAME identified by PASSWORD;
    

    Replace USERNAME and PASSWORD with the username and password of your choice. Please remember this username and password. If you had error executing the above with a message about resetlogs, then execute the following SQL command and try again:

    alter database open resetlogs;
    
  4. Grant privileges to the user account using the SQL command:

    grant connect, resource to USERNAME;
    

    Replace USERNAME and PASSWORD with the username and password of your choice. Please remember this username and password.

  5. Exit the sys admin shell using the SQL command:

    exit;
    
  6. Start the commandline shell as a regular user using the command:

    sqlplus
    

    Now, you can run sql commands...

 

 

 

 


Crie um site com

  • Totalmente GRÁTIS
  • Centenas de templates
  • Todo em português

Este site foi criado com Webnode. Crie um grátis para você também!