Supported Oracle Version(s)

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>;

Attribute	Value
Database Type	select "Oracle"
Hostname	Enter hostname or the IP address of the database
Port	TCP port number of the database server (by default 1521 for Oracle)
Database	Enter the name of the database/SID to connect (The Oracle "System Identifier". The default value for most Oracle servers is 'ORCL'. If you are using the Oracle Express Edition, this will be 'XE'.)
Username	Enter username to access the database
Password	Password to access the database.