Rodger's Notes

What Version of Weblogic Is It?

2012-01-28T00:26:00.000-06:00

Ever wonder what version of weblogic is on your server? Here is how to find out.

-------------

First, set the environment variables in $DOMAIN_HOME

In my case:

DOMAIN_HOME=/middleware/user_projects/domains/bifoundation_domain

-------------

Of course, you have to have already run the env file to get the DOMAIN_HOME.

Search for the environment variables with the find command.

In my case:

cd /middleware/user_projects/domains/bifoundation_domain/bin/
. setDomainEnv.sh

cd /middleware/user_projects/domains/bifoundation_domain/bin/
. setOBIDomainEnv.sh

-----

You will then notice a LOT of environment variables!

set | wc
249 719 33746

I get 249 lines of them.

---------------------

If you just want the bare minimum, run:

java weblogic.utils.Versions -h

WebLogic Server 10.3.5.0 Fri Apr 1 20:20:06 PDT 2011 1398638 ImplVersion: 10.3.5.0

---------------------

If you want to know everything, run either one of the commands:

java weblogic.version -verbose

java weblogic.utils.Versions

-----------

You will get more information from one, than the other.

java weblogic.utils.Versions | wc
236 2673 18846

java weblogic.version -verbose |wc
115 1161 8777

--------

To get everything, run the following command and see the results.

java weblogic.utils.Versions

