BUG in installing Designer6 Repository on 8.1.7 database

From: Sonja Šehović <sonja.sehovic_at_pbz.hr>
Date: Tue, 20 Mar 2001 02:14:38 -0800
Message-ID: <F001.002D155C.20010320015028@fatcity.com>

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: sonja.sehovic_at_pbz.hr

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: ListGuru_at_fatcity.com (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).

Received on Tue Mar 20 2001 - 04:14:38 CST