Re: ORA-03135: connection lost contact (368 Views)
Reply
Frequent Advisor
irfan77706
Posts: 41
Registered: ‎04-03-2013
Message 1 of 9 (379 Views)
Accepted Solution

ORA-03135: connection lost contact

Hi Experts,

 

we had an issue connecting to HPSM last night .Got resolved after a restart.

However could you please provide some inputs as to what might be the reason for this error .

PFA log file . 

Please use plain text.
Frequent Advisor
ArpitAggarwal07
Posts: 72
Registered: ‎09-10-2013
Message 2 of 9 (374 Views)

Re: ORA-03135: connection lost contact

Hi

 

It seems an issue with Oracle db connectivity .. HPSM was trying to connect to DB but was not able to .

 

Also check for the network connectivity issue between the db and application servers .

 

Regards

AA

Please use plain text.
Frequent Advisor
irfan77706
Posts: 41
Registered: ‎04-03-2013
Message 3 of 9 (368 Views)

Re: ORA-03135: connection lost contact

Hi Arpit,

 

Thank you for replying,

 

The DB Team says the following

"there were high number of connections came from application and because of which all memory is allocated to the existing users and new connections were not allowed. After you stopped the application, all sessions are gone and memory is released and DB came to normal state."

What do you make of it.Was it an issue from the application side.

 

 

Please use plain text.
Frequent Advisor
ArpitAggarwal07
Posts: 72
Registered: ‎09-10-2013
Message 4 of 9 (351 Views)

Re: ORA-03135: connection lost contact

Hi

 

Do you have some CIt services whihc is scheduled to run during the time the issue happened ..

 

From the log files .. it just shows users are trying to login but no response from DB .. can u check for other snippets of the log files ..

 

Regards

AA

Please use plain text.
Honored Contributor
Piku
Posts: 3,248
Registered: ‎06-17-2010
Message 5 of 9 (335 Views)

Re: ORA-03135: connection lost contact

Hi ,

If memory is completely exhausted then you should ask Db to increase you SGA and PGA target size.

However only user session will not consume whole memory till memory s as low as in few Mbs.


hth,
Please use plain text.
Frequent Advisor
irfan77706
Posts: 41
Registered: ‎04-03-2013
Message 6 of 9 (326 Views)

Re: ORA-03135: connection lost contact

Thanks Piku/Arpit,

 

we checked the alert from DB side this was just before our application was not connecting "

 

smprolb2.corp.du.ae Oracle Ora_Conf alert_hpsmpr.log ORA-04031:
unable to allocate 256 bytes of shared memory ("shared pool","SELECT * FROM SYSPUBLISHM1 W...","Heap0: KGL","kglob") 
Major  --X---- 23:28:31 12/22/13 smprolb2.corp.du.ae Oracle Ora_Conf alert_hpsmpr.log ORA-04031:
unable to allocate 56 bytes of shared memory ("shared pool","unknown object","CCursor","kkocsBeElem: kkoMergeBindEqvCtx") 
Critical  ---S-X- 23:48:06 12/22/13 smprolb1.corp.du.ae HPSM HPSM   report2 process is NOT Running on server smprolb1 "
 
As per this shall i go ahead and advice them to increase the SGA and PGA size ?
 
 
Please use plain text.
Honored Contributor
Piku
Posts: 3,248
Registered: ‎06-17-2010
Message 7 of 9 (320 Views)

Re: ORA-03135: connection lost contact

[ Edited ]

Hi,

It is cleared form above that it is memory related issue.
Your DBA must be awared of SGA and PGA , increase of these is normal practice in such errors.
Also more parameters like pool_size etc might required configuration.
If using 10g the SGA ,in case of oracle DB 11g you have to use SGA target size.

You DBA will tackle this issue easily and might requires downtime.

hth

Please use plain text.
Frequent Advisor
irfan77706
Posts: 41
Registered: ‎04-03-2013
Message 8 of 9 (314 Views)

Re: ORA-03135: connection lost contact

Hi Piku,

 

Just one more question ;how did the issue got resolved after restarting our HPSM application.

As there was nothing done from DB side.

 

Thanks in advance.

 

Please use plain text.
Honored Contributor
Piku
Posts: 3,248
Registered: ‎06-17-2010
Message 9 of 9 (307 Views)

Re: ORA-03135: connection lost contact

Hi Irfan,

During stop all the DB sessions will be released and automatically all the occupied memory will be regained.
When you again start the SM, connection starts piling up and memory usage increases lead to exhaust of all memory.


hth,
Please use plain text.
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation