Oracle form builder 10g

Question

While create a form in oracle form builder, In data block wizard am getting an error when giving my user,password,database and click "Ok".

Error is : ORQ-12154:TNS: could not resolve the connect identifier specified.

How to solve this error. plz anyone can help me??

Answer 1

you should configure TNSNAMES.ora file -it is in form builder folder;

Add the following entry in your TNSNAMES.ORA file and change the values shown in brackets to suit your environment:

<addressname> =
 (DESCRIPTION =
   (ADDRESS_LIST =
     (ADDRESS = (PROTOCOL = TCP)(Host = <hostname>)(Port = <port>))
   )
 (CONNECT_DATA =
   (SERVICE_NAME = <service_name>)
 )
)

Here is a completed example:

ORA11 =
 (DESCRIPTION = 
   (ADDRESS_LIST =
     (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.0)(PORT = 1521))
   )
 (CONNECT_DATA =
   (SERVICE_NAME = ORA12)
 )
)

READ THIS ARTICLE http://www.orafaq.com/wiki/Tnsnames.ora