Create the Database - Intergraph Smart Materials - Version 2020 (10.0) - Installation & Upgrade - Hexagon

Open the Oracle Database Configuration Assistant and run as administrator.

Choose Create a database and click Next.

Enter a Global database name, for example: SMAT.

Enter and confirm the Administrative password.

Clear Create as Container database.

Click Next.

When selecting the Advanced configuration, detailed customization can be made of the installation path, init.ora parameter and tablespace. Here you can also integrate the pre-steps (9, 11) for the database configuration.

Click Finish.

Click Close.

To create the Smart Materials specific tablespaces (MARIAN, M_INDEX, M_TEMP) and to change the size of SYSTEM and USERS tablespaces up to 250MB, use this sample script that is provided with the software:

%SMAT_DB_InstallFolder%\samples\SMat\create_tablespace_sample.sql

Proceed as follows:

1. In the sample script, replace the place holder

   ‘{ORACLE_BASE}\oradata\{DB_UNIQUE_NAME}’

   with your datapath, for example

   ‘C:\oracle\18c_Sta\base\oradata\SMAT\DATAFILE’

2. Open a Command Prompt as administrator.

3. Set oracle_home=C:\oracle\18c_Sta\db

4. Set oracle_sid=SMAT

5. Navigate to the directory where the modifed sample script is stored.

6. sqlplus /nolog

7. conn sys/<sys_password> as sysdba

8. @create_tablespace_sample.sql

9. Check the logfile create-smat-tablespace.log.

Import DTD – File as follows:

1. Open a Command Prompt as administrator.

2. Set oracle_home=C:\oracle\18c_Sta\db

3. Set oracle_sid=SMAT

4. Navigate to the directory %SMAT_DB_InstallFolder%\samples\SMat.

5. sqlplus /nolog

6. conn sys/<sys_password> as sysdba

7. @import-dtd.sql

8. Check the logfile import-dtd.log.

Modify init.ora as follows:

1. Open a Command Prompt as administrator.

2. Set oracle_home=C:\oracle\18c_Sta\db

3. Set oracle_sid=SMAT

4. sqlplus /nolog

5. conn sys/<sys_password> as sysdba

6. create pfile from spfile;

7. edit <oracle_home>\database\init<SID>.ora

   Change these parameters:

   Processes = 600

   Open_cursors = 1300

   Compatible = 18.6.0

   Add this parameter:

   *.Sessions = 1000

8. Save the file.

9. Shutdown immediate.

10. conn sys/<sys_password> as sysdba.

11. create spfile from pfile;

12. startup