Knowledge Base > Automation Engine and Target Systems > Databases > Connection to Oracle Databases

Connection to Oracle Databases

The databaseA database is an organized collection of data including relevant data structures. agentA program that enables the de-centralized execution of processes (such as deployments) on target systems (computers or business solutions) or a service that provides connectivity to a target system (such as for databases or middleware). An agent is also an object type in the Automation Engine. [Formerly called "Executor."] See also: host 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 Job objectAutomation Engine controlled activities and processes are structured in the form of objects. See also: Task 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 following steps are required in addition to installing the database agent:

1. Set the database agent's INI-file parameter useOraClient= to the value

  • "1".
  • 2. Install the Oracle Client or the Oracle Instant Client on the database agent's computer. Several packagesDelivery package, a bundle of functionality. are available for the Oracle Instant Client. The database agent requires the "Basic" packageA Package is an instance (a version, a revision, a tag, …) of your application and defines the content which you want to deploy. Here you decide, if you want to deploy the entire application or just a few specified components..
  • 3. When using the Oracle Instant Client, set two environmentAn Environment consists of Deployment Targets which represent your endpoints. Different environments are used for different phases in the software delivery cycle, for example Development, QA, Staging, Production. An environment is typically set up once and used by several applications. variables. Include the Oracle Instant Client's installation directory in the environment variableIt stores or retrieves values dynamically at runtime. An individual Automation Engine object type. PATH (for Windows) or LD_LIBRARY_PATH (for UNIX). The environment variable TNS_ADMIN must point to the directory in which the file tnsnames.ora is stored.
  • Example for the file tnsnames.ora:

    APPL_DB = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = db-server01)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = db-server02)(PORT = 1521)) (LOAD_BALANCE = yes) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = APPLDB.CUSTOMER.COM) ) )

    For this example, the name "APPL_DB" must be specified in the Job object's field Database.

     

     


    Automic Documentation - Tutorials - Automic Blog - Resources - Training & Services - Automic YouTube Channel - Download Center - Support

    Copyright © 2016 Automic Software GmbH