Using RMsis with Oracle Database

Supported Oracle Version(s)

• Currently, RMsis has been tested with Oracle Version 11G.

Database Setup using Oracle

• Ensure that you have a database instance available for RMsis (either create a new one or use an existing one).
• Within that database instance, create a user which RMsis will connect as (e.g. rmsisuser).
  • create user <rmsisuser> identified by <user_password> default tablespace <tablespace_name> quota unlimited on <tablespace_name>;
  • Notes :
    • When you create a user in Oracle, Oracle will create a 'schema' automatically.
    • When you create a user, the tablespace for the table objects must be specified.
• Ensure that the user has the following permissions:
  • grant connect to <rmsisuser>;
  • grant create table to <rmsisuser>;
  • grant create sequence to <rmsisuser>;
  • grant create trigger to <rmsisuser>;

Specifying Database Configuration for Oracle while configuring RMsis