Object ODS.OID_RESPONSE_ARRAY_TYPE does not exist, Grid Control 10.2.0.5

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

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 gave 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.

Searching in source-code in Designer-repository

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

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
;

[…]

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

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

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

[…]