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

I had a similar problem when upgrading 8.1.6.3 to 9.2.0.1.

The Ixora views were giving problems. These had to be dropped prior to the 9.2.0.1 upgrade.

In the end I had to drop the following X_ views before upgrading to 9.2.0.1:

HTH,
Gerardo

drop view SYS.X_$BH;
drop view SYS.X_$K2GTE;
drop view SYS.X_$K2GTE2;
drop view SYS.X_$KCBCBH;
drop view SYS.X_$KCBFWAIT;
drop view SYS.X_$KCBRBH;
drop view SYS.X_$KCBWAIT;
drop view SYS.X_$KCBWDS;
drop view SYS.X_$KCCCF;
drop view SYS.X_$KCCDI;
drop view SYS.X_$KCCFE;
drop view SYS.X_$KCCFN;
drop view SYS.X_$KCCLE;
drop view SYS.X_$KCCLH;
drop view SYS.X_$KCCRT;
drop view SYS.X_$KCFIO;
drop view SYS.X_$KCKCE;
drop view SYS.X_$KCKFM;
drop view SYS.X_$KCKTY;
drop view SYS.X_$KCLFH;
drop view SYS.X_$KCLFI;
drop view SYS.X_$KCLFX;
drop view SYS.X_$KCLLS;
drop view SYS.X_$KCLQN;
drop view SYS.X_$KCRFX;
drop view SYS.X_$KCRMF;
drop view SYS.X_$KCRMT;
drop view SYS.X_$KCRMX;
drop view SYS.X_$KCVFH;
drop view SYS.X_$KCVFHMRR;
drop view SYS.X_$KCVFHONL;
drop view SYS.X_$KDNSSF;
drop view SYS.X_$KDXHS;
drop view SYS.X_$KDXST;
drop view SYS.X_$KGHLU;
drop view SYS.X_$KGICC;
drop view SYS.X_$KGICS;
drop view SYS.X_$KGLAU;
drop view SYS.X_$KGLBODY;
drop view SYS.X_$KGLCLUSTER;
drop view SYS.X_$KGLCURSOR;
drop view SYS.X_$KGLDP;
drop view SYS.X_$KGLINDEX;
drop view SYS.X_$KGLLC;
drop view SYS.X_$KGLLK;
drop view SYS.X_$KGLNA;
drop view SYS.X_$KGLNA1;
drop view SYS.X_$KGLOB;
drop view SYS.X_$KGLPN;
drop view SYS.X_$KGLRD;
drop view SYS.X_$KGLST;
drop view SYS.X_$KGLTABLE;
drop view SYS.X_$KGLTR;
drop view SYS.X_$KGLTRIGGER;
drop view SYS.X_$KGLXS;
drop view SYS.X_$KKSAI;
drop view SYS.X_$KKSBV;
drop view SYS.X_$KLLCNT;
drop view SYS.X_$KLLTAB;
drop view SYS.X_$KMCQS;
drop view SYS.X_$KMCVC;
drop view SYS.X_$KMMDI;
drop view SYS.X_$KMMDP;
drop view SYS.X_$KMMRD;
drop view SYS.X_$KMMSG;
drop view SYS.X_$KMMSI;
drop view SYS.X_$KQDPG;
drop view SYS.X_$KQFCO;
drop view SYS.X_$KQFDT;
drop view SYS.X_$KQFSZ;
drop view SYS.X_$KQFTA;
drop view SYS.X_$KQFVI;
drop view SYS.X_$KQFVT;
drop view SYS.X_$KQRPD;
drop view SYS.X_$KQRSD;
drop view SYS.X_$KQRST;
drop view SYS.X_$KSBDD;
drop view SYS.X_$KSBDP;
drop view SYS.X_$KSIMAT;
drop view SYS.X_$KSIMAV;
drop view SYS.X_$KSIMSI;
drop view SYS.X_$KSLED;
drop view SYS.X_$KSLEI;
drop view SYS.X_$KSLES;
drop view SYS.X_$KSLLD;
drop view SYS.X_$KSLLT;
drop view SYS.X_$KSLLW;
drop view SYS.X_$KSLPO;
drop view SYS.X_$KSLWSC;
drop view SYS.X_$KSMFSV;
drop view SYS.X_$KSMHP;
drop view SYS.X_$KSMLRU;
drop view SYS.X_$KSMMEM;
drop view SYS.X_$KSMPP;
drop view SYS.X_$KSMSD;
drop view SYS.X_$KSMSP;
drop view SYS.X_$KSMSPR;
drop view SYS.X_$KSMSS;
drop view SYS.X_$KSMUP;
drop view SYS.X_$KSPPCV;

-----Original Message-----
Sent: Tuesday, May 13, 2003 11:32 PM
To: Multiple recipients of list ORACLE-L

On 2003.05.14 01:56 "Vergara, Michael (TEM)" 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

X$KCBCBH ???? What are you trying to do? I haven't seen that old V6 view for a very, very long time, wver since my stegosaurus pet has died. Are you trying to predict an increase in the cache hit rate if you increase your
buffer cache by certain number of buffers? Doesn't work that way any more.
What would X$KCBCBH do? You are aware that you have more then one buffer pool, one for each block size. Which buffers are we talking about? 4K? 8K? 16K? That table no longer makes any sense and the best way that RDBMS
has to convey that to you is ORA-600.

-- 
Mladen Gogala
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mladen Gogala
  INET: mgogala_at_adelphia.net

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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Molina, Gerardo
  INET: Gerardo.Molina_at_schwab.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).