...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
Supported Oracle Version(s)
RMsis has been tested with Oracle Version ZZ.ZZZ.
...
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>;
- Note 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. |
