Grid Control, OMS : large number of defunct-processes

By | 2009-03-31T10:32:21+00:00 March 31st, 2009|Categories: grid control|Tags: , |

On my Grid Control management-server (Suse Linux, OMS version 10.2.0.4) a very large number of <defunct> processes arose what eventually caused the OMS not to respond anymore.

Looked like this:
oracle   16932 15961  0 Mar03 ?        00:00:00 <defunct>
oracle   16987 15961  0 Mar03 ?        00:00:00 <defunct>
oracle   17027 15961  0 […]

Time-outs in web-forms environment

By | 2009-03-31T10:30:08+00:00 March 31st, 2009|Categories: App. Server|

Always confused with time-outs in a web-forms environment, so I wrote it in very short terms down to be memorized. Note 549735.1
on Metalink is the best source by the way where it is explained what time-outs you can use best, in this kind of environments

Three parameters of vital importance:

* FORMS_TIMEOUT […]

Every 5 seconds vpxoci-error in emagent.trc, ora-25228

By | 2009-03-27T20:30:51+00:00 March 27th, 2009|Categories: grid control|

Noticed that the following error was popping up in the emagent.trc of a 10.2.04 – Grid Control-agent  on a specific node, every 5 seconds. Annoying, unnecessary:

2007-09-18 12:15:14 Thread-134875 ERROR vpxoci: Error on dequeue from SYS.ALERT_QUE: ORA-00604:
error occurred at recursive SQL level 1
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at line 30
ORA-25228: […]

Connecting AS SYSDBA results in "Connected to idle instance"..

By | 2009-03-23T16:49:36+00:00 March 23rd, 2009|Categories: Database|

Most of the time I don’t even think about how I connect to a database: set the environment – variables,  connect /as sysdba, and voila..

Then I ran into a node in which this was not as simple as I thought. Only connections through the listener were accepted. After serious investigation […]

Bad Hummingbird performance (doc.mgmt.system)? Upgrade to 10.2 !

By | 2009-03-16T20:56:12+00:00 March 16th, 2009|Categories: Database|

Hummingbird, the document management system, uses an Oracle database 91 on Sun at this company. Performance of several functions were very bad. 40 seconds to give me a document in some cases.  Bad sql-statements all over the place.

Installed a Linux system with 10.2.0.4 on it, made an export on SUN […]