| Table of Contents |
|---|
...
RMsis requires it's own independent database. This section contains instructions for setting up all the supported versions of Databases.
...
Currently, RMsis supports Oracle 11G and later versions.
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>;
Database Configuration for Oracle
| 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. |
...