I had an interesting issue this week. The setup is as follows: WLS with Webcenter. The Datasource point to a database for the metadata. This database sits in the database zone. As we are not allowed to connect directly to the database there is a CMAN in between. After the setup of the CMAN and the database we had a connection using JDBC where the CMAN was our endpoint. So far so good. Now the IT department decided (a long time ago) to move a number of databases from one platform to another. As this meant a change in the IP and name of the database we expected that the only configuration that was needed to change was the CMAN. Database moved, CMAN config adapted and voila: nothing works! First test was to use the console and test the JDBC connection. Error was a ORA-12514 TNS:listener does not currently know of service requested in connect descriptor. This in itself was strange as from the WLS/Webcenter perspective nothing did change. Endpoint was still the CMAN, SID ...
Some of the stuff I do for a living. This mainly concerns working with Oracle Databases and Application Servers. Lately I picked up AWS, Azure and OCI.