How to connect Agentry application with Oracle database ?

[Former Member]

Hello experts,

                     I have a project which needs to get back-end from Oracle. I am tried to do this. But not succed. If possible let me know how to connect Oracle back-end with Agentry apllication with screen shot. Plz help me.

  Thanks

   Sudhir

[Former Member · Accepted solution]

Sorry I don't have screenshots,
1) Make sure you have the same bit version of the oracle client as the Agentry\SMP server you are using

2) Setup the tsnames.ora file to point to your database.

3) Use the tns ping application to test the connection

4) if you are using SMP 3n the backend configuration tab for your [sql-n] section, or in the Agentry.ini for earlier version.

4a) set dbConnectionType to: Oracle

4b) set queryConstansFile to: oracle_sd.in

[Former Member · Accepted solution]

Hello Stephen,

                       Actually I am new in SAP. So plz tell me in detail & let me know where to setup tnsnames.ora file. And let know about how to deploy Agentry application in SMP 3.0.

Thanks

Sudhir

[Former Member · Accepted solution]

Sorry, the tnsnames.ora file is not SAP, but oracle.

Local Naming Parameters (tnsnames.ora)