Smart Materials Update to 10.1 - Intergraph Smart Materials - Version 10.1 - Installation & Upgrade - Hexagon

Intergraph Smart Materials Installation (10.1)

Language
English
Product
Intergraph Smart Materials
Subproduct
Classic
Search by Category
Installation & Upgrade
Smart Materials/Smart Reference Data Version
10.1
  1. Back up your database before upgrade.

  2. Login with the local administrator account.

  3. Open a Command Prompt window as an administrator.

  4. Set ORACLE_HOME and ORACLE_SID.

  5. Perform this step only if updating after a fresh install, else continue with next step.

    • Change working directory to %SMAT_DB_InstallFolder101%\samples\SMat.

    • Invoke SQL*Plus

    • Connect as SYS.

    • Execute: @create_smat_web_workspace.sql <{ORACLE_BASE}\oradata\{DB_UNIQUE_NAME}\{PDB-DIRECTORY}\DATAFILE\{FILENAME}.DBF> <password for user BIR_SPMAT>

      Example:

      @create_smat_web_workspace.sql c:\oracle\CDB\SMAT\APEX_BIR.DBF password

    • Close SQL*Plus.

  6. Change working directory to %SMAT_DB_InstallFolder 101%\.

  7. Invoke SQL*Plus.

  8. Connect as SYS.

    If you have upgraded to 10.0 as described in Smart Materials Upgrade to 10.0, skip steps 9 to 16 and continue with step 17.

  9. Type shutdown immediate and press ENTER.

  10. Type conn sys/<sys_password>@<SID> as sysdba and press ENTER.

  11. Type create pfile from spfile; and press ENTER.

  12. 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

  13. Save the changes.

  14. Type create spfile from pfile; and press ENTER.

  15. Type startup and press ENTER.

  16. Execute tnsping to check if the database is available again.

    If tnsping succeeds, you can continue with the next step.

  17. Type @install_upgrade.sql and press ENTER to start the upgrade script.

  18. Read the instructions on the screen.

  19. Press ENTER to continue.

  20. Enter your <PDB Instance> and press ENTER.

  21. Enter the SYS password and press ENTER.

  22. Enter the M_SYS password and press ENTER.

  23. Press ENTER to start the upgrade process.

  24. Press ENTER again.

    The upgrade progress is shown in the SQL window.

  25. 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.

  26. To allow Java access to local files, open a SQL*Plus session, and connect as SYS.

    Ensure that you are connected to PDB (SMat) and not to CDB.

  27. 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.

    The path must match the PDB_REPORT_DEST_DB setting entered on the A.60.04 DBA Settings screen in Smart Materials. If you do not know this setting, you can perform this step at any time later on.

  • Customer CIPs are saved to the installation_logs folder during upgrade. You may have to modify and re-apply these procedures to the new Smart Materials release.

  • The upgrade of your database is now finished, and you can log on to your database.