Creating Oracle DB Connection

This topic provide instructions to connect Real-Time Designer with the Oracle database.

To connect RT Designer with Oracle DB:

  1. In Real-Time Designer, create a local database connection.

  2. Select Database Provider as Oracle and provide the database Server host name, User name, and Password.

  3. Download the latest Oracle Client Installation dll. The Oracle Client will be in a zip format.

  4. Extract the downloaded zip file and place it in the desired folder location.

  5. In the System Environment variable, add the extracted folder path.

    1. Navigate to System Properties > Advanced > Environment Variables.

    2. In the System Variables pane, edit the Path variable and add the extracted oracle folder path.

    3. Click OK.

  6. On your Oracle DB machine, navigate to <Oracle Home>\network\admin\ and open the tnsnames.ora file for editing.

  7. Provide necessary information in the tnsnames.ora file and save it. Sample values are given below:

    EGLUE = [This is Server Name from Database Connection]

    (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.1)(PORT = 1521) [Protocol Address Information]

    (CONNECT_DATA =

    (SERVER = DEDICATED)

    (SERVICE_NAME = pdb_1)

    (SID = eglue)))

  8. Copy the edited tnsnames.ora file to the following locations:

    • Real-Time Client installation folder

    • Real-Time Designer installation folder

    • Extracted Oracle Client folder (from step 4 above)

  9. In the Real-Time Designer, test the newly created Oracle database connection.