Oracle Dictionary
Edis, Bob
BEdis@usbnc.org
Wed, 29 May 2002 11:10:08 -0500
G'day Victor
It's been a couple of years since I worked with PowerHouse and an Oracle
database that required the use of the tnsnames file. I believe that the
name in the dictionary has to match exactly the tnsname reference. Through
the medium of the tnsnames file the database name is obscured from the
application so it must be referenced by the tnsname used.
Regards,
Blue
-----Original Message-----
From: Victor Geere [mailto:victor@nha.co.za]
Sent: Wednesday, May 29, 2002 5:41 AM
To: Boyle, Joe; powerh-l@lists.swau.edu
Subject: RE: Oracle Dictionary
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.
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.