Re: ORA-03135: connection lost contact (928 Views)
Reply
Frequent Advisor
irfan77706
Posts: 47
Registered: ‎04-03-2013
Message 1 of 9 (981 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 . 

Regular Advisor
ArpitAggarwal07
Posts: 104
Registered: ‎09-10-2013
Message 2 of 9 (976 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

Frequent Advisor
irfan77706
Posts: 47
Registered: ‎04-03-2013
Message 3 of 9 (970 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.

 

 

Regular Advisor
ArpitAggarwal07
Posts: 104
Registered: ‎09-10-2013
Message 4 of 9 (953 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

Honored Contributor
Piku
Posts: 4,013
Registered: ‎06-17-2010
Message 5 of 9 (937 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,
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Assign Kudo, if found post useful and mark it accepted if solves the issue.
http://h30499.www3.hp.com/t5/Tips-and-Tricks/Kudos-what-where-how-and-why/m-p/5677925#U5677925
Frequent Advisor
irfan77706
Posts: 47
Registered: ‎04-03-2013
Message 6 of 9 (928 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 ?
 
 
Honored Contributor
Piku
Posts: 4,013
Registered: ‎06-17-2010
Message 7 of 9 (922 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

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Assign Kudo, if found post useful and mark it accepted if solves the issue.
http://h30499.www3.hp.com/t5/Tips-and-Tricks/Kudos-what-where-how-and-why/m-p/5677925#U5677925
Frequent Advisor
irfan77706
Posts: 47
Registered: ‎04-03-2013
Message 8 of 9 (916 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.

 

Honored Contributor
Piku
Posts: 4,013
Registered: ‎06-17-2010
Message 9 of 9 (909 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,
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Assign Kudo, if found post useful and mark it accepted if solves the issue.
http://h30499.www3.hp.com/t5/Tips-and-Tricks/Kudos-what-where-how-and-why/m-p/5677925#U5677925
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.