Avoiding ORA-01000 maximum open cursors exceeded errors

Troubleshooting

Problem

The following error, "ORA-01000 maximum open cursors exceeded" can appear in the Tivoli Netcool Performance Manager for Wireless logs when the Oracle parameter OPEN_CURSORS is set too low.

Resolving The Problem

1. Check the current value for the OPEN_CURSORS parameter, as follows:

sqlplus system/<system password>@vtdb

SQL> show parameters OPEN_CURSORS

2. If the current value is set to lower than 4096, increase the setting to 4096

ALTER SYSTEM SET open_cursors = 4096 SCOPE=BOTH;

Using the above syntax of SCOPE=BOTH indicates that the change is made in memory and in the server parameter file. The new setting takes effect immediately and persists after the database is shut down and started up again.

[{"Product":{"code":"SSKGHX","label":"Tivoli Netcool Performance Manager for Wireless"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"--","Platform":[{"code":"PF027","label":"Solaris"},{"code":"PF016","label":"Linux"}],"Version":"9.2","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]

Product Synonym

TNPMW

Was this topic helpful?

Document Information

More support for:
Tivoli Netcool Performance Manager for Wireless

Software version:
9.2

Operating system(s):
Solaris, Linux

Document number:
403175

Modified date:
17 June 2018

UID

swg21425394

IBM Support

Tips