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

Is it possible to do a RMAN backup of the Flash Recovery Area (FRA) to disk. The standard method by RMAN is that this is only possible with the use of a SBT channel/library. The RMAN command ' BACKUP RECOVERY AREA ' works only with SBT channels, meaning a tertiary storage such as tape. Oracle has introduce an emulator for SBT library to do a backup of the FRA to disk. The RMAN disksbt library, which emulates a SBT library (but it writes the backups to a disk location). This disksbt , can be used to test backup the FRA to a disk location

New Behaviour for datafile: In patch set 11.2.0.2 a new behaviour for datafile write errors has been implemented.With this release ANY write error to a datafile will cause the instance to abort. Before 11.2.0.2 those errors usually led to an offline datafile if the database operates in archivelog mode (your production database do, don’t they?!) and the datafile does not belong to the SYSTEM tablespace. Internal discussion found this behaviour not up-to-date and alligned with RAC systems and modern storages. Therefore it has been changed and a new underscore parameter got introduced. _DATAFILE_WRITE_ERRORS_CRASH_INSTANCE=TRUE This is the default setting´and the new behaviour beginning with Oracle 11.2.0.2 If you would like to revert to the pre-11.2.0.2 behaviour you’ll have to set in your init.ora/spfile this parameter to false. But keep in mind that there’s a reason why this has been changed. More info in MOSC Note: 7691270.8 New Behaviour for Automatic Mamory ...

Clusterware References; Pro Oracle Database 10g RAC on Linux Metalink Notes 259301.1 CRS and 10g RAC This note contains a useful awk script to improve the output of crs_stat -ls 436067.1 Windows CRS_STAT script to display long names correctly 309541.1 How to start/stop the 10g CRS Clusterware 263897.1 How to stop Cluster Ready Services (CRS) 298073.1 How to remove CRS auto start and restart for a RAC instance 295871.1 How to verify if CRS install is valid 316583.1 VIPCA fails complaining that interface is not public 341214.1 How to cleanup after a failed (or successful) Oracle Clusterware installation 280589.1 How to install Oracle 10g CRS on a cluster where one or more nodes are not to be configured with CRS immediately 357808.1 CRS Diagnostics 272331.1 CRS 10g Diagnostic Guide 330358.1 CRS 10g R2 Diagnostic Collection Guide 331168.1 Oracle Clusterware consolidated logging in 10gR2 342590.1 CRS logs not being written 357808.1 Diagnosability for CRS/EVM/RACG 459694.1 ...

Regarding to the scan listener is the relocation not being handled correctly by Oracle Enterprise Manager(OEM) 11gR1 (shows target as down after relocate!), Oracle has solved this by the following bugs/fixes: