Last updated on JULY 06, 2017
Applies to:Oracle Utilities Network Management System - Version 220.127.116.11 to 18.104.22.168.0 [Release 1.12 to 2.3]
Oracle Network Management for Utilities - DMS - Version 22.214.171.124 to 126.96.36.199.0 [Release 1.12 to 2.3]
Information in this document applies to any platform.
The NMS system appears to be hanging.
A 'cmd snapshot' was taken.
The ISIS dump for a specific service shows that it is waiting for a response from a DBService.
The ISIS dump for the corresponding DBService shows that it is waiting for a query task to finish.
However, all entries in 'SQL Command History' show that they have completed.
The issue can be reproduced at will with the following steps:
1. Run these commands in a terminal
Returns "250" ( the "select count(1) from dual" queries will completely fill up DBService's command history -- which stores only the most recent 250 commands. )
The Sql Command History will be filled with
sql command: 'select count(1) from dual' returned: 1 after 1 ms
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms