Oracle Dictionary

[Victor Geere]

Hi Joe,
Well, it would be great to view the contents of the Oracle database via the dictionary, but I get a "(*W*)SQL start DBE error".  I am confident that the database statement is correct, and now I would like to know if the Powerhouse installation knows about Oracle.
Here is the contents of $PH_USR/lib.  How do I know if Powerhouse will shake hands with Oracle?

/home/oracle>ls $PH_USR/lib
cogdmab.ini     cogdmo7.ini     cogdmsy.ini     libcomn.sl      libsybdb.sl
cogdmct.ini     cogdmor.ini     core            libcs.sl        libtcl.sl
cogdmib.ini     cogdms4.ini     libclntsh.sl    libct.sl        ph14855.tmp
cogdmif.ini     cogdmsd.ini     libcog5a2a.sl   libgds.sl       ph14856.tmp
cogdmms.ini     cogdmsi.ini     libcog5a2b.sl   libinsck.sl
cogdmo6.ini     cogdmst.ini     libcognls5a.sl  libintl.sl

Is "orarip81" in the open clause a tnsname or a database name?

-----Original Message-----
From: Boyle, Joe [mailto:Joe.Boyle@cognos.com]
Sent: 29 May 2002 12:27
To: Victor Geere
Subject: RE: Oracle Dictionary


Hi Victor,

try 'ls $PH_USR/lib'

P.S. I thought you were asking how to view the contents of the Oracle database via the dictionary to check that PH had mapped the tables correctly.

Both connection methods below should work in PDL,
database mydb817 type oracle owner custsup1 &
open "ORACLE@custsup1@orasol81/custsup1" NULL VALUES ALLOWED

Database mydbst Type ORACLE NULL VALUES ALLOWED Open "orarip81" &
Owner scott UserID "scott" Password "tiger"

-----Original Message-----
From: Boyle, Joe 
Sent: 29 May 2002 11:10
To: 'Victor Geere'
Subject: RE: Oracle Dictionary


sorry Victor, I now see what you are getting at,  I'll take a look around and see what I can find,
-----Original Message-----
From: Victor Geere [mailto:victor@nha.co.za]
Sent: 29 May 2002 11:04
To: Boyle, Joe
Subject: RE: Oracle Dictionary


qshow is looking at the correct dictionary, compliments of an environment variable.  My concern is that the (Oracle libraries?) have not been installed during the Powerhouse installation, which I have not been envolved in.  How do I tell? Oracle was installed after Powerhouse.
-----Original Message-----
From: Boyle, Joe [mailto:Joe.Boyle@cognos.com]
Sent: 29 May 2002 11:59
To: Victor Geere; powerh-l@lists.swau.edu
Subject: RE: Oracle Dictionary


Hi Victor, 
first check that the correct dictionary is set with command 'showdict', if not, set to the dictionary with command 'setdict <filespec>',  and then run qshow and either type 'show database detail' or do the following, type 'show database', if more than one database is listed, decide which database you want to see and then type  'show database <databasename>'.


-----Original Message----- 
From: Victor Geere [mailto:victor@nha.co.za] 
Sent: 29 May 2002 10:39 
To: powerh-l@lists.swau.edu 
Subject: Oracle Dictionary 


Can anybody show me an example of a Powerhouse dictionary for Oracle? 
I am using 
DATABASE OEMREP& 
  TYPE ORACLE & 
  OPEN ORACLE@system@oemrep/pwd & 
  OWNER oracle & 
  NULL VALUES ALLOWED 
The owner is an OS(HP-UX) username that was used to install Oracle. 
The tnsname tests successfully in the net manager. 
I can also connect to it through jsp. 


Is there a way to check whether Oracle support is enabled in Powerhouse, and if not, does Powerhouse have to be reinstalled completely?
Are there any other snags as far as Powerhouse and Oracle is concerned that I need to be aware of? 
= = = = = = = = = = = = = = = = = = = = = = = = = = = = 
Mailing list: powerh-l@lists.swau.edu 
Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu 
Unsubscribe: "unsubscribe" in message body to powerh-l-request@lists.swau.edu 
http://lists.swau.edu/mailman/listinfo/powerh-l 
This list is closed, thus to post to the list you must be a subscriber. 
This message may contain privileged and/or confidential information.  If you have received this e-mail in error or are not the intended recipient, you may not use, copy, disseminate or distribute it; do not open any attachments, delete it immediately from your system and notify the sender promptly by e-mail that you have done so.  Thank you.


This message may contain privileged and/or confidential information. If you have received this e-mail in error or are not the intended recipient, you may not use, copy, disseminate or distribute it; do not open any attachments, delete it immediately from your system and notify the sender promptly by e-mail that you have done so. Thank you.