WebLogic Server 10.3.5.0 Fri Apr 1 20:20:06 PDT 2011 1398638 ImplVersion: 10.3.5.0
JDBC DMS ImplVersion: 11.2.0.2.0
Oracle WebLogic Server Module Dependencies 10.3 Thu Mar 3 14:37:52 PST 2011 ImplVersion: 10.3.5.0
Oracle WebLogic Server on JRockit Virtual Edition Module Dependencies 10.3 Thu Feb 3 16:30:47 EST 2011 ImplVersion: 10.3.5.0
Oracle Virtual Machine Manager Client implementation ImplVersion: 1.1.0.0
Adapter implementation for Oracle VM 2.2 WS api ImplVersion: 1.1.0.0
ANTLR Java based compiler generator Client 2.7 Mon Jun 11 12:19:48 EDT 2007 ImplVersion: 2.7.7
WebLogic Descriptors for J2EE 1.5 Wed May 5 14:32:58 EDT 2010 ImplVersion: 1.5.0.0
WebLogic Descriptors for J2EE 1.5 Binding Bundle ImplVersion: 1.5.0.0
WebLogic Specific Descriptors 1.3 Tue Sep 14 18:48:42 PDT 2010 ImplVersion: 1.3.3.0
WebLogic Specific Descriptors 1.3 Binding Bundle ImplVersion: 1.3.3.0
WebLogic Datasource 1.9 Tue Oct 26 13:50:26 PDT 2010 ImplVersion: 1.9.0.0
WebLogic Datasource 1.9 Binding Bundle ImplVersion: 1.9.0.0
WebLogic Beangen Client Capable 1.7 Wed Feb 24 16:02:48 PST 2010 ImplVersion: 1.7.0.0
WebLogic Beangen 1.7 Binding Bundle ImplVersion: 1.7.0.0
WLDF Accessor Client Capable 1.5 Fri Sep 3 17:10:52 EDT 2010 ImplVersion: 1.5.0.0
WLDF Accessor 1.5 Binding Bundle ImplVersion: 1.5.0.0
WebLogic Management Core Interfaces Client Capable 2.8 Thu Mar 3 12:10:10 EST 2011 ImplVersion: 2.8.0.1
WebLogic Management Core Interfaces 2.8 Binding Bundle ImplVersion: 2.8.0.1
WebLogic EJBGen Client Capable 1.1 Thu Jun 3 13:17:07 EDT 2010 ImplVersion: 1.1.0.2
BEA Patches of apache ant Client Capable 1.2 Wed Jan 13 08:48:17 PST 2010 ImplVersion: 1.2.0.0_1-7-1
Apache Byte Code Engineering Library (BCEL) extracted from 5.2.zip from http://jakarta.apache.org/site/downloads/downloads_bcel.cgi with packages renamed from org.apache.bcel to com.bea.core.repackaged.apache.bcel Client 5.2 Tue May 15 09:52:37 EDT 2007 ImplVersion: 5.2.1.0
Eclipse Java Development Tools 3.5.2 Thu Sep 2 09:47:11 EDT 2010 ImplVersion: 3.5.2.0
Apache commons collections package 3.2 Tue Mar 20 15:48:25 MDT 2007 ImplVersion: 3.2.0
Apache commons lang package 2.1 Tue Mar 20 15:48:30 MDT 2007 ImplVersion: 2.1.0
Apache commons pool package 1.3 Tue Mar 20 15:48:36 MDT 2007 ImplVersion: 1.3.0
Apache commons io 1.4 package 1.0 Wed Jun 2 17:36:36 EDT 2010 ImplVersion: 1.4
Apache commons fileupload 1.2.1 package 1.0 Wed Jun 2 17:36:36 EDT 2010 ImplVersion: 1.2.1
Apache DOM implementation 1.0 Tue Mar 20 15:36:46 MDT 2007 ImplVersion: 1.0.0.0
Apache Logging Support 1.0 Tue Mar 20 15:36:50 MDT 2007 ImplVersion: 1.0.0.0
Apache OpenJPA classes 1.2 Thu Jul 22 05:16:07 EDT 2010 ImplVersion: 1.2.0.0_1-1-1-SNAPSHOT
XMLBeans - Apache SVN rev 962560 2.1 Thu Jul 15 09:52:54 EDT 2010 ImplVersion: 2.5.1
BEA Logging Runtime Support Client Capable 1.8 Mon Jun 7 12:07:02 PDT 2010 ImplVersion: 1.8.0.0
BEA Common Security Open SAML 1.0 Fri May 14 20:18:10 PDT 2010 ImplVersion: 6.1.0.0
BEA OpenSAML 2.0 1.0 Wed Mar 24 13:18:27 PDT 2010 ImplVersion: 6.1.0.0
bea-harvester-api2.0 Client Capable 2.3 Mon Feb 15 14:41:06 EST 2010 ImplVersion: 2.3.0.0
bea-harvester-jmx2.0 Client Capable 2.3 Wed Feb 3 11:54:03 PST 2010 ImplVersion: 2.3.0.0
bea-harvester-utils Client Capable 1.4 Mon Feb 15 14:41:06 EST 2010 ImplVersion: 1.4.0.0
bea-mbean-typing-util 1.4 Wed Feb 24 19:15:33 EST 2010 ImplVersion: 1.4.0.0
Javolution 3.7.19 3.7 Tue Aug 28 17:32:21 PDT 2007 ImplVersion: 3.7.19.0
Joda-time 1.2.1 1.2 Tue Aug 28 17:32:27 PDT 2007 ImplVersion: 1.2.1.0
BEA STAX Build Time Support 1.5 Tue May 4 07:32:25 PDT 2010 ImplVersion: 1.5.0.0
BEA STAX Runtime Time Support Client Capable 1.7 Wed Aug 4 19:40:47 EDT 2010 ImplVersion: 1.7.0.0
BEA Generic Annotations Client Capable 1.3 Sat Jul 11 00:30:54 EDT 2009 ImplVersion: 1.3.0.0
BEA Kodo 1.4 Mon Feb 7 16:22:04 PST 2011 ImplVersion: 1.4.0.0_4-2-1
BEA Kodo Integration Client Capable 1.6 Sun Nov 22 16:29:06 PST 2009 ImplVersion: 1.6.0.0
BEA Kodo Integration 1.6 Binding Bundle ImplVersion: 1.6.0.0
BEA Kodo Integration Tools 1.4 Thu Feb 3 16:07:53 EST 2011 ImplVersion: 1.4.0.0
XML Beans Marshalling (package renamed com.bea) SVN 962560 2.3 Thu Mar 3 12:10:10 EST 2011 ImplVersion: 2.5.1
WebLogic STAX Client Capable 1.9 Thu Feb 10 18:00:52 PST 2011 ImplVersion: 1.9.0.0
WebLogic Utils Client Capable 1.9 Thu Mar 3 12:10:10 EST 2011 ImplVersion: 1.9.0.1
Aspect 5.3 Fri Jun 4 14:55:18 PDT 2010 ImplVersion: 5.3.0
BEA Apache Commons Logging Repackaged 1.2 Mon Jun 11 12:47:12 EDT 2007 ImplVersion: 1.2.0
Spring Framework 1.1 Thu Dec 3 12:21:08 EST 2009 ImplVersion: 2.5.3
Pitchfork 1.3 Thu Jun 3 13:17:07 EDT 2010 ImplVersion: 1.0
${description} 1.2 Fri Jun 25 16:25:26 EDT 2010 ImplVersion: 1.2.0.0
CSS i18n 1.0 Fri Oct 8 10:32:52 EDT 2010 ImplVersion: 6.1.0.0
CSS xacml 1.0 Fri Oct 8 10:32:52 EDT 2010 ImplVersion: 6.1.0.0
SAML2 Utils 1.0 Fri Oct 8 10:32:52 EDT 2010 ImplVersion: 6.1.0.0
BEA Common Security Engine Implementation 1.0 Fri Oct 8 10:32:52 EDT 2010 ImplVersion: 6.1.0.0
BEA Common Security Engine Interfaces 1.0 Fri Oct 8 10:32:52 EDT 2010 ImplVersion: 6.1.0.0
BEA Common Security API 1.0 Fri Oct 8 10:32:52 EDT 2010 ImplVersion: 6.1.0.0
BEA Common Security Implementation 1.0 Fri Oct 8 10:32:52 EDT 2010 ImplVersion: 6.1.0.0
BEA Common Security JDK Utilities 1.0 Fri Oct 8 10:32:52 EDT 2010 ImplVersion: 6.1.0.0
Security Utilities 1.0 Fri Oct 8 10:32:52 EDT 2010 ImplVersion: 6.1.0.0
Common Security SAML 2.0 1.0 Fri Oct 8 10:32:52 EDT 2010 ImplVersion: 6.1.0.0
Common Security SAML 2.0 Management JavaBeans 1.0 Fri Oct 8 10:32:52 EDT 2010 ImplVersion: 6.1.0.0
Security Provider Utilities 1.0 Fri Oct 8 10:32:52 EDT 2010 ImplVersion: 6.1.0.0
SAML Utils 1.0 Fri Oct 8 10:32:52 EDT 2010 ImplVersion: 6.1.0.0
XACML Utils 1.0 Fri Oct 8 10:32:52 EDT 2010 ImplVersion: 6.1.0.0
Security Provider Environment 1.0 Fri Oct 8 10:32:52 EDT 2010 ImplVersion: 6.1.0.0
RSA certj 3.1 Wed May 5 15:11:55 PDT 2010 ImplVersion: 3.1.0.0
Netscape LDAP JDK 1.2 Mon Jun 7 15:56:47 EDT 2010 ImplVersion: 1.2.0.0
Commons Networking Utilty classes 1.0 Wed Feb 6 15:01:03 PST 2008 ImplVersion: 1.4.1
WebLogic SAAJ 1.6 Wed Jun 16 22:02:31 EDT 2010 ImplVersion: 1.6.0.0
Expression Language 2.1 for JSP 1.0 Sun Jul 18 23:17:34 PDT 2010 ImplVersion: 1.0.0.0_2-1
jaxb-impl.jar taken from Glassfish JAXB 2.1.9 1.0 Fri Aug 20 14:37:07 EDT 2010 ImplVersion: 2.1.12
jaxb-impl.jar taken from Glassfish JAXB 2.1.12 1.0 Thu May 6 16:10:04 PDT 2010 ImplVersion: 2.1.12
resolver.jar taken from Glassfish JAXWS 2.1.5 1.0 Thu Dec 3 11:46:24 EST 2009 ImplVersion: 2.1.5
Fastinfoset.jar taken from Glassfish JAXWS 2.1.5 1.0 Thu Dec 3 11:46:27 EST 2009 ImplVersion: 2.1.5
jaxws-rt.jar taken from Glassfish JAXWS 2.1.5 1.2 Mon Feb 28 17:53:01 PST 2011 ImplVersion: 2.1.5
Java.net implementation of MimePull.jar taken from Glassfish JAXWS 2.1.5 1.0 Thu Dec 3 11:46:33 EST 2009 ImplVersion: 1.3
Codehaus STaX Interfaces 3.0.1 1.0 Mon Mar 8 20:49:50 PST 2010 ImplVersion: 3.0.1
Woodstox STaX Parser 4.0.5 1.0 Thu Dec 3 11:35:43 EST 2009 ImplVersion: 4.0.5
jaxws-tools.jar taken from Glassfish JAXWS 2.1.5 1.1 Fri Sep 24 17:55:05 PDT 2010 ImplVersion: 2.1.5
Java.net Stax Extensions 1.0 Tue Jun 3 07:12:06 PDT 2008 ImplVersion: 1.2
Java.net xml stream buffer 1.0 Tue Mar 17 05:24:12 PDT 2009 ImplVersion: 0.5
Jakarta ORO 1.0 Wed Feb 6 15:01:03 PST 2008 ImplVersion: 2.0.8
Javax Enterprise Activation 1.1 Tue Apr 8 09:31:17 PDT 2008 ImplVersion: 1.1
Javax Annotation 1.0 Fri Dec 25 09:02:47 PST 2009 ImplVersion: 1.0
Javax Interceptor 1.0 Tue Mar 20 15:37:16 MDT 2007 ImplVersion: 1.0
Javax Enterprise Beans 3.0 Mon Jun 11 12:21:01 EDT 2007 ImplVersion: 3.0.1
Java Data Objects 2.0 Mon Jun 11 12:20:56 EDT 2007 ImplVersion: 2.0.1
Java Enterprise Deployment APIs 1.2 Tue Mar 20 15:37:28 MDT 2007 ImplVersion: 1.2
Java Enterprise Messaging 1.1 Mon Jun 11 12:21:11 EDT 2007 ImplVersion: 1.1.1
Javax Server Pages Client Capable 1.2 Tue Jul 13 02:43:41 EDT 2010 ImplVersion: 2.1
Java Web Services 2.0 Tue Mar 20 15:37:37 MDT 2007 ImplVersion: 2.0
Javax Enterprise Mail 1.1 Mon Jul 6 10:41:09 MDT 2009 ImplVersion: 1.4.1
Java Enterprise Management APIs 1.0 Tue Mar 20 15:37:49 MDT 2007 ImplVersion: 1.0
Java Persistence Client Capable 1.0 Tue Oct 7 12:18:34 PDT 2008 ImplVersion: 1.0.2
Java Connector 1.5 Mon Jun 11 12:22:07 EDT 2007 ImplVersion: 1.5.1
Java Authorization Contract for Containers 1.0 Wed Feb 6 15:01:03 PST 2008 ImplVersion: 1.1
Javax Enterprise Servlets Client Capable 1.0 Thu Aug 2 12:41:25 EDT 2007 ImplVersion: 2.5
Javax Transaction APIs Client Capable 1.0 Thu Aug 2 12:42:14 EDT 2007 ImplVersion: 1.1
JAXB 2.1 Mon Jun 11 12:22:53 EDT 2007 ImplVersion: 2.1.1
Java XML Registry 1.0 Wed Feb 6 15:01:03 PST 2008 ImplVersion: 1.0
Java XML Soap Extensions 1.3 Mon Jun 11 12:22:59 EDT 2007 ImplVersion: 1.3.1.0
Java Stream XML Extensions 1.1 Mon Jun 11 12:23:05 EDT 2007 ImplVersion: 1.1.1.0
JAX-WS APIs 2.1 Mon Jun 11 12:23:16 EDT 2007 ImplVersion: 2.1.1
Java API for XML-based RPC 1.2 Mon Jun 11 12:23:10 EDT 2007 ImplVersion: 1.2.1
Monfox Dynamic SNMP Agent 1.1 Fri Mar 19 05:46:27 MDT 2010 ImplVersion: 4.7.30
Serp bytecode manipulation framework 1.14.3 Fri Jun 11 12:06:08 PDT 2010 ImplVersion: 1.14.3.0
WebLogic Apache Classes Client Capable 1.2 Thu Feb 18 22:06:19 PST 2010 ImplVersion: 1.2.0.1
WebLogic BeanInfo Caching and Discovery Client Capable 2.4 Sat Oct 25 20:46:29 PDT 2008 ImplVersion: 2.4.0.0
WebLogic Descriptor Client Capable 1.9 Tue Jul 20 16:03:09 EDT 2010 ImplVersion: 1.9.0.0
Repackaged ASM-3.2 1.0 Fri Jul 31 19:30:27 MDT 2009 ImplVersion: 3.2.0
Repackaged asm-commons-3.2 1.0 Fri Jul 31 19:30:27 MDT 2009 ImplVersion: 3.2.0
Repackaged asm-tree-3.2 1.0 Fri Jul 31 19:30:27 MDT 2009 ImplVersion: 3.2.0
Repackaged asm-util-3.2 1.0 Fri Jul 31 19:30:27 MDT 2009 ImplVersion: 3.2.0
Oracle JFR 1.0 Thu Feb 18 19:06:33 PST 2010 ImplVersion: 1.0.0.0
WebLogic Diagnostics Core Interfaces Client Capable 2.5 Thu Jun 3 05:20:41 PDT 2010 ImplVersion: 2.5.0.0
WebLogic Diagnostics Logging Client Capable 1.2 Fri Dec 12 11:37:59 MST 2008 ImplVersion: 1.2.0.0
WebLogic Diagnostics Query Module Client Capable 1.2 Tue Oct 27 02:48:36 PDT 2009 ImplVersion: 1.2.0.0
WebLogic Diagnostics Instrumentor Tool 1.7 Tue May 18 03:51:46 PDT 2010 ImplVersion: 1.7.0.0
WebLogic Diagnostics Instrumentor Config Tool 1.7 Tue Jun 29 16:41:19 EDT 2010 ImplVersion: 1.7.0.0
WebLogic Diagnostics JRockit Flight Recorder Interfaces Client Capable 1.1 Fri Oct 29 16:32:05 EDT 2010 ImplVersion: 1.1.0.0
Diagnostics Notifications Module Client Capable 1.4 Sun Nov 22 16:03:32 PST 2009 ImplVersion: 1.4.0.0
BEA Logging Runtime Support Client Capable 1.5 Thu Apr 29 20:43:42 EDT 2010 ImplVersion: 1.5.0.0
WebLogic i18n Runtime Support Client Capable 1.8 Fri Sep 10 08:12:34 EDT 2010 ImplVersion: 1.8.0.0
WebLogic i18n Build Support Client Capable 1.5 Fri Feb 19 15:03:15 EST 2010 ImplVersion: 1.5.0.0
WebLogic I18N tools Client Capable 1.3 Sun Nov 22 16:03:32 PST 2009 ImplVersion: 1.3.0.0
WebLogic Management JMX Interfaces 1.4 Thu Aug 12 11:16:22 PDT 2010 ImplVersion: 1.4.1.0
WebLogic Security Provider Generation Tool 1.5 Wed Oct 14 16:39:28 MDT 2009 ImplVersion: 1.5.0.0
WebLogic Security Provider Generation Tool Client Capable 1.5 Wed Oct 14 16:39:28 MDT 2009 ImplVersion: 1.5.0.0
WebLogic Messaging Kernel Client Capable 1.8 Mon Aug 23 21:42:11 EDT 2010 ImplVersion: 1.8.0.0
WebLogic Resource Pool Client Capable 1.7 Mon Sep 27 12:00:08 EDT 2010 ImplVersion: 1.7.0.0
WebLogic Socket Muxer API Client Capable 1.2 Thu Apr 1 21:16:27 EDT 2010 ImplVersion: 1.2.0.0
WebLogic RMI Client Capable 1.10 Tue Mar 22 16:56:32 PDT 2011 ImplVersion: 1.10.0.0
Common Security WebLogic Server Integration Support 1.0 Fri Oct 8 10:32:52 EDT 2010 ImplVersion: 6.1.0.0
Server Lifecycle Interfaces Client Capable 1.4 Fri Feb 19 15:03:15 EST 2010 ImplVersion: 1.4.0.0
WebLogic Store Client Capable 1.7 Fri Dec 17 16:52:31 EST 2010 ImplVersion: 1.7.0.0
WebLogic STORE GXA Client Capable 1.6 Mon Aug 23 21:16:10 EDT 2010 ImplVersion: 1.6.0.0
WebLogic Store Admin Tool Client Capable 1.2 Thu Jan 21 10:24:18 PST 2010 ImplVersion: 1.2.0.0
WebLogic JDBC Store Client Capable 1.3 Mon May 17 10:46:33 PDT 2010 ImplVersion: 1.3.0.0
WebLogic JTA implementation Client Capable 2.7 Fri Sep 17 12:19:45 PDT 2010 ImplVersion: 2.7.0.0
WebLogic Utils 1.9 Thu Mar 3 12:10:10 EST 2011 ImplVersion: 1.9.0.1
Agent Utililities 1.1 Tue Feb 16 00:16:03 EST 2010 ImplVersion: 1.1.0.0
WebLogic Utility Classloader implementations Client Capable 1.9 Wed Mar 2 14:10:04 PST 2011 ImplVersion: 1.9.0.0
WebLogic java compiler utils package Client Capable 1.2 Thu Feb 11 03:38:50 EST 2010 ImplVersion: 1.2.0.0
WebLogic Utils for working with Expressions Client Capable 1.4 Tue Sep 29 14:45:53 EDT 2009 ImplVersion: 1.4.0.0
WebLogic Utils for Dynamically Generated Class Wrappers Client Capable 1.4 Fri Feb 13 14:44:23 MST 2009 ImplVersion: 1.4.0.0
WebLogic Timers Client Capable 1.7 Thu Feb 18 13:08:44 EST 2010 ImplVersion: 1.7.0.0
WebLogic Work Manager Client Capable 1.10 Thu Feb 17 10:25:54 PST 2011 ImplVersion: 1.10.0.0
WebLogic Workarea Client Capable 1.7 Wed Feb 24 17:18:56 PST 2010 ImplVersion: 1.7.0.0
WebLogic XML XPath Implementation Client Capable 1.4 Mon Feb 22 15:07:14 PST 2010 ImplVersion: 1.4.0.0
Weblogic Tuxedo Connector Core Client Capable 1.5 Sat Jul 3 19:05:38 EDT 2010 ImplVersion: 1.5.0.0
WebLogic Security 1.0 Fri Oct 8 10:32:52 EDT 2010 ImplVersion: 6.1.0.0
Weblogic Server Java Authentication Helper Classes Client Capable 1.1 Mon Jul 5 20:42:35 EDT 2010 ImplVersion: 1.1.0.0
Weblogic Server Message Digest Utilities Client Capable 1.0 Thu Aug 2 12:51:30 EDT 2007 ImplVersion: 1.0.0.0
Weblogic Server Authenticated Subject Client Capable 1.1 Thu Oct 28 05:46:37 PDT 2010 ImplVersion: 1.1.2.1
Weblogic Server Authenticated Subject Client Capable 1.5 Thu Sep 9 10:23:21 MDT 2010 ImplVersion: 1.5.0.0
PrintingSecurityManager - PSM 1.1 Tue Feb 16 05:30:08 PST 2010 ImplVersion: 1.1.0.0
WebLogic security ssl classes 1.0 Tue Jun 15 17:39:53 EDT 2010 ImplVersion: 1.0.0.0
WebLogic Nodemanager Plugin Client Capable 1.3 Tue Nov 18 18:23:10 EST 2008 ImplVersion: 1.3.0.0
nodemanager module for managed processes 1.0 Thu Apr 8 15:14:38 PDT 2010 ImplVersion: 1.0.0.0
WebLogic JMS Pool Client Capable 1.8 Thu Mar 3 14:11:40 PST 2011 ImplVersion: 1.8.0.0
Contains compiled schema type from WLS 9.0 for WLP compatibility 1.3 Wed Feb 24 19:15:33 EST 2010 ImplVersion: 1.3.0.0
WebLogic Http Pub/Sub Module Client Capable 1.6 Mon Jul 12 02:31:07 EDT 2010 ImplVersion: 1.6.0.0
WebLogic WebApp Container Public API Client Capable 1.4 Fri Oct 1 20:01:15 PDT 2010 ImplVersion: 1.4.0.0
Class Redefinition Project 1.5 Mon May 10 19:48:21 EDT 2010 ImplVersion: 1.5.0.0
Class Redefinition Project Client Capable 1.5 Mon Apr 5 17:00:52 PDT 2010 ImplVersion: 1.5.0.0
Class Redefinition Project 1.5 Binding Bundle ImplVersion: 1.5.0.0
oracle.toplink ImplVersion: 11.1.1.5.0.110305
Commonj SDO 1.0 Wed Sep 24 19:11:23 PDT 2008 ImplVersion: 1.0
WebLogic Coherence Descriptor 1.1 Wed May 5 15:17:47 EDT 2010 ImplVersion: 1.1.0.0
WebLogic Coherence Descriptor 1.1 Binding Bundle ImplVersion: 1.1.0.0
This module contains all message catalogs 1.1 Fri Dec 17 08:04:35 PST 2010 ImplVersion: 1.1.0.0
WebLogic WebService Public API's 1.1 Tue Sep 21 22:15:05 EDT 2010 ImplVersion: 1.1.0.0
WebLogic EclipseLink Integration 1.0 Thu Feb 25 14:56:43 PST 2010 ImplVersion: 1.0.0.0
WebLogic SCA Client 1.0 Thu Feb 25 00:27:10 EST 2010 ImplVersion: 1.0.0.0
WebLogic RAC Module UCP Client Capable 1.0 Mon Sep 13 09:03:00 PDT 2010 ImplVersion: 1.0.0.0
JDBC ImplVersion: 11.2.0.2.0
FMW Generic Token 1.0.0.0 ImplVersion: 1.0.0.0
Dynamic Monitoring Service (DMS) ImplVersion:
Oracle Java Diagnostics Logging (OJDL) ImplVersion:
null ImplVersion: Oracle Middleware 11.1.1 (ASKERNEL_11.1.1.5.0_GENERIC_110418.2020, ADMINSERVER_11.1.1.5.0_GENERIC_110322.2200, J2EE_11.1.1.5.0_GENERIC_110329.0915, JDEVADF_11.1.1.5.0_GENERIC_110409.0025.6013, TOPLINK_11.1.1.5.0_GENERIC_110305.0900, ENTSEC_11.1.1.5.0_GENERIC_110326.1205, FMWCONFIG_11.1.1.4.0_GENERIC_RELEASE)
Oracle Java Diagnostics Logging (OJDL) ImplVersion:
Oracle Web Services Manager ImplVersion: J2EE_11.1.1.5.0_GENERIC_110329.0915
Oracle Web Services Manager ImplVersion: J2EE_11.1.1.5.0_GENERIC_110329.0915
Oracle Web Services Manager ImplVersion: J2EE_11.1.1.5.0_GENERIC_110329.0915
Oracle Web Services Manager ImplVersion: J2EE_11.1.1.5.0_GENERIC_110329.0915
Oracle Web Services Manager ImplVersion: J2EE_11.1.1.5.0_GENERIC_110329.0915
Oracle Web Services Manager ImplVersion: 11.1.1
Oracle Web Services Manager ImplVersion: J2EE_11.1.1.5.0_GENERIC_110329.0915
Oracle Web Services Manager ImplVersion: J2EE_11.1.1.5.0_GENERIC_110329.0915
Oracle Web Services Manager ImplVersion: J2EE_11.1.1.5.0_GENERIC_110329.0915
OC4JWLS Integration ImplVersion: March 29 2011
Oracle Universal Connection Pool ImplVersion: 11.1.1.3.0
Coherence ImplVersion: 3.6.0.4
HTTPClient ImplVersion: March 29 2011
WebLogic WebService Databinding Plugins 1.2 Fri Oct 15 07:38:46 PDT 2010 ImplVersion: 1.2.0.0
WebLogic WebService Databinding 1.2 Fri Oct 15 06:35:13 PDT 2010 ImplVersion: 1.2.0.0
null ImplVersion: 11.1.1.2.0
null ImplVersion:
null ImplVersion:
Oracle Security Developer Tools Security Engine ImplVersion: 3.1.0
Oracle Security Developer Tools PKI SDK CMP ImplVersion: 1.3.0
Oracle Security Developer Tools CMS ImplVersion: 2.3.0
Oracle Security Developer Tools Crypto ImplVersion: 3.1.0
Oracle Security Developer Tools JCE ImplVersion: 2.2.0
Oracle Security Developer Tools PKI SDK LDAP ImplVersion: 1.2.0
Oracle Security Developer Tools Liberty 1.1 ImplVersion: 2.2.0
Oracle Security Developer Tools Liberty 1.2 ImplVersion: 2.2.0
Oracle Security Developer Tools PKI SDK OCSP ImplVersion: 2.1.0
Oracle Security Developer Tools SAML 1.0/1.1 ImplVersion: 2.2.0
Oracle Security Developer Tools SAML 2.0 ImplVersion: 1.0.0
Oracle Security Developer Tools S/MIME ImplVersion: 2.3.0
Oracle Security Developer Tools PKI SDK TSP ImplVersion: 1.1.0
Oracle Security Developer Tools Web Services Security ImplVersion: 1.1.0
Oracle Security Developer Tools XKMS ImplVersion: 1.0.0
Oracle Security Developer Tools XML Security ImplVersion: 2.3.0
oracle.ldap.util ImplVersion: 1.0
OPSS ImplVersion: 11.1.1.1.0
OPSS ImplVersion: 11.1.1.1.0
OPSS ImplVersion: 11.1.1.1.0
OPSS (EE) ImplVersion: 11.1.1.1.0
OPSS ImplVersion: 11.1.1.1.0
OPSS ImplVersion: 11.1.1.1.0
OPSS ImplVersion: 11.1.1.1.0
OPSS (WLS) ImplVersion: 11.1.1.1.0
OPSS AZ Runtime ImplVersion: 11.1.1.3.0
OPSS AZ Runtime ImplVersion: 11.1.1.3.0
OPSS AZ Runtime ImplVersion: 11.1.1.3.0
OPSS AZ Runtime ImplVersion: 11.1.1.3.0
OPSS AZ Runtime ImplVersion: 11.1.1.3.0

