My Oracle Support Banner

ORA-06550 & PLS-00201: identifier CTXSYS.CTX_ADM must be declared during Database Upgrade from 11.2.0.4 to 12.1.0.2 (Doc ID 2190702.1)

Last updated on JULY 17, 2018

Applies to:

Oracle Text - Version 11.2.0.2 to 12.1.0.2 [Release 11.2 to 12.1]
Information in this document applies to any platform.

Symptoms

You can find the below error in the "upgrade0.log" file after the upgrade from 11.2.0.4 to 12.1.0.2. 

21:23:25 SQL> begin
21:23:25 2 ctxsys.ctx_adm.recover;
21:23:25 3 end;
21:23:25 4 /
ctxsys.ctx_adm.recover;
*
ERROR at line 2:
ORA-06550: line 2, column 3:
PLS-00201: identifier 'CTXSYS.CTX_ADM' must be declared
ORA-06550: line 2, column 3:
PL/SQL: Statement ignored

 

Check whether the below warning is reported in "Oracle_Server.log"  file.

*** WARNING: ERRORS FOUND DURING UPGRADE ***

Due to errors found during the upgrade process, the post
upgrade actions in catuppst.sql have not been automatically run. 

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
References


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