Archives by date

You are browsing the site archives for 2017.

ESU Installation Comparison Using SQL

oracle-sql-developer

If your JDE EnterpriseOne installation has been installed for more than… oh, 2 weeks… your pathcodes have obviously gotten out-of-sync. Ok, maybe it’s not that bad, but DV and PY can become much different than PD faster than a three-legged fox in a hen house. Is that fast? I don’t know, but it doesn’t take long. There are many reasons as to why the pathcodes get out-of-sync:

  • Testing an ESU without cleaning up after it didn’t resolve the issue
  • Forgetting about an ESU that was installed in DV or PY
  • Developers being slow to do retro-fits

Now, Developers, don’t get upset. I love developers. They provide job security for CNC Admins! Now come on… I’m just hackin’ on ya.

You can use SQL Developer to connect to the E1Local database.

The SQL I used to compare the ESU installations between pathcodes is below. This example tells us which ESUs are in PY910 but not in PD910. The SDSUDET=’90’ indicates that the ESU has been installed in that pathcode.

Any other quick and dirty SQLs that you use to report on ESUs? Please leave them in the comments below.

Run Apache HTTP Server As A Windows Service

While working with a JDE EnterpriseOne add-on application, I needed to install the Apache HTTP Server as a Windows Service so that it would start automatically when rebooted. The command I used is:

I got it from this Apache HTTP Server documentation:

Using Apache HTTP Server on Microsoft Windows

The relevant test is:

You can install Apache as a Windows NT service as follows from the command prompt at the Apache bin subdirectory:

httpd.exe -k install

If you need to specify the name of the service you want to install, use the following command. You have to do this if you have several different service installations of Apache on your computer. If you specify a name during the install, you have to also specify it during any other -k operation.

httpd.exe -k install -n “MyServiceName”

If you need to have specifically named configuration files for different services, you must use this:

httpd.exe -k install -n “MyServiceName” -f “c:\files\my.conf”

If you use the first command without any special parameters except -k install, the service will be called Apache2.4 and the configuration will be assumed to be conf\httpd.conf.

How To Start SQLPlus From The Linux Command Line

Run the following commands from the Linux command line to start SQLPlus:

 

 

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