Management Agent for Oracle Database
Applies To: Windows Server 2003 with SP1
Use the management agent for Oracle Database to synchronize with Oracle8i, Oracle9i, and Oracle10g Database.
Properties
Available in Identity Integration Feature Pack for Microsoft® Windows Server™ Active Directory® (IIFP) |
No |
Management agent type |
Call-based |
Supported connected data source versions |
|
MIIS 2003 features supported |
|
Schema Information
The schema is generated based on the source database table definition. When you refresh the schema for this management agent, the connected data source schema is rediscovered, the current management agent schema is updated, and then Management Agent Designer starts. In Management Agent Designer, you can correct any inconsistencies introduced by the updated schema, such as deleted object types or deleted attributes.
Remarks
Before creating a management agent for Oracle Database, you must install the Oracle client on the server running ILM 2007 FP1.
The Microsoft Identity Integration Server service account must have Full Control permissions to the root Oracle folder, for example C:\Oracle, and its subfolders. Use the folder properties to grant the Microsoft Identity Integration Server service account Full Control permission to the folder and its subfolders and files. Restart the Microsoft Identity Integration Server service in order for the new permissions to take effect.
By default, this management agent is run in the same process as the Microsoft Identity Integration Server service. However, it is recommended that you run this management agent in its own process to prevent a crash on the connected data source's client software from negatively affecting the Microsoft Identity Integration Server service. You can change this setting using the Run this management agent in a separate process option in Management Agent Designer.
If you are connecting to both Oracle8i, Enterprise Edition, Release 8.1.7; and Oracle9i, Enterprise Edition, Release 9.2.0.1.0 servers, use the Oracle9i client (Release 9.2.0.1.0) to connect to both server versions. Also use the Administrator option when installing the Oracle9i client.
To support tables containing BLOB, CLOB, NLOB, or BFILE columns, the management agent for Oracle Database uses the Oracle OLEDB provider, instead of the Microsoft OLEDB provider.
One object type is created in the connector space for each table or view.