Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Check if you can access database server. Run 'cmd.exe' and execute the following command 'tnsping host:port'  Example: tnsping evuakyisd0084.kyiv.epam.com:1521 If command output is 'OK' (see example below), continue from step 3. Otherwise, move to step 2. Used HOSTNAME adapter to resolve the alias Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=10.17.9.56)(PORT=1521))) OK (360 msec)
  2. Add definition of remote database TNS name on your machine. Open 'tnsnames.ora' and specify new TNS name (see example below). Save the file. TNS file location should be similar to: ..\oraclexe\app\oracle\product\11.2.0\server\network\ADMIN (depending on installed Oracle version) Example: EPMBFIX = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = EVUAKYISD0084.kyiv.epam.com)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = EPMBFIX) )) 
  3. Create System DSN: Open ODBC Data Sources Administrator (Start > Administrative Tools > Data Source (ODBC)) and create new DSN. 3.1 Choose System DSN and click 'Add' 3.2 In 'Create New Data Source' wizard select Oracle ODBC driver and click 'Finish' 3.3 Specify Oracle ODBC Driver configuration parameters and click 'OK':
    • Data Source Name = any value (this parameter will be used in BL_Config.xml)
    • Description = optional and can be omited
    • TNS Service Name = specify name of service name of database you are going to connect to Note, if new TNS was created in tnsnames.ora, its name should be used here (for our example it should be EPMBIX).  If database and FIX Edge are on different servers and step 2 was skipped, specify service name so: @//Database_Host:Database_port/Database_Service_Name  If database and FIX Edge are on the same server, specify database service name
    • Username = database username

...