Oracle Dictionary and Powerhouse

Fri May 8 07:26:16 CDT 2009

Do you have Oracle Data Access Piece/license for Powerhouse?
Are you running Oracle/Powerhouse on the same or different macines?
I'm running (VMS) powerhouse 840D1 against Oracle 10.2 (Solaris 10)
so your configuration "should" work...

$ type license1.dat
SERVER daldev 0060cf2146ce 
DAEMON cognos1d COGNOS$LICENSE50 0 
ADMIN:[COGNOS.DALLAS.LICENSE_V50]license.opt 0 
FEATURE PH8-ALPHA-DEVELOPMENT cognos1d 1.000 1-jan-0 8 XXXXXXXXXX 
"XXXXXXXXXX WEST FRASER MILLS LTD. VMS ALPHA"
FEATURE PH8-ALPHA-ORACLE-DATA-ACCESS cognos1d 1.000 1-jan-0 8 XXXXXXXXXX 
"XXXXXXXXXX WEST FRASER MILLS LTD. VMS ALPHA"

$ showpower

                 Disk: _$15$DKA203:
       Root Directory: [COGNOS]
       Active Version: 840D1

       Active License: DEVELOPMENT

Current Dictionary, of type PDC, is:
        $15$DKA102:[MDS.DICTIONARY]MDSDICT

$ show log ordb*

(LNM$PROCESS_TABLE)

  "ORDBA7_4_23355" = "PH_LOCATION:ORDBA9207_4_23355A840D1.EXE"

(SERVER_2415332814)

(LNM$JOB_814F6300)

(LNM$GROUP_000030)

(LNM$SYSTEM_TABLE)

  "ORDBA7_4_23355" = 
"_$15$DKA203:[COGNOS.POWERHSE.840D1.PH_COMMON]ORDBA9207_4_23355A840D1.EXE"
  "ORDBA7_4_VERS" = "920"

(LNM$SYSCLUSTER_TABLE)

(MDS$LOGICALS)

(DECW$LOGICAL_NAMES)

I looked around some of my other machines and found a reference to ORDBA

 "ORDBA" = "_$15$DKA203:[COGNOS.POWERHSE.820D3.PH_COMMON]ORDBAA820D3.EXE"

looks like a reference to one of the older ph kits (820d3) which we keep 
hanging around to access
some old yearend snapshots on the off chance the IRS comes asking around 
about them 
(We're a commercial site). 

also check your pwrboot file (if your on PH VMS), you need to supply a 
oracle version there 

$ type sys$manager:pwrboot_daldev.com
$ !
$ !     C O G N O S   P o w e r H o u s e  4 G L 8.40.D1
$ !               Startup Command Procedure
$ !
$ !     This command file is to be executed at system startup time
$ !
$ !     Created by DALDEV::SYSTEM On 25-JUN-2006 20:30:11.43 during 
installation.
$ !
$ @SYS$MANAGER:PWRLOGICAL SYSTEM 840D1 ADMIN COGNOS DEVELOPMENT
$ @SYS$MANAGER:PWRINSTALL "840D1" DEVELOPMENT "" 920

In this case we're loading the oracle 9.2 sql drivers for PH, (Ok as we 
are only running the sql 9.2
client on the VMS side, the oracle server is Solaris 10.2, the Oracle 
Client/Server versions would
have to match if we were on the same machine, but we're not.  "I think" 
that oracle 9.2 was terminal
for PH 840D1 (VMS), I need to get Powerhouse updated in our enviroment, 
getting a little dated,
but we always seem to have bigger fish to fry...

Can't help you (yet) if your running PH directly on Solaris, that's our 
intended direction, but
we're just slowly working towards that goal, step one has been get off VMS 
RMS/ISAM files and
onto Oracle, we're about 2/3 of the way towards that goal, once we get 
there we intend to start
moving batch jobs (QUIZ/QTP), and only then get around to tackeling QUICK 
(with embedded
shell commands that will be most of the work...).

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/ac6de87e/attachment-0001.htm 