Pin_upgrade_12ps4.pl with "Error: Unable To Update The Portal Base Database." (Doc ID 2822951.1)

Last updated on OCTOBER 09, 2024

Applies to:

Symptoms

On : 12.0.0.4.0 version, Infranet Install

pin_upgrade_12ps4.pl failed with error.

$ perl pin_upgrade_12ps4.pl

...
Started dd_objects_journal.source at Mon Nov 15 11:17:15 2021
12PS1 filename /u01/app/pin/BRM/sys/dd/data/dd_objects_journal.source
Modifying DB Schema...
EBUF: errno=<PIN_ERR_BAD_ARG:4> location=<PIN_ERRLOC_DM:4> class=<UNKNOWN:0> field num=<PIN_FLD_ACTION:5,83> recid=<0> reserved=<0>
*** Error: Unable to update the Portal Base database.
Exiting from the install without finishing successfully.

Errors in dm_oracle.pinlog:
====================
E Mon Nov 15 10:50:52 2021 <HOSTNAME> dm:3575 sm_dd_obj_set.c(22):2059 2:<HOSTNAME>:<no_name>:3063:-137722112:21:1636995052:1::::
        sdo_process_simpletype: cannot specify ADD for an existing field, name "PIN_FLD_TYPE"
W Mon Nov 15 10:50:52 2021 <HOSTNAME> dm:3575 dm_subr.c(180):1652 2:<HOSTNAME>:<no_name>:3063:-137722112:21:1636995052:1::::

        SQL_STMT do_sql: cmd="rollback"
D Mon Nov 15 10:50:52 2021 <HOSTNAME> dm:3575 ../dm_oracle_stmt_cache.c:366 2:<HOSTNAME>:<no_name>:3063:-137722112:21:1636995052:1::::
        PINStmtPrepare: SQL Statement = rollback
        audsession-id: 8991208; Statement-id: 31348424;
D Mon Nov 15 10:50:52 2021 <HOSTNAME> dm:3575 ../dm_oracle_stmt_cache.c:376 2:<HOSTNAME>:<no_name>:3063:-137722112:21:1636995052:1::::
        audsession-id: 8991208; Statement-id: 31348424; Time taken by OCIStmtPrepare = 0.034094 milliseconds
D Mon Nov 15 10:50:52 2021 <HOSTNAME> dm:3575 dm_if_oracle.c(228):935 2:<HOSTNAME>:<no_name>:3063:-137722112:21:1636995052:1::::
        audsession-id: 8991208; Statement-id: 31348424; Time taken by ExecuteSQLStmt = 1.048803 milliseconds
D Mon Nov 15 10:50:52 2021 <HOSTNAME> dm:3575 dm_if_oracle.c(228):9845 2:<HOSTNAME>:<no_name>:3063:-137722112:21:1636995052:1::::
        End of opcode PCM_OP_SET_DD
D Mon Nov 15 10:50:52 2021 <HOSTNAME> dm:3575 dm_if_oracle.c(228):9847 2:<HOSTNAME>:<no_name>:3063:-137722112:21:1636995052:1::::
        audsession-id: 8991208; Time taken by PCM_OP_SET_DD = 1.747847 milliseconds
E Mon Nov 15 10:50:52 2021 <HOSTNAME> dm:3575 dm_back.c(41):1635 2:<HOSTNAME>:<no_name>:3063:-137722112:21:1636995052:1::::
        DMbe #4: process_op: op 21(PCM_OP_SET_DD), err 4(PIN_ERR_BAD_ARG)

The upgrade comes from 7.5 Patch Set (PS) 19 to 12.0 PS4
Database (DB) version: 12.2.0.1.0
DB client version: 12.1.0.2.0

Cause

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