ORA-1403 In Token Manager Tables While Upgrading To 11g Upgrade

(Doc ID 1334891.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Server - Enterprise Edition - Version: 11.2.0.2 and later   [Release: 11.2 and later ]
Information in this document applies to any platform.

Symptoms


While upgrading from 10.2.0.4.0 to 11.2.0.2.0 receiving the following error:


Rem Change Token Manager Tables to use VARCHAR2 columns
Rem catxdbtm.sql also changes the names of token tables

declare
2 xdb11inst number := 0;
3 stmt11inst varchar2(2000);
4 localname_type varchar2(2000);
5 begin
6 :tm_name := '@nothing.sql';
7 stmt11inst := 'select count(*) from dba_tables ' ||
8 'where (owner = ''XDB'') and (table_name = ''XDB$TTSET'')';
9 execute immediate stmt11inst into xdb11inst;
10 if ( xdb11inst = 0 ) then
11 select data_type into localname_type from dba_tab_columns
12 where TABLE_NAME = 'XDB$QNAME_ID' and column_name = 'LOCALNAME';
13
14 if (localname_type = 'NVARCHAR2') then
15 execute immediate 'drop table xdb.xdb$nmspc_id';
16 execute immediate 'drop table xdb.xdb$qname_id';
17 execute immediate 'drop table xdb.xdb$path_id';
18 :tm_name := '@catxdbtm.sql';
19 end if;
20 -- exception handler not needed here:
21 -- an error here indicates token tables do not exist;
22 -- the error should be exposed
23 end if;
24 end;
25 /
declare
*
ERROR at line 1:
ORA-01403: no data found
ORA-06512: at line 11

The upgrade stops

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