autoupgrade fails with distinct errors : Latest autoupgrade Tool Recommended

刘泽宇

SYMPTOMS
autoupgrade failed with below errors:

1> 2020-04-09 06:58:42.562 ERROR
   DATABASE NAME: <db_name>
            CAUSE: ERROR at Line 1 in [Buffer]
           REASON: ORA-27550: Target ID protocol check failed. tid vers=0, type=1, remote instance number=2, local instance number=1
           ACTION: [MANUAL]
           DETAILS: 27550, 00000, "Target ID protocol check failed. tid vers=%s, type=%s, remote instance number=%s, local instance number=%s"
   // *Cause:  The local Oracle Real Application Cluster instance and remote
   //          instance are running with incompatible implementation of the
   //          inter-instance IPC protocol library. A misconfiguration or
   //          installation error occurred.
   // *Action: Check additional error messages in the alert log and the process
   //          trace file.

   2020-04-09 06:58:42.567 ERROR Database Open Failed for <db_name> ORA-27550: Target ID protocol check failed. tid vers=0, type=1, remote instance number=2, local instance number=1


2>  autoupgrade_<time_stamp>.log file:
    ----------------------------------
    2020-03-31 10:06:09.238 ERROR Error occurred while running the dispatcher for job 116
    Cause: An execution error occurred when running the database checks or fixups - AutoUpgDispatcher.run
    2020-03-31 10:06:09.238 ERROR The dispatcher has failed due to:
    Error: UPG-1316
    [Unexpected Exception Error]
    Cause: An execution error occurred when running the database checks or fixups

    autoupgrade_err.log file:
    ------------------------
    4000      NUMBER:=4000;
    *
    ERROR at line 11:
    ORA-06550: line 11, column 3:
    PLS-00103: Encountered the symbol "4000" when expecting one of the following:
    begin function pragma procedure subtype type <an identifier>
    <a double-quoted delimited-identifier> current cursor delete
    exists prior
    ] [D032_OEM_001]



3> alert log:

Using parameter settings in server-side spfile +DATA/PARAMETERFILE/spfile.ora
WARNING: spfile modifications are disabled because multiple spfiles were used

When trying to modify parameter:
ORA-32000: write to SPFILE requested but SPFILE is not modifiable
4>
ERROR at line 1:
ORA-04045: errors during recompilation/revalidation of GDOSYS.DELETEMETADATAGMT
ORA-01031: insufficient privileges
ORA-06512: at line 77
5> Error : AUPG-2758 AU Precheck "TARGET_HOME_REGISTERED_INVENTORY" failing

   autoupgrade_err.log file contains below error.

   2022-03-21 22:11:51.071 ERROR The following checks have ERROR severity and no fixup is available or
   the fixup failed to resolve the issue. Fix them manually before continuing:
   <db_name> ARCHIVE_MODE_ON
   <db_name> TARGET_HOME_REGISTERED_INVENTORY - ChecksController.evaluateBlockerChecks
6> /java -jar autoupgrade.jar -config orcl.cfg -mode analyze
   AutoUpgrade 21.3.211115 launched with default options
   Processing config file ...
   upg1
   There was an error initializing the patching information for entry upg1
7> ORA-01678: parameter db_file_name_convert must be pairs of pattern and repla
   BUG 34184367 - AUT FAILS IF DB_FILE_NAME_CONVERT PARAMETER HAS PDBSEED IN VALUE IN SOME CASES

CHANGES
Upgrading the database to higher version using autoupgrade tool.

CAUSE
Due to older version of autoupgrade.jar file.The bugs in autoupgrade are fixed in latest autoupgrade tool.

SOLUTION
Download the latest version of autoupgrade from below note and re-run autoupgrade.

AutoUpgrade Tool (Doc ID 2485457.1)