Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

TNS-12531: TNS:cannot allocate memory - all five to ten days

robertl2Jul 25 2018 — edited Jul 25 2018

Dear all,

all five to ten days we get the "TNS-12531: TNS:cannot allocate memory" error in the listener.log file.

Every time, the system triggers this error for a while again and again, and than the listener dies after a while, and the lsnrctl utility does not response when try to start it.

Sometimes it helps to restart the listener service, but sometimes we need to restart the server.

There is only one listener which serves only one database, and on the database is near then no user traffic, because it is not in production yet (two test users with a few short sessions a per day, and a daily dump export job),.

The database version is 11.2.0.4 Standard Edition One.

The machine is a virtual server with a 64-bit-OS Windows Server 2016 Standard, 16 GB RAM allocated.

Greatful for help, BR

Robert

Example:

TNS-12531: TNS:cannot allocate memory

Sat Jun 30 07:27:24 2018

30-JUN-2018 07:27:24 * service_update * symassdb01 * 0

Sat Jun 30 07:27:42 2018

30-JUN-2018 07:27:42 * 12531

TNS-12531: TNS:cannot allocate memory

Sat Jun 30 07:27:54 2018

30-JUN-2018 07:27:54 * service_update * symassdb01 * 0

Sat Jun 30 07:28:24 2018

30-JUN-2018 07:28:24 * service_update * symassdb01 * 0

Sat Jun 30 07:28:49 2018

30-JUN-2018 07:28:49 * 12531

TNS-12531: TNS:cannot allocate memory

30-JUN-2018 07:28:54 * service_update * symassdb01 * 0

Sat Jun 30 07:29:24 2018

30-JUN-2018 07:29:24 * service_update * symassdb01 * 0

Sat Jun 30 07:29:48 2018

30-JUN-2018 07:29:48 * 12531

TNS-12531: TNS:cannot allocate memory

Sat Jun 30 07:30:48 2018

30-JUN-2018 07:30:48 * service_update * symassdb01 * 0

30-JUN-2018 07:30:54 * service_update * symassdb01 * 0

Sat Jun 30 07:31:24 2018

30-JUN-2018 07:31:24 * service_update * symassdb01 * 0

Sat Jun 30 07:31:45 2018

30-JUN-2018 07:31:45 * service_update * symassdb01 * 0

Sat Jun 30 07:33:07 2018

30-JUN-2018 07:33:07 * 12531

TNS-12531: TNS:cannot allocate memory

Sat Jun 30 07:35:43 2018

30-JUN-2018 07:35:43 * 12531

TNS-12531: TNS:cannot allocate memory

Sat Jun 30 07:35:58 2018

30-JUN-2018 07:35:58 * 12531

TNS-12531: TNS:cannot allocate memory

Sat Jun 30 07:36:14 2018

30-JUN-2018 07:36:14 * 12531

TNS-12531: TNS:cannot allocate memory

Sat Jun 30 07:36:29 2018

30-JUN-2018 07:36:29 * 12531

TNS-12531: TNS:cannot allocate memory

Sat Jun 30 07:36:46 2018

30-JUN-2018 07:36:46 * 12531

TNS-12531: TNS:cannot allocate memory

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 22 2018
Added on Jul 25 2018
4 comments
1,791 views