PowerHouse and Oracle on Solaris -- howto?

Fri May 8 10:10:29 CDT 2009

Something else to try, set LD_LIBRARY_PATH to

$ORACLE_HOME/lib32;$PH_USR/lib

assuming that your ORACLE_HOME and PH_USR variables have been set up,

Regards

Erik Hurworth
Senior Support Specialist
Customer Success and Support

Office:  +44 (0) 1344 707799
Email: hurworth at uk.ibm.com

IBM Business Intelligence and Performance Management
Westerly Point, Market Street, 
Bracknell, RG12 1QB, 
United Kingdom 

This message is intended for use of the individual or entity to which it 
is addressed and may contain confidential information. If you received 
this in error, please contact the sender and delete the material from any 
computer. 

From:
"Greig Morrison" <greig.morrison at sympatico.ca>
To:
<powerh-l at lists.sowder.com>
Date:
08/05/2009 16:05
Subject:
RE: PowerHouse and Oracle on Solaris -- howto?

John,

Things to check:

1. A PowerHouse license for ORACLE access.
2. The Oracle 32bit client installed on the PowerHouse machine.
3. Environment variables
4. PDL entry.
5. Test the oracle client using sqlplus

License:
FEATURE PH8-UNIX-ORACLE-DATA-ACCESS ...

Oracle 32bit client:
In my example Oracle 9i installed in /usr/app/oracle/product32/9.2.0.1.0
PowerHouse is a 32bit app and requires the 32bit Oracle client installed
even if you have 64bit Solaris.

Environment variable:
ORACLE_HOME=/usr/app/oracle/product32/9.2.0.1.0
TNS_ADMIN=/usr/app/oracle/product32/9.2.0.1.0/network/admin
LD_LIBRARY_PATH=/usr/app/oracle/product32/9.2.0.1.0/lib
ORA_NLS33=/usr/app/oracle/product32/9.2.0.1.0/ocommon/nls/admin/data
ORDBA=ordba9

PDL entry:
Database oracledb  Type ORACLE   NULL VALUES ALLOWED   Open  &
           "ORACLE@$ora_username@$ora_instance/$ora_userpswd" &
          Owner DBOWNER
;Note: $ora_username, $ora_instance, $ora_userpswd are all environment
variables.

Regards,
Greig

-----Original Message-----
Date: Thu, 07 May 2009 08:51:34 -0600
From: John MacLerran <macljohn at isu.edu>
Subject: PowerHouse and Oracle on Solaris -- howto?
To: powerh-l at lists.sowder.com
Message-ID: <4A02F576.30401 at isu.edu>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed

Dear PowerHouse list

I'm new to using PowerHouse with Oracle, and I'm trying to get the two
to talk nicely together.  (Sorry if this is a duplicate. I sent it
yesterday, but it didn't show up in the list archives, and I never
received notification that it posted, so I figure it got held
somewhere.)

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!

-- 
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l at lists.sowder.com
Subscribe: 'subscribe' in message body to 
powerh-l-request at lists.sowder.com
Unsubscribe: 'unsubscribe &lt;password&gt;' in message body to 
powerh-l-request at lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
Add 'site:lists.sowder.com powerh-l' to your search terms to search the 
list archive at Google.

Unless stated otherwise above:
IBM United Kingdom Limited - Registered in England and Wales with number 
741598. 
Registered office: PO Box 41, North Harbour, Portsmouth, Hampshire PO6 3AU

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20090508/c0d32283/attachment-0001.htm 