My Oracle Support Banner

Forms Migration Assistant (FMA) Ignores TNS_ADMIN Setting in Registry (Doc ID 333622.1)

Last updated on OCTOBER 09, 2023

Applies to:

Oracle Forms - Version 6.0.8 and later
Information in this document applies to any platform.


Problem occurs when: setting TNS_ADMIN to a specific location than the default, e.g. d:\network\tns_admin and then moving tnsnames.ora and sqlnet.ora to d:\network\tns_admin and remove/rename the files from the default location $ORACLE_HOME\NETWORK\ADMIN.
When opening the Forms Migration Assistant and trying to migrate a Form, I fails to connect to the database with the message:

"Unable to connect to database with the information provided"

Connecting from the Forms Builder works fine
Connecting from SQLPLUS works fine also.

In  Forms the issue does not reproduce and the connection is successful. This happens  for Forms 10g version10. and  only when trying to connect to the DB  from FMA.


In Forms the FMA pick up the value for TNS_ADMIN from the frmplsqlconv.bat file which is used to call the Forms Migration Assistant.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.