You are right both have seperate ORACLE_HOME(s)...unfortunately both tnsnames.ora files are the identical.

Does anyone know where the log files will reside so I could look at the actual connect string being used.

C:\temp\log_sales>tnsping db122

TNS Ping Utility for 64-bit Windows: Version 12.2.0.1.0 - Production on 22-MAR-2017 09:45:06

Copyright (c) 1997, 2016, Oracle.  All rights reserved.

Used parameter files:
c:\oracle\product\12.2.0.1\network\admin\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.25)(PORT = 1522)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = db122)))

Please also check the contents of sqlnet.ora in both homes. Also run the SQL*Plus from Forms Home and try to connect using the TNS Name you have given above and check the results.

Running

C:\Oracle12c\Middleware\Oracle_Home\bin\sqlplus.exe hr/hrpassword@pdborcl

gave the same TNS error message:

ORA-12154: TNS:could not resolve the connect identifier specified

and tnsping also fails:

C:\Users\fleck>C:\Oracle12c\Middleware\Oracle_Home\bin\tnsping.exe pdborcl

TNS Ping Utility for 64-bit Windows: Version 11.2.0.3.0 - Production on 19-MAR-2017 16:27:47

Copyright (c) 1997, 2011, Oracle. All rights reserved.

Used parameter files:
C:\Oracle12c\Middleware\Oracle_Home\network\admin\sqlnet.ora

TNS-03505: Failed to resolve name

BUT both the DB $ORACLE_HOME\network\admin\sqlnet.ora and the Forms $ORACLE_HOME\network\admin\sqlnet.ora are the same:

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

Anymore ideas?

The tnsnames.ora file is under the forms domain fmwconfig folder. I am on windows 10 and this is under:

C:\Oracle12c\Middleware\FRS\Forms\Domain\config\fmwconfig

Where C:\Oracle12c\Middleware\FRS\Forms\Domain is where I configured my Forms domain.

All installations (unix/Linux/Windows) will have similar setups but differing directory/folder names.

Thanks for your help in looking

Is it possible for your do the following and then try?

- Remove the TNS Entry from TNSNAMES.ORA of Forms home
- Add the TNS Entry using Net Manager (being run from Forms Home)

Hi All

Resolved my TNS issue but no I am unable to run forms from within my recently installed/configured Forms Builder application. I am simply choosing Program->Run Form from the toolbar. The form seems to starts to deploy, A message appears in the browser top right - ORACLE FORMS. This then disappears and is replaced by a blank browser screen. What am I missing? Please help.

Oracle Version : 12.2.0.1.0
FMW/FRS : 12.2.1.2.0

DB Oracle Home : C:\Oracle12c\DB\Oracle_Home
FMW Oracle Home : C:\Oracle12c\Middleware\Oracle_Home
FRS Domain : C:\Oracle12c\Middleware\FRS\Forms\Domain
Forms Home : C:\Oracle12c\DB\Oracle_Home\forms
fmwconfig/TNS_ADMIN : C:\Oracle12c\Middleware\FRS\Forms\Domain\config\fmwconfig
WLS_SERVER config : C:\Oracle12c\Middleware\FRS\Forms\Domain\config\fmwconfig\servers\WLS_FORMS\applications\formsapp_12.2.1\config

I am starting the various node manager and weblogic servers in the following order:

C:\Oracle12c\Middleware\FRS\Forms\Domain\bin\startNodeManager.cmd - Node Manager
C:\Oracle12c\Middleware\FRS\Forms\Domain\bin\startWeblogic.cmd - AdminServer Server
C:\Oracle12c\Middleware\FRS\Forms\Domain\bin\startManagedWeblogic WLS_FORMS - WLS_FORMS Server

I have set the web browser to chrome and also tried firefox but with same results, and set the run time Application Server URL to http://LAPTOP-9R3NTMTP:9001/forms/frmservlet I have tried both test.fmx and mysimpleform.fmx in both the Application Server URL ( http://LAPTOP-9R3NTMTP:9001/forms/frmservlet?form=test.fmx/mysimpleform.fmx ) and by setting the form parameter in the formsweb.cfg config file (form=test.fmx/mysimpleform.fmx), and added my FMX directory to the FORMS_PATH environment variable in default.env.

What am I missing guys? Any help would be greatly appreciated. I've been trying to look for log files to see if I can see exactly what is being sent to OHS, but am not able to find any (must not be looking in the right places).

Yes it was a browser issue.

I have resolved it using IE11 with the Java Plugin, as later browsers don't support it. I'll have to get used to using Java Web Start to enable use with all browsers.

Thanks for looking into this and giving great advice.

C:\temp\log_sales>tnsping db122 . This tnsping command helped me to resolve my issue.

Thanks too much You saved me , After working of days I could find your trick.
I copied tnsnames.ORA from DB to Forms home
Thanks too much.

Hi, I am not able to connect from Oracle Form to oracle Database. Both forms and database are on my machine. I have copied all 3 ora files from db to oracle form.
Form version - Oracleform 12c
DB - Oracle Database 18c Express Edition Release 18.0.0.0.0.

Getting error - ORA-12154: TNS: Could not resolve the connect identifier specified.

Would be great if someone can give advise?