Ask the Expert

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?

    Requires Free Membership to View

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

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

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: