This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C20702.7CE310E0 Content-Type: text/plain; charset="iso-8859-1" Hi Victor, Is your login configured with all the correct environment variables? Here's an extract from a script I run to set up my login... ORACLE_HOME=/ripper2a/app/oracle/product/8.1.6 export ORACLE_HOME LD_LIBRARY_PATH=$ORACLE_HOME/lib export LD_LIBRARY_PATH ORACLE_SID=ORARIP81 export ORACLE_SID SHLIB_PATH=$ORACLE_HOME/lib:$SHLIB_PATH export SHLIB_PATH PATH=$ORACLE_HOME/bin:$PATH export PATH In my dictionary, I have described my database as follows: database OEMREP & type oracle & open 'ORACLE' & owner oracle & userid 'oemrep' password 'pwd' & null values allowed This works fine for me. Best regards, Mark Fry Mark.Fry@Cognos.com -----Original Message----- From: Victor Geere [mailto:victor@nha.co.za] Sent: 29 May 2002 11:41 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. 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. ------_=_NextPart_001_01C20702.7CE310E0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">RE: Oracle Dictionary Hi Victor,
Is your login configured with all the correct = environment variables?
Here's an extract from a script I run to set up my = login...ORACLE_HOME=3D/ripper2a/app/oracle/product/8.1.6
export ORACLE_HOME
LD_LIBRARY_PATH=3D$ORACLE_HOME/lib
export LD_LIBRARY_PATH
ORACLE_SID=3DORARIP81
export ORACLE_SID
SHLIB_PATH=3D$ORACLE_HOME/lib:$SHLIB_PATH
export SHLIB_PATH
PATH=3D$ORACLE_HOME/bin:$PATH
export PATHIn my dictionary, I have described my database as = follows:
database OEMREP &
type oracle &
open 'ORACLE' &
owner oracle &
userid 'oemrep' password 'pwd' = &
null values allowed
This works fine for me.
Best regards,
Mark Fry
Mark.Fry@Cognos.com-----Original Message-----
From: Victor Geere [mailto:victor@nha.co.za]
Sent: 29 May 2002 11:41
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.slIs "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 ALLOWEDDatabase 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?
=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D = =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D
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.
=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D = =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D
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.
------_=_NextPart_001_01C20702.7CE310E0--