Share
 
 

Creating a Workgroup Database in Oracle

The following is checklist for the creation process of a Workgroup Database in Oracle.

  1. Download the appropriate database and role creation scripts (Ora_create.sql and Ora_roles.sql) from the Autodesk website (or from the InfoWorks Workgroup Server installation directory for versions prior to 8.0). Make sure that you have the correct scripts for your application. Either:
    • ICM/ICMLive/InfoNet
    • WS Pro/IWLive Pro/DemandWatch Pro
  2. Open the Ora_Create.sql script in a text editor.
    1. Find the line near the end of the script, which starts: INSERT INTO global …
    2. Replace the default database identifier “SQL_INNOVYZEWG00” to a unique value. This will normally be the last argument in the INSERT statement.
  3. Open the Ora_Roles.sql script in a text editor.
    1. Replace the string “CHANGETHIS” with the name of the database Table Owner (as specified in the master.ini file).
    2. Replace the string “INNOVYZEUSER” with the name of the database User (as specified in the master.ini file).

The following steps are usually carried out using Oracle SQLPlus.

  1. Log in to Oracle as the Table Owner for the database.
  2. Run the Ora_create.sql script.
  3. Run the Ora_Roles.sql script.
  4. Ensure that the database transactions are completed.
  5. Check that all instructions ran without errors and that the global table has a single row (select * from global).

On the machine running the InfoWorks Workgroup Server:

  1. Create an empty folder in the Data Store directory, using a database name suitable for end users. Ensure that the folder name ends with “.sndb”, so that it is identified as a database folder to the InfoWorks Workgroup Server.
  2. Create the master.ini file within this folder (see earlier in this document for how to do this).
  3. Clients should now be able to connect to this database in the usual manner.

Was this information helpful?