Kevin Kempf's Blog

February 12, 2013

Installing the Oracle 11g Client on Ubuntu 12.1 64-bit

Filed under: 11g, Ubuntu — kkempf @ 2:01 pm

This pertains to who?

I suppose the audience for this post is pretty narrow; namely, Oracle DBA’s running Ubuntu as their desktop.  It’s basically a way to cram a square peg into a round hole and get the Oracle 11g (11.2.0.1) client running on Ubuntu.  I won’t go on another rant about why I don’t run Windows at work.  The beauty of it is, these days I don’t have to, have you seen Windows 8?  Ha, OK, let met get to it here.

My original post

I performed this experiment a few years back when I first went to Ubuntu as my desktop, and it was on version 10.  At some point since then, my walk through started to fail, so I was compelled to write it up again as I hacked up my OS to get it working.  Still, the original is more verbose, and probably worth a look.

Download the Installer

I grabbed V17532-1.zip from edelivery.oracle.com; this is the 11.2.0.1 64-bit linux client.  I think you could get it from OTN also.  Obviously, unzip this file somewhere convenient.

Get the required packages installed in Ubuntu

Basically, this means get all the libaio packages installed.  From software center, yours should look like this

software center installs libaio

Create symbolic links

You will need the following, run as root:

  • ln -s /usr/lib/x86_64-linux-gnu /usr/lib64
  • ln -s /lib/x86_64-linux-gnu/libgcc_s.so.1 /lib/libgcc_s.so (I created this before the install, since it was absent, and now it’s a file and not a link.  Not sure what to make of that, exactly)
  • ln -s /usr/bin/basename /bin/basename
  • ln -s /usr/bin/awk /bin/awk
  • I think the installer creates this one:  ln ­-s $ORACLE_HOME/lib/libagtsh.so.1.0 $ORACLE_HOME/lib/libagtsh.so

Screenshot from 2013-02-12 11:05:37 Screenshot from 2013-02-12 11:10:27goodone

Run the installer

runInstaller

The installer complains about the versions of all your packages; just hit ignore all, and force it to proceed.  Next, next, next just like Windows.

You will have to run 2 root.sh type scripts from the command line after the installer finishes.  There should be no errors whatsoever after the system check warnings.

Final Proof

proof

 

Advertisements

Running the Oracle Mobile Supply Chain (MSCA) GUI on Ubuntu 12.1

Filed under: 11i, Ubuntu — kkempf @ 1:34 pm

MSCA Overview

Oracle’s 11i Mobile Supply Chain (which is itself a small piece of their warehouse application) is essentially a telnet version of the forms relevant to certain business areas.  Why, you might ask?  As a manufacturer, we find it rather convenient to be able to perform Work in Process and Shipping transactions from a hand-held wireless device, instead of being tied down to a PC with a browser logged into Oracle professional forms.  In short, it’s a small footprint, narrowed-down version of 11i forms.  My original post is here, but it’s a bit dated.

Patches

What would an Oracle product implementation be without a bunch of patches?  To get this product cooking right, you need to put in 5712178 (allows you to start/stop the applications tier telnet server via adstrtal.sh/adstpall.sh) and 8305261 (fixes a bug which didn’t allow you to actually stop the telnet server via adstrtal.sh/adstpall.sh).

Why Ubuntu?

You can find plenty of articles about how to install the MSCA client on Windows.  But I don’t like to run Windows; it’s clumsy and tries too hard to out-think me (not hard to do).  Ubuntu is a nice compromise, because it is still linux, but has good desktop support (drivers for wifi and displays come to mind).  I especially like being able to right click and open a terminal (sudo apt install nautilus-open-terminal) and type sqlplus apps@prod and be able to connect to my database directly.  More on installing the Oracle 11g client in the next post.

Oracle’s GUI

It’s not pretty.  It’s basically a java GUI to wrap around a telnet session.  But it is much nicer than telnet.  Incidentally, don’t hit the tab key, ever, when you’re using it.  Despite the fact that it’s almost second nature to do so, it’s not supported unless you’re using java 1.1.8 (yep, the one from 1999) and if you do hit tab, the GUI gets totally hosed.  I don’t know how to explain it better.  Oracle is aware of the bug, but since they haven’t solved it since 1.3 came out, I don’t have a lot of faith a patch is eminent.

Download the MSCA patch

Basically, to use this GUI you need to pull patch 4205328.  There is an updated version of this patch which I could not get to work (more on that later).  Extract the zip file and get the j4205328.zip file, that’s all you need.

Setup your environment

Create an MWA install directory.  In my case, I made /usr/local/oracle/msca/lib and /usr/local/oracle/msca/log.  Then I created a runMSCA.sh script which looks like this (you may need to tweak the JAVA_HOME to match your settings):

JAVA_HOME=/opt/java/jre1.6.0_38
#JAVA_HOME=/opt/java/jdk1.6.0_38
MWA_GUI_TOP=/usr/local/oracle/msca
$JAVA_HOME/bin/java -classpath $MWA_GUI_TOP/lib/j4205328.zip oracle.apps.mwa.awt.client.StartGUI

Note that you can point to either a JRE or JDK top; either work.  chmod +x your script and you’re basically done.

Launch it

In my case, runMSCA.sh is on my Ubuntu Desktop.   So I double clicked it

runMSCA.sh

Click Run

Now you get to the host screen

host login

Specify the Site Name, Host name and port

This can be defaulted through MSCA configuration

This can be defaulted through MSCA configuration

Login with your normal apps 11i credentials

Login with your normal apps 11i credentials

Select an MSCA responsibility

Select an MSCA responsibility

menu items

Ready for business!

Updated GUI versions

While I know we got the newer version of the GUI to run on Windows, it wouldn’t cooperate with me on Ubuntu.  The newer patch is 12780257 which supposedly fixed some bugs (curiously, though, not the tabbing issue!).  When I tried to put my launcher together, it crashed and burned

msca2.sh

Seems straight forward

 

msca2.sh_error

Conclusion

You can run the GUI from Ubuntu (or any Linux version which has a JDK/JRE available) with a little improvisation.  Perhaps I made a simple mistake on the newer version, if so I’d love to hear about it.  In the meantime, I can at least regression test mobile apps from my preferred desktop!

 

 

 

Create a free website or blog at WordPress.com.