<br><font size=2 face="sans-serif">Do you have Oracle Data Access Piece/license
for Powerhouse?</font>
<br><font size=2 face="sans-serif">Are you running Oracle/Powerhouse on
the same or different macines?</font>
<br><font size=2 face="sans-serif">I'm running (VMS) powerhouse 840D1 against
Oracle 10.2 (Solaris 10)</font>
<br><font size=2 face="sans-serif">so your configuration "should"
work...</font>
<br>
<br><font size=2 face="r_ansi">$ type license1.dat</font>
<br><font size=2 face="r_ansi">SERVER daldev 0060cf2146ce </font>
<br><font size=2 face="r_ansi">DAEMON cognos1d COGNOS$LICENSE50 0 ADMIN:[COGNOS.DALLAS.LICENSE_V50]license.opt
0 </font>
<br><font size=2 face="r_ansi">FEATURE PH8-ALPHA-DEVELOPMENT cognos1d 1.000
1-jan-0 8 XXXXXXXXXX "XXXXXXXXXX WEST FRASER MILLS LTD. VMS ALPHA"</font>
<br><font size=2 face="r_ansi">FEATURE PH8-ALPHA-ORACLE-DATA-ACCESS cognos1d
1.000 1-jan-0 8 XXXXXXXXXX "XXXXXXXXXX WEST FRASER MILLS LTD. VMS
ALPHA"</font>
<br>
<br><font size=2 face="r_ansi">$ showpower</font>
<br>
<br><font size=2 face="r_ansi">
Disk: _$15$DKA203:</font>
<br><font size=2 face="r_ansi"> Root Directory:
[COGNOS]</font>
<br><font size=2 face="r_ansi"> Active Version:
840D1</font>
<br>
<br><font size=2 face="r_ansi"> Active License:
DEVELOPMENT</font>
<br>
<br><font size=2 face="r_ansi">Current Dictionary, of type PDC, is:</font>
<br><font size=2 face="r_ansi"> $15$DKA102:[MDS.DICTIONARY]MDSDICT</font>
<br>
<br><font size=2 face="r_ansi">$ show log ordb*</font>
<br>
<br><font size=2 face="r_ansi">(LNM$PROCESS_TABLE)</font>
<br>
<br><font size=2 face="r_ansi"> "ORDBA7_4_23355" = "PH_LOCATION:ORDBA9207_4_23355A840D1.EXE"</font>
<br>
<br><font size=2 face="r_ansi">(SERVER_2415332814)</font>
<br>
<br><font size=2 face="r_ansi">(LNM$JOB_814F6300)</font>
<br>
<br><font size=2 face="r_ansi">(LNM$GROUP_000030)</font>
<br>
<br><font size=2 face="r_ansi">(LNM$SYSTEM_TABLE)</font>
<br>
<br><font size=2 face="r_ansi"> "ORDBA7_4_23355" = "_$15$DKA203:[COGNOS.POWERHSE.840D1.PH_COMMON]ORDBA9207_4_23355A840D1.EXE"</font>
<br><font size=2 face="r_ansi"> "ORDBA7_4_VERS" = "920"</font>
<br>
<br><font size=2 face="r_ansi">(LNM$SYSCLUSTER_TABLE)</font>
<br>
<br><font size=2 face="r_ansi">(MDS$LOGICALS)</font>
<br>
<br><font size=2 face="r_ansi">(DECW$LOGICAL_NAMES)</font>
<br>
<br><font size=2 face="sans-serif">I looked around some of my other machines
and found a reference to ORDBA</font>
<br>
<br><font size=2 face="r_ansi"> "ORDBA" = "_$15$DKA203:[COGNOS.POWERHSE.820D3.PH_COMMON]ORDBAA820D3.EXE"</font>
<br>
<br><font size=2 face="sans-serif">looks like a reference to one of the
older ph kits (820d3) which we keep hanging around to access</font>
<br><font size=2 face="sans-serif">some old yearend snapshots on the off
chance the IRS comes asking around about them </font>
<br><font size=2 face="sans-serif">(We're a commercial site). </font>
<br>
<br>
<br><font size=2 face="sans-serif">also check your pwrboot file (if your
on PH VMS), you need to supply a oracle version there </font>
<br>
<br><font size=2 face="r_ansi">$ type sys$manager:pwrboot_daldev.com</font>
<br><font size=2 face="r_ansi">$ !</font>
<br><font size=2 face="r_ansi">$ ! C O G N O S P o
w e r H o u s e 4 G L 8.40.D1</font>
<br><font size=2 face="r_ansi">$ !
Startup Command Procedure</font>
<br><font size=2 face="r_ansi">$ !</font>
<br><font size=2 face="r_ansi">$ ! This command file is to
be executed at system startup time</font>
<br><font size=2 face="r_ansi">$ !</font>
<br><font size=2 face="r_ansi">$ ! Created by DALDEV::SYSTEM
On 25-JUN-2006 20:30:11.43 during installation.</font>
<br><font size=2 face="r_ansi">$ !</font>
<br><font size=2 face="r_ansi">$ @SYS$MANAGER:PWRLOGICAL SYSTEM 840D1 ADMIN
COGNOS DEVELOPMENT</font>
<br><font size=2 face="r_ansi">$ @SYS$MANAGER:PWRINSTALL "840D1"
DEVELOPMENT "" 920</font>
<br>
<br><font size=2 face="sans-serif">In this case we're loading the oracle
9.2 sql drivers for PH, (Ok as we are only running the sql 9.2</font>
<br><font size=2 face="sans-serif">client on the VMS side, the oracle server
is Solaris 10.2, the Oracle Client/Server versions would</font>
<br><font size=2 face="sans-serif">have to match if we were on the same
machine, but we're not. "I think" that oracle 9.2 was terminal</font>
<br><font size=2 face="sans-serif">for PH 840D1 (VMS), I need to get Powerhouse
updated in our enviroment, getting a little dated,</font>
<br><font size=2 face="sans-serif">but we always seem to have bigger fish
to fry...</font>
<br>
<br><font size=2 face="sans-serif">Can't help you (yet) if your running
PH directly on Solaris, that's our intended direction, but</font>
<br><font size=2 face="sans-serif">we're just slowly working towards that
goal, step one has been get off VMS RMS/ISAM files and</font>
<br><font size=2 face="sans-serif">onto Oracle, we're about 2/3 of the
way towards that goal, once we get there we intend to start</font>
<br><font size=2 face="sans-serif">moving batch jobs (QUIZ/QTP), and only
then get around to tackeling QUICK (with embedded</font>
<br><font size=2 face="sans-serif">shell commands that will be most of
the work...).</font>
<br>
<br>
<br>
<br>
<br>
<table width=100%>
<tr valign=top>
<td width=40%><font size=1 face="sans-serif"><b>John MacLerran <macljohn@isu.edu></b>
</font>
<br><font size=1 face="sans-serif">Sent by: powerh-l-bounces+herald.kaffka=westfraser.com@lists.sowder.com</font>
<p><font size=1 face="sans-serif">05/08/2009 04:55 AM</font>
<td width=59%>
<table width=100%>
<tr valign=top>
<td>
<div align=right><font size=1 face="sans-serif">To</font></div>
<td><font size=1 face="sans-serif">"PowerHouse Mail List (E-mail)"
<powerh-l@lists.sowder.com></font>
<tr valign=top>
<td>
<div align=right><font size=1 face="sans-serif">cc</font></div>
<td>
<tr valign=top>
<td>
<div align=right><font size=1 face="sans-serif">Subject</font></div>
<td><font size=1 face="sans-serif">Oracle Dictionary and Powerhouse</font></table>
<br>
<table>
<tr valign=top>
<td>
<td></table>
<br></table>
<br>
<br>
<br><tt><font size=2>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.<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<br>
the database software is configured correctly and is supported on this
<br>
version<br>
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>
<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 <br>
started? 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>
John MacLerran </font></tt><a href=http://picasaweb.google.com/jmaclerran><tt><font size=2>http://picasaweb.google.com/jmaclerran<br>
IT Analyst, Senior
email: macljohn@isu.edu<br>
Idaho State University
V(208) 282-2954<br>
</font></tt><a href=http://www.isu.edu/~macljohn><tt><font size=2>http://www.isu.edu/~macljohn
F(208) 282-3673<br>
----------------------------------------------------------------------<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<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>
<br>
</font></tt></a></a></a>
<br><br />
<br />----------------------------
<br />This e-mail message and any attachments are confidential. Any dissemination or use of this information by a person other than the intended recipient is unauthorized. If you are not the intended recipient, please notify me by return e-mail, do not open any attachment and delete this communication and any copy. Thank you