Joords Oracle DBA blog

Customize your Firefox to use acronym and contents of mentioned Metalink Note displayed without the need to open Metalink web site. “mn 1269139.1″ ( mn was an acronym for Metalink Note)  How to do this see the blog of   Oleksandr Denysenko's Blog

The Problem Enterprise Manager Database Control with Oracle Database 10.2.0.4 and 10.2.0.5 " The DBCONSOLE" will not work. The root certificate used to secure communications via the Secure Socket Layer (SSL) protocol will expire on 31-Dec-2010 00:00:00.  ATTENTION - Enterprise Manager Database Control 10.2.0.4 Or 10.2.0.5 - Patch Required from 31-Dec-2010 onwards [ID 1217493.1] Solving this problem If you plan to configure Database Control with either of these Oracle Database releases, Oracle strongly recommends that you apply   Patch 8350262   to your Oracle Home installations before you configure Database Control. Configuration of Database Control is typically done when you create or upgrade Oracle Database, or if you run Enterprise Manager Configuration Assistant (EMCA) in standalone mode.

After upgrading to the 10.2.0.5.0 release the database is encounter a file handle leak.  The leak is seen in production and development instances. The leak happens on different processes (emagent and MMNL process are the current ones).  Test on growing of openfiles: lsof -p 10140 |wc -l => 600 lsof -p 10140 |wc -l => 759 Now we wait for the sollution of oracle to solve this bug. The max file limit has been reached so the db will have to be shutdown or the  process killed, if possible, to free up files. The leak happen over time and manifests itself when the limits are reached as error ORA-27041. The sollotion VARIOUS ORACLE PROCESSES CONSUMING LARGE QUANTITIES OF FILE DESCIPTORS (NFILES) Patch 9981011 . For us we need the  Patch download for Oracle 10.2.0.5 on HP-UX Itanium. This patch is also suitable for a 10.2.0.5.1 home, there are no conflicts with 10.2.0.5.1