Help!! Oracle, HP3000 MPE/iX, PowerHouse

[Rodney Behrendorff]

Hi all,

Has anyone successfully managed to get PowerHouse to talk to Oracle on a
HP3000?

We have tried many combinations of things but so far can't get past the
following error:-

DMS-E-GENERAL, A general exception has occurred during operation 'attach 
database'.
ORA-12154: TNS:could not resolve service name

We have a few specific questions regarding the Knowledge Base document
KB76487CS, but any broader advice will also gratefully be accepted.  We have
worked through this document (which describes "How to connect to Oracle 7.3x
using Powerhouse version 8.19Cx") but are confused about the PDL dictionary
entry documented in step 3 as follows:-

3. Create a PDL dictionary that opens the Oracle database:
CREATE DICT oraphd NOT PRELOADED
DATABASE ORACLE7 TYPE ORACLE OPEN "ORACLE@ownername@tnsname/password" OWNER
ownername
LOAD

QUESTION 1:-  What exactly is the "ownername"?  Is it the MPE file owner, or
the Oracle user who owns the tables, or what?  If anyone has a "real world"
PDL entry that works, maybe they could send it to me (changing the password
etc) to help clarify what each of the parameters relate to in either the
Oracle or MPE environments.

QUESTION 2:- I presume "tnsname" corresponds to the entry in the
"/ORACLE/NETWORK/admin/tnsnames.ora" file.  I think we are also having
difficulty with this file and also the "listener.ora" file.  Some examples
of  "real world" versions of these would also be appreciated.

QUESTION 3:- The document (in Step 2) says to perform SETVAR ORACLE_HOME
"/ORACLE" i.e. where the Oracle software has been installed.  This is
consistent with its meaning in Unix BUT the HP3000 Oracle documentation says
that ORACLE_HOME should be set to where the actual database is.  The latter
seems to give us the most success with SQLPLUS etc.  Does anyone know why
this document says what it does in Step 2?

Our environment is PowerHouse 8.19.C3, MPE/iX 6, Oracle 7.3.4.1.0

Many thanks for whatever small or large morsels of wisdom or experience you
can share.

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.