Do you use a Oracle password file?
Check the value or remote_login_passwordfile (Oracle parameter). Should be set to EXCLUSIVE/SHARED
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,
did you upgrade the sensor on the DB to the latest ?
thank you everyone
The solution was : "Setup of alternate connection and restart sensor"