If your Smart Materials database is already on version 8.4 or higher, skip this section and continue with Smart Materials Upgrade to 10.0.
-
Back up your database before upgrade.
-
Login with the local administrator account.
-
Open a Command Prompt window as an administrator, with the%SMAT_DB_InstallFolder 8.4%\ as working directory.
-
Set ORACLE_HOME and ORACLE_SID.
-
Invoke SQL*Plus.
-
Connect as SYS.
-
Type shutdown immediate and press ENTER.
-
Type conn sys/<sys_password>@<SID> as sysdba and press ENTER.
-
Type create pfile from spfile; and press ENTER.
-
Modify <ORACLE_HOME>\database\initSID.ora, change the compatible parameter from 18.6.0.0.0 to 19.7.0.0.0:
compatible=19.7.0.0.0
-
Save the changes.
-
Type create spfile from pfile; and press ENTER.
-
Type startup and press ENTER.
-
Execute tnsping to check if the database is available again.
If tnsping succeeds, you can continue with the next step.
-
Copy and replace the variable.sql from %SMAT_DB_InstallFolder 10.1%\scripts into %SMAT_DB_InstallFolder 8.4%\scripts.
-
Type @install_upgrade.sql and press ENTER to start the upgrade script.
-
Read the instructions on the screen.
-
Press ENTER to continue.
-
Enter your <SID> 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.
-
To allow Java access to local files, open a SQL*Plus session, and connect as SYS.
-
Type the following command:
EXEC dbms_java.grant_permission('M_SYS','java.io.FilePermission','<your
PDB_REPORT_DEST_DB directory>','read,write,delete');
Example:
EXEC dbms_java.grant_permission('M_SYS','java.io.FilePermission','C:
\oradata\SMAT\utl','read,write, delete');
PL/SQL procedure successfully completed.