Procedure: Fast upgrade Unica Platform
Unica Platform pre-upgrade
About this task
Upgrading the Unica Platform database manually
You should manually execute the following scripts provided in the table underneath on the Unica Platform database while upgrading from various base versions. These steps are not applicable to Fast Upgrade from version 11.0 to version 12.0.0:
Version | SQL scripts to execute |
8.6.x to 12.0.0 |
SQL Server
|
8.6.x to 12.0.0 |
Oracle
|
8.6.x to 12.0.0 |
DB2
OR if Unicode environment execute:
Or if Unicode environment execute:
Or if Unicode environment execute: <
Or if Unicode environment execute:
Or if Unicode environment execute:
Or if Unicode environment execute:
Or if Unicode environment execute:
Or if Unicode environment execute:
|
9.0.x to 12.0.0 |
SQL Server
|
9.0.x to 12.0.0 |
Oracle
|
9.0.x to 12.0.0 |
DB2
OR if Unicode environment execute: <PLATFORM_HOME>/db/upgrade90to91/ManagerSchema_DB2_91upg_unicode.sql
OR if Unicode environment execute: <PLATFORM_HOME>/db/ upgrade91to911/ManagerSchema_DB2_911upg_unicode.sql
OR if Unicode environment execute: <PLATFORM_HOME>/db/upgrade912to10/ManagerSchema_DB2_10upg_unicode.sql
OR if Unicode environment execute: <PLATFORM_HOME>/db/upgrade10001to10002/ManagerSchema_DB2_10002upg_unicode.sql
OR if Unicode environment execute: <PLATFORM_HOME>/db/ upgrade10002to101/ManagerSchema_DB2_101upg_unicode.sql
OR if Unicode environment execute: <PLATFORM_HOME>/db/ upgrade101to11/ManagerSchema_DB2_11upg_unicode.sql
Or if Unicode environment execute:
|
9.1.x to 12.0.0 |
SQL Server
|
9.1.x to 12.0.0 |
Oracle
|
9.1.x to 12.0.0 |
DB2 <PLATFORM_HOME>/db/upgrade91to911/ManagerSchema_DB2_911upg.sql OR if Unicode environment execute: <PLATFORM_HOME>/db/ upgrade91to911/ ManagerSchema_DB2_911upg_unicode.sql <PLATFORM_HOME>/db/upgrade912to10/DB2_QRTZ_Scheduler_10_upggrade_Script.sql <PLATFORM_HOME>/db/upgrade912to10/ManagerSchema_DB2_10upg.sql OR if Unicode environment execute: <PLATFORM_HOME>/db/upgrade912to10/ ManagerSchema_DB2_10upg_unicode.sql <PLATFORM_HOME>/db/upgrade10001to10002/ManagerSchema_DB2_10002upg.sql OR if Unicode environment execute: <PLATFORM_HOME>/db/upgrade10001to10002/ManagerSchema_DB2_10002upg_unicode.sql <PLATFORM_HOME>/db/ upgrade10002to101/ ManagerSchema_DB2_101upg.sql OR if Unicode environment execute: <PLATFORM_HOME>/db/ upgrade10002to101/ ManagerSchema_DB2_101upg_unicode.sql <PLATFORM_HOME>/db/upgrade101to11/ManagerSchema_DB2_11upg.sql OR if Unicode environment execute: <PLATFORM_HOME>/db/ upgrade101to11/ManagerSchema_DB2_11upg_unicode.sql <PLATFORM_HOME>/db/upgrade111to11102/ManagerSchema_DB2_11102upg.sql <PLATFORM_HOME>/db/upgrade11102to12/ManagerSchema_DB2_12upg.sql OR if Unicode environment execute: <PLATFORM_HOME>/db/upgrade11102to12/ManagerSchema_DB2_12upg_unicode.sql |
9.1.1.x to 12.0.0 |
SQL Server
|
9.1.1.x to 12.0.0 |
Oracle
|
9.1.1.x to 12.0.0 |
DB2
OR if Unicode environment execute: <PLATFORM_HOME>/db/upgrade912to10/ManagerSchema_DB2_10upg_unicode.sql
OR if Unicode environment execute: <PLATFORM_HOME>/db/upgrade10001to10002/ManagerSchema_DB2_10002upg_unicode.sql
OR if Unicode environment execute: <PLATFORM_HOME>/db/ upgrade10002to101/ManagerSchema_DB2_101upg_unicode.sql
OR if Unicode environment execute:
<PLATFORM_HOME>/db/upgrade111to11102/ManagerSchema_DB2_11102upg.sql <PLATFORM_HOME>/db/upgrade11102to12/ManagerSchema_DB2_12upg.sql OR if Unicode environment execute:
|
9.1.2.x to 12.0.0 |
SQL Server
|
9.1.2.x to 12.0.0 |
Oracle
|
9.1.2.x to 12.0.0 |
DB2
OR if Unicode environment execute: <PLATFORM_HOME>/db/upgrade912to10/ManagerSchema_DB2_10upg_unicode.sql
OR if Unicode environment execute: <PLATFORM_HOME>/db/upgrade10001to10002/ManagerSchema_DB2_10002upg_unicode.sql
OR if Unicode environment execute: <PLATFORM_HOME>/db/ upgrade10002to101/ManagerSchema_DB2_101upg_unicode.sql
OR if Unicode environment execute: <PLATFORM_HOME>/db/ upgrade101to11/ManagerSchema_DB2_11upg_unicode.sql
Or if Unicode environment execute:
|
10.0.x to 12.0.0 |
SQL Server
|
10.0.x to 12.0.0 |
Oracle
|
10.0.x to 12.0.0 |
DB2
OR if Unicode environment execute: <PLATFORM_HOME>/db/upgrade10001to10002/ManagerSchema_DB2_10002upg_unicode.sql
OR if Unicode environment execute: <PLATFORM_HOME>/db/ upgrade10002to101/ManagerSchema_DB2_101upg_unicode.sql
OR if Unicode environment execute: <PLATFORM_HOME>/db/ upgrade101to11/ManagerSchema_DB2_11upg_unicode.sql
OR if Unicode environment execute:
|
10.1.0 to 12.0.0 |
SQL Server
|
10.1.0 to 12.0.0 |
Oracle
|
10.1.0 to 12.0.0 |
DB2
OR if Unicode environment execute: <PLATFORM_HOME>/db/ upgrade101to11/ManagerSchema_DB2_11upg_unicode.sql
Or if a Unicode environment exceute:
|
11.0 to 12.0.0 | Does not require execution of any scripts |
11.0.1 to 12.0.0 |
SQL Server
Oracle
DB2
Or if a unicode environment exceute
|
Updating the JDBC files in Unica Platform
About this task
- Take a back up the jdbc.properties file from the 12.0.0 environment
(Platform/tools/bin/jdbc.properties). Update the username in the 12.0.0
platform system database / schema name in jdbc.properties file.
Example of jdbc.properties:
uasm.jdbc_driver=com.ibm.db2.jcc.DB2Driver
uasm.data_source=jdbc:db2://<DB_HOST>:<DB_PORT>/<DB2_SID>
uasm.data_source_login=<PLATFORM_DB_SCHEMA>
uasm.data_source_password=ENC(T+rsrWP41Vqu8SoDARMhDdWkf0dFB0Zc) hibernate.dialect=org.hibernate.dialect.DB2Dialect
- To update the encrypted password in the jdbc.properties file run the
following command:Navigate to Platform/tools/bin directory and execute the
below command:
./encryptPasswords.sh –d <PLATFORM_DB_USER_PASSWORD>
This will update the encrypted password in the jdbc.properties file. Save the Platform/tools/bin/jdbc.properties with this encrypted password of the new schema user.
- In the application server, update the JNDI details (schema / SID, userid, password) for Platform JNDI as per the new database schema used with v12.0.0 environment.
Upgrading the Unica Platform configuration
Procedure
Importing Asset Picker node to Unica Platform
About this task
To perform a fast upgrade of Asset Picker, you must import the Asset Picker node to Unica Platform. To import the Asset Picker node to Unica Platform, complete the following steps: