<br><font size=2 face="sans-serif">Something else to try, set LD_LIBRARY_PATH
to</font>
<br>
<br><font size=2 face="sans-serif">$ORACLE_HOME/lib32;$PH_USR/lib</font>
<br>
<br><font size=2 face="sans-serif">assuming that your ORACLE_HOME and PH_USR
variables have been set up,</font>
<br><font size=2 face="sans-serif"><br>
Regards<br>
<br>
Erik Hurworth<br>
Senior Support Specialist<br>
Customer Success and Support<br>
<br>
Office: +44 (0) 1344 707799<br>
Email: hurworth@uk.ibm.com<br>
<br>
IBM Business Intelligence and Performance Management<br>
Westerly Point, Market Street, <br>
Bracknell, RG12 1QB, <br>
United Kingdom <br>
<br>
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. </font>
<br>
<br>
<br>
<table width=100%>
<tr valign=top>
<td><font size=1 color=#5f5f5f face="sans-serif">From:</font>
<td><font size=1 face="sans-serif">"Greig Morrison" <greig.morrison@sympatico.ca></font>
<tr valign=top>
<td><font size=1 color=#5f5f5f face="sans-serif">To:</font>
<td><font size=1 face="sans-serif"><powerh-l@lists.sowder.com></font>
<tr valign=top>
<td><font size=1 color=#5f5f5f face="sans-serif">Date:</font>
<td><font size=1 face="sans-serif">08/05/2009 16:05</font>
<tr valign=top>
<td><font size=1 color=#5f5f5f face="sans-serif">Subject:</font>
<td><font size=1 face="sans-serif">RE: PowerHouse and Oracle on Solaris
-- howto?</font></table>
<br>
<hr noshade>
<br>
<br>
<br><tt><font size=2>John,<br>
<br>
Things to check:<br>
<br>
1. A PowerHouse license for ORACLE access.<br>
2. The Oracle 32bit client installed on the PowerHouse machine.<br>
3. Environment variables<br>
4. PDL entry.<br>
5. Test the oracle client using sqlplus<br>
<br>
License:<br>
FEATURE PH8-UNIX-ORACLE-DATA-ACCESS ...<br>
<br>
Oracle 32bit client:<br>
In my example Oracle 9i installed in /usr/app/oracle/product32/9.2.0.1.0<br>
PowerHouse is a 32bit app and requires the 32bit Oracle client installed<br>
even if you have 64bit Solaris.<br>
<br>
Environment variable:<br>
ORACLE_HOME=/usr/app/oracle/product32/9.2.0.1.0<br>
TNS_ADMIN=/usr/app/oracle/product32/9.2.0.1.0/network/admin<br>
LD_LIBRARY_PATH=/usr/app/oracle/product32/9.2.0.1.0/lib<br>
ORA_NLS33=/usr/app/oracle/product32/9.2.0.1.0/ocommon/nls/admin/data<br>
ORDBA=ordba9<br>
<br>
PDL entry:<br>
Database oracledb Type ORACLE NULL VALUES ALLOWED Open
&<br>
"ORACLE@$ora_username@$ora_instance/$ora_userpswd"
&<br>
Owner DBOWNER<br>
;Note: $ora_username, $ora_instance, $ora_userpswd are all environment<br>
variables.<br>
<br>
Regards,<br>
Greig<br>
<br>
-----Original Message-----<br>
Date: Thu, 07 May 2009 08:51:34 -0600<br>
From: John MacLerran <macljohn@isu.edu><br>
Subject: PowerHouse and Oracle on Solaris -- howto?<br>
To: powerh-l@lists.sowder.com<br>
Message-ID: <4A02F576.30401@isu.edu><br>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed<br>
<br>
Dear PowerHouse list<br>
<br>
I'm new to using PowerHouse with Oracle, and I'm trying to get the two<br>
to talk nicely together. (Sorry if this is a duplicate. I sent it<br>
yesterday, but it didn't show up in the list archives, and I never<br>
received notification that it posted, so I figure it got held<br>
somewhere.)<br>
<br>
OS is Solaris 10<br>
Oracle version is 10.2<br>
PowerHouse version is 8.43.F -- brand new...<br>
<br>
Oracle is installed, and I can TNSPING the database I'm trying to<br>
connect to, and I can access it with SQLPlus. However, when I create
a<br>
PDL dictionary and try to access it in quiz, I get the following:<br>
<br>
$setdict aiqdb.pdc<br>
$quiz<br>
Q U I Z (PowerHouse 8.43.F)<br>
Copyright (C) 2008 Cognos Incorporated. All rights reserved.<br>
<br>
> access spriden in BTEST<br>
<br>
*W* SQL START DBE error (BTEST).<br>
DMS-E-YV_LOADSGIFAILED, Unable to load the 'ordba' gateway. Please<br>
ensure that the database software is configured correctly and is<br>
supported on this version of the operating system.<br>
<br>
SPRIDEN is a valid table in BTEST, and that's the database name I can<br>
TNSPING and access via SQLPlus.<br>
<br>
Here's what I have in my PDL source:<br>
<br>
<br>
database BTEST type Oracle &<br>
open 'BTEST' &<br>
;;; (note: I've also tried BTEST.isos.isu.edu -- the
name that <br>
TNSPing returns and the service_name in the tnsnames.ora file)<br>
null values ALLOWED &<br>
userid 'macljohn' password 'blahblah' <br>
The macljohn userid does have read access to SPRIDEN in BTEST.<br>
<br>
I queried the list archives, and one message said that the resolution to<br>
the problems was that PowerHouse wasn't installed with Oracle support.
I<br>
wasn't present when PowerHouse was installed on the server, but neither<br>
the Getting Started guide nor the Release and Install notes mentioned<br>
anything special that was needed to install with Oracle Support. There<br>
is a section in the Getting Started guide that mentions that the<br>
LD_LIBRARY_PATH for the database must be set before executing the . <br>
setpow script, and I've done that, but the error still occurs. Did
the<br>
LD_LIBRARY_PATH need to be set correctly before the install was started?<br>
I don't believe that was done.<br>
<br>
Where is the 'ordba' gateway that is mentioned in the error message? Is<br>
that a PowerHouse component or an Oracle one? I did a find . -name
on<br>
it, and didn't find it, but that could be due to my rights not being<br>
correct.<br>
<br>
I'd appreciate any insight.<br>
Thanks!<br>
<br>
-- <br>
= = = = = = = = = = = = = = = = = = = = = = = = = = = =<br>
Mailing list: powerh-l@lists.sowder.com<br>
Subscribe: 'subscribe' in message body to powerh-l-request@lists.sowder.com<br>
Unsubscribe: 'unsubscribe &lt;password&gt;' in message body to
powerh-l-request@lists.sowder.com<br>
</font></tt><a href="http://lists.sowder.com/mailman/listinfo/powerh-l"><tt><font size=2>http://lists.sowder.com/mailman/listinfo/powerh-l</font></tt></a><tt><font size=2><br>
This list is closed, thus to post to the list you must be a subscriber.<br>
Add 'site:lists.sowder.com powerh-l' to your search terms to search the
list archive at Google.<br>
</font></tt>
<br>
<br><font size=2 face="sans-serif"><br>
</font>
<br><font size=2 face="sans-serif"><br>
</font>
<hr><font size=2 face="sans-serif"><br>
<i><br>
</i></font>
<p><font size=2 face="sans-serif"><i>Unless stated otherwise above:<br>
IBM United Kingdom Limited - Registered in England and Wales with number
741598. <br>
Registered office: PO Box 41, North Harbour, Portsmouth, Hampshire PO6
3AU</i></font>
<p><font size=2 face="sans-serif"><br>
<br>
</font>
<br>
<br><font size=2 face="sans-serif"><br>
</font>