Thursday, 18 February 2010

I want to manage OAS, what port is the Application Server Console on?

I tried looking at the opmn.xml files and grepping through all of the logs, but to no avail.

I tried netstat –p and a few other commands, but still had no success..

I then looked at the httpd.conf file for Apache and saw that the default port – grep httpd.conf Port and it’ll tell you the default port. 

Make sure that the home app is up using opmnctl –status

it was 7777 on my OEL Linux machine

I’ve tried lsof, but there does not seem to be a relationship between the java process and the apache process…  So, I’m going to find the port in the httpd.conf file.

mine was here, if this helps you…. /u01/product/

Friday, 12 February 2010

Which cache is what cache – JDBj cache

There are 2 main caches that should be taken into consideration

  • Generic JDBC caching on JAS servers (service cache)
  • Internal JDEBASE DB caching – kernel (database cache)

If you want to clear the cache, you MUST clear both.  Remember that if you just do the web/service cache, your BSFN’s will validate against the wrong data!


Service Cache

The JDBC caching is easy, the cache just needs to be cleared, but there are two other caches that you need to consider. This is cleared by using SM for SAW depending on the release. In the newer releases of JDE this can be done over all instances – which is cool!

  • Data Dictionary Alpha Cache (c.f., DDTEXT)
  • JDBJ OCM Cache
  • Row Column Cache (c.f., FDATEXT)
  • JDBj Service Cache (refer Service Cache)
  • Menu Cache (from F989998/F989999)
  • Data Dictionary Glossary Text (F00165 -Media Object)
  • JDBj Security Cache
  • Serialized Objects (Object Cache data in F989998/F989999 - Java Persistent Data)

Note that the tables that are cached by the web server can be found in :

  • Service Cache
    • Do not change defined values/tables as it may cause unexpected results when running certain applications. You can get this information from \System_JAR\com\jdedwards\database\services\serviceobj\ on your JAS server to check tables which are members of ServiceCache

Note that the duration that some of these are maintained is controlled by settings in the JDBj Runtime Properties of the JAS.INI

There is a timeout setting for each of the cache types.

The value in the ini file is in milliseconds, default is 600000. There are 1000 milliseconds in a second, so this means that the cache lasts for 600 seconds or 10 minutes.

  • Service Cache
    • Use SAW (Server Administration Workbench) or Server Manager (depending on your Tools Release
    • Find the JAS instance you're working with
    • In the Runtime Metrics Category (SMC), click on JDBJ Database Caches
    • Select JDBj Service Caches and click on Clear Cache to flush Service Cache
    • Verify that Cache Size is set to zero

Database Cache

Internal JDEBASE caching is controlled by P98613. I suggest caution when using this application. This controls how many records are cached internally by JDE.


Unless you are on one of the newer releases, I find that this is not 100%. There is a menu item from WSJ to “reset cache” which can clear many of the troublesome caches on the server, but this is not 100% in my experience.

  • Database Cache
    • Log into a FAT/HTML or WebDev client
    • Fast Path to WSJ (Work with Submitted Jobs)
    • Highlight your logic Server and from ROW menu click on Reset Cache
    • Select Database, then click OK.  This will flush database caching


Thursday, 11 February 2010

shell on AS/400

yes, for all you unix nerds – I’ve found AS/400 nerd-vana…  just simple, QSH

you can then run all your unix commands in the QSH shell, awesome!

Tuesday, 9 February 2010

Local web URL for WAS61


That could be handy for you one day…

uninstall WAS6.1 express to fix local web

Done everything to get local web working for webSphere site. 


These are instructions for manual removal (when all else fails).

All of it is normal:

1. uninstall

2.  delete IBM dir

3.  delete registry settings that mention WebSphere

4. in %WINDIR%   ****Wait, you might have missed that.

6.  from the WAS install location, run C:\temp\was61expressinstall\WAS\installRegistryUtils\bin>installRegistryUtils.bat -cleanAll

#6 was a doozy

back it up and delete the original.  try the install again.

servermanager runAgent new to me

I had an instance that I could not see the enterprise server processes on a linux machine via SM.

I tried starting the agent as oracleas and jde812, but nothing.

I looked at the sm logs e1agent_1.log and found that the user could not chmod

I also noticed that it was owned by root, which means some pain in the arse had tried to start the Agent as root and messed things up…

So I logged in as root and chown’d and chgrp’d the crap out of the files and then started the agent as jde812 (as it should be).

Now everything is peachy.

Now I try to install to this server…

Friday, 5 February 2010

opmnctl usage

D:\oracle\\OracleAS_1\opmn\bin>opmnctl status

Processes in Instance: oc4j1013.myrstest01.MITS.local
ias-component                    | process-type       |     pid | status
OC4JGroup:default_group          | OC4J:e812_dvtc_web |     N/A | Down
OC4JGroup:default_group          | OC4J:e812_myr_web  |     N/A | Down
OC4JGroup:default_group          | OC4J:e812_wcb_web  |     N/A | Down
OC4JGroup:default_group          | OC4J:e812_poc_web  |     N/A | Down
OC4JGroup:default_group          | OC4J:e812_dev_web  |    6236 | Alive
OC4JGroup:default_group          | OC4J:home          |    4212 | Alive
ASG                              | ASG                |     N/A | Down
HTTP_Server                      | HTTP_Server        |    2176 | Alive

Then to start any of them individually:

opmnctl verbose startproc ias-component=HTTP_Server

Where the ias_component is listed in the status output

There is a previous post about getting the console working too.  I don’t want to waste the internet and repeat it.

Thursday, 4 February 2010

Faster gen?

Make sure that you have WEB DEVELOPMENT=TRUE set.

This setting is almost twice as fast… Well, it is for me!

Tuesday, 2 February 2010

Viewing failed transactions / Failure Recovery Data

Easy in 8.98, there is an option in the main tool bar.

In older releases try P95400

You don’t always get a result, but when you do – it can be GOLD!!!

When was that object put into an update package?

This is not that easy to find in JDE, opening all of the package definitions is a slow way of getting there.

Just run a query like:

SELECT * FROM SY812.F9631 WHERE PDOBNM = ‘F0911’ and PDPATHCD = ‘PD812’

Note that this stoopid editor has put funny “’”s in it, you’re gunna have to replace them with single ones.