Knowabouts regarding C# webservices connecting Oracle database


A java-progam (.jar) is calling a webservice, written in C#. I’m able to unzip the jarfile or load it in JDeveloper to detect which service it is calling, but how do I know the service is listening to that name? Especially it’s not documented and I don’t have a clue about the name of the wsdl-file.

But, I’m an administrator, and in my case I’m able to log in on the Windows-server where the webservice reside. And I’m looking for a service which might be called ‘HummingBirdService’.
– Start –> run –> inetmgr
– The Internet Information Services (IIS) Manager is started.
– Browse to the tree below the node-name, to ‘Web Sites’ –> ‘Default Web Site’ –>and (yes!)  ‘HummingBirdServices’.
(when you rightclick this by the way, the directory of the files on the right side is shown at the button ‘properties’)
– On the right side of this window the file ‘HummingBirdServiceHost.svc’ resides .
– Right click on this filename (still in the inetmgr !) and choose browse…
A browser opens and the method to call your service is shown by means of an URL.


A webservice, written in C#, is calling an Oracle Database. Oracle 9i client has been installed.
Message appears: “System.Data.OracleClient requires Oracle client software version 8.1.7 or greater”.

What is missing here is the data provider for .NET. The standard is missing that option.
To correct this: download the ODAC-install for 9i here (at the bottom of the page the last time I looked). This is a which includes the data provider for .NET.
Then install (custom option, same home as the standard the oracle data provider for .NET in oracle

By | September 28th, 2009|Categories: App. Server|Tags: , |0 Comments

OID gives status NONE. Error: sgslunlListen: Bind Failed On Communication Endpoint

Installed and configured application server  on VM-ware with guest-OS Suse Linux 9. All worked fine, until a (hard) reboot by system admin. OID can’t connect to the default port 13060.

Error in $ORACLE_HOME/ldap/log/oidldapd01.log :

“Bind Failed On Communication Endpoint”  and “Dispatcher Process unable to bind to port”

Because it was a rough shutdown, I cleaned up all the necessary things like ods.ods_process, state-directory, ‘netstat -a’ etc., all the things the note 329808.1 (Troubleshooting OID) also is mentioning.  Ldapbind still didn’t want to connect.

Even thought of note 444873, about not setting the ‘setuid’ on the mountpoint, and checking the firewall. Permissions of the files perhaps…

Eventually I just ran $ORACLE_HOME/ again in the ORACLE_HOME of the infra. Problem solved…. Aaargh !! How on earth is it possible!  Most likely I made a mistake while installing (I was root too at that moment) and ran only at the middle-tier. Can’t think of any other reason for the time being unfortunately.

Had to be sleeping at the time, or just getting old..  No comment on the last remark please 🙂

By | September 10th, 2009|Categories: App. Server|Tags: , , |2 Comments

Object ODS.OID_RESPONSE_ARRAY_TYPE does not exist, Grid Control

After installing Oracle Application Server, with corresponding OID,  Grid Control 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
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

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/
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

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:


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

Creating / deleting a reports server in OAS 10.1.2, integrated with EM/AS-console

Creating a reports server and integrate it with Enterprise Manager / iasconsole

– Under control of opmn (wil be automatically restarted)
– Visible and manageable under Enterprise Manager.

1. Create/start a new reports server : “$ORACLE_HOME/bin/ repproject
2. A small window will pop-up, showing that the reports server is starting up.
3. After it’s status is ready, stop this server.
4. Register this new reports server (you can do this also by hand, in the section of deleting this, you can also see what files you will have to update to insert or delete a reports server).

$ORACLE_HOME/bin/ repproject

The command registers the reports server to OPMN and Enterprise Manager.

The following entry is added to $ORACLE_HOME/opmn/conf/opmn.xml (sorry for the layout) :

<ias-component id=”repproject” status=”enabled” id-matching=”false”>
<process-type id=”ReportsServer” module-id=”ReportsServices”>
<process-set id=”repproject” restart-on-death=”true” numprocs=”1″>
<variable id=”PATH” value=”/home/ias10g/OraHome1/bin:/usr/bin:/usr/ccs/bin:/bin:/usr/kerberos/bin:/opt/IBMJava2-131/bin:/opt/IBMJava2-131/jre/bin:/bin:/usr/bin:/usr/local/bin:/usr/bin/X11:/usr/X11R6/bin”/>
< module-data>
<category id=”general-parameters”>
<data id=”batch” value=”yes”/>
<category id=”restart-parameters”>
<data id=”reverseping-timeout” value=”120″/>
<OID infrastructure=”true”/>
<database infrastructure-key=”portal”/>
<managed-process ias-component=”OC4J” process-type=”OC4J_BI_Forms” process-set=”default_island” autostart=”true”/>
<managed-process ias-component=”HTTP_Server” process-type=”HTTP_Server” process-set=”HTTP_Server” autostart=”true”/>
<start timeout=”120″ retry=”3″/>
<stop timeout=”120″/>
<restart timeout=”120″/>
<ping timeout=”30″ interval=”30″/>


By | July 10th, 2009|Categories: App. Server|Tags: , |1 Comment