'ORA-04042' error returned by 'tmsmupg521to522step2.sql' when upgrading from TMS 4.6.6 to 5.2.3.
(Doc ID 2617810.1)
Last updated on DECEMBER 05, 2019
Applies to:
Oracle Thesaurus Management System - Version 5.2.3 and laterInformation in this document applies to any platform.
Symptoms
tmsupg_<db name>.log contains below error when upgrading from TMS 4.6.6 to version 5.2.3:
running TMSMUPG521to522STEP2.SQL...
Connecting as TMS
Connected.
Procedure created.
Procedure created.
Regrant the needed privileges for all load users
BEGIN
*
ERROR at line 1:
ORA-04042: procedure, function, package, or package body does not exist
ORA-06512: at "TMS.GRANT_OBJECT", line 7
ORA-06512: at "TMS.GRANT_LOAD_USER", line 20
ORA-06512: at line 10
Procedure dropped.
Procedure dropped.
Commit complete.
finished TMSMUPG521to522STEP2.SQL...
Connecting as TMS
Connected.
Procedure created.
Procedure created.
Regrant the needed privileges for all load users
BEGIN
*
ERROR at line 1:
ORA-04042: procedure, function, package, or package body does not exist
ORA-06512: at "TMS.GRANT_OBJECT", line 7
ORA-06512: at "TMS.GRANT_LOAD_USER", line 20
ORA-06512: at line 10
Procedure dropped.
Procedure dropped.
Commit complete.
finished TMSMUPG521to522STEP2.SQL...
Changes
Upgrading from TMS 4.6.6 to TMS 5.2.3
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 |
Changes |
Cause |
Solution |