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