I'm getting a message of "TNS:listener does not currently know of SID given in connect descriptor" -- The Oracle DB Monitor Configuration screen does not provide a place to include the SID. How do I provide a SID?
In fact, you should be able to use your SID name in the "database" field.
Now you can also switch to advanced mode and use that URL:
jdbc:oracle:thin:@<host>:<port>:<SID>
Moreover if you have a service name instead of a SID that is very common with latest Oracle versions, you can use that URL instead:
jdbc:oracle:thin:@//<host>:<port>/<service_name>
I hope it will help you.
