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.