If your database is on version 2016 (8.4.0) or higher, you can skip this section
and continue with Perform the Smart Materials Upgrade to Version 10.0.0.
You can find the needed upgrade scripts in the %SMAT_DB_InstallFolder%\others\prerequisites\dbserver in the setup directory.
To perform the 8.4.0 upgrade, proceed as follows:
-
Login with the local administrator account.
-
Open a Command Prompt window as an administrator, with this folder as working directory.
-
Set ORACLE_HOME and ORACLE_SID.
-
Invoke SQL*Plus.
-
Connect as SYS.
-
Type @install_upgrade.sql and press ENTER to start the upgrade script.
-
Read the instructions on the screen.
-
Press ENTER to continue.
-
Enter the database connect string, and press ENTER.
-
Enter the SYS password, and press ENTER.
-
Enter the M_SYS password, and press ENTER.
-
Press ENTER to start the upgrade process.
-
Press ENTER again; the upgrade progress is shown in the SQL window.
-
When the upgrade is complete, check all log files for possible Oracle errors.
The log files are located in the installation_logs and import folders. Logs have the following extensions: *.log, *.lst, and *.tmp. You can safely ignore all errors that refer to index creation with a specified indexed column combination that is already indexed. It is a best practice to keep these log files for later analysis. Do not use the same folder for more than one upgrade but copy it for each separate database upgrade.