Getting ORA-12154: TNS error when running a form [message #605309] |
Wed, 08 January 2014 10:40 |
|
rock_oradev
Messages: 8 Registered: November 2013 Location: Boston
|
Junior Member |
|
|
Hi,
I have installed Oracle Forms 11g on Windows Server 2008 R2. Also, Oracle client 11g was installed on the same server.
There is connectivity between the forms and database.
Forms are getting compiled, but when I run the form I am getting the following error:
ORA-12154: TNS:could not resolve the connect identifier specified.
tnsnames.ora is in Oracle forms home/config
TNS_ADMIN entry and path is there under system environment variables
Can anyone please help me fixing this?
Thanks,
Rakesh
|
|
|
|
|
Re: Getting ORA-12154: TNS error when running a form [message #605367 is a reply to message #605309] |
Wed, 08 January 2014 22:29 |
|
rock_oradev
Messages: 8 Registered: November 2013 Location: Boston
|
Junior Member |
|
|
Thanks mughals_king & Littlefoot for replying. But my case is different.
I have the connectivity to the database from forms. I am able to compile the forms. But, when I run the form I am getting this error: ORA-12154: TNS:could not resolve the connect identifier specified.
I have placed the tnsnames.ora file in both the locations:
1) C:\oracle\fmw11g\asinst_1\config
2) C:\oracle\fmw11g\asinst_1\network\admin
Added TNS_ADMIN entry in the environment system variables.
Do I need to modify any other config files to get this fixed?
Thanks in advance!
[Updated on: Thu, 09 January 2014 08:32] by Moderator Report message to a moderator
|
|
|
|
|
|
|
|
|