To upgrade the target database to SDB 12.6, you need to run the upgrade.sql script on the SDB 12.4 or 12.5 database.
You need to upgrade the database version to SRD 10.5 before proceeding with the migration.
This upgrade script will install all the additional SDB objects required for the SDB 12.6 upgrade.
Run the upgrade.sql script
-
Run Command Prompt as an administrator.
-
Enter the SDB product installation location in the Command Prompt to run the upgrade.sql script.
For example: cmd>cd "C:\Program Files\Standard Database for Intergraph Smart Reference Data\SDB 12.6"
Make sure you have the Write permissions on the logs and cip_backup folders.
For example: "C:\Program Files\Standard Database for Intergraph Smart Reference Data\SDB 12.6\logs" and "C:\Program Files\Standard Database for Intergraph Smart Reference Data\SDB 12.6\cip_backup"
-
Connect to the database using SQLPlus. Sign in with a username and include as sysdba after the username.
For example: cmd>"<Oracle_Home>\BIN\sqlplus.exe" sys/<Password>@<SID> as sysdba
-
If SQLPlus is not accessible from the Command Prompt, then you need to enter the complete path of sqlplus.exe, or the Oracle home path must be added in the environment variables paths.
-
If you are on a multi-tenant architecture (CDB or PDB), ensure that you are connected to PDB and not to CDB.
-
-
Run the upgrade.sql script. Enter all the inputs prompted by the script (The default password is MANAGER30).
SQL>@ upgrade.sql
-
Log files will be generated in the logs folder present in the SDB installation location.
-
The default log file path is <SDB Installation Location>\logs\.
-
A few of the pre-migration scripts may fail to run if the target database has invalid records.
-
Backups of the target database packages are stored in the <SDB installation folder>\ cip_backup folder. If any customization has been done in these packages before, you must merge the changes after completing the migration.
-
The backup package in the cip_backup folder is overwritten each time the SDB migration is run. A copy of this folder must be created before running the SDB migration again.
-
Copy the S50RSDB.rdf file from <SDB Install Folder>\Reports to the application server (<Smart Materials Installation folder>\rep\) to extract spec reports from the S.50.R.SDB.03 SDB Spec Report screen.
-
After migration, it is recommended to run the post import script (post_import.sql) specific to SRD. The post_import.sql file can be found in <Smart Materials Installation folder>\samples\post_import\import_general.
-
Any modifications made to the custom packages on the target database need to be handled after the upgrade process.