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

    Login

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

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top