Skip to content

CI failing to connect to OracleDB. TNS Connection fail

Yesterday evening, 19 to 20, the Oracle team upgraded the INTDB19, where castorint is located, (OTG0151149). After that upgrade all CI jobs are failing with error: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

In the past we had some problems with TNS and we removed the tns rpms, they were problematic for CI because this rpm sets a cronjob and if the cronjob does not run in time the CI tests fail... So, now we manually set a connection string.

The machine, port and service names are still the same, the connection should not be failing as the connection URL should be the same. And the updated tnsnames.ora file has the same configuration for that DB:

castorint=(
	DESCRIPTION=
	(ADDRESS= (PROTOCOL=TCP) (HOST=devdbs2-rac16-scan.cern.ch) (PORT=10121) )
	(LOAD_BALANCE=on)
	(ENABLE=BROKEN)
	(CONNECT_DATA=
		(SERVER=DEDICATED)
		(SERVICE_NAME=castorint.cern.ch)
	)
)

Probably there is something incompatible from our side after the upgrade of the DB to RHEL 8.

Edited by Pablo Oliver Cortes