[
https://issues.apache.org/jira/browse/RANGER-4190?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17712665#comment-17712665
]
Ramachandran commented on RANGER-4190:
--------------------------------------
[[email protected]] The review is available here
:https://reviews.apache.org/r/74398/
> Apache Ranger does not recover from a recoverable SQL exception
> ---------------------------------------------------------------
>
> Key: RANGER-4190
> URL: https://issues.apache.org/jira/browse/RANGER-4190
> Project: Ranger
> Issue Type: Improvement
> Components: Ranger
> Reporter: Ramachandran
> Assignee: Ramachandran
> Priority: Major
> Fix For: 3.0.0
>
>
> It seems the Ranger instance is not able to connect Oracle ATP. This issue
> could be the loss of network connectivity to the load balancer which will
> connect to oracle ATP.
> java.sql.SQLRecoverableException: I/O Exception: Connection reset
> Internal Exception: java.sql.SQLRecoverableException: No more data to read
> from socket
> Error Code: 17410
> This issue could happen due to the loss of connectivity to the oracle ATP
> network load balancer.
> ADB network properties -
> [https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/connect-prepare-jdbc-thin.html#GUID-0A619DFE-5F5F-4302-BF43-B08AEDA05A6C]
>
> [https://docs.oracle.com/en/database/oracle/oracle-database/12.2/rilin/load-balancing-of-connections-to-oracle-rac-databases.html#GUID-06B4373D-1217-44E4-BD86-DE353DA657F6]
> part of the Ranger start we need to add the below JVM parameters to disable
> the network cache by lowering its TTL to
> 0;-Djava.security.egd=[file:///dev/urandom] -Dnetworkaddress.cache.ttl=0
> -Dnetworkaddress.cache.negative.ttl=0
>
> By default, the [OpenJDK 8
> InetAddress|http://hg.openjdk.java.net/jdk8/jdk8/jdk/file/687fd7c7986d/src/share/classes/java/net/InetAddress.java#l189]
> will cache failed DNS queries, referred to as "negative caching", for 10
> seconds. It's recommended to disable both the positive and negative cache by
> setting them to 0 seconds, and rely on the DNS caching implemented inside
> OCI's DNS systems.
> {panel}
> {panel}
> |{{{}java.security.Security.setProperty({}}}{{{}"networkaddress.cache.ttl"{}}}{{{},
> {}}}{{{}0{}}}{{{});{}}}
> {{{}java.security.Security.setProperty({}}}{{{}"networkaddress.cache.negative.ttl"{}}}{{{},
> {}}}{{{}0{}}}{{{});{}}}
> {{// (Optional) Force Java to use a specific DNS provider}}
> {{// By default it will use whatever lookup is defined in the system =>
> files,nis,dns}}
> {{// as in /etc/nsswitch.conf on linux}}
> {{{}System.setProperty({}}}{{{}"sun.net.spi.nameservice.provider.1"{}}}{{{},
> {}}}{{{}"dns,sun"{}}}{{{});{}}}|
> Or as an argument when invoking Java:
> {panel}
> {panel}
> |{{{}java -Dnetworkaddress.cache.ttl={}}}{{{}0{}}}
> {{{}-Dnetworkaddress.cache.negative.ttl={}}}{{{}0{}}} {{app.jar}}|
>
>
>
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
