Object ODS.OID_RESPONSE_ARRAY_TYPE does not exist, Grid Control 10.2.0.5

After installing Oracle Application Server 10.2.0.2, with corresponding OID,  Grid Control 10.2.0.5 gave me the obove mentioned error, and the the item OID a ‘metric collection error’.

To fix the metric collection error downloaded and applied Patch 5686191 on top of OID product.This is a sql-script to run against the OID-repository. Unpublished bug according to note 764088.1

Shutdown the DAS:

~/media/5686191> opmnctl stopproc process-type=OC4J_SECURITY

~/media/5686191> /software/oracle/product/10.2/infra/OPatch/opatch apply

Oracle Interim Patch Installer version 1.0.0.0.52
Copyright (c) 2005 Oracle Corporation. All Rights Reserved..

We recommend you refer to the OPatch documentation under
OPatch/docs for usage reference. We also recommend using
the latest OPatch version. For the latest OPatch version
and other support related issues, please refer to document
293369.1 which is viewable from metalink.oracle.com

Oracle Home = /software/oracle/product/10.2/infra
Location of Oracle Universal Installer components = /software/oracle/product/10.2/infra/oui
Location of OraInstaller.jar  = “/software/oracle/product/10.2/infra/oui/jlib”
Oracle Universal Installer shared library = /software/oracle/product/10.2/infra/oui/lib/linux/liboraInstaller.so
Location of Oracle Inventory Pointer = /etc/oraInst.loc
Location of Oracle Inventory = /software/oracle/product/10.2/infra/inventory
Path to Java = /software/oracle/product/10.2/infra/jre/1.4.2/bin/java
Log file = /software/oracle/product/10.2/infra/.patch_storage/<patch ID>/*.log

Backing up comps.xml …

OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only.

By |August 31st, 2009|Categories: grid control|Tags: , |1 Comment

Searching in source-code in Designer-repository

Especially for those who loves Designer, or who are forced to work with it.. :-( ,  2 scripts to search in de source-code of Designer (version 10.1.2.4):

Script 1 can be used for searching text-strings in the source of pl/sql in Designer.
Script 2 can be used to search for the use of column-names in modules.

Run this as the owner of the repository.

With thanks to Timo Schijf,  developer.

Script1 : Searching in  pl-sql code

set feedback off
set pages 50000
set lines 300
set trimspool on
set verify off

break on modulename skip 1

select name “Workareas:”
from sdd_workareas
;

prompt
prompt
accept workarea_name default ‘GLOBAL SHARED WORKAREA’ char prompt ‘Name of Workarea [Default: GLOBAL SHARED WORKAREA] : ‘

prompt
prompt
accept searchstring char prompt ‘Text-string : ‘

begin
jr_context.set_workarea (’&&workarea_name’);
end;
/

select distinct name “Applications in this workarea:”
from ci_application_systems
;

By |August 14th, 2009|Categories: Database|Tags: , , |0 Comments

Adding a true-type font to Reports Services while running Reports deployed on the web

Problem: A report, designed for generating PDF with the true-type font Univers in it, does not work while deployed on the web, and uses other fonts instead.
Cause: there’s no Univers installed in the Reports Services on Unix.
Solution: install the font and configure the Reports Service!  Sounds simple…

In the process of figuring this out, I had several error-messages, like rep-1352 (The fonts specified for this report cannot be found for the character set specified by NLS_LANG) , and rep-1 (nothing else…).
Took a lot of time to eliminate those errors, partly because there was a feature in the specified report what did’nt speed up the process of resolving this issue: embedded html. This caused for example the “rep-1″-error.

With special thanks to Marc Riesewijk, developer:

1. First, make a so called ‘AFM’-file of the font-files from your windows-client, which will be used to copy to the Linux-server.

In the case of Univers there are the following files in c:\windows\fonts:
-unvr55w.TTF
-unvr56w.TTF
-unvr57w.TTF
-unvr58w.TTF
-unvr65w.TTF
-unvr66w.TTF
-unvr67w.TTF
-unvr68w.TTF

m4s0n501
By |August 11th, 2009|Categories: App. Server|Tags: , , , |0 Comments