{"id":474,"date":"2012-09-09T23:14:04","date_gmt":"2012-09-10T04:14:04","guid":{"rendered":"http:\/\/otac.isa-geek.net\/blog\/?p=474"},"modified":"2012-09-09T23:14:04","modified_gmt":"2012-09-10T04:14:04","slug":"12-everywhere-installing-oracle-r12-on-ubuntu-12-04","status":"publish","type":"post","link":"https:\/\/otac.isa-geek.net\/blog\/?p=474","title":{"rendered":"12 Everywhere: Installing Oracle R12 on Ubuntu 12.04"},"content":{"rendered":"<p>I previously put together instructions for deploying <a href=\"http:\/\/www.oracle.com\/us\/products\/applications\/ebusiness\/overview\/index.html\">Oracle Enterprise Business Suite<\/a> (EBS) 11i on <a href=\"http:\/\/www.ubuntu.com\/\">Ubuntu<\/a> 7.04 (<a href=\"http:\/\/otac.isa-geek.net\/blog\/2007\/12\/18\/105-installing-oracle-ebusiness-suite-on-ubuntu\">Installing Oracle eBusiness Suite on Ubuntu<\/a>). In this go-round, I am working through the steps to deploy the latest release of Oracle&#8217;s ERP (R12) on the latest Ubuntu server platform, 12.04. Although Ubuntu is not an Oracle-supported platform for R12, it is a stable, well-maintained, and popular Linux environment, with tremendous acceptance and community support. This makes it a great candidate for some third-party investigation on the steps required to render it a suitable infrastructure choice for ERP deployment.<br \/>\nI won&#8217;t repeat\u00a0 the mechanism for procuring the install media for R12; this was covered in my original <a href=\"http:\/\/otac.isa-geek.net\/blog\/2007\/12\/18\/105-installing-oracle-ebusiness-suite-on-ubuntu\">11i\/Ubuntu post<\/a>. It has all\u00a0 the instructions for\u00a0 downloading R12 from the <span>Oracle\u00ae E-Delivery Web site<\/span> (<a href=\"http:\/\/edelivery.oracle.com\/\">http:\/\/edelivery.oracle.com\/<\/a>), as well as how to prepare the staging folder for the R12 install (<a title=\"Installing Oracle eBusiness Suite on Ubuntu - II\" href=\"http:\/\/otac.isa-geek.net\/blog\/2007\/12\/20\/106-installing-oracle-ebusiness-suite-on-ubuntu-ii\">Installing Oracle eBusiness Suite on Ubuntu \u2013 II<\/a>).<\/p>\n<p>The following\u00a0 instructions also assume that R12 is being installed on a 32-bit Ubuntu Precise (12.04) server environment. Since this is for demo purposes that uses the preset Oracle EBS Vision instance, I used\u00a0 a throw-away <a href=\"https:\/\/www.virtualbox.org\/\">VirtualBox<\/a> environment with 400 GB of storage, and 4 GB of RAM allocated. Since the base Ubuntu server install does not have a GUI out of the box, I\u00a0 installed the ubuntu-desktop package:<\/p>\n<p><strong>$ sudo apt-get install ubuntu-desktop<\/strong><\/p>\n<p>This permitted me to perform\u00a0 my installation investigations easily, and then dispose of the environment quickly and easily to stay within Oracle licensing guidelines. So, on to the steps.<\/p>\n<p><strong>Prerequisites<\/strong><\/p>\n<p>i. Create <strong>oracle<\/strong> user in the Ubuntu 12 environment to own the oracle installation.<\/p>\n<p>$ <strong>sudo adduser oracle<\/strong><\/p>\n<p>ii. Create group dba, and add oracle user to the dba group to allow Oracle DBMS system admin login and management of the 11g RDBMS.<\/p>\n<p><strong>\u00a0$ sudo adduser oracle dba<\/strong><\/p>\n<p>iii. Sign in as the new oracle user, and ensure that the stage directory is available. For my purposes, I copied the stage folder into the oracle home\u00a0 in a sub-directory <strong>stage12i<\/strong>.<br \/>\niv.\u00a0 Update software and dependent packages for the install:<\/p>\n<p><span style=\"text-decoration: underline;\">Unzip<\/span><\/p>\n<p>Download unzip version 5.52 from <a href=\"http:\/\/launchpadlibrarian.net\/12763424\/unzip_5.52-10ubuntu1.1_i386.deb\">http:\/\/launchpadlibrarian.net\/12763424\/unzip_5.52-10ubuntu1.1_i386.deb<\/a><\/p>\n<p>Remove current version using:<\/p>\n<p><strong>oracle@madara:~$ sudo apt-get remove unzip<\/strong><\/p>\n<p>Then install 5.52 version using:<\/p>\n<p><strong>oracle@madara:~$ sudo dpkg -i &#8216;unzip_5.52-10ubuntu1.1_i386.deb&#8217;<\/strong><\/p>\n<p><span style=\"text-decoration: underline;\">Oracle 11gR2 dependencies<\/span><\/p>\n<p>Install the following packages to meet library dependency requirements:<\/p>\n<p><strong>oracle@madara:~$ sudo apt-get install alien binutils build-essential cpp-4.4 debhelper g++-4.4 gawk gcc-4.4 gcc-4.4-base gettext html2text intltool-debian ksh lesstif2 bzip2 lib64z1 libaio-dev libaio1 libbeecrypt7 libc6 libc6-dev libdb4.8 libelf-dev libelf1 libltdl-dev libltdl7 libmotif4 libodbcinstq4-1 libodbcinstq4-1:i386 libqt4-core libqt4-gui libsqlite3-0 libstdc++5 libstdc++6 libstdc++6-4.4-dev lsb lsb-core lsb-cxx lsb-desktop lsb-graphics lsb-qt4 make odbcinst pax po-debconf rpm rpm-common sysstat unixodbc unixodbc-dev libdb1-compat<\/strong><\/p>\n<p>v. Configure kernel parameters:<\/p>\n<p>First check the current kernel parameter values:<\/p>\n<p><strong>oracle@madara:~$ sysctl -a | grep sem<\/strong><br \/>\n<strong>oracle@madara:~$ sysctl -a | grep shm<\/strong><br \/>\n<strong>oracle@madara:~$ sysctl -a | grep file-max<\/strong><br \/>\n<strong>oracle@madara:~$ sysctl -a | grep ip_local_port_range<\/strong><br \/>\n<strong>oracle@madara:~$ sysctl -a | grep rmem_default<\/strong><br \/>\n<strong>oracle@madara:~$ sysctl -a | grep rmem_max<\/strong><br \/>\n<strong>oracle@madara:~$ sysctl -a | grep wmem_default<\/strong><br \/>\n<strong>oracle@madara:~$ sysctl -a | grep wmem_max<\/strong><\/p>\n<p>Then edit the <strong>\/etc\/sysctl.conf<\/strong> and add the following lines:<\/p>\n<pre>fs.aio-max-nr = 1048576\r\nfs.file-max = 6815744\r\nkernel.shmall = 2097152\r\nkernel.shmmax = 536870912\r\nkernel.shmmni = 4096\r\nkernel.sem = 250 32000 100 128\r\nnet.ipv4.ip_local_port_range = 9000 65500\r\nnet.core.rmem_default = 262144\r\nnet.core.rmem_max = 4194304\r\nnet.core.wmem_default = 262144\r\nnet.core.wmem_max = 1048586<\/pre>\n<p>Run the following command to reload these kernel parameters:<\/p>\n<p><strong>oracle@madara:~$ sudo sysctl -p<\/strong><\/p>\n<p>vi.\u00a0 Put in a fake Redhat flag file to fool the installer:<\/p>\n<p><strong>oracle@madara:~$ sudo echo &#8216;Red Hat Linux release 5&#8217; &gt; \/etc\/redhat-release<\/strong><\/p>\n<p>vii. Link expected locations for dependency library files to the source files in Ubuntu:<\/p>\n<p><strong>oracle@madara:~$sudo ln -s \/lib\/i386-linux-gnu\/libgcc_s.so.1 \/usr\/lib\/<\/strong><br \/>\n<strong>oracle@madara:~$sudo ln -s \/usr\/bin\/awk \/bin\/awk<\/strong><br \/>\n<strong>oracle@madara:~$sudo ln -s \/usr\/bin\/basename \/bin\/basename<\/strong><br \/>\n<strong>oracle@madara:~$sudo ln -s \/usr\/bin\/rpm \/bin\/rpm<\/strong><br \/>\n<strong>oracle@madara:~$sudo ln -s \/usr\/lib\/i386-linux-gnu\/libc_nonshared.a \/usr\/lib\/<\/strong><br \/>\n<strong>oracle@madara:~$sudo ln -s \/usr\/lib\/i386-linux-gnu\/libpthread_nonshared.a \/usr\/lib\/<\/strong><br \/>\n<strong>oracle@madara:~$sudo ln -s \/usr\/lib\/i386-linux-gnu\/libstdc++.so.6 \/usr\/lib\/<\/strong><\/p>\n<p>viii. Verify shared memory is configured correctly for the 11g database:<\/p>\n<p>Check shared memory device <strong>\/run\/shm<\/strong> with command:<\/p>\n<p>$ <strong>df -hk<\/strong><\/p>\n<p>Filesystem 1K-blocks Used Available Use% Mounted on<\/p>\n<p>\/dev\/mapper\/madara-root 409441664 59198564 329444636 16% \/<\/p>\n<p>udev 1553456 4 1553452 1% \/dev<\/p>\n<p>tmpfs 624404 948 623456 1% \/run<\/p>\n<p>none 5120 0 5120 0% \/run\/lock<\/p>\n<p>none 1561008 156 1560852 1% \/run\/shm<\/p>\n<p>cgroup 1561008 0 1561008 0% \/sys\/fs\/cgroup<\/p>\n<p>\/dev\/sda1 233191 46981 173769 22% \/boot<\/p>\n<p>Update <strong>\/etc\/fstab<\/strong>, adding line below to change the shared memory <strong>\/run\/shm\/<\/strong> filesystem from none to tmpfs:<\/p>\n<p><strong>tmpfs \/run\/shm tmpfs defaults,noexec,nosuid 0 0 <\/strong><\/p>\n<p>ix. Reboot to make sure kernel params and shared memory change are detected.<\/p>\n<p>x. Create the instance directory for the R12 install, setting the permissions so it can be updated by the oracle owner:<\/p>\n<p><strong>oracle@madara:~$ sudo mkdir \/d01<\/strong><\/p>\n<p><strong>oracle@madara:~$ sudo chmod 777 \/d01<\/strong><\/p>\n<p>xi. Run the R12 Rapid Installer:<\/p>\n<p><strong>oracle@madara:~$\u00a0cd stage12i\/startCD\/Disk1\/rapidwiz<\/strong><\/p>\n<p><strong>oracle@madara:~$\u00a0.\/rapidwiz<\/strong><\/p>\n<p>Rapid Install Wizard is validating your file system&#8230;&#8230;<\/p>\n<p>4 dvd labels found<\/p>\n<p>Rapid Install Wizard will now launch the Java Interface&#8230;..<\/p>\n<table>\n<tbody>\n<tr>\n<td>\n<p><div id=\"attachment_519\" style=\"width: 160px\" class=\"wp-caption alignnone\"><a href=\"http:\/\/otac.isa-geek.net\/blog\/wp-content\/uploads\/2012\/09\/EBS_R12_Ubuntu_1204_post_html_m15200d84.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-519\" class=\"size-thumbnail wp-image-519\" title=\"R12 Rapid Install wizard\" src=\"http:\/\/otac.isa-geek.net\/blog\/wp-content\/uploads\/2012\/09\/EBS_R12_Ubuntu_1204_post_html_m15200d84-150x150.png\" alt=\"R12 Rapid Install wizard\" width=\"150\" height=\"150\" \/><\/a><p id=\"caption-attachment-519\" class=\"wp-caption-text\">R12 Rapid Install wizard<\/p><\/div><\/td>\n<td>\n<p><div id=\"attachment_520\" style=\"width: 160px\" class=\"wp-caption alignnone\"><a href=\"http:\/\/otac.isa-geek.net\/blog\/wp-content\/uploads\/2012\/09\/EBS_R12_Ubuntu_1204_post_html_692099fd1.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-520\" class=\"size-thumbnail wp-image-520\" title=\"Choose EBS install method\" src=\"http:\/\/otac.isa-geek.net\/blog\/wp-content\/uploads\/2012\/09\/EBS_R12_Ubuntu_1204_post_html_692099fd1-150x150.png\" alt=\"Choose EBS install method\" width=\"150\" height=\"150\" \/><\/a><p id=\"caption-attachment-520\" class=\"wp-caption-text\">Choose EBS install method<\/p><\/div><\/td>\n<td>\n<p><div id=\"attachment_515\" style=\"width: 160px\" class=\"wp-caption alignnone\"><a href=\"http:\/\/otac.isa-geek.net\/blog\/wp-content\/uploads\/2012\/09\/EBS_R12_Ubuntu_1204_post_html_m3ab14a5.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-515\" class=\"size-thumbnail wp-image-515\" title=\"Enter Oracle Support details\" src=\"http:\/\/otac.isa-geek.net\/blog\/wp-content\/uploads\/2012\/09\/EBS_R12_Ubuntu_1204_post_html_m3ab14a5-150x150.png\" alt=\"Enter Oracle Support details\" width=\"150\" height=\"150\" \/><\/a><p id=\"caption-attachment-515\" class=\"wp-caption-text\">Enter Oracle Support details<\/p><\/div><\/td>\n<\/tr>\n<\/tbody>\n<tbody>\n<tr>\n<td>\n<p><div id=\"attachment_516\" style=\"width: 160px\" class=\"wp-caption alignnone\"><a href=\"http:\/\/otac.isa-geek.net\/blog\/wp-content\/uploads\/2012\/09\/EBS_R12_Ubuntu_1204_post_html_m17bc98a6.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-516\" class=\"size-thumbnail wp-image-516\" title=\"Enter Express configuration etails (database, domain, home directory)\" src=\"http:\/\/otac.isa-geek.net\/blog\/wp-content\/uploads\/2012\/09\/EBS_R12_Ubuntu_1204_post_html_m17bc98a6-150x150.png\" alt=\"Enter Express configuration etails (database, domain, home directory)\" width=\"150\" height=\"150\" \/><\/a><p id=\"caption-attachment-516\" class=\"wp-caption-text\">Enter Express configuration etails (database, domain, home directory)<\/p><\/div><\/td>\n<td>\n<p><div id=\"attachment_509\" style=\"width: 160px\" class=\"wp-caption alignnone\"><a href=\"http:\/\/otac.isa-geek.net\/blog\/wp-content\/uploads\/2012\/09\/EBS_R12_Ubuntu_1204_post_html_2e6505f0.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-509\" class=\"size-thumbnail wp-image-509\" title=\"Install running prerequisite checks (space, network, executables)\" src=\"http:\/\/otac.isa-geek.net\/blog\/wp-content\/uploads\/2012\/09\/EBS_R12_Ubuntu_1204_post_html_2e6505f0-150x150.png\" alt=\"Install running prerequisite checks (space, network, executables)\" width=\"150\" height=\"150\" \/><\/a><p id=\"caption-attachment-509\" class=\"wp-caption-text\">Install running prerequisite checks (space, network, executables)<\/p><\/div><\/td>\n<td>\n<p><div id=\"attachment_511\" style=\"width: 160px\" class=\"wp-caption alignnone\"><a href=\"http:\/\/otac.isa-geek.net\/blog\/wp-content\/uploads\/2012\/09\/EBS_R12_Ubuntu_1204_post_html_6e9d6ba9.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-511\" class=\"size-thumbnail wp-image-511\" title=\"Prerequisite checks confirmed\" src=\"http:\/\/otac.isa-geek.net\/blog\/wp-content\/uploads\/2012\/09\/EBS_R12_Ubuntu_1204_post_html_6e9d6ba9-150x150.png\" alt=\"Prerequisite checks confirmed\" width=\"150\" height=\"150\" \/><\/a><p id=\"caption-attachment-511\" class=\"wp-caption-text\">Prerequisite checks confirmed<\/p><\/div><\/td>\n<\/tr>\n<tr>\n<td>\n<p><div id=\"attachment_517\" style=\"width: 160px\" class=\"wp-caption alignnone\"><a href=\"http:\/\/otac.isa-geek.net\/blog\/wp-content\/uploads\/2012\/09\/EBS_R12_Ubuntu_1204_post_html_m42d6f74d.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-517\" class=\"size-thumbnail wp-image-517\" title=\"Component Installation Review\" src=\"http:\/\/otac.isa-geek.net\/blog\/wp-content\/uploads\/2012\/09\/EBS_R12_Ubuntu_1204_post_html_m42d6f74d-150x150.png\" alt=\"Component Installation Review\" width=\"150\" height=\"150\" \/><\/a><p id=\"caption-attachment-517\" class=\"wp-caption-text\">Component Installation Review<\/p><\/div><\/td>\n<td>\n<p><div id=\"attachment_510\" style=\"width: 160px\" class=\"wp-caption alignnone\"><a href=\"http:\/\/otac.isa-geek.net\/blog\/wp-content\/uploads\/2012\/09\/EBS_R12_Ubuntu_1204_post_html_3c93e5a3.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-510\" class=\"size-thumbnail wp-image-510\" title=\"Rapid Installation Progress Dialog\" src=\"http:\/\/otac.isa-geek.net\/blog\/wp-content\/uploads\/2012\/09\/EBS_R12_Ubuntu_1204_post_html_3c93e5a3-150x150.png\" alt=\"Rapid Installation Progress Dialog\" width=\"150\" height=\"150\" \/><\/a><p id=\"caption-attachment-510\" class=\"wp-caption-text\">Rapid Installation Progress Dialog<\/p><\/div><\/td>\n<td>\n<p><div id=\"attachment_513\" style=\"width: 160px\" class=\"wp-caption alignnone\"><a href=\"http:\/\/otac.isa-geek.net\/blog\/wp-content\/uploads\/2012\/09\/EBS_R12_Ubuntu_1204_post_html_6332de8e.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-513\" class=\"size-thumbnail wp-image-513\" title=\"Post-install Checks completed successfully\" src=\"http:\/\/otac.isa-geek.net\/blog\/wp-content\/uploads\/2012\/09\/EBS_R12_Ubuntu_1204_post_html_6332de8e-150x150.png\" alt=\"Post-install Checks completed successfully\" width=\"150\" height=\"150\" \/><\/a><p id=\"caption-attachment-513\" class=\"wp-caption-text\">Post-install Checks completed successfully<\/p><\/div><\/td>\n<\/tr>\n<tr>\n<td>\n<p><div id=\"attachment_512\" style=\"width: 160px\" class=\"wp-caption alignnone\"><a href=\"http:\/\/otac.isa-geek.net\/blog\/wp-content\/uploads\/2012\/09\/EBS_R12_Ubuntu_1204_post_html_71ac556d.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-512\" class=\"size-thumbnail wp-image-512\" title=\"R12 Framework main screen\" src=\"http:\/\/otac.isa-geek.net\/blog\/wp-content\/uploads\/2012\/09\/EBS_R12_Ubuntu_1204_post_html_71ac556d-150x150.jpg\" alt=\"R12 Framework main screen\" width=\"150\" height=\"150\" \/><\/a><p id=\"caption-attachment-512\" class=\"wp-caption-text\">R12 Framework main screen<\/p><\/div><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p>These instructions are in no way a substitute for careful analysis and assessment of the requirements and purpose for a production R12 instance. However,\u00a0 hopefully this provides some guidance on the technical hurdles and resolutions to deploying R12 on an unsupported Linux variant.<\/p>\n<p>References:<\/p>\n<p>(Instant Client downloads for Linux x86:) <a href=\"http:\/\/www.oracle.com\/technetwork\/topics\/linuxsoft-082809.html\">http:\/\/www.oracle.com\/technetwork\/topics\/linuxsoft-082809.html<\/a><\/p>\n<p>(Oracle Database 11g Release 2 on Ubuntu 12.04 HOWTO) <a href=\"http:\/\/edin.no-ip.com\/comment\/418\">http:\/\/edin.no-ip.com\/comment\/418<\/a><\/p>\n<p>(Oracle Application R12 (12.1.3) Installation on Red Hat Linux &#8211; 64 bit) <a href=\"https:\/\/blogs.oracle.com\/ptian\/entry\/oracle_application_r12_12_1\">https:\/\/blogs.oracle.com\/ptian\/entry\/oracle_application_r12_12_1<\/a><\/p>\n<p>(Oracle EBS Vision Demo Default Application Passwords) <a href=\"http:\/\/swimmingpooldotnet.wordpress.com\/2011\/01\/29\/oracle-ebs-vision-demo-default-application-passwords\/\">http:\/\/swimmingpooldotnet.wordpress.com\/2011\/01\/29\/oracle-ebs-vision-demo-default-application-passwords\/<\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I previously put together instructions for deploying Oracle Enterprise Business Suite (EBS) 11i on Ubuntu 7.04 (Installing Oracle eBusiness Suite on Ubuntu). In this go-round, I am working through the steps to deploy the latest release of Oracle&#8217;s ERP (R12) on the latest Ubuntu server platform, 12.04. Although Ubuntu is not an Oracle-supported platform for [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7,37,57,86,44],"tags":[82,83,84,65,66,85],"class_list":["post-474","post","type-post","status-publish","format-standard","hentry","category-oracle","category-ebs","category-oracle-virtualbox","category-r12","category-ubuntu","tag-erp","tag-linux","tag-oracle","tag-oracle-ebs","tag-r12","tag-ubuntu"],"_links":{"self":[{"href":"https:\/\/otac.isa-geek.net\/blog\/index.php?rest_route=\/wp\/v2\/posts\/474","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/otac.isa-geek.net\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/otac.isa-geek.net\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/otac.isa-geek.net\/blog\/index.php?rest_route=\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/otac.isa-geek.net\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=474"}],"version-history":[{"count":0,"href":"https:\/\/otac.isa-geek.net\/blog\/index.php?rest_route=\/wp\/v2\/posts\/474\/revisions"}],"wp:attachment":[{"href":"https:\/\/otac.isa-geek.net\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=474"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/otac.isa-geek.net\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=474"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/otac.isa-geek.net\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=474"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}