Installing
Oracle SQL Developer & Oracle 11g Database in Ubuntu
Install
Oracle JAVA10 in ubuntu 16.04
sudo
add-apt-repository ppa:webupd8team/java
sudo apt-get
update
sudo apt-get
install oracle-java8-installer
To validate the Java installation, execute the following
command:
java -version
This should result in the following (or something similar).
java version “1.7.0_51”
Java(TM) SE Runtime Environment (build 1.7.0_51-b13)
Java HotSpot(TM) 64-Bit Server VM (build 24.51-b03, mixed
mode)
The next next step is to set the JAVA_HOME environment
variable. To do this, open the /etc/bash.bashrc file by executing the following
statement.
sudo gedit /etc/bash.bashrc
Scroll to the bottom of the file and add the following
lines.
export JAVA_HOME=/usr/lib/jvm/java-8-oracle
export PATH=$JAVA_HOME/bin:$PATH
Save the file and close the editor. To load the changes,
execute the following statement.
source /etc/bash.bashrc
To validate the changes you can execute the following
statement.
echo $JAVA_HOME
The result of this statement should be the following.
/usr/lib/jvm/java-8-oracle
generate soft
link for sqldeveloper.sh
sudo ln -s
~/Downloads/sqldeveloper/sqldeveloper.sh /usr/local/bin/sqldeveloper
Open file
sqldeveloper.sh using gedit
$gedit
sqldeveloepr.sh
#!/bin/bash
#cd
"`dirname $0`"/sqldeveloper/bin && bash sqldeveloper $*
unset -v
GNOME_DESKTOP_SESSION_ID
cd
~/Downloads/sqldeveloper/sqldeveloper/bin && bash sqldeveloper $*
Save
now type $sqldeveloper
on command line to open SQLdeveloper
Installing Oracle
Database 11g in Ubuntu 16.04
For the
installation of Oracle 11g R2 Express Edition (XE), a couple of additional
Linux packages are required. These packages can be installed by executing the
following statement.
sudo apt-get
install alien libaio1 unixodbc
The next step
is to download the Oracle 11g R2 Express Edition from the Oracle website.
cd Downloads
The next step
step is to unzip the downloaded file. To do this, execute the following
command.
unzip
oracle-xe-11.2.0-1.0.x86_64.rpm.zip
A new
directory (Disk1) is added to the Download directory. Navigate to this
directory:
cd Disk1
Now we have
to convert the Red Hat package (rpm) to a Debian package. This may be done
using the alien command. The -d parameter is used to inform alien that a Debian
package should be generated.
sudo alien
--scripts -d oracle-xe-11.2.0-1.0.x86_64.rpm
The Red Hat
package, relies on the /sbin/chkconfig file, which is not used in Ubuntu. To
successfully install Oracle XE we use a simple trick. Start by creating a
custom /sbin/chkconfig file by executing the following statement.
sudo gedit
/sbin/chkconfig
Copy and
paste the following into the editor:
#!/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
#EOF
Save the file and close the editor. Now we have to provide the file with the appropriate execution privileges.
sudo chmod
755 /sbin/chkconfig
After this,
we have to create the file /etc/sysctl.d/60-oracle.conf to set the additional
kernel parameters. Open the file by executing the following statement.
sudo gedit
/etc/sysctl.d/60-oracle.conf
Copy and paste the following into the file. Kernel.shmmax is the maximum possible value of physical RAM in bytes. 536870912 / 1024 /1024 = 512 MB.
# 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
Save the
file. The changes in this file may be verified by executing:
sudo cat
/etc/sysctl.d/60-oracle.conf
Load the
kernel parameters:
sudo service
procps start
The changes
may be verified again by executing:
sudo sysctl
-q fs.file-max
This method
should return the following:
fs.file-max =
6815744
After this,
execute the following statements to make some more required changes:
sudo ln -s
/usr/bin/awk /bin/awk
mkdir /var/lock/subsys
touch
/var/lock/subsys/listener
Close the
second terminal window and return to the first terminal window.
sudo dpkg
--install oracle-xe_11.2.0-2_amd64.deb
NOTE THE PASSWORD YOU WOULD SPECIFY HERE FOR YOUR DATABASE. YOU WOULD BEED THAT TO CONNECT WHILE ACCESSING DATABASE FROM SQL DEVELOPER !
Execute the
following to avoid getting a ORA-00845: MEMORY_TARGET error. Note: replace
“size=4096m” with the size of your machine’s RAM in MBs.
sudo rm -rf
/dev/shm
sudo mkdir
/dev/shm
sudo mount -t
tmpfs shmfs -o size=4096m /dev/shm
Create the
file /etc/rc2.d/S01shm_load.
sudo gedit
/etc/rc2.d/S01shm_load
Copy and
paste the following in the file. Note: replace “size=4096m” with the size of
your machine’s RAM in MBs.
#!/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
mount -t
tmpfs shmfs -o size=4096m /dev/shm ;;
*) echo error
exit 1 ;;
esac
Save the
file, close the editor and provide the appropriate execution privileges.
sudo chmod
755 /etc/rc2.d/S01shm_load
Configuring
Oracle 11g R2 Express Edition
If you have
successfully installed to Oracle 11g R2 Express Edition server, it’s time to
configure the server. Default values are shown between brackets for each
question.
sudo
/etc/init.d/oracle-xe configure
Now it is
time to set-up some environmental variables. Open the /etc/bash.bashrc file by
executing the following statement:
sudo gedit /etc/bash.bashrc
Scroll to the
bottom of the file and add the following lines.
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
Save the file
and close the editor. To load the changes, execute the following statement:
source
/etc/bash.bashrc
To validate
the changes you can execute the following statement.
echo
$ORACLE_HOME
This
statement should result in the following output.
/u01/app/oracle/product/11.2.0/xe
After this
step it is recommended to reboot the machine. After the reboot is completed, you
should be able to start the Oracle server using the following command:
sudo service
oracle-xe start
A file named
oraclexe-gettingstarted.desktop is placed on your desktop. To make this file
executable, navigate to you desktop.
cd ~/Desktop
To make the
file executable, execute the following statement.
sudo chmod
a+x oraclexe-gettingstarted.desktop
Now, you got your Oracle 11g Database installed in Ubuntu 16.04 with its Desktop icon also.
Next step is to open Oracle SQL Developer and connect it to Database using specified password (set during database installation).
Hope you would have understood the steps. Feel free to contact in case of any issue!
Happy Learning :-)
