EnterpriseOne

The EnterpriseOne category will include all posts and pages pertaining to EnterpriseOne.

3 Ways To Find Your Oracle Weblogic Version

There are at least 3 different ways to find the version of Oracle Weblogic Server that you are running:

  1. Using the registry.xml file located in your MW_HOME directory.
    • example: /u01/weblogic/Oracle/Middleware or E:\Oracle\Middleware
    • Look for a line similar to:
      <component name=”WebLogic Server” version=”10.3.4.0″ InstallDir=”/u01/weblogic/Oracle/Middleware/wlserver_10.3″&gt;
  2. Using the .product.properties file located in your WLS_HOME directory.
    • example: /u01/weblogic/Oracle/Middleware/wlserver_10.3 or E:\Oracle\Middleware\wlserver_10.3
    • Look for a line similar to:
      WLS_PRODUCT_VERSION=10.3.4.0
  3. Using the Oracle Weblogic Server Administration Console
    • Use the left hand menu to navigate to Environment -&gt; Servers. Then, click the [Monitoring] tab. You should see a screen similar to the one below:
      Oracle Weblogic Server Administration Console

Pause/Resume E1 Scheduler with SQL

Below are SQL statements that can be used to Pause and Resume the E1 Job Scheduler:

--*** PAUSE SCHEDULER ***
update sy900.f91300 set SJSCHCTCD01='011' where sjschjbnm='*SCHEDULER'

--*** RESUME SCHEDULER ***
update sy900.f91300 set SJSCHCTCD01='111' where sjschjbnm='*SCHEDULER';

 

How To Find Basic Linux Hardware Info

You can use the below to find some basic information about the hardware your Linux system is installed on:

How much RAM is installed and how much of it is in use (megabytes).
 It will also include swap memory:
  $ free -m
 total used free shared buffers cached
Mem: 3949 3189 760 0 599 1594
-/+ buffers/cache: 995 2954
Swap: 16386 109 16277

Processor type:
  $ cat /proc/cpuinfo

Check the size of the hard drive and what hard drives are available in the system.
 This command will also list USB drives and sticks. You need root permissions to execute the fdisk command:
  $ sudo fdisk -l | grep GB
Disk /dev/sda: 42.9 GB, 42949672960 bytes
Disk /dev/sdb: 107.3 GB, 107374182400 bytes

Got any other tips for me?

How To Find Your Linux Version

I’ve been doing a few things in Linux lately and needed a couple things like: What version of Linux am I using?

$ lsb_release -a
LSB Version: :core-3.1-amd64:core-3.1-ia32:core-3.1-noarch:graphics-3.1-amd64:graphics-3.1-ia32:graphics-3.1-noarch
Distributor ID: EnterpriseEnterpriseServer
Description: Enterprise Linux Enterprise Linux Server release 5.5 (Carthage)
Release: 5.5
Codename: Carthage

This Linux stuff is a little new for me, so hope that helps someone else out there.

How To Add An iSeries JobQueue To Oracle JDE EnterpriseOne

This is old news to many, but I have recently needed to go through this process again and had a heck of a time finding documentation on it. So, this is now my documentation on how to add an iSeries job queue to Oracle JDE EnterpriseOne.

  1. Login to the IBM iSeries server as ONEWORLD
  2. Use DSPSBSD QBATCH and choose option 6 to get the next available sequence number. You may need to page-down see the last entry.
  3. Press F5 twice to get out of the DSPSBSD program and back to the A98OWMNU.
  4. Choose option 11 to Create Job Queue
    A98OWMNU
  5. Enter the name of your new job queue and the next open sequence number that you found earlier.
  6. Use command ADDJOBQE to add a job queue entry to an active subsystem.
    1. Example:
      ADDJOBQE SBSD(QBATCH) JOBQ(R4164) MAXACT(1) SEQNBR(170)
    2. CHGJOBQE will permit you to make changes to the job queues description, i.e. maximum active jobs.
  7. Use the DSPSBSD command to verify that the previously added job queue is recognized by the subsystem and have been setup with a max active job of what you indicated in the MAXACT parameter.
    DSPSBSD

Like I said. Most people probably know this already, but I just needed a place to put it so that I don’t have to search for it next time.