This content has been marked as final. Show 3 replies
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.
1) Error which I am getting while connecting Form Builder
TNS: Could not resolve the connect identifier specified.
2) where should I create users to use in Forms?? If I create in Oracle 10g Express edition, will they work properly in Oracle 10g forms builder ?
3) how should I configure?? Can you paste the code which will work?? or can you show me the text file by taking example?
4) tell me clearly about the configuration mainly about tnsname and listener. I am facing most of the difficulties here itself.
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.
You only need to configure tnsnames.ora, as already said.