Q

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?

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 following:

ORCL =
  (DESCRIPTION = 
      (ADDRESS_LIST = 
         (ADDRESS=(PROTOCOL=TCP)(HOST=myhost.acme.com)(PORT=1521))
      )
      (CONNECT_DATA = 
         (SERVICE_NAME=orcl)
      )
   )

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

Dig deeper on Oracle database backup and recovery

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close