RE: HP-UX 11i/9.2.0.3/Upgrade Question

From: Vergara, Michael (TEM) <mvergara_at_guidant.com>
Date: Wed, 14 May 2003 10:57:25 -0800
Message-ID: <F001.00598AB4.20030514105725@fatcity.com>

Hi All!

Actually, Oracle support came through on this one. They told me to find the object_id of the view using dba_objects, then delete any dependencies from sys.dependency$, and then drop the views. I can post the exact text from the TAR if there is interest.

And interestingly enough, this was a pre-production database so I checked production. Same problem is there at 8.1.7.4. Attempt to drop the view - ORA-600. But now I can fix it in the next maintenance window.

Thanks to All!
Mike

-----Original Message-----
Sent: Wednesday, May 14, 2003 9:07 AM
To: Multiple recipients of list ORACLE-L

Mike:
Good luck -- you're going to need it.
This view was valid in 7.3.4, but is no longer valid in 8i. I opened up a tar with Oracle on this view, and they were unhelpful in the extreme. I only found 1 reference in Metalink, and it just says that the view is invalid in 8i.

Your best bet is to remove the view before you upgrade. (Same is true of x_$kcbrbh)

Barb

• "Vergara, Michael (TEM)" <mvergara_at_guidant.com> wrote:
  > Hi All!
  >
  > I am trying to upgrade an 8.1.7.4 instance to
  > 9.2.0.3. I
  > installed the software, installed the 9.2.0.3 patch,
  > ran
  > the upgrade, and now I'm getting an ORA-600 [16206].
  > I
  > get this error querying the x$ view X_$KCBCBH.
  >
  > I have opened an iTAR with Oracle, but I was hoping
  > that
  > somebody out here has tripped over this and could
  > lend their
  > expertise.
  >
  > Thanks,
  > Mike
  >
  -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) INET: mvergara_at_guidant.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

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 Wed May 14 2003 - 13:57:25 CDT