Get ORA-942 due to missing SYS.CSMV$KTFBUE table when running CSSCAN (Doc ID 2194183.1)

Last updated on OCTOBER 17, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.5 to 10.2.0.5 [Release 10.2]
IBM z/OS on System z

Symptoms

CSSCAN is terminating unsuccessfully when running in table mode on z/OS.

csscan parfile=/u/hp02dba/csscan_parfile.txt

 

$ more csscan_parfile.txt

USERID=SYSTEM/????????
TABLE=(SYS.SQL_VERSION$)
TOCHAR=al32utf8

 

Character Set Scanner v2.1 : Release 10.2.0.5.0 - Production on Wed Sep 28 15:05:32 2016

Copyright (c) 1982, 2007, Oracle. All rights reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 P13 - Production
With the Partitioning, Oracle Label Security and Data Mining options

Enter array fetch buffer size: 1024000 >
Enter number of scan processes to utilize(1..64): 1 >
Enumerating tables to scan...

ORA-00942: table or view does not exist
CSS-00151: failed to enumerate user tables
CSS-00120: failed to enumerate tables to scan

Scanner terminated unsuccessfully.

 

 

 


///////////////////////////////////////////////////////////////////////////
/ Oracle for OS/390 Diagnostic Trace -- 2016/10/05 20:24:06.302 /
/ System SYSx Subsystem xxxx Service ORAORA2 Session 18 PID 11F90012/
///////////////////////////////////////////////////////////////////////////
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 P13 - Production
With the Partitioning, Oracle Label Security and Data Mining options
OS/390 SP7.2.1 , CPU MODEL 2098
Instance name: ORA2
Redo thread mounted by this instance: 1
Oracle process number: 20
OSDI process pid: 11F90012, image:

*** ACTION NAME:() 2016-10-05 20:24:06.290
*** MODULE NAME:(/eis/oracle/v10g205pD/bin/csscan) 2016-10-05 20:24:06.290
*** SERVICE NAME:(SYS$USERS) 2016-10-05 20:24:06.290
*** SESSION ID:(341.5237) 2016-10-05 20:24:06.290
*** 2016-10-05 20:24:06.282
ksedmp: internal or fatal error
ORA-00942: table or view does not exist
Current SQL statement for this session:
INSERT INTO CSM$TABLES (USR#, OBJ#, BLOCKS, FILES, MINROWID, MAXROWID) SELECT O.OWNER#, O.OBJ#, S
DBMS_ROWID.ROWID_CREATE(1, O.DATAOBJ#, U.KTFBUEFNO, MIN(U
DBMS_ROWID.ROWID_CREATE(1, O.DATAOBJ#, U.KTFBUEFNO, MAX(U.KTF
0) FROM SYS.TAB$ T, SYS.OBJ$ O, SYS.CSMV$KTFBUE U, CSMIG.CSMV$EXTABLES E WHERE T.OBJ# = O.O
SEGBNO = T.BLOCK# AND U.KTFBUESEGFNO = T.FILE# AND U.KTFBUESEGTSN = T.TS# AND O.OBJ#
TAND(O.FLAGS,128)=0 AND E.PROPERTY = 0 AND BITAND(T.PROPERTY, 67108864) =0 GROUP BY O.OWN
J#, U.KTFBUEFNO

 

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms