Discoverer did what it was supposed to do ..... but it did it in a VERY
UGLY MANNER.
You should have seen the Crap SQL it returned for its queries... I would
have expected a product written BY ORALCE FOR ORACLE to be written in such a
way that it returned the best SQL that could be generated.
This was pure unadulterated Crap.
And that is not just my opinion .... its the unadulterated truth !
Kevin
-----Original Message-----
Sent: Wednesday, October 31, 2001 3:12 PM
To: Multiple recipients of list ORACLE-L
David,
In it's current incarnation I'd recommend against it.
Dick Goulet
____________________Reply Separator____________________
Author: David Wagoner <[EMAIL PROTECTED]>
Date: 10/31/2001 12:05 PM
Wow. Thanks for your effort here Dick. Sounds like quite an ordeal. At
least I'll know some problems to look for if my company decides to try
Discoverer!
David B. Wagoner
Database Administrator
Arsenal Digital Solutions Worldwide Inc.
4815 Emperor Blvd., Suite 110
Durham, NC 27703
Tel. (919) 941-4645
Fax (919) 474-0735
Email mailto:[EMAIL PROTECTED]
Web http://www.arsenaldigital.com/
*** NOTICE ***
This e-mail message is confidential, intended only for the named
recipient(s) above and may contain information that is privileged, work
product or exempt from disclosure under applicable law. If you have
received this message in error, or are not the named recipient(s), please
immediately notify the sender at (919) 941-4645 and delete this e-mail
message from your computer. Thank you.
-----Original Message-----
Sent: Wednesday, October 31, 2001 9:55 AM
To: Multiple recipients of list ORACLE-L
David,
OK, first off the Oracle sales droid and pre-sales droid came in to do
the
install of the product (9iAS Enterprise Edition which BTW, you HAVE to have
the
Enterprise edition or else you don't get the WEB based tool). The install
manual said it would need 6GB of HP-UX disk to install properly, BULL it was
much closer to 9GB (OK, 8.75 to be exact). You end up installing WEB forms,
graphics, reports, and the cache DB even though your not going to use them.
We
were told the install and initial configuration would only take half a day,
it
took that long just to read in the CD's and in actually took the better part
of
16 hours with configuration going on into a third 8 hour time period. What a
pile of BLOATware, YUCK!!
Next the locator process intermittently died for no apparent reason.
There
was no core dump, or other indication that something odd had happen & the
log
file was less than helpful it turns out. Actually pointed us in the WRONG
direction. According to the log we were having a semaphore problem when in
truth it turned into a semaphore set problem. This thing LOVES doing IPC's.
Next we had a problem with browsers. The company 'standard' is
MicroSlop IE
5.0. Suppose to work, WRONG!! The only machine that would run Discoverer
was a
brand new one with ME and IE 5.51 or something like that, and then it wasn't
exactly sure it wanted to go!! This one appears to be a JVM issue (MS does
not
like SUN on which Oracle's Java implementations is based), but MetaLink has
a
pointer to an article on 'How to use JInitiator with IE 5.x', but for some
reason it has not been 'published' yet so you get an 'document is
unavailable'
message. The product did work with Netscape 4.61 and beyond but it was SLOW
to
startup. After that the interface being a 'navigation tree' was so foreign
to
our users that they were totally disenchanted. The 'last straw' was the
admin
edition where you had to map all of the tables, etc.. into the end user
layer.
Doing certain common tasks, although possible, was not intuitive (like sub
queries). The great part was that it did use the referential integrity to
self
join tables, warned when you created a Cartesian query but let you run it
anyway, and it has a damn good query predictor that gets smarter as time
(read
than as number of executions of the query) passes.
What Oracle needs to do here is:
1) Support the MicroSlop browsers most likely by getting that article
published.
2) Train their sales folks, they were going through the first install
right
along with us!!
3) Cut out the bloat. There is no reason for all the other stuff if all
you
want is Discoverer.
4) Figure out what the 'real' numbers are for disk and semaphore sets
and
publish them.
5) Put back that ability to use the native dictionary as well as the
EUL.
That was the way it was in Discoverer 2000, why the change?
6) Get rid of that 'navigation tree' in favor of the graphical table
layout
diagram.
7) Let end users edit their SQL. Easiest way to insert sub queries
there
ever was.
8) Improve the graphics capabilities, their a little primitive in the
current version.
In the end, when we told them we had decided against Discoverer 3000 they
were
"not suprised".
Dick Goulet
____________________Reply Separator____________________
Author: David Wagoner <[EMAIL PROTECTED]>
Date: 10/29/2001 10:52 AM
Dick,
Can you elaborate a little on the instability of Oracle Discoverer 3000 with
Oracle 9i database? I was planning to investigate Discoverer as an end-user
reporting/query tool sometime soon. We have Oracle 8i and 9i databases. I
just heard that Discoverer is an HTML-based data query tool for end-users.
TIA,
david
David B. Wagoner
Database Administrator
Arsenal Digital Solutions Worldwide Inc.
4815 Emperor Blvd., Suite 110
Durham, NC 27703
Tel. (919) 941-4645
Fax (919) 474-0735
Email mailto:[EMAIL PROTECTED]
Web http://www.arsenaldigital.com/
*** NOTICE ***
This e-mail message is confidential, intended only for the named
recipient(s) above and may contain information that is privileged, work
product or exempt from disclosure under applicable law. If you have
received this message in error, or are not the named recipient(s), please
immediately notify the sender at (919) 941-4645 and delete this e-mail
message from your computer. Thank you.
-----Original Message-----
Sent: Monday, October 29, 2001 9:40 AM
To: Multiple recipients of list ORACLE-L
Oracle Browser 2/Oracle Discoverer 2000 is a VERY old piece of software that
does not interact well with any Oracle instance beyond 7.3.4. We've got it,
it's a pain in the neck, and I would NOT recommend anyone else try to use
it,
except if your still running 7.x databases. Your options are not very
great,
use Oracle 9iAS enterprise edition for the browser based version of Oracle
Discoverer 3000 (not a very stable product from our experience [9iAS version
9.0.1 on HP-UX]) Or go to the third party market We are with a product
called
Brio.
Dick Goulet
____________________Reply Separator____________________
Author: "Michael" <[EMAIL PROTECTED]>
Date: 10/28/2001 4:05 AM
Hi all,
Doesn't anybody out there know what Oracle Browser 2 is, and where I
might be able to download a copy ?
Thanks for your time.
Michael.
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2600.0" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=507420512-28102001><FONT face=Arial size=2>Hi
all,</FONT></SPAN></DIV>
<DIV><SPAN class=507420512-28102001><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=507420512-28102001> <FONT face=Arial
size=2>Doesn't anybody out there know what Oracle Browser 2 is, and where I
might be able to download a copy ?</FONT></SPAN></DIV>
<DIV><SPAN class=507420512-28102001><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=507420512-28102001> <FONT face=Arial
size=2>Thanks for your time.</FONT></SPAN></DIV>
<DIV><SPAN class=507420512-28102001><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=507420512-28102001><FONT face=Arial
size=2>Michael.</FONT></SPAN></DIV>
<DIV><SPAN class=507420512-28102001></SPAN> </DIV></BODY></HTML>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: David Wagoner
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: David Wagoner
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kevin Lange
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
