Skip to Content
0
Former Member
Mar 02, 2010 at 08:32 AM

"No connect to database, session terminated" popup on the GUI window

17 Views

Dear experts

Now our prd system always got this error while running.... when the workload is heavy, this error occured more frequently.

I have check the oracle's session status meanwhile, but it's seams fine....since we have 480 sessions defined in oracle spfile and it keeps occupied 175~180.

I have check the dev_w* log and lots of ORA-12154: TNS:could not resolve the connect identifier specified there.. I think this should be the resean for the GUI disconnected auto or forced by serverside..

I was wondering why this happened? is there any parameter/ settings/ configurations should be done? For I am not expert on this. Hope any of you can give me some advise.

I have change the message server connection clients from 300 to 600(ms/max_clients) but seems not working.

Our CI+DB is running on UX with oracle 10g (0.2.0.4) and DIs are running on NT server. The oracle client version is also 10.2.0.4.0.

Any suggestions or advise will be appreciated

Regards

Ethern