Overcoming the Oracle Apps R12 Error APP-FND-01542 on 64 bit Redhat 5.5

2012-01-24T01:39:00.000-06:00

Symptom:

Ever try to login to Oracle Apps R12, and get the error APP-FND-01542 on 64 bit Redhat 5.5?

APP-FND-01542
The applications servers is not authorized to access this database.

Here is how to solve it.

Cause:

In the CONTEXT_FILE, the setting, s_appserverid_authentication is set to SECURE.

Modes:
- ON : Partial
- SECURE : activates full server security (SECURE mode)
- OFF : deactivates server security

Solution:

Find the CONTEXT_FILE. In my case:

CONTEXT_FILE=/oapps/applmgr/VIS/inst/apps/VIS_black/appl/admin/VIS_black.xml

cd /oapps/applmgr/VIS/inst/apps/VIS_black/appl/admin

Backup the file:
cp VIS_black.xml VIS_black.xml_2012jan21

Look for the setting: s_appserverid_authentication
Ensure it is there:

cat /oapps/applmgr/VIS/inst/apps/VIS_black/appl/admin/VIS_black.xml | grep -i "appserverid_auth"
SECURE

Edit the file. Change the setting to OFF.

------------

Of course, only change the setting to OFF, if your environment security policies would allow it.

