DFC Session error

Hi All,

We are getting the below error in our load test env when we are trying to open around 100 session through DFC service and Webtop -

[DM_SESSION_E_CANT_MAKE_TEMP_CONNECTION]error: "Could not establish an internal, temporary database connection (database_name = , docbase_owner = xxxx, connection_string = yyyyy); database system error was: Error while trying to retrieve text for error ORA-12537

We have checked with DBA that 250 max session are set in database side and concurrent_sessions = 100 is set in server.ini file. Session pooling is also enabled.

We have observed that, 2 session are getting created for each DFC call in database side. It is holding session for sometime.

Can you please let me know why 2 session are getting created and how we can avoid the error?

CS : 6.5 SP3 P11

Database : Oracle 11.2.0.1

Kind regards,

Sumanta Pakira

Find more posts tagged with

Comments

eikrid

you could look at the sever.ini file

concurrent_sessions

aflowers001

You get 2 connections to the database as Documentum creates a read only connection and a read/write connection for each DFC session.

I would also suggest a search for ORA-12537 , try http://www.dba-oracle.com/t_ora_12537_tns_error.htm. What do you have in the server logs?

DCTM_Guru

Not sure if connections are independent of sessions, but I have seen that Webtop establishes multiple user sessions for a single user after you log in. I dont why Webtop does this, but as eikrid suggested, you can always bump up the concurrent_sessions in server.ini to meet the "num of concurrent users" you want to support.