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