------------

Run the Script:
adautocfg.sh

You then need to "recompile" all the scripts that Oracle Apps uses.

Use the script: adautocfg.sh
Found in ADMIN_SCRIPTS_HOME

In my case:
ADMIN_SCRIPTS_HOME=/oapps/applmgr/VIS/inst/apps/VIS_black/admin/scripts

Shutdown the APPS middle tier.

As applmgr:

cd /oapps/applmgr/VIS/inst/apps/VIS_black/admin/scripts/
sh adautocfg.sh

Enter the password for APPS

It will then take a number of minutes to reconfigure all the scripts.

Enter the APPS user password:

The log file for this session is located at: /oapps/applmgr/VIS/inst/apps/VIS_black/admin/log/01221331/adconfig.log

AutoConfig is configuring the Applications environment...

AutoConfig will consider the custom templates if present.
Using CONFIG_HOME location : /oapps/applmgr/VIS/inst/apps/VIS_black
A Classpath : /oapps/applmgr/VIS/apps/apps_st/comn/java/lib/appsborg2.zip:/oapps/applmgr/VIS/apps/apps_st/comn/java/classes

Using Context file : /oapps/applmgr/VIS/inst/apps/VIS_black/appl/admin/VIS_black.xml

Context Value Management will now update the Context file

Updating Context file...COMPLETED

Attempting upload of Context file and templates to database...COMPLETED

Configuring templates from all of the product tops...
Configuring AD_TOP........COMPLETED
Configuring FND_TOP.......COMPLETED
Configuring ICX_TOP.......COMPLETED
Configuring MSC_TOP.......COMPLETED
Configuring IEO_TOP.......COMPLETED
Configuring BIS_TOP.......COMPLETED
Configuring AMS_TOP.......COMPLETED
Configuring CCT_TOP.......COMPLETED
Configuring WSH_TOP.......COMPLETED
Configuring CLN_TOP.......COMPLETED
Configuring OKE_TOP.......COMPLETED
Configuring OKL_TOP.......COMPLETED
Configuring OKS_TOP.......COMPLETED
Configuring CSF_TOP.......COMPLETED
Configuring IGS_TOP.......COMPLETED
Configuring IBY_TOP.......COMPLETED
Configuring JTF_TOP.......COMPLETED
Configuring MWA_TOP.......COMPLETED
Configuring CN_TOP........COMPLETED
Configuring CSI_TOP.......COMPLETED
Configuring WIP_TOP.......COMPLETED
Configuring CSE_TOP.......COMPLETED
Configuring EAM_TOP.......COMPLETED
Configuring FTE_TOP.......COMPLETED
Configuring ONT_TOP.......COMPLETED
Configuring AR_TOP........COMPLETED
Configuring AHL_TOP.......COMPLETED
Configuring OZF_TOP.......COMPLETED
Configuring IES_TOP.......COMPLETED
Configuring CSD_TOP.......COMPLETED
Configuring IGC_TOP.......COMPLETED

AutoConfig completed successfully.

--------------

It reconfigures 31 TOPs.

