I have an issue with DAM sensor and Oracle
The sensor's status is Connected but the DBMS's Status is disconnected.
The error is this
“Error 9 - DAL_ERROR reported by sensor: servername.com, DBMS: SEPM Error code: 853750737
Sensor message: Unable to connect to the database [SEPM] error :[ ORA-01031: insufficient privileges ]
But I don't know wich privileges!!!!
The DAM version is 4.4.9 Standalone
The Oracle server's Windows 2012 and Oracle version's 188.8.131.52.0
Does anyone knows what the privileges do I need?
Hi, I got the same error message.
Since I found no place for credentials, I figured it uses OS authentication.
In my environment it was enough to set SQLNET.ORA:
SQLNET.AUTHENTICATION_SERVICES = (NTS)
This turns on OS authentication in Windows, you may need to configure other things as well, check here if that's not enough:
For me that was enough. I just restarted listener and Sensor and it switched from DISCONNECTED to FULLY MONITORED.
Also, it may not be possible to turn OS authentication on always. It sometimes introduces other issues in Windows & Oracle environments - but one problem at a time...
Hope this helps,