Connecting Oracle forms developer to a database
How do I connect the Oracle forms developer to my own database? Should I have a network folder that contains the tnsnames.ora and listener.ora files in my database folder?
Your Oracle Forms installation should have a network/admin directory. In that directory, you will need to configure a sqlnet.ora and tnsnames.ora configuration file. The tnsnames.ora file needs to have a TNS alias which points to your database's listener. For instance, your tnsnames.ora file could have an entry that looks similar to the
When connecting using Forms, you can use the "userid/password@tns_entry" construct. If your TNS alias looks like the above, the TNS entry you will use is "ORCL."
This was first published in August 2005