Check the activity in the log file. Almost 4000 lines long.

/oapps/applmgr/VIS/inst/apps/VIS_black/admin/log/01221331/adconfig.log

From the log, it also logs into the database with sqlplus

--------------

Restart The Apps Middle Tier.

Test.

file:///oapps/applmgr/VIS/apps/tech_st/10.1.2/tools/web/html/runform.htm

Login

The error should be solved now.

--------------------

Useful Links:

From 2007:
http://firokun.wordpress.com/2007/06/11/app-fnd-01542-this-application-server-is-not-authorized-to-access-this-system/

http://onlineappsdba.blogspot.com/2007/10/enabling-f60cgi-direct-login-in-oracle.html

From 2010:
http://appsdbaworkshop.blogspot.com/2010/12/app-fnd-01542-this-application-server.html

Oracle Apps R12 - Let Me Count the XML Files

2012-01-24T00:17:00.000-06:00

Just how many XML files does Oracle Apps R12 use?

On the Oracle side:

find /oapps/oracle -type f -iname "*.xml" | wc
2982 2982 325846

On the applmgr side:

find /oapps/applmgr -type f -iname "*.xml" | wc
93513 93513 9851930

Over 93K XML files for applmgr.

Between the two, over 96K XML files! Wow!

So, who can tell me, within those 96,494 XML files, how many attributes are defined?

Review of Colasoft - Network Activity Analyzer - It's Awesome!

2012-01-23T21:29:00.000-06:00

The other week, I downloaded Colasoft's Network Activity Analyzer, and took it for a test drive. Colasoft is a fabulous network analyzer, intuitively obvious and such a pleasure to work with. It installs and works in a few minutes. Highly recommended!

I was prompted to download it, because I've often wondered about network activity on my machines.

In addition to seeing the total network activity on the machine, I'd like to see the network activity by each browser window. And further, by each tab in each web browser. So far, I haven't found a product to do this. If anyone knows of a such a product, please leave a comment. I'd love to see the product.

When I downloaded the product, the browser displayed a license key. Copy that and save it to disk. It was a little confusing, because the message said to wait for for an email. But the email never came. Perhaps it comes for the enterprise versions I would pay for. Then, I remembered the license key, and proceded to install with that key.

Colasoft Installed In Few Minutes:

If you have read some of my other posts, you will know that I place a big emphasis on a quick and reliable install.

The first thing to strike me was how simple and reliable the install was. I installed Colasoft in just a few minutes, and it proceded to work. So much unlike so many other installs I've been struggling with. Isn't it such a pleasure when software just installs properly?!

Intuitively Obvious:

Immediately after installing, working with Colasoft also intuitively obvious. You click on the different categories on the left, and the tabs on the top. I don't work in Cisco networking. But because the interface of the product is so well thought out, I immediately understood how to use the product. And immediately understood what the product was doing. That's what GUIs are for, right?

You can see all the physical machines on your network. And all conversations between machines on your network, and web pages on the internet. You can also see the packets.

What was really cool, was the matrix that Colasoft shows in graphical form. If there is network activity, the lines will change color, in real time.

Fabulous Documentation and Demos:

On the right hand side, Colasoft has some documentation and demos. It lists important security issues to look for, and how to use Colasoft to detect them. Such as: How To Detect A SQL Slammer. Very smart. This is the first time I've really noticed something like this. The really important things you should know about, are not only documented, they are highlighted!

In most all other documentation, you have to first know about these things, and then search for them. You will be lucky if the product gives clear instructions or a tutorial on how or what to do. Perhaps the product won't even do what you need it to do, or what you thought it did. You will also have to be creative on how to search for the solution, entering many variations of different key words. See my rants on useless documentation.
http://rodgersnotes.wordpress.com/2012/01/15/thoughts-on-useless-documentation/

Again, for most software, the best documentation, will not be in the company's docs, but in the blogs of users. Like mine. :) But with Colasoft, it seems the best documentation seems to come with the product!

I really applaud Colasoft on this. And everything else! This is excellent documentation!

Other Notes:

I won't comment all the features, since networking is not my specialty. It would also take a long time I'm sure. Colasoft works on Windows only. Sorry Linux lovers. Written in Microsoft Visual Studio. Stable. No crashes. No funny error messages.

Summary:

Colasoft is a fabulous network analyzer. I had no need to read docs, either on how to install the product, or how to use it. Installs and is working in a few minutes. Colasoft is intuitively obvious to work with. Why isn't all software made like Colasoft?

Colasoft is such a pleasure to work with.

It's highly recommended!

Download From:

http://www.colasoft.com/download/
http://www.colasoft.com/capsa/capsa-free-edition.php

Using NMAP To Find The Ports For Oracle Apps, OBIEE, Listener

2012-01-21T23:46:00.000-06:00

Not finding a port with netstat? Nmap finds what netstat does not. Nmap can also point out your servers' vulnerabilities.

On my server, there are a number of applications that work via a browser. Each with an associated port.

Usually, I'll use netstat to find the port.

netstat -a | grep 9704

You can also find the unix process that is using the port by adding the flag, -al.

netstat -al | grep -i 9704

tcp 0 0 black.testrac.com:9704 *:* LISTEN oracle 162677
tcp 0 0 fe80::200:ff:fe00:0:9704 *:* LISTEN oracle 162676
tcp 0 0 ::ffff:192.168.122.1:9704 *:* LISTEN oracle 162675
tcp 0 0 localhost.localdomain:9704 *:* LISTEN oracle 162674
tcp 0 0 localhost6.localdomain:9704 *:* LISTEN oracle 162673
tcp 0 0 fe80::223:54ff:fe73:5f:9704 *:* LISTEN oracle 162672
tcp 0 0 black.testrac.com:49854 black.testrac.com:9704 ESTABLISHED
tcp 0 0 black.testrac.com:9704 black.testrac.com:49854 ESTABLISHED

However, netstat doesn't find a number of processes or ports. Such as these important ports and applications:
1521 - Oracle listener
1158 - enterprise manager
7003 - Oracle Weblogic/OBIEE admin
8000 - Oracle Applications

I always found this really aggravating. I knew the port was in use. Why didn't netstat find it?

Then recently, I discovered that nmap will find the ports that netstat does not.

nmap -v black.testrac.com

