oracle - Periodic tns-12531: TNS: Cannot allocate memory -


i have problem that's been plaguing me year now. have oracle 12.1.x.x installed on machine. after day or 2 listener stops responding , listener.log contains bunch of tns-12531 messages. if reboot, problem goes away , i'm fine day or two. i'm lazy , hate rebooting, decided track down, i'm having no luck. since alternative work don't want do, i'm going spend time researching this.

some notes:

  • windows 10 pro
  • 64-bit
  • 32 gb ram
  • generally, 20gb free when error occurs
  • i have several databases , doesn't matter db running
  • restarting db doesn't help
  • restarting listener doesn't help
  • only rebooting clears problem
  • when set trace_level_listener = 16, don't more info. trace files not written to
  • i can connect db if bypass listener (ie, set oracle_sid=xxx , connect without db identifier)
  • all other network interactions seem work fine after listener stops
  • lsnrctl status hangs , adds tns-12531 listener.log
  • i have same config @ home , not happen

below example of listener.log file:

fri jul 28 14:21:47 2017 system parameter file d:\app\user\product\12.1.0\dbhome_1\network\admin\listener.ora log messages written d:\app\user\diag\tnslsnr\lj-quad\listener\alert\log.xml trace information written d:\app\user\diag\tnslsnr\lj-quad\listener\trace\ora_24288_14976.trc trace level 16  started pid=24288 listening on: (description=(address=(protocol=tcp)(host=lj-quad)(port=1521))) listening on: (description=(address=(protocol=ipc)(pipename=\\.\pipe\extproc1521ipc))) listener completed notification crs on start  timestamp * connect data [* protocol info] * event [* sid] * return code 28-jul-2017 14:22:06 * 12531 tns-12531: tns:cannot allocate memory 28-jul-2017 14:22:47 * 12531 tns-12531: tns:cannot allocate memory 28-jul-2017 14:26:24 * 12531 tns-12531: tns:cannot allocate memory

thanks bunch can provide!


Comments

Post a Comment

Popular posts from this blog

javascript - Create a stacked percentage column -

i have collection of data : var data = [ {"p301a":"10","p301b":"7","p301c":"7","p301d":"3","p301e":"8","p301f":"8","p301g":"8","p301h":"8","p301i":"8","p301j":"8","p301k":"8","p301l":"8","p301m":"8","p301n":"8","p301o":"8","age":"31-40 years","profesion":"2","position":"2"}, {"p301a":"5","p301b":"4","p301c":"4","p301d":"4","p301e":"4","p301f":"4","p301g":"4","p301h":"4","p301i":"4","p301j":"4","p301k":"4...
Read more

Optimising Firebase database by automatically overwriting data -

in firebase app have following structure: posts latest all users can write posts > latest . want limit entries 20 posts save space in database. , posts beyond 20 unnecessary never shown on homepage. how can limit posts 20, when user writes posts > latest posts @ end drop off (be deleted) automatically? this sample should you. you need : const max_log_count = 20; exports.removeold = functions.database.ref('/posts/latest/{postid}').oncreate(event => { const parentref = event.data.ref.parent; return parentref.once('value').then(snapshot => { if (snapshot.numchildren() >= max_log_count) { let childcount = 0; const updates = {}; snapshot.foreach(function(child) { if (++childcount <= snapshot.numchildren() - max_log_count) { updates[child.key] = null; } }); // update parent. removes children. ...
Read more

javascript - Angular UI-Grid customTemplate directive causing rows to load slowly/? -

Image
each grid cell can have more 1 customtemplate loaded. have directive holds watcher on model_col_field listen cell updates on scroll when dom rows updated , recompile celltemplate . without watcher , $compile rows repeat on scroll, showing same set of rows. is there more angular way of approaching or way improve performance? relevant controller code: create gridoptions.data & gridoptions.columndefs : var customtemp = '<div ng-repeat="opt in grid.appscope.colvalueoptionsmodel" ng-init="tempstring=model_col_field.clazz+opt.key;"><comparison-directive dbo="model_col_field" attobj="opt" fff="grid.appscope.getattributetemplate(tempstring)" /></div>'; $scope.gridoptions.columndefs = [ { name:'yindex',pinnedleft:true,celltemplate: customtemp, displayname:'index'}, { name:'col1',celltemplate: customtemp}, { name:'col2',celltemplate: c...
Read more