Project and Portfolio Management Practitioners Forum
cancel

Migrating from 5.5 to 7.1 and hve question on Oracle setting

Highlighted
Rich Y_1
Super Contributor.

Migrating from 5.5 to 7.1 and hve question on Oracle setting

We’re currently in the middle of migrating from ITG 5.5 to 7.1. Our DBAs are asking about Oracle setting that we have set in 5.5. I looked in the 7.1 'System Administration Guide and Reference' and found some of these setting but not all of them. Is there another guide I should look at or do you know if the listed below are needed in 7.1.


_complex_view_merging=TRUE
_fast_full_scan_enabled=FALSE
_new_initial_join_orders=TRUE
_optimizer_mode_force=TRUE
_ordered_nested_loop=TRUE
_push_join_predicate=TRUE
_push_join_union_view=TRUE
_sqlexec_progression_cost=0
_table_scan_cost_plus_one=TRUE
optimizer_features_enable=8.1.7
optimizer_mode=CHOOSE
3 REPLIES
Darshan Bavisi
Outstanding Contributor.

Re: Migrating from 5.5 to 7.1 and hve question on Oracle setting

Hi Rich,

The sys admin guide should be sufficient for the database configurations.

Just as a general question and out of curiosity - Are you upgrading directly from 5.5 to 7.1 or are you upgrading first from 5.5 to 6.0 and then from 6.0 to 7.1? I believe, per HP, it is necessary to upgrade from 5.5 to 6.0 first before upgrading to 7.1. So just wanted to know if you are upgrading directly from 5.5 to 7.1 then how did it go and if you faced any issues during the upgrade.
Rich Y_1
Super Contributor.

Re: Migrating from 5.5 to 7.1 and hve question on Oracle setting

Hello Darshan,

Thanks for the update. We will have to 1st go to 6.0 and then to 7.1. Our systems will only be on 6.0 for a short period just long enoug to start-up and verify that it is running. Then I'll start the 7.1 upgrade. Our migration date is set rigt now as eod of July.

Thanks Again
Rich
Rich Y_1
Super Contributor.

Re: Migrating from 5.5 to 7.1 and hve question on Oracle setting

I'm using the setting in the Sys Admin Guide