Help!! Oracle, HP3000 MPE/iX, PowerHouse

[Darren Reely]

Rodney,

I can only give you an example from a unix environment.  It may help you
get some of the parameters correct.

Here is what we use for both our development and production system.  Since
the app is on the same machine as the Oracle database, there is no need for
a remote logon string.

Database MFG             &
  Type ORACLE            &
  Null values allowed    &
  Open ORACLE@OPS$USER   &
  Owner PDATA

ops$user = is the user logon name


Here is a sample I just created.  I accessed our production database from
out development box.

create dict mypdc not preloaded
database mymfg &
  Type ORACLE   &
  Null values allowed   &
  Open ORACLE@reely@mfg/mypassword &
  Owner PDATA
load

mypdc = my PH dictionary
mymfg = how you refer to the database eg. access table in mymfg
reely = username
mfg = the tnsnames entry for the database
mypassword = obvious
PDATA = here is both the schema and the owner of the schema
        I believe it really means the schema name, based on
        a 'show databases' while I was in quiz.

Hope this helps.

Darren


Rodney Behrendorff wrote:
> 
> 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.
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.