Starting Nmap 4.11 ( http://www.insecure.org/nmap/ ) at 2012-01-18 15:51 CST
Initiating Connect() Scan against black.testrac.com (192.168.2.201) [1680 ports] at 15:51
Discovered open port 22/tcp on 192.168.2.201
Discovered open port 6000/tcp on 192.168.2.201
Discovered open port 929/tcp on 192.168.2.201
Discovered open port 5520/tcp on 192.168.2.201
Discovered open port 8000/tcp on 192.168.2.201
Discovered open port 7003/tcp on 192.168.2.201
Discovered open port 12345/tcp on 192.168.2.201
Discovered open port 1521/tcp on 192.168.2.201
Discovered open port 1158/tcp on 192.168.2.201
Discovered open port 111/tcp on 192.168.2.201
The Connect() Scan took 0.04s to scan 1680 total ports.
Host black.testrac.com (192.168.2.201) appears to be up ... good.
Interesting ports on black.testrac.com (192.168.2.201):
Not shown: 1670 closed ports
PORT STATE SERVICE
22/tcp open ssh
111/tcp open rpcbind
929/tcp open unknown
1158/tcp open lsnr
1521/tcp open oracle
5520/tcp open sdlog
6000/tcp open X11
7003/tcp open afs3-vlserver
8000/tcp open http-alt
12345/tcp open NetBus
So there the ports are. Very cool!

-----------

So, if you can't figure out what port your application was supposed to use, if you know that the processes are running, you can probe the ports with nmap. If you change some ports, you can check to see if they show up with nmap.

---------

Lots Of Options:

Nmap comes with many options. nmap --help returns 88 lines! You can do many kinds of searches. And get lots of detailed, and different information back.

There is also a GUI version for Linux: nmapfe. For nmap front end.

And, there is a GUI version for Windows too. This one is actually called Zenmap. It is a GUI frontend to an nmap backend.

The interfaces, while similar, are rather different. Even the predetermined scans are different.

The nice thing about these GUIs is that they have a number of predetermined scans. Just pick the type, and click the button.

----------

Protect your Machines!

The scary thing is, you can also scan all the ports of a remote computer. I scanned the ports of my windows machine. While the machine was being probed, I noticed in Task Manager that the network activity of the Windows machine went up to 200 to 300K per second.

-----------

You can even scan machines on the web. Here, I scan yahoo.com.

nmap -v yahoo.com

Starting Nmap 4.11 ( http://www.insecure.org/nmap/ ) at 2012-01-21 01:47 CST
Warning: Hostname yahoo.com resolves to 4 IPs. Using 98.139.180.149.
Machine 98.139.180.149 MIGHT actually be listening on probe port 80
DNS resolution of 1 IPs took 0.13s.
Initiating Connect() Scan against ir1.fp.vip.bf1.yahoo.com (98.139.180.149) [1680 ports] at 01:47
Discovered open port 80/tcp on 98.139.180.149
Discovered open port 443/tcp on 98.139.180.149
The Connect() Scan took 48.01s to scan 1680 total ports.
Host ir1.fp.vip.bf1.yahoo.com (98.139.180.149) appears to be up ... good.
Interesting ports on ir1.fp.vip.bf1.yahoo.com (98.139.180.149):
Not shown: 1678 filtered ports
PORT STATE SERVICE
80/tcp open http
443/tcp open https

I've read that much of the hacking that goes on in the world, uses nmap. So you can also use it to check your vulnerabilities, and either be aware of them, or close them.

Scary what you can do with nmap. Or what the nasty people can do to you via the web! Practice safe computing. Use your protection!

Overcoming Oracle Apps R12 FRM-92101 Error On Redhat Linux 5.5

2012-01-21T21:43:00.000-06:00

Have you ever got the Oracle Forms error, FRM-92101 with Oracle Applications R12 on 64 bit Redhat Linux 5.5? Here is how to overcome it.

Here is my environment:

Server: Redhat Linux 5.5

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

uname -a
Linux black.testrac.com 2.6.18-194.el5 #1 SMP Mon Mar 29 22:10:29 EDT 2010 x86_64 x86_64 x86_64 GNU/Linux

select
APPLICATIONS_SYSTEM_NAME
, ARU_RELEASE_NAME
, release_name
from apps.fnd_product_groups

APPLICATIONS_SYSTEM_NAME ARU_RELEASE_NAME
------------------------------ -------------------
RELEASE_NAME
--------------------------------------------------
VIS R12
12.1.1

-----------

Prerequisites:

The java is working in your browser. To test whether Java is working in the web browser, run this in the URL.
http://java.com/en/download/testjava.jsp

You have overcome the error concerning: NPX_PLUGIN_PATH, and oaj2se.exe
See my previous post.

http://rodgersnotes.blogspot.com/2012/01/firefox-oracle-apps-java-plugins-on-64.html

-----------

Symptom:

Start the database, listener, and all the Oracle Apps processes. Open a browser. Test an Oracle Apps Form with the forms test webpage. In my case:

file:///oapps/applmgr/VIS/apps/tech_st/10.1.2/tools/web/html/runform.htm

You get a java window open. But you get the error: FRM-92101 There was a failure in the Forms server during startup. This could happen due to an invalid configuration. Please look into the web server log for the details.

You get a java window open. But you get the error: FRM-92101 There was a failure in the Forms server during startup. This could happen due to an invalid configuration. Please look into the web server log for the details.

Click on Details:

Java exception:

oracle.forms.net.ConnectionException: forms session <1> failed during startup: no response from runtime process
at oracle.forms.net.ConnectionException.createConnectionException(Unknown source)
at oracle.forms.net.HTTPStream.getResponse(Unknown source)
at oracle.forms.net.HTTPStream.doFlush(Unknown source)
at oracle.forms.net.HTTPStream.Flush(Unknown source)
at java.io.DataOutputStream.flush (DataOutputStream.java:106)
at oracle.forms.net.HTTPConnection.connect(Unknown source)
at oracle.forms.engine.FormsDispatcher.initConnection(Unknown source)
at oracle.forms.engine.FormsDispatcher.init(Unknown source)
at oracle.forms.engine.Runform.initConnection(Unknown source)
at oracle.forms.engine.Runform.startRunform(Unknown source)
at oracle.forms.engine.Main.createRunform(Unknown source)
at oracle.forms.engine.Main.start(Unknown source)
at sun.plugin2.applet.Plugin2Manager$AppletExecutionRunnable.run(Plugin2Manager.java:1698)
at Java.lang.Thread.run(Thread.java:662)

------------

Check the Oracle Forms Log:

$LOG_HOME/ora/10.1.3/opmn/forms_default_group_1/formsstd.out

In my case:
/oapps/applmgr/VIS/inst/apps/VIS_black/logs/ora/10.1.3/opmn/forms_default_group_1/formsstd.out

tail -100 /oapps/applmgr/VIS/inst/apps/VIS_black/logs/ora/10.1.3/opmn/forms_default_group_1/formsstd.out

...

12/01/21 12:32:08 FormsServlet init():
configFileName: /oapps/applmgr/VIS/inst/apps/VIS_black/ora/10.1.2/forms/server/appsweb.cfg
testMode: false
12/01/21 12:32:08 Oracle Containers for J2EE 10g (10.1.3.4.0) initialized
12/01/21 13:04:27 ListenerServlet init()
12/01/21 13:04:28 Forms session <1> aborted: runtime process failed during startup with errors /oapps/applmgr/VIS/apps/tech_st/10.1.2/bin/frmweb: error while loading shared libraries: libXm.so.2: cannot open shared object file: No such file or directory

12/01/21 13:19:53 Forms session <2> aborted: runtime process failed during startup with errors /oapps/applmgr/VIS/apps/tech_st/10.1.2/bin/frmweb: error while loading shared libraries: libXm.so.2: cannot open shared object file: No such file or directory

--------------

And check the file, application.log:

tail -100 /oapps/applmgr/VIS/inst/apps/VIS_black/logs/ora/10.1.3/j2ee/forms/forms_default_group_1/application.log

12/01/21 13:04:27.314 formsweb: ListenerServlet init()
12/01/21 13:04:28.455 formsweb: Forms session <1> aborted: runtime process failed during startup with errors /oapps/applmgr/VIS/apps/tech_st/10.1.2/bin/frmweb: error while loading shared libraries: libXm.so.2: cannot open shared object file: No such file or directory

12/01/21 13:04:28.455 formsweb: Forms session <1> exception stack trace:
oracle.forms.engine.RunformException: Forms session <1> failed during startup: no response from runtime process
at oracle.forms.servlet.RunformProcess.connect(Unknown Source)
at oracle.forms.servlet.RunformProcess.dataToRunform(Unknown Source)
at oracle.forms.servlet.RunformSession.dataToRunform(Unknown Source)
at oracle.forms.servlet.ListenerServlet.doPost(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:713)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:871)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.AJPRequestHandler.run(AJPRequestHandler.java:313)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.AJPRequestHandler.run(AJPRequestHandler.java:199)
at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
at java.lang.Thread.run(Thread.java:619)
--------------

Cause:

The cause is not unusual with Linux, or Oracle, or Oracle Apps. It's that Oracle Forms is looking for a library file. But the file doesn't exist in the expected place. Nor does a link. Not again.

In this case, libXm.so.2 can't be found.

----------

Analysis:

Find the files. As root, do lots of linear searches all over the hard drive looking for library files.

find / -type f -ls 2> /dev/null | grep -i "libXm.so"

...
214067513 2692 -rwxr-xr-x 1 root root 2747528 Jun 6 2007 /usr/lib64/libXm.so.3.0.2
214054985 2776 -rwxr-xr-x 1 root root 2836528 Mar 4 2010 /usr/lib64/libXm.so.4.0.1

214067522 2492 -rwxr-xr-x 1 root root 2542828 Jun 6 2007 /usr/lib/libXm.so.3.0.2
1802278 2584 -rwxr-xr-x 1 root root 2637260 Mar 4 2010 /usr/lib/libXm.so.4.0.1
...

I did have more occurences of this file. But they were under different subdirectories.
/oapps/oracle/VIS/db/tech_st/11.1.0/lib32/stubs
/middleware/Oracle_BI1/lib32/stubs

The directories under /usr are the critical ones.

You can find any existing links with:

find / -type l -ls 2> /dev/null | grep -i "libXm.so"

---------------

File types:

file /usr/lib64/libXm.so.4.0.1
/usr/lib64/libXm.so.4.0.1: ELF 64-bit LSB shared object, AMD x86-64, version 1 (SYSV), stripped

file /usr/lib/libXm.so.3.0.2
/usr/lib/libXm.so.3.0.2: ELF 32-bit LSB shared object, Intel 80386, version 1 (SYSV), stripped

---------------

Find or Verify the Packages Needed For The Library Files:

Reading other webpages (below), these library files are provided by the package: openmotif22-2.2.3-18.

I had installed everything, every last package, when I installed Redhat. It's to avoid nonsense like this. So, I already the package installed. If you don't have the package installed, download it, and install it. rpmfind.net is a good place to start.

Another time, I'd stuggled with a similar installation. In my notes, I was concerned with three library files: libMrm.so, libUil.so, and libXm.so. So, I leveraged my notes, and looked for all three. Turns out they are all owned by the same package: openmotif.

-----

What Package, Is Associated With The File:

rpm -q -f /usr/lib64/libXm.so.4.0.1
openmotif-2.3.1-2.el5_4.1

-----

rpm -q -f /usr/lib/libXm.so.3.0.2
openmotif22-2.2.3-18

-----

What Are All The Files Associated With That Package?

rpm -q openmotif22 -l | sort | more

/usr/lib64/libMrm.so.3
/usr/lib64/libMrm.so.3.0.2

/usr/lib64/libUil.so.3
/usr/lib64/libUil.so.3.0.2

/usr/lib64/libXm.so.3
/usr/lib64/libXm.so.3.0.2

....

/usr/lib/libMrm.so.3
/usr/lib/libMrm.so.3.0.2

/usr/lib/libUil.so.3
/usr/lib/libUil.so.3.0.2

/usr/lib/libXm.so.3
/usr/lib/libXm.so.3.0.2

/usr/share/doc/openmotif22-2.2.3
...

This query obviously finds both the 32 and 64 bit files.

-----------------

Analysis For Links:

cd /usr/X11R6/lib

Original files:

/usr/lib/libMrm.so.3.0.2
/usr/lib/libMrm.so.4.0.1

/usr/lib/libUil.so.3.0.2
/usr/lib/libUil.so.4.0.1

/usr/lib/libXm.so.3.0.2
/usr/lib/libXm.so.4.0.1

-----

The application, is looking for files in the directory: /usr/X11R6/lib
But it does not exist. Create it.

As root:
mkdir -p /usr/X11R6/lib

-----

Make Same Name Links To The Original Files:

cd /usr/X11R6/lib

ln -s /usr/lib/libMrm.so.3.0.2 .
ln -s /usr/lib/libMrm.so.4.0.1 .

ln -s /usr/lib/libUil.so.3.0.2 .
ln -s /usr/lib/libUil.so.4.0.1 .

ln -s /usr/lib/libXm.so.3.0.2 .
ln -s /usr/lib/libXm.so.4.0.1 .

The above ^ will have a link, the same name as the original file.

-----

Make Links With An Abbreviated Name:

ln -s /usr/lib/libXm.so.3.0.2 libXm.so.3
ln -s /usr/lib/libXm.so.4.0.1 libXm.so.4
ln -s /usr/lib/libXm.so.4.0.1 libXm.so

ln -s /usr/lib/libUil.so.4.0.1 libUil.so.4
ln -s /usr/lib/libUil.so.3.0.2 libUil.so.3
ln -s /usr/lib/libUil.so.4.0.1 libUil.so

ln -s /usr/lib/libMrm.so.4.0.1 libMrm.so.4
ln -s /usr/lib/libMrm.so.3.0.2 libMrm.so.3
ln -s /usr/lib/libMrm.so.4.0.1 libMrm.so

-----

At this point,I still got the error: FRM-92101

Of course, the software is still looking for libXm.so.2, but I had not yet created the link it.

As root:

cd /usr/X11R6/lib

ln -s /usr/lib/libMrm.so.3.0.2 libMrm.so.2

ln -s /usr/lib/libUil.so.3.0.2 libUil.so.2

ln -s /usr/lib/libXm.so.3.0.2 libXm.so.2

-----------

Try again. It works. In the sense that I can get a login form.

However, when I try logging in as sysadmin, OPERATIONS, or APPS, I now get another error:

APP-FND-01542:
The applications servers is not authorized to access this database.

Are these not the right users to login with? If so, when do the errors ever stop? If not, what are the right users to login with? Please leave a comment.

---------------

Useful Links:

Test whether Java is working in the web browser.
http://java.com/en/download/testjava.jsp

Installing Oracle E-Business 12.1.1 on Oracle Enterprise Linux 5.4 64-bit
http://www.oracle-developer.com/installing_oracle_r12_rhel5_64bit.html

Installing Oracle E-Business 12.1.1 on Oracle Enterprise Linux 5.4 64-bit
http://www.pythian.com/news/1265/installing-oracle-r12-ebs-in-my-living-room/

Oracle® Fusion Middleware Release Notes
11g Release 1 (11.1.1) for Linux x86 E10133-25
44 Oracle Forms
http://docs.oracle.com/cd/E23549_01/relnotes.1111/e10133/forms.htm

Firefox, Oracle Apps, Java plugins, on 64 Bit Redhat 5.5

2012-01-21T00:16:00.001-06:00

When using Firefox on Linux, have you ever got the aggravating message concerning oaj2se.exe, or NPX_PLUGIN_PATH? Here is the solution.

From what I have read, on Linux, using the Firefox browser for Oracle Forms is not certified. At least it wasn't in the past. Bizarre.

-----------

Symptom:

On Redhat Linux, you try working with an app such as Oracle Apps, and navigate to where the software takes you. But you suddenly get the error message:

In order to access this application, you must install the J2SE Plugin version 1.6.0_07 on your client and NPX_PLUGIN_PATH environment variable is set before starting Netscape. To install this plugin, click here to download the oaj2se.exe executable. Once the download is complete, double-click the oaj2se.exe file to install the plugin. You will be prompted to restart your browser when the installation is complete.

The problem is, oaj2se.exe is an executable that only works on Windows.

-----------

You can try clicking the buttons. But it didn't help me.

The following plugins are available.
Java runtime Environment: 1.6 u29
Next.
Java runtime Environment: 1.6 u29 Not available.

Manual install.

I clicked more, and got a webpage.
http://java.com/en/download/index.jsp
Free Java Download
Download Java for your desktop computer now!
Version 6 Update 30

------------

Rants and Criticisms:

The problem is, there is already a LOT of java installed on my server. And I don't want to overwrite any versions.

If you upgrade or overwrite versions in Linux, your applications may suddenly stop working! Do you ever see all the prerequisites and certification matrices for Oracle products? Don't mess them up. Don't get creative.

Only with the Linux operating system. You upgrade a Linux package or the operating system, and suddenly your existing applications on the server, that worked fine, may suddenly stop working. Bizarre! It's happened enough times before for me to be careful. (See my post on installing Virtual Box, and the issues with kernel-devel.)

You have to hand it to Mr. Bill. When you patch or upgrade the Windows operating system, all the existing applications continue to work. If only everyone involved with Linux were as aware of this concept. And rigorously ensured that the same happened on Linux.

The other issue for me is, why is this a manual install? With the same Firefox, I clicked a few buttons, and installed the Flash player, and watched videos in just a few minutes. Why is something as important as java, also not put into a simple installation script, that works with a few mouse clicks? Let's get with the program please.

-----------

How To Get Firefox To Work On Redhat:

Check Firefox version. Help, About Firefox. You will see if it is 32 or 64 bit. In my case: Mozilla/5.0 (X11; U; Linux x86_64;

-----------

Check if Firefox has the plugin, java. If you have this symptom, it probably doesn't.

Open Firefox.

1)
Put this in the URL section:
about:plugins

2)
Tools, Addons, Plugins,

