This behavior is not observed using non-SSL enabled SQL*Net / OCI listener. This behavior was working with SSL enabled SQL*Net / OCI listener prior to a specific date. The sqlnet.ora on the OBIEE Server ("client" side) includes SSL_CERT_REVOCATION=NONE The issue is observed in multiple environments.
On a specific date and time: Domain Name Server (DNS) resolution for all clients (this includeds the OBIEE server which is a "client" to the database) was switched to use a new DNS router.
The previous DNS router/server binds used authoritative answers (AA).
The new DNS router/server is not authoritative for the xxxxxx.domain.com zone; therefore, the "authoritative answer" flag is not sent in the response.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!