Identify your JDBC Connection in v$session

A major problem for DBA's is the fact that in the v$session view it's really hard to identify which session comes from which J2EE Application.A select over the v$session view just shows the connected users and from which machine the connect is established, but we can't see from which J2EE Application the sessions are coming :-(With Oracle AS 10.1.3.x we have the possibility to add a property in the data-source.xml, that is displayed in the column...

Read More

SUN's JRE 1.6 Certification for Oracle Forms

Since a short time SUN's JRE 1.6.0_04 is now certified for usage of Oracle Forms 10g Release 2.The only pre-requirement is that the Patchset 3 (10.1.2.3.0) for the Oracle Application Server (Oracle AS) must be applied.The installation of the Patchset 3 for the Oracle AS normally don't cause any problems. My first tests with the JRE 1.6.0 shows, that the initial startup time (loading of the Applet) is faster :-) Additional informations about my tests will be posted later.Original Statement from Oracle Technology Network:"We have finished the certification...

Read More

Good old Days

Original posted 18th Apr 2008:Normally, you will find here something about Oracle Application Server, but today I discover the "Good old Days" again with Oracle 4.1 on MS-DOS The startup was really simple, just type the command ORACLEand after this startup your instance with the IOR utilityLook at the SGA Size: 16K nothing with MB or GB.Instead of SQLPlus, we got the UFI (User Friendly Interface):Even on Oracle 4.1 user scott was existing. And an...

Read More

OpenWorld 2007 Presentation about Oracle AS 11g

Original posted 21st Nov 2007:Today I found a cool presentation about the future of Oracle AS 11g from John Lang (Group Manager, Fusion Middleware Product Management).There will be a complete break of technology, structure, concept and administration of the Oracle AS. Some highlights are:Separation of binaries and configuration filesSeveral command line interface (CLI) will be merged into one CLI called asctlJ2EE 1.5 StandardOne Software installation...

Read More

WebUtil and Oracle AS 10.1.2 PatchSet 2 Problem

Original posted 13th Oct 2007:During the last weeks I faced with two customers some problems concerning WebUtil and Oracle AS 10.1.2.2.0, e.g. a Reports Call over WebUtil was not working or the WebUtil function file_open_dialog was not working a.s.o. Under Oracle AS 10.1.2.0.2 everything was working fine. The problem came out of the PatchSet 2 (Patch-No. 4960210) which didn't apply the frmwebutil.jar to the Oracle AS you wanted to patch. To solve this problem just follow these steps: unzip the PatchSet 2 to any directory which you prefergo to the...

Read More

Network Traffic in Oracle Forms

Original posted 4th Oct 2007:Regularly I get the questions from my customers "What is the network traffic in my Forms applications?". A simple way to display the number of transmitted bytes and number of round trips is to add the parameter networkStats=true in your Named Configuration inside your formsweb.cfg configuration file. Additionally you have to modify the corresponding base*.htm or webutil*.htm as follows: <PARAM NAME="networkStats" VALUE="%networkStats%"> Inside the Tag <EMBED...> add following: networkStats="%networkStats%"...

Read More

Installing WebCache Standalone 10.2.0.2 on Redhat 64bit

Original posted 14th Sept 2007:Sometime ago I run in some problems during the installation of Oracle WebCache Standalone 10.2.0.2 on an Redhat 4 x86_64 system. All prerequirements were made, the Oracle Universal Installer didn't complain anything, but during the link process following error message came up: error while loading shared libraries: libclntsh.so.10.1: cannot open shared object file: No such file or directory After some investigations my ex-colleague from Trivadis (Engelbert Wystrach) and me came to following solution: create as root...

Read More

Reports 10.1.2. and SuSE Enterprise Linux 10

Original posted 11th Sept 2007:Officially the Oracle AS 10.1.2 is not yet certified with SLES 10 and therefor Reports 10.1.2. is not certified. Nevertheless the Oracle AS 10.1.2 is installable on SLES 10, but if you try to run a Report you are receiving an error. The corresponding logfile $ORACLE_HOME/opmn/logs/OC4J~OC4J_BI_Forms~default_island~1 shows following error stack:java.lang.UnsatisfiedLinkError: /u00/app/oracle/product/as-fr-10.1.2/lib/librwu.so:/usr/X11R6/lib/libXm.so.2: undefined symbol: _XsetlocaleTo resolve this problem perform...

Read More

Did you forget the password of the ias_admin user?

Original posted 10th Sept 2007:Your colleague installed an Oracle AS Environment, went on holiday and didn't tell you the password of the ias_admin user to access the administrative WebInterface Application Server Control (ASC) or you installed your Oracle AS long time ago and forgot the password of the ias_admin user? If you have an Oracle AS environment which is NOT connected to an Oracle AS Identity Management (IDM), here is a small trick to reset the password of the ias_admin user.Just go to the directory $ORACLE_HOME/sysman/j2ee/conf. In this...

Read More

Oracle Internet Directory Light for tnsnames Resolution

Original posted 9th Sept 2007: Since a few days the Oracle Authentication Service for Linux (http://www.oracle.com/technology/products/oid/oracleauthenticationservices.html) is available. Mainly this technology preview is addressed to handle User Authentication of Linux Desktops. I had a closer look on this product and what I saw is, that the Oracle Authentication Service for Linux is an Oracle Internet Directory (OID) just as an RPM-File (Size...

Read More

Welcome to my new Blog

As I move my Blog from http://blogs.trivadis.com/blogs/dirknachbar to here, I'll fillup my old entries in the next days.So please be patient ...

Read More