To setup the Oracle database do the following:

  1. Create a user.

  2. Give the user the right to do a select on table v$database. This system table is queried by the SMSSMEX web service to validate database connections.
  3. Login as the user and run the script create_tables_oracle.sql (log in from path <SMSSMEX_installDir>\sql so that the script is found). This creates all required tables.

These tables are created within the schema of the database user (the tables are logically separated and do not interfere with each other).