Help!! Oracle, HP3000 MPE/iX, PowerHouse

[Rodney Behrendorff]

Thanks to all those who replied with various hints and ideas.

We have now managed to get PowerHouse to talk to Oracle on a HP3000.

The first step was to correctly set up the MPE and ORACLE environment (eg.
the files listener.ora and tnsnames.ora, starting the listener and the net
server etc.) with assistance from Oracle documentation and Oracle Support.
When we could successfully use "sqlplus ownername/password@TNSNAME" (i.e.
access the Oracle database via the tnsnames.ora details), only then was it
time to address the PowerHouse issues.

All that was required for PowerHouse was:-

1.  A dictionary entry like

DATABASE OURDB &
  TYPE ORACLE &
  OPEN "ORACLE@ownername@TNSNAME/password" OWNER ownername

where:-
"OURDB" is what you refer to in PowerHouse e.g ACCESS EMPLOYEE_TABLE IN
OURDB
"ownername" is the Oracle owner of the tables (SELECT TABLE_NAME, OWNER FROM
ALL_TABLES will show you this)
"TNSNAME" is the entry in the tnsnames.ora file that points to the database
"password" is the password of ownername

2. SETVAR TNS_ADMIN "/ORACLE/NETWORK/admin" i.e. the location of your
tnsnames.ora file

We didn't seem to need the rest of Knowledge Base document KB76487CS (yet?)
and in particular, after receiving information from Oracle Support, suspect
that the instruction to SETVAR ORACLE_HOME "/ORACLE" (or the location where
Oracle has been installed) may not be correct.  For MPE, ORACLE_HOME is
apparently always the account and group where the database is (unlike in
Unix where it is the location of the software), and is specified in the
listener.ora file so doesn't seem to be needed to be SETVAR'ed.

Thanks again for all your assistance,
Rodney.


Rodney Behrendorff
Data Administrator
University of Southern Queensland
Toowoomba QLD Australia
Ph 07 46312621
Email: Rodney.Behrendorff@usq.edu.au
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.