Re: More upgrade woes! ORA-00600:[kpdbHashTableIns:nullval]
Date: Mon, 25 Nov 2019 08:14:15 -0500
Message-ID: <90b9d154-4282-3d9b-8385-ac912889fb71_at_gmail.com>
Howard, one question:
Why did you upgrade to 18c? 18c is a dead end. Version 19c is the last version in the "12c" series of products and will be the only version supported for the long time. Second question: which exact version of 18c did you upgrade to? The bug you're hitting is fixed in 18.8. I would have upgraded the $ORACLE_HOME to 18.8 before doing the upgrade, but I believe you can still do it. For more, see
Database 18 Release Updates and Revisions Bugs Fixed Lists (Doc ID 2369471.1)
*Oracle Multitenant*
18.8.0.0.DBRU:191015 27902561
<https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=2369471.1&id=27902561.8>
Wrong results or invalid LOB locators with Multiple Character Set
(MCSC) mode and cross-container queries
28585411
<https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=2369471.1&id=28585411.8>
_*ORA-00600 [kpdbhashtableins:nullval] Restore CDB SEED With DB Name
"sh46"*_
29312672
<https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=2369471.1&id=29312672.8>
pdb restore failed with ORA-65114: space usage in container is too high 18.7.0.0.DBRU:190716 28993353invalid identifier"
<https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=2369471.1&id=28993353.8>
ADW: AUTO PDB UPGRADE MAY FAIL WITH "ORA-00904: PQ_TIMEOUT_ACTION:
29331493
<https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=2369471.1&id=29331493.8>
Application Root - Internal default setting change
29379978
<https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=2369471.1&id=29379978.8>
ORA-00600 [kcffo_add_tmpf-1] when trying to add temp file 18.6.0.0.DBRU:190416 2748730927542824
<https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=2369471.1&id=27487309.8>*E*
IDENTIFIED BY VALUES CLAUSE SHOULD NOT BE ALLOWED IN CLOUD ENV
<https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=2369471.1&id=27542824.8>
PARALLEL clause ignored when cloning PDBs
27758972
<https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=2369471.1&id=27758972.8>
ORA-7445 [PC:0xEE00] with DBMS_PDB.CHECK_PLUG_COMPATIBILITY after
12.2.0.1.180116RU apply
28600233
<https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=2369471.1&id=28600233.8>
Application Container - Internal Statement capture does not happen if
session's module name is changed
18.5.0.0.DBRU:190115 28752599
<https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=2369471.1&id=28752599.8>
Plug of 12.1.0.2 PDB to 18.4 upgraded CDB causes ORA-3113, ORA-7445
[_IO_vfprintf()]
18.4.0.0.DBRU:181016 28210192
<https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=2369471.1&id=28210192.8>
Dynamic sampling should not be disabled for NO_CROSS_CONTAINER cases 18.3.0.0.DBRU:180717 2176622025824236
<https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=2369471.1&id=21766220.8>
ORA-600 followed by ORA-603 when dropping a common user
<https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=2369471.1&id=25824236.8>
UTL_HTTP should be able to use network ACLS in CDB$ROOT for all PDBs
27310092
<https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=2369471.1&id=27310092.8>
hot clone of pdb with a read-only plugin tablespace fails with
ORA-283/ORA-1184
27345498
<https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=2369471.1&id=27345498.8>
DB upgrade is slower because pdb$seed is upgraded in a batch of its own
27378103
<https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=2369471.1&id=27378103.8>
DBA_LOCKDOWN_PROFILES.CLAUSE_OPTION column has an extra trailing null
character
27384222
<https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=2369471.1&id=27384222.8>
CMAN fails with TNS:connect request rejected based on current filtering
rules
27425507
<https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=2369471.1&id=27425507.8>
standby does not instantiate source pdb with big file tablespace
27450400
<https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=2369471.1&id=27450400.8>
VPD layer does not handle fixed tables to retrieve object name
27469329
<https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=2369471.1&id=27469329.8>
relocate pdb to original POD fails ORA-65012: pluggable database
already exists
27496224
<https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=2369471.1&id=27496224.8>
need to fire the PDB close trigger earlier rather than waiting for
sessions to exit
27498477
<https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=2369471.1&id=27498477.8>
ORA-4036 during concurrent workload
27533819
<https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=2369471.1&id=27533819.8>
ADWC: PDB load data failed with ORA-65114 after PDB restore
27563629
<https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=2369471.1&id=27563629.8>
Cloned DB instance may crash with ORA-00600 [kcfbsy_offline_with_enq]
error
27602488
<https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=2369471.1&id=27602488.8>
lockdown profile's "option all except" clause does not work as expected
27608669
<https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=2369471.1&id=27608669.8>
describe of a fixed object in a closed db leads to ORA-1219
27649707
<https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=2369471.1&id=27649707.8>
update the lockdown profile to allow creation of validated constraints
in ADWC
27679806
<https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=2369471.1&id=27679806.8>
ADWC: stack corruption in kpdbocGetObject()
27950708
<https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=2369471.1&id=27950708.8>
Query on CDB_TAB/ROLE_PRIVS takes 8.5 hrs and consumes 10 GB of PGA
28059199
<https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=2369471.1&id=28059199.8>
Local undo does not work after CDB upgrade from version 12102 18.2.0.0.DBRU:180417 2176622025824236
<https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=2369471.1&id=21766220.8>
ORA-600 followed by ORA-603 when dropping a common user
<https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=2369471.1&id=25824236.8>
UTL_HTTP should be able to use network ACLS in CDB$ROOT for all PDBs
27425507
<https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=2369471.1&id=27425507.8>
standby does not instantiate source pdb with big file tablespace
If you trace the bug through the Oracle support, you'll see that all versions below 19.1 are affected. My advice would be to immediately apply upgrade bundle from October 2019 (18.8) and if database opens OK, to immediately upgrade to 19.5. (19.0 with October bundle).
On 11/25/19 7:44 AM, Howard Latham wrote:
> Anybody had this error trying to open a db upgraded to 18c from 11.2.04? > ORA-00600:[kpdbHashTableIns:nullval] > RH Linux 64bit > > it opens ok in upgrade mode. > > > Best Wishes > > Howard A. Latham > >
-- Mladen Gogala Database Consultant Tel: (347) 321-1217 -- http://www.freelists.org/webpage/oracle-lReceived on Mon Nov 25 2019 - 14:14:15 CET