3.1.3.2 Properties for Oracle

When you are using an Oracle database, set the following properties in install.xml:

PropertyDescription
install.ora.jdbc.user

Default value: mzadmin

This property specifies the username of the database that the Platform will be using during runtime.

Note!

The installation will fail if the same username is configured for both the database owner, install.ora.owner, and the runtime (jdbc) user. If it is necessary to have the same username for both users, then the oracle_user.sql file must be manually updated prior to creation of the database.

install.ora.jdbc.password

Example value: mz

This property specifies the password for the jdbc user, previously described.

The password can be changed at a later stage. For further information about changing the database password, see 2.10 Changing Database Password in the System Administrator's Guide.

install.ora.owner

Default value: mzowner

This property specifies the Oracle username for the database owner. The user will own all the data definitions in the Oracle instance to be created.

Note!

When the database is installed in Amazon Web Services, you must set this property to the actual username of the database owner. The database instance is not created during the installation.

Note!

The installation will fail if the same username is configured for both the database owner and the runtime (jdbc) user, mz.jdbc.user . If it is necessary to have the same username for both users, then the oracle_user.sql file must be manually updated prior to the creation of the database.

install.ora.password

Default value: mz

This property specifies the password for the database owner, defined with the install.ora.owner variable described above.

Note!

When the database is installed in Amazon Web Services, you must set this property to the actual password of the database owner. The database instance is not created during the installation. 

install.ora.host

Default value: localhost

This property specifies the IP address or hostname for the database instance.

Note!

When the database is installed in Amazon Web Services, you must set this property to the endpoint hostname. 

install.ora.size

Default value: small

This property specifies the size of the Oracle database instance. Possible values are small, medium or large.

  • small is aimed at test and demo installations.
  • medium is aimed at small and medium-sized operators.
  • large is aimed at large operators.

Table Space

Small (MB)

Medium (MB)

Large (MB)

System

250

250

500

Rollback

125

400

1000

Database Tables

200

600

1200

Database Table Indexes

100

250

500

Temporary Data

80

200

400

Log

60

120

400

Sysaux

100

200

300

Total:

915

2020

4300

install.ora.port

Default value: 1521

This property specifies the Oracle database port.

Note!

When the database is installed in Amazon Web Services, you must set this property to the port number in the endpoint hostname.

install.ora.home

Example value: /opt/oracle/product/12.1.0

This property specifies the Oracle home directory. This value must be identical to the value assigned to the environment variable ORACLE_HOME previously described.

When the database is installed in Amazon Web Services, this property has no effect.

install.ora.sid

Example value: MZ

This property specifies the Oracle SID for the instance to be created. The value must be identical to the value assigned to the environment variable ORACLE_SID , previously described.

Note!

 When the database is installed in Amazon Web Services, you must set this property to the actual database name. The database instance is not created during the installation.

install.ora.data

Example value: /opt/dbfiles

This property specifies a directory path to be used in other Oracle directory definitions. The variable is used for convenience when the same directory path is repeated for any of the following definitions.

When the database is installed in Amazon Web Services, this property has no effect.

install.ora.data.tab

Example value: ${install.ora.data}/tables

This property specifies the directory where the Oracle table space data files are to be created.

When the database is installed in Amazon Web Services, this property has no effect.

install.ora.data.idx

Example value: ${install.ora.data}/indexes

This property specifies the directory where the Oracle index data files are to be created.

When the database is installed in Amazon Web Services, this property has no effect.

install.ora.data.temp

Example value: ${install.ora.data}/temp

This property specifies the directory where the Oracle temporary table space data files are to be created.

When the database is installed in Amazon Web Services, this property has no effect.

install.ora.data.log

Example value: ${install.ora.data}/logfiles

This property specifies the directory where the Oracle log files are to be created.

When the database is installed in Amazon Web Services, this property has no effect.

install.ora.data.roll

Example value: ${install.ora.data}/rollback

This property specifies the directory where the Oracle rollback data files are to be created.

When the database is installed in Amazon Web Services, this property has no effect.

install.ora.data.ctrl

Example value: ${install.ora.data}/control

This property specifies the directory where the Oracle control data files are to be created.

When the database is installed in Amazon Web Services, this property has no effect.

If new directories are specified for the Oracle data, these directories must be created by the Oracle user.