Oracle Dictionary and Powerhouse

[John MacLerran]

Dear PowerHouse list

I'm new to using PowerHouse with Oracle, and I'm trying to get the two 
to talk nicely together.

OS is Solaris 10
Oracle version is 10.2
PowerHouse version is 8.43.F -- brand new...

Oracle is installed, and I can TNSPING the database I'm trying to 
connect to, and I can access it with SQLPlus.  However, when I create a 
PDL dictionary and try to access it in quiz, I get the following:

$setdict aiqdb.pdc
$quiz
Q U I Z   (PowerHouse  8.43.F)
Copyright (C) 2008 Cognos Incorporated. All rights reserved.

 > access spriden in BTEST

*W* SQL START DBE error (BTEST).
DMS-E-YV_LOADSGIFAILED, Unable to load the 'ordba' gateway. Please 
ensure that
the database software is configured correctly and is supported on this 
version
of the operating system.

SPRIDEN is a valid table in BTEST, and that's the database name I can 
TNSPING and access via SQLPlus.

Here's what I have in my PDL source:


database BTEST type Oracle    &
   open 'BTEST'              &
;;;   (note:  I've also tried  BTEST.isos.isu.edu -- the name that 
TNSPing returns and the service_name in the tnsnames.ora file)
   null values ALLOWED        &
   userid 'macljohn' password 'blahblah'      

The macljohn userid does have read access to SPRIDEN in BTEST.

I queried the list archives, and one message said that the resolution to 
the problems was that PowerHouse wasn't installed with Oracle support. I 
wasn't present when PowerHouse was installed on the server, but neither 
the Getting Started guide nor the Release and Install notes mentioned 
anything special that was needed to install with Oracle Support.  There 
is a section in the Getting Started guide that mentions that the 
LD_LIBRARY_PATH for the database must be set before executing the . 
setpow  script, and I've done that, but the error still occurs.  Did the 
LD_LIBRARY_PATH need to be set correctly before the install was 
started?  I don't believe that was done.

Where is the 'ordba' gateway that is mentioned in the error message?  Is 
that a PowerHouse component or an Oracle one?  I did a find . -name on 
it, and didn't find it, but that could be due to my rights not being 
correct.

I'd appreciate any insight.
Thanks!
-- 

----------------------------------------------------------------------
  John MacLerran              http://picasaweb.google.com/jmaclerran
  IT Analyst, Senior                       email:   macljohn at isu.edu
  Idaho State University                             V(208) 282-2954
  http://www.isu.edu/~macljohn                       F(208) 282-3673
----------------------------------------------------------------------