My Oracle Support Banner

SOA Upgrade Assistant Readiness Check Fails For OWSM Component (Doc ID 2854651.1)

Last updated on JUNE 03, 2024

Applies to:

Oracle Web Services Manager - Version and later
Information in this document applies to any platform.


When running the ua -readiness in preparation for a SOA upgrade to, all JDBC connections succeed but the OWSM (upgrade.WSM.WSMPLUGIN) failed with the following error:

oracle.mds.exception.MDSRuntimeException: MDS-00003: error connecting to the database
java.sql.SQLRecoverableException: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor

When viewing the database listener.log, it is observed that the request is being sent with an incomplete SERVICE_NAME. The host is being omitted and only the domain is being used:

The connect descriptor in the mds-owsm data source is correct and the correct connection is made by OWSM in the environment.

A 19c database with CDB/PDB is being used for the MDS data that OWSM uses. There is a grid listener servicing this database.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.