Oracle Access Token

Answered

Follow

Madhur Telang

• October 06, 2020 23:01

I am trying to create the token to connect to Oracle DB. Here is the connection string that I passed in

Database server name field : (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<ip address>)(PORT=<port number>))(CONNECT_DATA=(SERVICE_NAME=<service name>)))

port : blank

I am getting following error

System.TypeInitializationException: The type initializer for 'Oracle.DataAccess.Client.OracleConnection' threw an exception. ---> Oracle.DataAccess.Client.OracleException: The provider is not compatible with the version of Oracle client

 

Does that mean the oracle client version installed on application server is not matching with DB? Any help is appreciated.

 

0

• 

  AgilePoint NX Support

  • October 07, 2020 04:46

  Hi Madhur,

  Could you please mention your DB & Client Versions?

  Also, could you please give one more try by reinstalling the Oracle client?

  Thanks

  0

  Comment actions Permalink
• 

  Venkat A

  • October 07, 2020 04:54

  Hi Madhur,

  Can you please provide your inputs for these questions?

  1.which oracle client version installed on the application server?

  2.What is the version Oracle DB server?

  3.What is your AgilePoint NX installed version? 

   

  Thanks,

  Venkat  

  0

  Comment actions Permalink
• 

  Madhur Telang

  • October 07, 2020 15:20

  Hi Venkat and support team,

  Oracle DB version : Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit

  NX version : AgilePoint NX v7.0 SU2.5

  Regarding Oracle client, it seems we do not have it installed on the app server. Can you please share the guide or pre-requisite what steps need to be taken to create access token for Oracle?

   

  Thanks !

  0

  Comment actions Permalink
• 

  Venkat A

  • October 08, 2020 05:25

  Hi Madhur,

  Please follow the below steps.

  1.NET Framework 3.5 should be installed(enabled) on the AgilePoint Server machine prior to Oracle client installation.

  2. You need to have Oracle Client to be installed in the AgilePoint server and the supported version is till 12c Release1.

  3. Use the Administrator option when performing the Oracle Client installation.

  4. Please find the below download link reference and Screen captures.

  Oracle 12c Release 1: https://www.oracle.com/database/technologies/database12c-win64-downloads.html

   

  

  2

  Comment actions Permalink
• 

  Madhur Telang

  • October 09, 2020 16:07

  Thank you, this resolved the issue. Appreciate the support. 

  0

  Comment actions Permalink

Please sign in to leave a comment.