Please let me know how to connect to db from forms 11g.
I installed forms and reports 11g R2, configured the weblogic server, created a domain, in the network/admin folder of forms domain I did'nt find the tnsnames.ora file. I copied a one from my dev suite 10g version and tried to connect to db from forms 11g but did'nt work. Do you have any solutions
I think a better solution would be to create a TNS_ADMIN environment variable and point to a single instance of the "tnsnames.ora" file. By using the environment variable, all instances of Oracle will see this variable and use it. The other option would be to add the TNS_ADMIN key to your registry, but with this option you have to add the key to each Oracle Home. Consequently, I like the environment variable better! ;)
Hope this helps,
If someone's response is helpful or correct, please mark it accordingly.
I have the same setup as the user stated above and have moved my tnsnames.ora from my 10g Dev environment to asinst\config folder and I still can't connect. The error says that the listener doesn't know of the service in the connect descriptor, however when looking at the status of the lsnrctl, it shows that the service is registered. Is there any other kinds of configuration (ie, file locations) that may be different for forms 11g?