Upgrading from 7.0 to 12.1 fails with ORA-01017 part way through
Article ID: 50268
Updated On:
Products
Issue/Introduction
Description:
When using the hdbsetup UR option to upgrade the repository from Harvest 7.0 to SCM 12.1 it fails part way through. The updateschema.log file shows the following information at the end:
INDEX HARLINKEDPROCESS_POBJID ON HARLINKEDPROCESS (PROCESSOBJID) CREATED INDEX HARSTATE_ENVOBJID ON HARSTATE (ENVOBJID) CREATED Upgrade to R7.1 Complete PL/SQL procedure successfully completed. ERROR: ORA-01017: invalid username/password; logon denied
Solution:
When upgrading the repository from 7.0 to 12.1 using the hdbsetup UR option the upgrade is performed in two separate phases. The first phase from 7.0 to 7.1 uses a sql script and the second phase from 7.1 to 12.x uses the hserver executable internal upgrade feature.
These different phases use separate database connections and it has been seen in some situations that after the first phase has completed it fails to connect correctly to begin the second phase.
In this situation as long as the updateschema.log shows the following sequence:
... PL/SQL procedure successfully completed. Upgrade to R7.1 ... ... .. Upgrade to R7.1 Complete PL/SQL procedure successfully completed. ERROR: ORA-01017: invalid username/password; logon denied
Then the solution is simply to close hdbsetup and then restart it and select the UR option again. It will then continue the upgrade from the second phase.
Environment
Component:
Feedback
