How to Install Oracle 11g R2 Database on Ubuntu 16.04 Xenial LTS 64-bit Easy Guide

Ubuntu 16.04 Install Oracle 11g R2 - QuickStart Guide Hi! The Tutorial shows you Step-by-Step and Visually How to Install and Getting-Started on Oracle 11g R2 Database in Ubuntu 16.04 Xenial LTS Amd64 GNU+Linux Desktop/Server. And the Guide Includes All the Essentials Commands and Basic Screenshots of Installing Oracle 11g on Ubuntu 16.04. Especially relevant: Ubuntu-like Systems are Not in the List of Oracle 11g Database Supported OS So you should Be Careful and Use it at most for Development and Not As Production Database Server! Finally, the Process is somewhat Extended and Advanced and so it require a little confidence with the Command Line shell. Now Relax and Take the Time of Reading, Understanding and Executing Carefully the Instructions Contained here. 1. Downloading Download the Oracle 11g R2 Database for Linux: Oracle 11g R2 .zip for Linux The Link Contains the List of Oracle 11g r2 Database Releases. 2. Accessing Shell Open a Shell Session or Terminal Emulator Window Ctrl+Alt+t on desktop (Press "Enter" to Execute Commands). In case first see: Terminal QuickStart Guide. Or Login into Server Shell. And Update Apt Sources: sudo apt update 3. Login as SuperUser Login as Super-User This to make Commands shorter to Execute: sudo su If Got "User is Not in Sudoers file" then see: How to Enable sudo 4. Making Network Setup Then to Make Network Configuration Do: Get hostname: hostname Get IP: /sbin/ifconfig You will Find It Under the lo >> inet Section. Check if Hostname is Already into the Enabled Hosts File. cat /etc/hostsIf It's Not Present then Insert it with: nano /etc/hosts Insert: Example: '127.0.0.1 localhost.localdomain' Ctrl+Shift+v to Paste Content on nano Ctrl+x to Save and Exit from nano Editor :) Grant Connection to X Server xhost +myIPExample: # xhost +127.0.0.1 5. Setting Up Parameters Parameters Configuration SetUp So Execute: Edit /etc/sysctl.conf file. nano /etc/sysctl.confThen hit Ctrl+x to Save and Exit from nano Editor Add or amend the following lines #### Oracle 11g Kernel Parameters #### fs.suid_dumpable 1 fs.aio-max-nr 1048576 fs.file-max 6815744 kernel.shmall 818227 kernel.shmmax 4189323264 kernel.shmmni 4096 kernel.panic_on_oops 1 # semaphores: semmsl, semmns, semopm, semmni kernel.sem 250 32000 100 128 net.ipv4.ip_local_port_range 9000 65500 net.core.rmem_default262144 net.core.rmem_max4194304 net.core.wmem_default262144 net.core.wmem_max1048576 The Values of 'shmall' and 'shmmax' Need to be Customized following your System Memory Size. Here above is a Valid Setup for a 8Gb RAM Size! If you need to Change first Check your Phisical Memory Size with: cat /proc/meminfo | grep MemTotal Then 'shmall' should be Set as: / 10 And instead 'shmmax' as: * 1024 / 2 For further Instructions See Oracle Documentation... If Exists then Comment out these lines below that Gives an Error #net.bridge.bridge-nf-call-ip6tables 0 #net.bridge.bridge-nf-call-iptables 0 #net.bridge.bridge-nf-call-arptables 0 Edit /etc/security/limits.conf file. nano /etc/security/limits.conf Add the following lines #### oracle User Settings 4 Oracle 11g ####/noracle soft nproc 2047/noracle hard nproc 16384/noracle soft nofile 1024/noracle hard nofile 65536/noracle soft stack 10240 Load the New Kernel Parameters /sbin/sysctl -p 6. Installing Packages Installing the Required Packages Some Package in Not Any More in the Actual Repo and so we have to Unpack some Legacy Stuff... From Trusty Universe: /necho 'deb http://us.archive.ubuntu.com/ubuntu/ trusty main universe' >> /etc/apt/sources.list.d/extra-trusty.list apt update Then Execute: sudo apt install lsb-cxx pdksh Disable Trusty Universe: sudo rm /etc/apt/sources.list.d/extra-trusty.list Again Restore the Repos with: apt update Finally, Install Remaining Dependencies: /napt-get install alien autoconf automake autotools-dev binutils doxygen elfutils expat gawk gcc gcc-multilib g++-multilib libstdc++6:i386 ksh less libtiff5 libtiff5-dev lib32z1 libaio1 libaio-dev libc6-dev libc6-dev-i386 libc6-i386 libelf-dev libltdl-dev libodbcinstq4-1 libodbcinstq4-1:i386 libstdc++5 make openssh-server rlwrap rpm sysstat unixodbc unixodbc-dev x11-utils libpth-dev zlibc libglapi-mesa:i386 libglu1-mesa:i386 libqt4-opengl:i386 libpthread-workqueue0 libpthread-workqueue-dev libzthread-2.3-2 libzthread-dev libmotif-common 7. Making Symlinks Make Symlinks to Binaries and Libraries. Linking Binaries ln -s /usr/bin/awk /bin/awk ln -s /usr/bin/rpm /bin/rpm ln -s /usr/bin/basename /bin/basename Linking Libraries ln -s /usr/lib/x86_64-linux-gnu /usr/lib64 cd /lib64 ln -s /lib/x86_64-linux-gnu/libgcc_s.so.1 . 8. Making Groups & User Add Groups and User Run: groupadd -g 502 oinstall groupadd -g 503 dba groupadd -g 504 oper groupadd -g 505 asmadmin useradd -u 502 -g oinstall -G dba,asmadmin,oper -s /bin/bash -m oracle passwd oracleTake Note of the oracle User Pass :) 9. Making Directories To Make Target Directories Commands: mkdir -p /u01/app/oracle/product/11.2.0/ chown -R oracle:oinstall /u01 chmod -R 775 /u01 10. Extracting Unzip, Set oracle as Owner and Relocate database To Extract from Command Line: cd /home//Downloads unzip linux_11gR2_database_1of2.zip unzip linux_11gR2_database_2of2.zip chown -R oracle:oinstall database mv database /tmp 11. Setting the PATH Now Add Paths to oracle's .bashrc Fist Login as the Oracle User: su oracleEdit .bashrc file nano ~/.bashrcInsert: # Oracle Settings TMP/tmp; export TMP TMPDIR$TMP; export TMPDIR ORACLE_HOSTNAME; export ORACLE_HOSTNAME ORACLE_UNQNAMEDB11G; export ORACLE_UNQNAME ORACLE_BASE/u01/app/oracle; export ORACLE_BASE ORACLE_HOME$ORACLE_BASE/product/11.2.0/dbhome_1; export ORACLE_HOME ORACLE_SID; export ORACLE_SID PATH/usr/sbin:$PATH; export PATH PATH$ORACLE_HOME/bin:$PATH; export PATH LD_LIBRARY_PATH$ORACLE_HOME/lib:/lib:/usr/lib:/usr/lib64; export LD_LIBRARY_PATH CLASSPATH$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH Replace with IP and with SID Name In this Example Respectively: HOSTNAME 127.0.0.1 DBSID SID Load New .bashrc Settings: bash 12. Installing Software Finally, to Install the Oracle 11g Database Software First, Run the Installer: cd /tmp/database chmod -R +x /tmp/database ./runInstaller If you Get: "Check if the DISPLAY variable is set. Failed". Look Link Below. Link2+ Oracle 11g Database Troubleshooting . On the first screen Just Leave eMail Blank and Un-Check the Demand of Security Update Support then Click on Next Then Confirm on Warning and Follow. On "Select Installation Option" Select "Install database software only" and Click on Next . On Step 3 Leave Default "Single instance database installation" and Click on Next . On Step 4 Select your Language and Click on Next On Step 5 Leave Default Enterprise Edition and Click on Next On "Installation Location" Set All As Here Below and Click on Next Oracle Base: /u01/app/oracle Software Location: /u01/app/oracle/product/11.2.0/dbhome_1 These are the Same Settings Inserted into the .bashrc File... On "Create Inventory" if you Setup the Path on .bashrc Like Here Leave Default and Click on Next . On "Operating System Groups" if you Setup the Path on .bashrc Like Here Leave Default and Click on Next . On "Prerequisite Checks" you will Get Easily a "Warning Message" about some Missing Requirements Just Check: "Ignore All" and Follow Up with Installation... Check Ignore All and Follow... On the "Summary" Click on "Save Response File" to Take Note of Settings and then Click on Finish or Install . The Installation Product Procedure should Start... Solving Errors in invoking target 'install' & 'agent nmhs' Troubleshooting for Libraries Linking Errors Troubleshooting Oracle 11g Db Setup Execute Scripts Right Before the End of Process a Pop-Up Window will Show the Path to Two Configuration Scripts you Need to Execute on Terminal! Next Oracle Should Confirm you of the Successful Installation Achivement.) . 13. Making a Listenere How to Create and Run an Oracle 11g Listener Oracle 11g DB Listener Guide Make Oracle Listener This Step is Required to Run the Database. 14. Creating Database How to Create an Oracle 11g Database Instance Oracle 11g Database Guide Make Oracle Db

How to Install Oracle 11g R2 Database on Ubuntu 16.04 Xenial LTS 64-bit Easy Guide

Installing Database

13. Making a Listenere

14. Creating Database

Contents