Oracle Dictionary and Powerhouse

Fri May 8 08:35:42 CDT 2009

Realized I missed a PDL issue in your message

Here's a fully qualified TNS name from the tnsnames.ora file:

MDS.WESTFRASERTIMBER.CA = 
  (DESCRIPTION = 
    (ADDRESS_LIST = 
        (ADDRESS = 
          (COMMUNITY = tcp.WORLD)
          (PROTOCOL = TCP)
          (Host = ORAWPP01)
          (Port = 1521)
        )
    )
    (CONNECT_DATA = (SID = MDS)
     )
  )

Here's how we reference in the PDL file:

DATABASE MDS TYPE ORACLE   NULL VALUES ALLOWED   OPEN &
           "ORACLE at USERNAME@MDS.WESTFRASERTIMBER.CA/PASSWORD" OWNER 
USERNAME

OPEN  "ORACLE at USERNAME@TNSNAME/PASSWORD" OWNER USERNAME

Username/password are usually the username/password for the schema you're 
connecting
to in oracle (Could be different if you have a security wanked out DBA who 
has set things up
so you can add/update your own data, but not change table structures via 
the password he's
given you).  "I think" owner is optional, it will default to the username 
in the PDL, (again, allowing
the DBA to grant you update to your data without your being able to change 
it's structure, 
in that case it allows you to simply access "TABLENAME in ORACLE" instead 
of
"OWNER.TABLENAME in ORACLE" without the DBA having to set up synonyms...).

John MacLerran <macljohn at isu.edu> 
Sent by: powerh-l-bounces+herald.kaffka=westfraser.com at lists.sowder.com
05/08/2009 04:55 AM

To
"PowerHouse Mail List (E-mail)" <powerh-l at lists.sowder.com>
cc

Subject
Oracle Dictionary and Powerhouse

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
----------------------------------------------------------------------

-- 
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.

----------------------------
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

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