List hi!
Here is description of the Bug we found.
It is quite unpleasent. For a while everything looks just nice, then
installation freeze.
There are no errors of any kind; system just hangs (and it can lasts for
hours)! It cost me 3 hours, before I realized something is very wrong (you
think it's almost done)!
Just to let you know.
Sonja
Title: ALERT: Some Repository versions will not install on
Oracle
8.1.7.0.0
ALERT: Some Repository versions will not install on Oracle 8.1.7.0.0
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Versions Affected
~~~~~~~~~~~~~~~~~
Oracle Designer/Repository 6i Release 1 and all Oracle Designer 6.0 versions
prior to Designer 6.0.3.11 (patchset 7)
Platforms Affected
~~~~~~~~~~~~~~~~~~
ALL
Description
~~~~~~~~~~~
During the installation phase of Designer Repository when the script
CIUEET.OPB is fired the 8.1.7.0.0 database server will show 100% CPU
usage and hang indefinitely. The script CIUEET.OPB installs the
component that is responsible for managing UE elements Type Extensions
to the repository. This problem can also occur if you attempt a full
repository import.
Note: This is an Oracle 8.1.7 PLSQL Server bug and not a Designer bug.
See Oracle 8.1.7 Server PLSQL bug <Bug:1396675>.
Likelihood of Occurrence
~~~~~~~~~~~~~~~~~~~~~~~~
HIGH: This problem will occur everytime you attempt to install or
import(full repository) a Designer Repository against 8.1.7.0.0 of the
Oracle Server. The exception to this is Designer 6i release 2 which has
a workaround to the bug applied to its code. This workaround will be
introduced to a future Designer 6.0 patchset.
Possible Symptoms
~~~~~~~~~~~~~~~~~
When the script CIUEET.OPB is fired by the Repository Adminstration Utility
(RAU), the database server will show 100% CPU usage and the database will
hang indefinitely. The database will also hang if a full repository
import is attempted, as the package cioue_element_type(orginal created by
the CIUUET.OPB script) will be executed.
Workaround
~~~~~~~~~~
Use 8.1.6 of the Oracle Server.
Patches
~~~~~~~
However, a workaround has been introduced in the Designer 6i Release 2 code
to
get past the plsql problem. This release has been certified. For Designer
6.0
the code change has been introduced in Designer 6.0.3.11.0 (patchset 7).
References
~~~~~~~~~~
<Bug:1396675>
<Bug:1528667>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-2?Q?Sonja_=A9ehovi=E6?=
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).
