{"id":80,"date":"2015-12-06T19:51:21","date_gmt":"2015-12-06T17:51:21","guid":{"rendered":"http:\/\/geekinto.com\/?p=80"},"modified":"2015-12-15T17:48:14","modified_gmt":"2015-12-15T15:48:14","slug":"80","status":"publish","type":"post","link":"https:\/\/howoracleapex.com\/?p=80","title":{"rendered":"Installing Java, Oracle 11g R2 Express Edition and SQL Developer on Ubuntu\/Mint 64-bit"},"content":{"rendered":"

\u00a0Installing Java<\/h2>\n
\n
\n

We start with installing Java on the machine. My personal preference is to use Oracle Java JDK. Installing this JDK could be done easily by performing the following statements.<\/p>\n

sudo add-apt-repository ppa:webupd8team\/java\r\nsudo apt-get update\r\nsudo apt-get install oracle-java7-installer<\/pre>\n
Notice::<\/strong>
\nYou can change version from “oracle-java7-installer” to\u00a0“oracle-java6-installer” or\u00a0“oracle-java8-installer” .. as you want \ud83d\ude42<\/span><\/p>\n
The screen in figure 1 will appear in the terminal, hit enter to proceed. After this, the screen in figure 2 will be shown. Navigate to <Yes> using the left arrow on your keyboard and hit enter. Oracle JDK 7 will be installed.<\/p>\n
\"\"<\/p>\n
\"\"<\/p>\n
To validate the Java installation, execute the following command:<\/p>\n
java -version<\/pre>\n
This should result in the following (or something similar).<\/p>\n
\n
\n
java version \u201c1.7.0_51\u201d\r\nJava(TM) SE Runtime Environment (build 1.7.0_51-b13)\r\nJava HotSpot(TM) 64-Bit Server VM (build 24.51-b03, mixed mode)<\/pre>\n
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.<\/p>\n
sudo gedit \/etc\/bash.bashrc<\/pre>\n
Scroll to the bottom of the file and add the following lines<\/p>\n
export JAVA_HOME=\/usr\/lib\/jvm\/java-7-oracle\r\nexport PATH=$JAVA_HOME\/bin:$PATH<\/pre>\n
Save the file and close the editor. To load the changes, execute the following statement.<\/p>\n
source \/etc\/bash.bashrc<\/pre>\n
To validate the changes you can execute the following statement.<\/p>\n
echo $JAVA_HOME<\/pre>\n
The result of this statement should be the following.<\/p>\n
\/usr\/lib\/jvm\/java-7-oracle<\/pre>\n
Installing Oracle 11g R2 Express Edition<\/h2>\n
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.<\/p>\n
sudo apt-get install alien libaio1 unixodbc<\/pre>\n
The next step is to download the Oracle 11g R2 Express Edition from the Oracle website. Make sure you select the Linux x64 version from http:\/\/www.oracle.com\/technetwork\/products\/express-edition\/downloads\/index.html<\/a>.\u00a0After the download is completed, open the terminal and navigate to the download directory. In my case this can be done by executing the following statement.<\/p>\n
cd Downloads<\/pre>\n
The next step step is to unzip the downloaded file. To do this, execute the following command.<\/p>\n
unzip oracle-xe-11.2.0-1.0.x86_64.rpm.zip<\/pre>\n
A new directory (Disk1) is added to the Download directory. Navigate to this directory:<\/p>\n
cd Disk1<\/pre>\n
ow 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. When the -scripts parameter is toggled, alien will try to convert the scripts that are meant to be run when the package is installed and removed.<\/p>\n
sudo alien --scripts -d oracle-xe-11.2.0-1.0.x86_64.rpm<\/pre>\n
This step may take a while, while this statement is executing we can do the following steps. Open a new terminal window for these steps.<\/p>\n
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.<\/p>\n
sudo gedit \/sbin\/chkconfig<\/pre>\n
Copy and paste the following into the editor:<\/p>\n
#!\/bin\/bash\r\n# Oracle 11gR2 XE installer chkconfig hack for Ubuntu\r\nfile=\/etc\/init.d\/oracle-xe\r\nif [[ ! `tail -n1 $file | grep INIT` ]]; then\r\necho >> $file\r\necho '### BEGIN INIT INFO' >> $file\r\necho '# Provides: OracleXE' >> $file\r\necho '# Required-Start: $remote_fs $syslog' >> $file\r\necho '# Required-Stop: $remote_fs $syslog' >> $file\r\necho '# Default-Start: 2 3 4 5' >> $file\r\necho '# Default-Stop: 0 1 6' >> $file\r\necho '# Short-Description: Oracle 11g Express Edition' >> $file\r\necho '### END INIT INFO' >> $file\r\nfi\r\nupdate-rc.d oracle-xe defaults 80 01\r\n#EOF<\/pre>\n
Save the file and close the editor. Now we have to provide the file with the appropriate execution privileges.<\/p>\n
sudo chmod 755 \/sbin\/chkconfig<\/pre>\n
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.<\/p>\n
sudo gedit \/etc\/sysctl.d\/60-oracle.conf<\/pre>\n
Copy and paste the following into the file. Kernel.shmmax is the maximum possible value of physical RAM in bytes. 536870912<\/strong><\/span> \/ 1024 \/1024 = 512 MB.<\/p>\n
Notice::
\nif your RAM is 8G
\ncalculate you 8G RAM by … 8*1024*1024*1024=8589934592<\/span><\/strong><\/p>\n
# Oracle 11g XE kernel parameters\r\nfs.file-max=6815744\r\nnet.ipv4.ip_local_port_range=9000 65000\r\nkernel.sem=250 32000 100 128\r\nkernel.shmmax=536870912<\/pre>\n
Save the file. The changes in this file may be verified by executing:<\/p>\n
sudo cat \/etc\/sysctl.d\/60-oracle.conf<\/pre>\n
Load the kernel parameters:<\/p>\n
sudo service procps start<\/pre>\n
The changes may be verified again by executing:<\/p>\n
sudo sysctl -q fs.file-max<\/pre>\n
This method should return the following:<\/p>\n
\n
\n\n\n\n
<\/td>\n\n
\n
fs.file-max = 6815744<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n
After this, execute the following statements to make some more required changes:<\/p>\n
sudo ln -s \/usr\/bin\/awk \/bin\/awk\r\nmkdir \/var\/lock\/subsys\r\ntouch \/var\/lock\/subsys\/listener<\/pre>\n
Close the second terminal window and return to the first terminal window. The rpm package should be converted and a new file called oracle-xe-11.2.0-2_amd64.deb have been generated. To run this file, execute the following command:<\/p>\n
sudo dpkg --install oracle-xe_11.2.0-2_amd64.deb<\/pre>\n
Execute the following to avoid getting a ORA-00845: MEMORY_TARGET error. Note:<\/strong> replace \u201csize=4096m\u201d with the size of your (virtual) machine\u2019s RAM in MBs.<\/p>\n<\/div>\n<\/div>\n
sudo rm -rf \/dev\/shm\r\nsudo mkdir \/dev\/shm\r\nsudo mount -t tmpfs shmfs -o size=4096m \/dev\/shm<\/pre>\n
Create the file \/etc\/rc2.d\/S01shm_load.<\/p>\n
sudo gedit \/etc\/rc2.d\/S01shm_load<\/pre>\n
Copy and paste the following in the file. Note:<\/strong> replace \u201csize=4096m\u201d with the size of your machine\u2019s RAM in MBs.<\/p>\n
#!\/bin\/sh\r\ncase \"$1\" in\r\nstart) mkdir \/var\/lock\/subsys 2>\/dev\/null\r\ntouch \/var\/lock\/subsys\/listener\r\nrm \/dev\/shm 2>\/dev\/null\r\nmkdir \/dev\/shm 2>\/dev\/null\r\nmount -t tmpfs shmfs -o size=4096m \/dev\/shm ;;\r\n*) echo error\r\nexit 1 ;;\r\nesac<\/pre>\n
Save the file, close the editor and provide the appropriate execution privileges.<\/p>\n
sudo chmod 755 \/etc\/rc2.d\/S01shm_load<\/pre>\n
Configuring Oracle 11g R2 Express Edition<\/h2>\n
If you have successfully installed to Oracle 11g R2 Express Edition server, it\u2019s time to configure the server. To start the configuration of the server, execute the following command and follow the \u201cwizard\u201d in the terminal. Default values are shown between brackets for each question.<\/p>\n
sudo \/etc\/init.d\/oracle-xe configure\r\n<\/pre>\n
Now it is time to set-up some environmental variables. Open the \/etc\/bash.bashrc file by executing the following statement:<\/p>\n
sudo gedit \/etc\/bash.bashrc<\/pre>\n
Scroll to the bottom of the file and add the following lines.<\/p>\n
export ORACLE_HOME=\/u01\/app\/oracle\/product\/11.2.0\/xe\r\nexport ORACLE_SID=XE\r\nexport NLS_LANG=`$ORACLE_HOME\/bin\/nls_lang.sh`\r\nexport ORACLE_BASE=\/u01\/app\/oracle\r\nexport LD_LIBRARY_PATH=$ORACLE_HOME\/lib:$LD_LIBRARY_PATH\r\nexport PATH=$ORACLE_HOME\/bin:$PATH<\/pre>\n
Save the file and close the editor. To load the changes, execute the following statement:<\/p>\n
source \/etc\/bash.bashrc<\/pre>\n
To validate the changes you can execute the following statement.<\/p>\n
echo $ORACLE_HOME\r\n<\/pre>\n
\n
This statement should result in the following output.<\/div>\n<\/div>\n
\n
\n
\/u01\/app\/oracle\/product\/11.2.0\/xe<\/pre>\n
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:<\/p>\n
sudo service oracle-xe start<\/pre>\n<\/div>\n<\/div>\n
A file named oraclexe-gettingstarted.desktop is placed on your desktop. To make this file executable, navigate to you desktop.<\/p>\n
cd ~\/Desktop<\/pre>\n
To make the file executable, execute the following statement.<\/p>\n
sudo chmod a+x oraclexe-gettingstarted.desktop\r\n<\/pre>\n
\n
\n
Installing SQL Developer \u00a0\/Tow Method<\/h2>\n
#Method 1<\/strong><\/span><\/em><\/span><\/p>\n
Finally, after the installation of Oracle 11g R2 Express Edition and Java, SQL Developer could be installed. This is done by performing the following steps.<\/p>\n
Download Oracle SQL Developer from the Oracle site. Select the Linux RPM package:\u00a0http:\/\/www.oracle.com\/technetwork\/developer-tools\/sql-developer\/downloads\/index.html<\/a>.\u00a0Open a terminal window and navigate to the Download directory:<\/p>\n
\n
\n
cd Downloads<\/pre>\n<\/div>\n<\/div>\n
Convert the Red Hat package to a Ubuntu package. Note: this may take a while.<\/p>\n
sudo alien --scripts -d sqldeveloper-4.0.0.13.80-1.noarch.rpm\r\n<\/pre>\n
A file named sqldeveloper_4.0.0.13.80-2_all.deb will be generated. To run this file, execute the following statement:<\/p>\n
sudo dpkg --install sqldeveloper_4.0.0.13.80-2_all.deb<\/pre>\n
Create a .sqldeveloper directory in your home folder:<\/p>\n
sudo mkdir \/home\/.sqldeveloper\/<\/pre>\n
Run SQL Developer from the terminal.<\/p>\n
\n
\n
sudo \/opt\/sqldeveloper\/sqldeveloper.sh<\/pre>\n<\/div>\n<\/div>\n
Now enter the full Java path. In my case this is done as follows:<\/p>\n
\/usr\/lib\/jvm\/java-7-oracle<\/pre>\n
These steps worked for me to install Oracle XE and SQL Developer on Ubuntu 64-bit, and have been validated by one of my colleagues. I am curious to know if it worked for you. Please also let me know if you find any mistakes or have any additions to make this script better.<\/p>\n<\/div>\n<\/div>\n
——<\/p>\n
#Method 2<\/strong><\/em><\/span><\/p>\n
o get the SQLDeveloper download, you will need an Oracle Technet account. Fortunately, this is free.
\nYou can do this by going to the Technet Home Page<\/a>.<\/p>\n
Once you\u2019re set up, go to the SQLDeveloper Downloads Page<\/a>.<\/p>\n
There are a couple of things to note here.
\nFirst, the package you need to download is labelled Other Platforms<\/strong>.
\nSecondly, if you do happen to look at the Release instructions for this package, it will mention JDK 1.6.0_11 or above.
\nThese instructions are out of date in this regard and refer to the previous version of SQLDeveloper.<\/p>\n
Anyway, on the download page, click accept License Agreement and click on the Other Platforms Download.<\/p>\n
\"\"<\/p>\n
\n
\n
At this point, you may be asked to re-enter your Technet credentials.<\/p>\n
When prompted by Mint, save the file.<\/p>\n
Once completed, go to the Downloads directory and you should see\u2026<\/p>\n
cd $HOME\/Downloads\r\nls sqldeveloper-4.0.1.14.48-no-jre.zip\r\nsqldeveloper-4.0.1.14.48-no-jre.zip<\/pre>\n
INSTALLING SQLDEVELOPER4<\/strong><\/h3>\n
We\u2019re going to install SQLDeveloper under \/opt so\u2026<\/p>\n
sudo mkdir \/opt\/sqldeveloper4<\/pre>\n
Now to copy and extract the zip file \u2026<\/p>\n
sudo cp $HOME\/Downloads\/sqldeveloper-4.0.1.14.48-no-jre.zip \/opt\/sqldeveloper4\/\r\ncd \/opt\/sqldeveloper4\r\nsudo <\/code>unzip sqldeveloper-4.0.1.14.48-no-jre.zip<\/code><\/pre>\n
Once completed, we\u2019re now ready to finalise the configuration.<\/p>\n
Setting the Java Path for SQLDeveloper<\/strong><\/h4>\n
To do this, we simply need to run SQLDeveloper. The first time it starts, it will ask for a path to the JDK.
\nThis will be the path we figured out earlier. So\u2026<\/p>\n
cd \/opt\/sqldeveloper4\/sqldeveloper\r\nsudo chmod a+x sqldeveloper.sh\r\n.\/sqldeveloper.sh<\/pre>\n
When we execute the shell script to start SQLDeveloper we\u2019ll get SQLDeveloper SCREEN \u2026<\/p>\n
At this point, we enter the path, minus the bin directory (which SQLDeveloper will look in automatically) :<\/p>\n
Now request v of java ..<\/p>\n
Open terminal else and type:<\/p>\n
echo $JAVA_HOME<\/pre>\n
Return like ..
\n\/usr\/lib\/jvm\/java-7-oracle<\/p>\n
copy returned value to path request ..<\/p>\n<\/div>\n
\n
If you have a previous version of SQLDeveloper installed, you will be asked if you want to copy all the settings, connections etc to the latest version :
\n\"\"<\/p>\n
Finally, SQLDeveloper will start.<\/p>\n
Adding SQLDeveloper4 to the Cinnamon Menu<\/strong><\/h4>\n
To add SQLDeveloper to the menu\u2026<\/p>\n
Right-click the Menu in the bottom left corner of the screen and select Configure<\/strong> :
\n\"\"<\/p>\n
Click the Open the menu editor<\/strong> button.<\/p>\n
\"menu_editor\"<\/a><\/p>\n
Select New Item<\/strong><\/p>\n
Name<\/strong> : SQLDeveloper4.0.1
\nCommand<\/strong> : \/opt\/sqldeveloper4\/sqldeveloper\/sqldeveloper.sh<\/p>\n
Click on the rocket icon and select the sqldeveloper icon at :
\n\/opt\/sqldeveloper4\/sqldeveloper<\/em><\/p>\n
Now you should see the SQLDeveloper4.0.1 option under the Programming Menu.<\/p>\n
After all that, I feel like a cup of coffee. Now where did I leave that Sonic Screwdriver\u2026<\/p>\n
Good luck! .. \ud83d\ude42<\/span><\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"
\u00a0Installing Java We start with installing Java on the machine. My personal preference is to use Oracle Java JDK. Installing this JDK could be done easily by performing the following statements. sudo add-apt-repository ppa:webupd8team\/java...<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4,2,21],"tags":[],"class_list":["post-80","post","type-post","status-publish","format-standard","hentry","category-dba","category-oracle","category-sql-developer"],"_links":{"self":[{"href":"https:\/\/howoracleapex.com\/index.php?rest_route=\/wp\/v2\/posts\/80","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/howoracleapex.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/howoracleapex.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/howoracleapex.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/howoracleapex.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=80"}],"version-history":[{"count":5,"href":"https:\/\/howoracleapex.com\/index.php?rest_route=\/wp\/v2\/posts\/80\/revisions"}],"predecessor-version":[{"id":85,"href":"https:\/\/howoracleapex.com\/index.php?rest_route=\/wp\/v2\/posts\/80\/revisions\/85"}],"wp:attachment":[{"href":"https:\/\/howoracleapex.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=80"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/howoracleapex.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=80"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/howoracleapex.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=80"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}