Unable to create connection to the database using Oracle 12 pluggable database as remote database on RSA Via Lifecycle & Governance
2 years ago
Originally Published: 2016-04-20
Article Number
000064608
Applies To
RSA Product Set: Identity Management and Governance
RSA Product/Service Type: Software Appliance
RSA Version/Condition: 7.0.0
Platform: Wildfly
Cause
Connection strings are set to use SID by default
Need to manually edit them
Resolution
vim /home/oracle/wildfly/standalone/configuration/aveksa-standalone-full.xml

** Find each jdbc:oracle:thin connection string (there are more than on in that file **
** Replace the last : in the line between the port and service_name with a / **

Example:

From:
jdbc:oracle:thin:@rtpldbdvavk01.na.directenergy.corp:1521:CORAVKQA1.na.directenergy.corp

To:
jdbc:oracle:thin:@rtpldbdvavk01.na.directenergy.corp:1521/CORAVKQA1.na.directenergy.corp

** Save and restart the acm services **

acm stop
acm start