OCROSD]utgdv:ocr loc file cannot be opened

[] [] [] [] [] [] [] [] []

Symptom

A trace file in saptrace/usertrace contains the error message:
[ OCROSD]utgdv:2:ocr loc file cannot be opened
[ OCROSD]utopen:1: Couldnt find ocr,[ocrmirror] location in config file
[ OCRRAW]proprinit: Could not open raw device
[ default]a_init:7!: Backend init unsuccessful : [33]
[ CSSCLNT]clsssinit: error(33 ) in OCR initialization

Other terms

oradict_stats, dbms_stats, ocr, ossd, asm
Reason and Prerequisites

The problem is caused by Oracle bug 5938326 (unpublished).
This can occur if:
brconnect -u / -c -f stats -t oradict_stats
is started
or
DBMS_RDBMS.GATHER_FIXED_OBJECTS_STATS
is executed manually in SQLPLUS.
Patch set 10.2.0.4 is installed in the database.
The option ASM or RAC is not installed.
The error occurs if the fixed view X$KFGRP is queried by SQL. This is the case during the creation of fixed object statistics.
The view X$KFGRP is an ASM-specific view. If the ASM is not installed, the query about it is unnecessary but it is performed by default, and it then writes an error message in a trace file because the required configuration is not found.
The error itself is harmless, and the system continues to determine the statistics correctly.

Solution

You can ignore the error message.
The patch set 10.2.0.5 contains a fix, but there is no fix for patch set 10.2.0.4 because the conversion is too time-consuming.
We do not recommend the workaround specified in Oracle Metalink Note 798603.1 due to previously unknown side effects in an SAP installation.

[Slashdot] [Digg] [Reddit] [del.icio.us] [Facebook] [Technorati] [Google] [StumbleUpon]

Leave a Comment