Upgrading from Version 9.0.1 or 9.1.0 for Oracle

10.3 HotFix 3

Back Next

Step 4. Create the ActiveVOS SchemaStep 4. Create the ActiveVOS Database

Step 4. Create the ActiveVOS Schema
Step 4. Create the ActiveVOS Database

To install ActiveVOS, you need to create the ActiveVOS schema. To create the schema, run the

create_bpm

script.

To install ActiveVOS, you need to create the ActiveVOS database. To create the database, run the

create_bpm

script.

If you want to create multiple MDM Hub Master Databases, create an ActiveVOS schema for each MDM Hub Master Database.

If you want to use the Oracle multitenant feature, create the ActiveVOS schema in a pluggable database (PDB).

If you want to create multiple MDM Hub Master Databases, create an ActiveVOS database for each MDM Hub Master Database.

Open a command prompt and change to the following directory:

MDM Hub distribution directory

>/database/bin

Run the following command:

On UNIX.

./sip_ant.sh create_bpm

On Windows.

sip_ant.bat create_bpm

Answer the prompts that appear.

The prompt displays default text in brackets. Press

Enter

to use the default value and go to the next prompt.

IBM DB2 data sources are case-sensitive. To avoid issues related to case-sensitivity, Informatica recommends that you use uppercase letters to define names, such as those for schemas, columns, and triggers.

Property	Description
Database Type	Type of database to use. For IBM DB2, specify DB2 . The database type must be the same as the database type selected for the MDM Hub Master Database and the Operational Reference Stores.
ActiveVOS Database Host Name	Name of the machine that hosts the database.
ActiveVOS Database TCP/IP Port	Port number that the database listener uses.
ActiveVOS Database Name	Name of the database.
ActiveVOS Database Schema/User Name	User name of the ActiveVOS Server administrative user.
ActiveVOS User Password	Password of the administrative user.
DBA User Name	User name of the database administrative user.
DBA Password	Password of the administrative user.
ActiveVOS Tablespace Name	The name of the tablespace that contains the records that are involved in MDM workflows.

Property	Description
Database Type	The type of database. For an Oracle database, specify Oracle . The database type must be the same as the database type selected for the MDM Hub Master Database and the Operational Reference Stores.
Oracle Connection Type	Connection type. Use one of the following values: SERVICE. Uses the service name to connect to Oracle. SID. Uses the Oracle System ID to connect to Oracle.
ActiveVOS Database Host Name	Name of the machine that hosts the database.
ActiveVOS Database Port	Port number that the database listener uses.
Database Service Name	Name of the Oracle service. This property is required when the selected Oracle connection type is SERVICE.
Oracle Net Connect Identifier (TNS Name)	Oracle TNS name.
Database SID	Name of the Oracle System ID. This property is required when the selected Oracle connection type is SID.
DBA User Name	User name of the database administrative user.
DBA Password	Password of the administrative user.
ActiveVOS User Name	User name of the ActiveVOS Server administrative user.
ActiveVOS User Password	Password of the administrative user.
ActiveVOS User Tablespace	The name of the tablespace that contains the records that are involved in MDM workflows.
ActiveVOS User Temp Tablespace	The name of the temporary tablespace.

Property	Description
Database Type	Type of database to use. For Microsoft SQL Server, specify MSSQL . The database type must be the same as the database type selected for the MDM Hub Master Database and the Operational Reference Stores.
ActiveVOS User Name	User name of the ActiveVOS Server administrative user.
ActiveVOS User Password	Password of the administrative user.
ActiveVOS Collation Name	Name of the ActiveVOS database collation. For example, Latin1_General_CI_AS .
ActiveVOS Database Host Name	Name of the machine that hosts the database.
ActiveVOS Database Path	Path to the database location.
DBA User Name	User name of the SA user.
DBA Password	Password of the SA user account.