I have installed Form/Reports 11gr2 with Weblogic 10.3.6 64-bit & database 11gr2.
All installations and configures are successful.
But when I give URL address (servername:portno/forms/frmservlet?form=main) to open a form, it gives me following error;
ora-12514: TNS:listener does not currently know of service requested in connect descriptor.
I searched on google, but didn't clear my error. I also checked Oracle services, all are started.
So please guide me !
I never changed settings in tnsnames.ora, it is always as per default settings. If required now then let me know.
Please note that when I connect my form builder with databases, it is connected. But when I run my form it again show same error and open a dialog box for
username,password & databases connection string.
I copied this file into "E:\Oracle\Middleware\asinst_1\config" of form.
Below is my tnsnames.ora file;
# tnsnames.ora Network Configuration File: E:\app\admin\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(SID = CLRExtProc)
(PRESENTATION = RO)
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
Check that 'orcl' is the connection string you are using
In the $home/oracle/.batch_profile
Check for the TNS_ADMIN Configuration...
Check your database connections using tnsping so that you have correct tns configuration and a listener at the specified ip address.
The Below threads will be helpful for you,