Simply copy this information to the end of your tnsnames.ora found where Forms/Reports is installed then restart any running Forms or Builders.
ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = YOURSERVER.COM)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) )
I want to generate forms & reports by accessing data from above mentioned databases.Well, first and foremost - Oracle Forms/Reports is designed to connect only to an Oracle database. If you want to connect to a non-Oracle database you will have to configure Heterogeneous Services in your Oracle Database - if your edition supports this. This enables the Oracle database to connect to non-Oracle databases. Once you have this configured and you are able to read/write to the non-Oracle database from your Oracle database, then and only then, will you be able to use Oracle Forms/Reports to use the non-Oracle databases.