It’s been a while since I posted anything, but I ran in to some problems with EM’s lately. I was working in a Windows environment and some how the dbconsole and iasconsole failed to start on several machines.

They all failed with the same error messages in emdctl.trc: http: snmehl_connect: connect failed to . The agent started just fine. but was unable to communicate with the dbconsole. The following error was found in the emagent.trc.

Thread-2952 ERROR fetchlets.sql: Error in getting session id and serial number for session 15998ac, = ORA-00942: table or view does not exist

On one machine I had this problem with an OID 10.1.4.2. The solution here was a file JAVA with no extension in $ORACLE_HOME/jdk/bin. This was an empty file and the dbconsole tried to use this file instead of java.exe. This problem can only occur on windows platforms. For more information see Oracle Metalink note 370913.1.