You are viewing limited content. For full access, please sign in.

Question

Question

How to choose Oracle TNS listener version in Forms Database Connections?

Forms
Updated May 14, 2024
asked on May 13, 2024

After getting a timeout error on our Forms Oracle Database connection, the IT department is requesting we use the TNS listener version 19 recently installed adjacent to the older version. However when I configure the data source, it only asks for TNS Name without any option for which version I want to connect to.

With SQL server, the engine can be any version and we can connect to it. Seems TNS listeners require a version be specified if they install more than one?

0 0

Replies

replied on May 14, 2024

Hi Chad,

 

As you mentioned, when configuring the data source, Forms asks for TNS name only, and if I'm not wrong, TNS listeners does require a version be specified if there's more than one installed.

So the TNS Name itself specified in Forms doesn’t directly determine the listener version, it identifies the database service. The listener version might need to be determined by the Oracle Home where the listener process runs and you might need to configure there.

I found the following posts might be helpful:

oracleforms - Oracle forms: TNS: could not resolve the connect identifier specified - Stack Overflow

oracle - ORA-12514 TNS:listener does not currently know of service requested in connect descriptor - Stack Overflow

1 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...