At least this is the navigation in Firefox version 3.0.18. My other beef is that software companies constantly change the navigation between releases.

In either case, if you don't see: Java(TM) Plug-in, this is the problem.

-----------

Check your server to see if you have the Java jdk, and jre.

rpm -qa --qf "%{NAME}-%{VERSION}-%{RELEASE}_%{ARCH}.rpm \n " | grep "jdk" | sort
jdk-1.6.0_26-fcs_x86_64.rpm
ldapjdk-4.18-2jpp.3.el5_x86_64.rpm

rpm -qa --qf "%{NAME}-%{VERSION}-%{RELEASE}_%{ARCH}.rpm \n " | grep "jre" | sort
jre-1.6.0_22-fcs_i586.rpm

Note whether they are 32 or 64 bit versions.

If you don't have these packages installed, you will need to download and install them. See the links at the bottom.

-------------

Find the location of the file: libnpjp2.so:

libnpjp2.so is the culprit we need.

find / -type f -iname "libnpjp2.so" 2> /dev/null

/usr/java/jre1.6.0_22/lib/i386/libnpjp2.so
/usr/java/jdk1.6.0_26/jre/lib/amd64/libnpjp2.so

I actually had this file in many places. But these ones are the relevant files. The others were specific to other applications. Stick with the generic ones.

-------------

Check if libnpjp2.so files are 32 or 64 bit:

file /usr/java/jre1.6.0_22/lib/i386/libnpjp2.so
/usr/java/jre1.6.0_22/lib/i386/libnpjp2.so: ELF 32-bit LSB shared object, Intel 80386, version 1 (SYSV), not stripped

file /usr/java/jdk1.6.0_26/jre/lib/amd64/libnpjp2.so
/usr/java/jdk1.6.0_26/jre/lib/amd64/libnpjp2.so: ELF 64-bit LSB shared object, AMD x86-64, version 1 (SYSV), not stripped

