PowerHouse and RMS/Oracle Databases

[Victor Geere]

The question of whether it will work on two separate machines is more an Oracle question than a powerhouse one.
Since powerhouse only needs a tnsname on the client, the rest is up to Oracle.
If Powerhouse and Oracle runs on the same machine you still need to load an Oracle client that talks to the Oracle server. The fact that it is on the same machine is circumstantial.  

The same would have applied if you had a web server attaching to an Oracle database on the other side of the globe when the web server has a tnsname set up that points to the Oracle server.

You can test the tnsname by installing Oracle client, HTTP server, tnsname on one machine that points to an Oracle server on the other machine and look at the Oracle server through http://machinename:7777 on the web server before you start converting anything.

hth

Victor


Here is a question for those with experience of:
*	Compaq Alpha,
*	Running OpenVMS 7.1-1H1,
*	With PowerHouse (7.10G2 at present - we realise that this will need
to be upgraded to 8.30D to use Oracle) application, 
*	Using RMS data files,
*	And Oracle!

We will need to read and write to an Oracle Database on a 'box' running a
'flavour' of Unix (yes - for those of you who may have guessed, this machine
and operating system have not yet been completely specified/purchased yet)

With the added 'feature' of having the PowerHouse application server some
distance away (100's of miles) to the Oracle Application server over a 2mb
network link.

I understand from Cognos we will need to upgrade to PowerHouse 8.30D (and
recompile the application), install an PowerHouse Oracle licence, install an
Oracle user licence for the Alpha and configure necessary TNS.ORA file,
sequel net etc...

Although this will probably work where the RMS files and Oracle database are
on the same machine, we have no idea if it will work on between two
machines/two operating systems/two locations over a 2mb WAN...

Does anyone have any experience of this?

Will it work?

How well will it perform?

TIA

Regards,


Trevor Dockeray