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 MAY 19, 2023
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
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 |