Linux + Oracle Apps + Sun JRE Plugin

I recently upgraded my production instance to 11i.ATG_PF.H RUP 5 and replaced JInitiator with the Sun JRE Plugin. To be able to use Linux with the application’s applets, just perform the following steps:

  1. Install Mozilla Firefox if you don’t already have it.
  2. Download the supported JRE. In my case, it is 1.5.0_12. Because Oracle cannot keep up with new technology, I had to dig around in the Sun Java Archive to find it.
  3. Copy the JRE bin file to where you want it installed. I copied mine to /opt.
  4. Make the bin file executable:
    sudo chmod 744 jre-1_5_0_12-linux-i586.bin
  5. Install the bin file:
    sudo jre-1_5_0_12-linux-i586.bin
  6. Create a symlink to the JRE plugin:
    sudo ln -s /opt/jre1.5.0_12/plugin/i386/ns7/libjavaplugin_oji.so /usr/lib/firefox/plugins
    UPDATE: For Firefox 3:
    sudo ln -s /opt/jre1.5.0_12/plugin/i386/ns7/libjavaplugin_oji.so /usr/lib/firefox-addons/plugins
  7. Startup Firefox, and give it a whirl.
<span class="entry-utility-prep entry-utility-prep-cat-links">Posted in</span> Applications, Linux, Oracle | <span class="entry-utility-prep entry-utility-prep-tag-links">Tagged</span> , , , , , , | 2 Comments

Tucson Pictures

As promised, here are some pictures from my Tucson trip. Please thank my good friend Heather, as she is practically the only reason I have any pictures at all. 🙂

Rock climbing on my first day back.
Dinner and hookah smokin’ on my last night.
<span class="entry-utility-prep entry-utility-prep-cat-links">Posted in</span> Commentary | Leave a comment

Custom SQL Developer Reports

As I come across useful scripts, I create SQL Developer reports to retain them. Some of my reports may not work in your environment, but please feel free to download them and try them out using the link below.

SQL Developer User Defined Reports

<span class="entry-utility-prep entry-utility-prep-cat-links">Posted in</span> SQL Developer | Leave a comment

Trentemoller Coming To Seattle On October 8th, 2007

As a few of my closest friends know, I have been listening to Trentemoller for the past few several months. Surprisingly, he is playing at Neumos on Monday, October 8th, 2007. The show is a few weeks off, so watch the Moan video in the meantime.

 

<span class="entry-utility-prep entry-utility-prep-cat-links">Posted in</span> Music | Leave a comment

How To Change Oracle Apps System Passwords

Issue


You need to change the SYSTEM, APPS, and Oracle Applications schema passwords. 

Solution


Run the linked Apps Change Passwords Script on an application tier.After changing the passwords, run Autoconfig on each of the Application Tier Nodes.

<span class="entry-utility-prep entry-utility-prep-cat-links">Posted in</span> Applications, Database, Oracle | Leave a comment