Data Archive
- Data Archive 6.5 HotFix 1
- All Products
@|* $ # ! % ( ) { } [ ] , ; '
Field
| Description
|
---|---|
Database Type
| Database for the ILM repository, usually called AMHOME.
You can install the ILM repository on Oracle, Microsoft SQL Server, or IBM DB2.
|
Database URL
| Host name and port number for the database instance or Microsoft SQL Server instance.
Enter in the following format:
For a Microsoft SQL Server with SSL enabled, enter in the following format:
If the same machine hosts both the ILM repository and Data Archive web server, the database URL must not be a loopback URL, for example 127.0.0.1 or localhost. If the database URL is a loopback, the Enterprise Data Manager will fail to connect to the ILM repository database.
Use a host name or IP number that is compatible with all potential clients. For example, remote employees in your organization may only be able to connect to the database with a full domain name.
If the ILM repository is located in an Oracle Real Application cluster, enter the RAC SCAN host name and verify that the cluster has more than one node. If the cluster has one node, the ILM application server might not start if the node is unavailable.
|
Repository Schema Name
| A unique placeholder for tables. This placeholder is different from the default placeholder. On an Oracle database, the repository schema name must be the same as the repository login name.
|
Repository Login Name
| Login name for a user who has full access to the repository schema. On an Oracle database, the repository login name must be the same as the repository schema name.
If you install Data Visualization, the repository login name cannot contain the following special characters: @ :
|
Repository Password
| Password for the ILM repository database user or login.
If you install Data Visualization, the repository password cannot contain the following special characters: @ :
|
Database Service Name
| ILM repository database service name or database name.
JDBC connections use the Oracle service name to connect to the database. The Oracle service name may not be the same as the Oracle SID. Use the following SQL statement to determine the database service name:
|
Data Tablespace Name
| Tablespace or data filegroup name, such as AM_DATA.
Not required for Data Vault Loader and Data Discovery installation.
|
Index Tablespace Name
| Index tablespace or filegroup name, such as AM_INDEX.
Not required for Data Vault Loader and Data Discovery installation.
|
SSL Enabled
| Check box to confirm the AMHOME database is SSL enabled.
This property is supported for Oracle 11g and later.
|
Field
| Description
|
---|---|
Database Type
| Database for the ILM repository, usually called AMHOME.
If you install Data Archive only, you can install the ILM repository on Oracle or Microsoft SQL Server. For IBM DB2, you must select the previous option, "Repository Already Exists."
|
Database URL
| Host name and port number for the database instance or Microsoft SQL Server instance.
Enter in the following format:
For a Microsoft SQL Server with SSL enabled, enter in the following format:
If you want to locate the ILM repository in an Oracle Real Application cluster, enter the RAC SCAN host name and verify that the cluster has more than one node. If the cluster has one node, the ILM application server might not start if the node is unavailable.
|
Database User ID
| Admin database user that has required privileges to create or access the ILM repository user/schema. This can be the system or any other admin user.
If you install Data Visualization, the database user ID cannot contain the following special characters: @ :
|
Password
| Password for the ILM repository database user or login.
If you install Data Visualization, the database user password cannot contain the following special characters: @ :
|
Database Service Name
| ILM repository database service name or database name.
JDBC connections use the Oracle service name to connect to the database. The Oracle service name may not be the same as the Oracle SID. Use the following SQL statement to determine the database service name:
|
SSL Enabled
| Check box to confirm the AMHOME database is SSL enabled.
This property is supported for Oracle 11g and later.
|
Tablespace Status
| Field
| Description
|
---|---|---|
New Tablespaces
Existing Tablespaces
| User Name
| ILM repository user account.
|
New Tablespaces
Existing Tablespaces
| Password
| Password for the ILM repository user account.
|
New Tablespaces
Existing Tablespaces
| Data Tablespace Name
| Name of the tablespace or filegroup in which to create the ILM repository tables, such as AM_DATA.
If blank, the installation creates the repository tables in the default tablespace or filegroup.
|
New Tablespaces
Existing Tablespaces
| Index Tablespace Name
| Name of the index tablespace or filegroup, such as AM_INDEX.
|
New Tablespaces
| Data Tablespace Size (MB)
| Size of the tablespace or filegroup. Minimum recommended size is 3000 MB.
|
New Tablespaces
| Data File Name and Location
| File name and path for the tablespace or filegroup data file.
For example:
|
New Tablespaces
| Index Tablespace Size (MB)
| Size of the index tablespace or filegroup. Minimum recommended size is 3000 MB.
|
New Tablespaces
| Index File Name and Location
| File name and path for the tablespace .dbf file.
For example:
C:\oracle\oradata\orcl11\AM_INDEX |