My Oracle Support Banner

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
  Symptoms
  Cause
  Solution

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.