| Cannot make more than 1 Db connect [message #605985] |
Fri, 17 January 2014 02:23  |
chat2raj.s
Messages: 161
Registered: October 2010
Location: Chennai, India
|
Senior Member |
|
|
Dears,
When i am connecting to a particular network schema through my forms application, then i can open only one oracle forms session at a time. If i try to open one another screen, then i get ORA-03114 error. Then, i have to close the already open screen and go for the next screen. The same happens if i am connected to that schema in the Form builder also, i will not be able to open even that 1 screen. I will have to disconnect the form builder from the schema and then open the screen in my application.
This happens only in my system and other system works perfect for the same schema.
Any suggestions to fix this.
Thanks
Raj
|
|
|
|
|
|
| Re: Cannot make more than 1 Db connect [message #605994 is a reply to message #605990] |
Fri, 17 January 2014 04:11  |
chat2raj.s
Messages: 161
Registered: October 2010
Location: Chennai, India
|
Senior Member |
|
|
Thank you..I have gone through them and found reasons and solutions mostly for a permanent disconnect from oracle. My case is like i can get one session always without errors and the second session is only the problem and that too via Oracle forms 6i only (form builder/reports builder/forms run time application alone). I can make any number of connection via, sql tools/toad directly without erros.
I suspect some issues/setup in the Forms folder only can solve this.
|
|
|
|
| Re: Cannot make more than 1 Db connect [message #606001 is a reply to message #605994] |
Fri, 17 January 2014 05:25 |
chat2raj.s
Messages: 161
Registered: October 2010
Location: Chennai, India
|
Senior Member |
|
|
Issues is solved after removing the TNS_ADMIN variable from Environment Variable of the system.
TNS_ADMIN was pointing to the oracle db's TNS alone and not to the Forms26 folder. May be that is the reason for this.
Thank you.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
