4
Managing OracleAS InterConnect

This chapter describes how to manage OracleAS InterConnect after installation.

Topics discussed are:

• Starting OracleAS InterConnect

• Changing OracleAS InterConnect and Oracle Workflow Schemas Passwords

• Creating Multiple Repository Schemas in the Same Database

• Creating Multiple Adapters using the copyAdapter Script

• Windows Service Names of the OracleAS InterConnect Components

Starting OracleAS InterConnect

Start OracleAS InterConnect using the following steps:

1. Start the hub database. This is the Oracle8i or Oracle9i database.

2. Start the hub database listener.

3. Start Oracle Management Server.

4. Start InterConnect Repository.

   Note: On both Windows and UNIX, you must run the start command from the repository directory, as indicated in the following instructions.

   On UNIX:

   Use the start command:

   cd ORACLE_HOME/oai/9.0.4/repository
   ./start
   
   

   On Windows:

   Use the start.bat command or the Service panel for the repository:

   cd ORACLE_HOME\oai\9.0.4\repository
   .\start.bat
   
   

5. Use iStudio to design integration metadata. To start iStudio, use the following shortcut from the Start menu:

   Start > Programs > ORACLE_HOME_NAME > Application Development

6. Start adapter(s).

   See Also: Table 2-1 for a list of adapter-specific documentation.

Changing OracleAS InterConnect and Oracle Workflow Schemas Passwords

You might need to change the passwords of the oaihub904 and owf_mgr schemas on a regular basis, depending on your company's security policy. The oaihub904 is the schema for OracleAS InterConnect, and owf_mgr is the schema for Oracle Workflow.

Change the passwords of the oaihub904 and owf_mgr schemas in the Oracle database using the following steps:

1. Obtain the necessary system privileges to change schema passwords in the database.

   See Also: Refer to the Oracle database documentation for details on changing schema passwords.

2. Encrypt the new password using the encrypt utility in the ORACLE_HOME/oai/9.0.4/bin directory. This is the OracleAS InterConnect Oracle home (as opposed to the database Oracle home).

   When you run encrypt, you are prompted to enter the password to encrypt.

3. Update the appropriate parameter in the .ini files with the encrypted password. This is the OracleAS InterConnect Oracle home (as opposed to the database Oracle home).

   Table 4-1 contains information about updating files with encrypted passwords.

   Table 4-1 Update Files with Encrypted Password

   Enter the encrypted password for this schema	In this parameter	In this file	On these machines
   oaihub904	encrypted_hub_password	ORACLE_HOME/hub/hub.ini	All machines
   owf_mgr	encrypted_aq_bridge_password	ORACLE_HOME/workflow/adapter.ini	Hub machine

Creating Multiple Repository Schemas in the Same Database

The first schema was created in the repository database during the hub installation. If you need a second schema in the repository database, you can create it using the following steps:

1. Run the installation procedure.

   When the installer prompts you for database information, enter hub information (database host, port, and SID) that is identical to the hub information in the first install.

2. Make a copy of the following files so that you have a copy of the original. You will be making changes to these files:
   • ORACLE_HOME/oai/9.0.4/repository/hubschema

   • ORACLE_HOME/oai/9.0.4/repository/oaiexport

   • ORACLE_HOME/oai/9.0.4/repository/oaiimport

   • ORACLE_HOME/oai/9.0.4/repository/sql/hub1.sql

   • ORACLE_HOME/oai/9.0.4/repository/sql/deinstall_schema.sql

   • ORACLE_HOME/oai/9.0.4/hub/hub.ini

3. Replace all occurrences of oaihub904 with the name of the new schema in the original files.

   For example, if you want the new schema to be called oaihub, replace oaihub904 with oaihub.

4. Execute the modified hubschema script to create the new hub user (oaihub in this example) in the hub database.

5. Run postinstallation steps as described in "Hub Postinstallation Tasks".

Creating Multiple Adapters using the copyAdapter Script

The copyAdapter script is copied to the following bin directory only during hub installation:

• UNIX: ORACLE_HOME/oai/9.0.4/bin

• Windows: ORACLE_HOME\oai\9.0.4\bin

If you need to use this script to create multiple adapters on a spoke machine, copy the script to the bin directory on the spoke machine, and edit the script to reflect the new Oracle home.

Windows Service Names of the OracleAS InterConnect Components

The Windows Service Names of the OracleAS InterConnect Components are:

• OracleAS InterConnect Adapters: Oracle<OracleHomeName>InterConnect-<adapterName>, for example, myAQApp

• OracleAS InterConnect Repository: Oracle<OracleHomeName>InterConnectRepository

• Oracle Workflow: Oracle<OracleHomeName>InterConnect