DBA in the Trenches

During a PSU check I saw a list of patches that are recommended. I saw a list that has JVM and the DB bundled. I wasn't sure what this was and which one I should apply. After some digging around I understood that I could check whether I had JVM installed on the database although now I understand that with EBS it will probably be used by the database. This quick and dirty SQL will give you a list of components loaded into the database. One of which will be JServer JAVA Virtual Machine Release XXXXXXX. If its not there you probably don't have it installed. SQL> set pages 100 SQL> select * from all_registry_banners; BANNER -------------------------------------------------------------------------------- Oracle Database Catalog Views Release 11.2.0.4.0 - 64bit Production Oracle Database Packages and Types Release 11.2.0.4.0 - Development JServer JAVA Virtual Machine Release 11.2.0.4.0 - Development Oracle XDK Release 11.2.0.4.0 - Development Oracle Database Java Pac...

When opening a form the Java Security pop shows but then freezes and you can't continue. The only way to close the form is via Task Manager. Solution Control panel > Java > Advanced > Java Plugin > [Disable] Enable the Next Generation Java Plug-in. Reference: ORACLE FORMS – THE APPLICATION’S DIGITAL SIGNATURE HAS AN ERROR – YOUR FORMS APPLICATION IS FOZEN

In accessing R12 applications, it throws the security warning message "The application's digital signature cannot be verified" In some of the client machine once this warning message pops-up, their IE session is getting hanged. Only option is to kill the session from task manager. This is creating problems with application users and hence provide us a solution to get rid of this warning message.  Solution Control panel > Java > Advanced > Security > Disable verification Reference:  Bug 11847386 : NEED TO SUPRESS R12 HANGING WARNING MESSAGE

public class SimpleJava {       public void showMessage() {       System.out.println("Here we are");    } }    Ran into this small little problem when compiling java to use in an Oracle procedure. ORA-29516: Aurora assertion failure: Assertion failure at eox.c:359 Uncaught exception System error: java/lang/UnsupportedClassVersionError I could understand that I had somehow compiled the class using an incorrect version but seeing as I had done this from the server I thought I would have been OK. A bit of digging and I came up with the following: Find the version the class was actually compiled in: javap -verbose SimpleJava This gave the following output along with some other info: public class SimpleJava extends java.lang.Object SourceFile: "SimpleJava.java" minor version: 0 major version: 50 Table of versions: major  minor Java platform version  45       3       ...

This will be an on going series of posts as i find out more shortcuts in various programs. This is for eclipse and a simple quick shortcut for printing out a line. Type: syso + ctrl + space Result: System.out.println(); Its the little things in life that make is easier