In the second part of our notes on an upgrade from Siebel 8.1.1.x to Innovation Pack 2013, we are back waiting for the Siebel Upgrade Wizard to finish its arduous task.
8. Backup the Database and execute DB stats
At this step, the Upgrade Wizard stops with the above dialog and urges us to take a backup of the database and then execute DB stats. This is obviously a manual step.
The Database Upgrade Guide shares with us the necessary lines for executing DB stats as follows (Oracle database example):
=>true,estimate_percent => dbms_stats.auto_sample_size);
The above command (with the correct table owner name which usually is SIEBEL) must be run using a SYSDBA account.
Alternatively you can run the more sophisticated stats package available from My Oracle Support as Document Id 781927.1 (thanks to Oli for the link).
Because I encountered problems with too many open cursors on a previous occasion, I also used the following command to increase the maximum amount of open cursors for my Oracle database (not sure if this is truly necessary for Oracle 11g):
|The Hierarchical Merge Report window in Siebel Tools IP 2013|
- Export "New Customer Repository" to a .dat file
- Truncate the repository tables
- Import the new customer repository as "Siebel Repository"
- Migrate Open UI manifest data from XML files to the database