Dollar Universe - UVMS - installation on oracle 19c

Products

• CA Automic Dollar Universe

Issue/Introduction

Install of UVMS 6.10 on an oracle 19c multitenant (PDB/CDB) throws an error:

ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

        at oracle.net.ns.NSProtocolNIO.negotiateConnection(NSProtocolNIO.java:284)
        at oracle.net.ns.NSProtocol.connect(NSProtocol.java:340)
        at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1600)
        at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:591)
        ... 17 more

Unable to join database !!

Environment

Release : 6.10

Component : DOLLAR UNIVERSE

Cause

Wrong parameter for the service name.

Resolution

Set below parameter to "y" during installation:

Use Oracle Service URL (y/n)                          => y

 

Documentation link:

https://docs.automic.com/documentation/webhelp/english/ALL/components/DU_AS/latest/%20%20Dollar%20Universe%20Guides/help.htm#UVCHelp/uvc_databasesettings.htm?Highlight=%20Use%20Oracle%20Service%20URL

Additional Information

Example of tnsnames.ora setup:

ORACLR_CONNECTION_DATA
 (DESCRIPTION = 
  (ADDRESS_LIST = 
   (ADDRESS = (PROTOCOL - IPC)(KEY - EXTPROC1521))
  )
  (CONNECT_DATA = 
  (SSID = CLRExtProc)
  (PRESENTATION = RO)
  ) 
 )
 
QAORACLE19 = 
 (DESCRIPTION =
  (ADDRESS = (PROTOCOL - IPC)(HOST - uvms_host_name)(PORT =1521))
  (CONNECT_DATA = 
   (SERVER = DEDICATED)
   (SERVICE_NAME = qaoracle19.com)
  )
 )
 
UVMS19PDB = 
 (DESCRIPTION =
  (ADDRESS = (PROTOCOL - IPC)(HOST - uvms_host_name)(PORT =1521))
  (CONNECT_DATA = 
   (SERVER = DEDICATED)
   (SERVICE_NAME = uvms19pdb.com)
  )
 )