Anyone using clarity application with #dbaas (Oracle Database as service).?
please do let me know we are working on way to achieve this. we are having issues with establishing connection from clarity to DBaaS.
What challenge you are facing, even in Database as Service you would connect via JDBC URL. What is the JDBC URL you are using and what error you are getting
To connect to Oracle 12C pluggable database (PDB), we need to connect using service name. when i tried to update the JDBC URL with no SID it fails to connect and i get an error like [CA Clarity][Oracle JDBC Driver][Oracle]ORA-12505 Connection refused, the specified SID (Null) was not recognized by the Oracle server.
I am not sure if SID is mandatory to establish a connection to database from clarity.
SID is never mandatory, here is an example of PDB of my lab, go ahead and modify the JDBC URL by changing your parameters
Thank you Suman for your solution. it worked.