My Oracle Support Banner

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

Last updated on MAY 11, 2021

Applies to:

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

Symptoms

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 10.1.2.0.2 works fine
Connecting from SQLPLUS works fine also.

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

Changes

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

Cause

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
Symptoms
Changes
Cause
Solution
References


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