DX UIM database connection error to Oracle DB 19c during installation
Article ID: 231496
Updated On:
Products
Issue/Introduction
Installing UIM 20.4 version. The database used is Oracle DB 19c. The database is installed successfully, and the database is configured according to the requirements of the installation documentation.
During the installation process, when the database connection test was performed on the database connection interface, the installation program reported the following error: for oracle 12 the service name entry must be a valid pluggable database name
Environment
Release : 20.4
Component :Install
Resolution
Installation logs show error as below
2021-12-28 21:09:53,618 INFO provider.NimDBProviderBase:initDriver:83 [AWT-EventQueue-0] - post: successfully initialized driver: oracle.jdbc.driver.OracleDriver
2021-12-28 21:09:53,621 ERROR individual.OracleDBProvider:createConnection:153 [AWT-EventQueue-0] - Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
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
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:743)
at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:666)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:566)
Verify the service name is configured correctly
"Specify the name of the PDB to be created. The first character of a PDB name must be alphanumeric and the remaining characters can be alphanumeric
or the underscore character (_).
The PDB name must be unique in the CDB, and it must be unique within the scope of all the CDBs whose instances are reached through a specific listener."
Additional Information
Feedback