Note that one file is 32 bit, and the other 64 bit.

Since my Firefox is 64 bit, guess which file I will use?

-------------

Find the Plugin Directories For Firefox and Mozilla:

find / -type d -iname "plugin*" | grep -i -e "mozilla" -e "firefox"

/etc/skel/.mozilla/plugins

/usr/lib64/mozilla/plugins-wrapped
/usr/lib64/mozilla/plugins

/usr/lib/mozilla/plugins-wrapped
/usr/lib/mozilla/plugins

/home/applmgr/.mozilla/plugins
/home/oracle/.mozilla/plugins

-------------

Since we are concerned with 64 bit, ignore the 32 bit directories:

/usr/lib/mozilla/plugins-wrapped
/usr/lib/mozilla/plugins

-------------

Find the Flash Directory:

If you have already installed the flash player, and it works, a way to find the correct directory is to find the flash player link.

cd /usr/lib64/mozilla/plugins
ls -l
lrwxrwxrwx 1 root root 41 Nov 17 18:46 libflashplayer.so -> /usr/lib64/flash-plugin/libflashplayer.so

-------------

Create Links In The Plugin Directories:

From above, change to the directory with the flash plugin, and create the link.

cd /usr/lib64/mozilla/plugins
ln -s /usr/java/jdk1.6.0_26/jre/lib/amd64/libnpjp2.so .

Bounce firefox to test.

If this doesn't work, try creating the link in the other directories. Turns out that I initially missed this directory. But things worked after I created the link in the all other directories. Brute force algorithm. :)

cd /usr/lib64/mozilla/plugins-wrapped
ln -s /usr/java/jdk1.6.0_26/jre/lib/amd64/libnpjp2.so .

cd /etc/skel/.mozilla/plugins
ln -s /usr/java/jdk1.6.0_26/jre/lib/amd64/libnpjp2.so .

cd /home/applmgr/.mozilla/plugins
ln -s /usr/java/jdk1.6.0_26/jre/lib/amd64/libnpjp2.so .

cd /home/oracle/.mozilla/plugins
ln -s /usr/java/jdk1.6.0_26/jre/lib/amd64/libnpjp2.so .

Bounce firefox to test.

-----------------
Check the plugins:

about:plugins

Tools, Addons, Plugins,

At this point, it worked.

Java(TM) Plug-in 1.6.0_26

File name: libnpjp2.so
The next generation Java plug-in for Mozilla browsers.

MIME Type Description Suffixes Enabled
application/x-java-vm Java Plug-in Yes
application/x-java-applet Java Plug-in Applet Yes
...

------------

Interestingly, in about:plugins, the versions range from:

Applets:
application/x-java-applet;version=1.1
...
application/x-java-applet;version=1.6

Beans:
application/x-java-bean;version=1.1
...
application/x-java-bean;jpi-version=1.6.0_26

----------

Test your app:

In my case, Oracle Apps and Forms. Of course, first, bring up the database, and all the Oracle Apps processes. Start Firefox. Open this URL:

file:///oapps/applmgr/VIS/apps/tech_st/10.1.2/tools/web/html/runform.htm

You will get:

OracleAS Forms Services
Welcome to the OracleAS Forms Services Run/Test page
This HTML form may be used to run any Forms application on the web

Run the form test.fmx with the correct port. Mine worked, but I got an FRM-92101 error. But at least that was further than before. Yet another issue!

-----------------

Useful and Relevant Links:

Mozilla Plugin Support on Linux (x86_64)
http://plugindoc.mozdev.org/linux-amd64.html

System configurations and browsers:
http://www.oracle.com/technetwork/java/javase/system-configurations-135212.html

JRE and the JDK:
http://www.oracle.com/technetwork/java/javase/install-linux-64-rpm-138254.html
http://www.oracle.com/technetwork/java/javase/install-linux-64-rpm-141906.html

Instructions on how to:
http://www.oracle.com/technetwork/java/javase/manual-plugin-install-linux-136395.html

-------

How is that for instantly digestible? Hope this is useful! If it is, please leave a comment.

-------

I've been writing at: http://rodgersnotes.wordpress.com. But I have lots of issues with Wordpress. Let's see how well blogspot works. So far, the time to complete this same post is multiples faster than with Wordpress.

Oracle database tuning and being "nice"

2010-02-10T20:13:00.000-06:00

I was reading this blog about the Linux "nice" command
http://prodlife.wordpress.com/2008/04/09/yet-another-nice-myth/

which was referenced in another blog about 100% CPU utilization.
http://hoopercharles.wordpress.com/2010/02/05/faulty-quotes-6-cpu-utilization/

Both reminded me of experiences while I was researching how to insert one billion rows per day that I'd written about in my first post.

I'd started out around 6K rows per second insert speed. With more research I was able to get the insert speed up to about 9k or 10k per second. Usually I ran Oracle data dictionary queries to monitor the performance and other activity. Then I started using unix commands as well.

On the dedicated database server, there were some unix processes taking up the majority of the cpu. So all the CPU were running at least 99%, 100% of the time.

It turned out that the unix admin was, on the company servers, privately running processes on the "spare" cpu using "nice". The processes had to do with something astronomical, calculating things with brute force algorithms for a non profit.

I said that this was slowing down Oracle, and my testing. He insisted that since it was running at the lowest priority of nice, it could not possibly be slowing down the database. Intuitively, I knew this was wrong.

Eventually, we got those astronomical calculation processes off the server. The insert speed immediately went up to 13k rows per second. This was a very significant increase in performance.

Conclusion: the extra "nice" processes on the CPU had in fact been slowing down the Oracle database.

So, given these experiences, on multi user, multi tasking Oracle, I don't think it's a good idea to have 100% CPU server utilization for sustained periods of time. Especially if there are a lot of inserts or updates (reads and writes to the hard drives) occurring.

Oracle Performance Tuning

2010-01-20T20:33:00.000-06:00

I guess the first entry to start my notes should be the one thing I’ve already done a lot of writing on.

Since I started working with the Oracle database in 1995, I've always been very concerned about tuning, performance and response times. Even with the poor software and hardware that we had, I still had to make it work fast. Even though much of the conventional wisdom at the time was to just buy faster hardware, this was never an option at the companies where I worked. I made things go fast by doing what I could do; changing the code, not by buying new hardware.

Later, I was promoted from a developer, to a DBA, and a unix admin. A new job in year 2000 - 2001 gave me a daunting challenge. The startup wanted to insert ONE BILLION rows of data into an Oracle 8i database, every day. Which is about 11,000 rows per second. This is not difficult now, but with year 2000 hardware and Oracle 8i software, I was only getting about 6,000 row inserts per second to begin with on the hardware I had. I researched how to do this all day and evening. It took me very deep into Oracle internals and storage.

One of my “few” discoveries was that a number of the tuning paradigms at the time, after I tried them, really made absolutely no significant difference at all. Some of these concepts were whether we used RAID 0, 1, or 5, and hit ratios in Oracle's buffers. My rigorous experiments where I modified only one variable at a time, such as the RAID setting, produced no difference in the data results at all. The data results were not supporting the paradigms.

For those of you who are firm believers that RAID 0 or 1 is faster than RAID 5, that may be true at the hard drive level. However, the slowest part of doing those 11,000 inserts on average per second was in fact Oracle's Log Writer (LGWR). The LGWR was slower than the hard drives that wrote the log to disk. Even those disks set at RAID 0 or 1. While Oracle can have many parallel server processes reading the data, and many database writer (DBWR) processes writing the data, there is only one log process. And, it MUST be sequential. And it must work without fail, otherwise the Oracle database stops. When we used Spotlight on Oracle during these heavy insert processes, the indicator for the log writer turned red, red, red. Eventually, I was able to get 13,000 inserts per second. But it wasn’t easy. And it was not achieved by the paradigms that I had had been advised to do.

Fortunately, since then, a number of Oracle researchers such as Tom Kyte, and Cary Millsap did experiments that exposed the flaws of some of the original paradigms of Oracle tuning. They made perfect sense to me. Google for: “Why a 99% buffer cache is NOT Ok”

A few years later, I presented at the Oracle User's Group on PLSQL and SQL tuning. There was not much theory. It was pretty much all case studies on how I dramatically sped queries up from hours, to minutes. And sometimes, hours to seconds. I've received compliments in emails from Germany, Italy, and India about my ideas. Many websites are referencing it around the world. You can google my name, or find the presentation here:

home.earthlink.net/~rodger22/plsql.htm

I resonate a lot with the experts Tom Kyte and Cary Millsap. Don’t speculate. Do the experiment, show me the data, and analyze it. Draw conclusions based on the data, not the other way around. If you have not read any of Tom Kyte’s or Cary Millsap’s work, it’s highly recommended. Do look them up.

Method-r.com

Asktom.oracle.com