The database agent"Programme permettant l'exécution de Traitements sur des systèmes cible comme un ordinateur ou des solutions d'entreprise. Egalement un type d'objet distinct dans l'Automation Engine. [Anciennement appelé ""Exécuteur de tâches"".]" can connect either to an Oracle Database instance or to Oracle RAC nodes.
Single Instance Oracle Connections
This is the standard connection method. The Database can only connect to an Oracle Database instance. The JobTraitement sur un système cible. Egalement un type d'objet distinct dans l'Automation Engine. object contains the relevant connection data.
The database agent's INI-file parameter useOraClient= (section [SQL]) must be set to the value "0".
Oracle RAC connections
The database agent can connect itself to Oracle RAC nodes. The Oracle file tnsnames.ora contains the relevant connection data. It is not necessary to fill in the field "Server" in the Job object's SQL tab.
The agent's connection information itself has to be defined by using Connection objects (e.g. in SQL variables). In the Connection object you would use Oracle or Oracle OCI as connection type.
The following steps are required in addition to installing the database agent:
The "Oracle Full Client" must be installed (instead of "Oracle Instant Client").