When I am trying to open Form Builder and connecting to database, its error out.Which exact error do you get ?
will the username and password for connecting to Database in Form builder are as same which I used in Oracle 10g Express edition?To test the connection, yes, but you should never use SYS or SYSTEM users to work with your forms, you should create your own.
Do I need to modify tnsnames.ora and listeners.ora files ??You have to configure a TNS entry within tnsnames.ora in Forms HOME to point to your database.
What is the host name in addition to username, password which I mentioned in question 1??The one you configured above.
2) where should I create users to use in Forms??Within the database.
If I create in Oracle 10g Express edition, will they work properly in Oracle 10g forms builder ?Yes.
3) how should I configure??You can use Net Configuration Assistant from Forms menu. Or you can add lines like the following to tnsnames.ora (Forms HOME) :
XE = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = <machine name>)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE) ) )
4) tell me clearly about the configuration mainly about tnsname and listener.The listener is a "server" process, so it's not relevant from Forms point of view. It is from database point of view, but you shouldn't need to do anything about it.