Knowabouts regarding C# webservices connecting Oracle database

First:

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.

Second:

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 9.2.0.1-client 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 9.2.0.1-client which includes the data provider for .NET.
Then install (custom option, same home as the standard 9.2.0.1-client) the oracle data provider for .NET in oracle 9.2.0.7

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

Headstart 10g installation/configuration 6.5.4

10 years ago the installation and configuration of Headstart was a lot of sweating, mostly not automated installation-scripts with a lot of faults in it. And thank God it has not changed!! Scripts are Windows-oriented, documentation is not quite self-explainable.

I am not allowed to publish an updated documentation, but sharing experiences is something else.

Maybe still unclear, but 1 different grant or statement in Headstart can make a world of difference…

Situation

- Designer repository-database op Linux, had ooit iemand half Headstart 6.5.0 op geïnstalleerd

- Applicatieserver op Linux (10.2.0.2), idem.

- Windows-clients.

Downloaded:

- PATCH6540_FOR_10G.zip (looks like a patch, maar it isn’t a patch…)

- PATCH65401_FOR_10GR2.zip ( indeed, it is a patch)

- ONE_OFF_QMSOLM65.zip

Install this in this order on your windows-client and on the applicatie-server, check with “unzip –l” where the files will come. Chosen by me: c:/hst10g en /software/hst10g.

Compile the forms, libraries, menu’s against the hst65-user in de designer-repository, will we do this in another step.

Next step

Got the installation document ‘Installation Instructions for Oracle Headstart 6.5.4.0 for 10g (Revision 6.5.4.1 for 10g)’. This document is not in the base-set you download…. Exists of 4 parts, client (1) , application server(2), the development database (3) and the designer repository (4)

1. Client

Put the shortcuts of the directory ‘environment-setup’ on my desktop, updated the properties. The documentation keep mentioning about ‘forms90’ which is not right. Your URL for the serverinstall could be something like ( my case: “LTOA”,domain JOBACLE, de URL ) : http://ltoa.jobacle.nl:7778/forms/frmservlet?config=hsd65_serverinstall .A little bit in the blind, on the application server isn’t installed anything yet.

2. On the application server LTOA

The documentation tells me that you have to update the file <10gasbifhome>\j2ee\OC4J_BI_Forms\config\oc4j.properties (back-slashes, so this will not work..) in order to use hsd65formsweb.cfg.

Advice: don’t do that. Several tools […]

By |June 8th, 2009|App. Server|0 Comments