<br><font size=2 face="sans-serif">Realized I missed a PDL issue in your
message</font>
<br>
<br><font size=2 face="sans-serif">Here's a fully qualified TNS name from
the tnsnames.ora file:</font>
<br>
<br><font size=2 face="r_ansi">MDS.WESTFRASERTIMBER.CA = </font>
<br><font size=2 face="r_ansi"> (DESCRIPTION = </font>
<br><font size=2 face="r_ansi"> (ADDRESS_LIST = </font>
<br><font size=2 face="r_ansi"> (ADDRESS = </font>
<br><font size=2 face="r_ansi"> (COMMUNITY
= tcp.WORLD)</font>
<br><font size=2 face="r_ansi"> (PROTOCOL
= TCP)</font>
<br><font size=2 face="r_ansi"> (Host
= ORAWPP01)</font>
<br><font size=2 face="r_ansi"> (Port
= 1521)</font>
<br><font size=2 face="r_ansi"> )</font>
<br><font size=2 face="r_ansi"> )</font>
<br><font size=2 face="r_ansi"> (CONNECT_DATA = (SID = MDS)</font>
<br><font size=2 face="r_ansi"> )</font>
<br><font size=2 face="r_ansi"> )</font>
<br>
<br>
<br><font size=2 face="sans-serif">Here's how we reference in the PDL file:</font>
<br>
<br><font size=2 face="r_ansi">DATABASE MDS TYPE ORACLE NULL VALUES
ALLOWED OPEN &</font>
<br><font size=2 face="r_ansi"> "ORACLE@USERNAME@MDS.WESTFRASERTIMBER.CA/PASSWORD"
OWNER USERNAME</font>
<br>
<br>
<br><font size=2 face="sans-serif">OPEN "ORACLE@USERNAME@TNSNAME/PASSWORD"
OWNER USERNAME</font>
<br>
<br><font size=2 face="sans-serif">Username/password are usually the username/password
for the schema you're connecting</font>
<br><font size=2 face="sans-serif">to in oracle (Could be different if
you have a security wanked out DBA who has set things up</font>
<br><font size=2 face="sans-serif">so you can add/update your own data,
but not change table structures via the password he's</font>
<br><font size=2 face="sans-serif">given you). "I think"
owner is optional, it will default to the username in the PDL, (again,
allowing</font>
<br><font size=2 face="sans-serif">the DBA to grant you update to your
data without your being able to change it's structure, </font>
<br><font size=2 face="sans-serif">in that case it allows you to simply
access "TABLENAME in ORACLE" instead of</font>
<br><font size=2 face="sans-serif">"OWNER.TABLENAME in ORACLE"
without the DBA having to set up synonyms...).</font>
<br>
<br>
<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