com.oracle.ojdbc:ojdbc8:19.3.0.0 이상 버전으로 spring boot 기동시 configure ONS in FanManager failed 오류 발생시 조치사항
 
[2022-12-22 11:05:29.987|ERROR|main|..|oracle.simplefan.FanManager:FanManager.java:configure:107] attempt to configure ONS in FanManager failed with oracle.ons.NoServersAvailable: Subscription time out

해결방안

  1. spring boot 기동시 vm option 추가
    -Doracle.jdbc.fanEnabled=false
  2. pom.xml 에서 simplefan,ons 종속성 제거
    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    <dependency>
      <groupId>com.oracle.database.jdbc</groupId>
      <artifactId>ojdbc8</artifactId>
      <version>19.3.0.0</version>
      <exclusions>
        <exclusion>
          <groupId>com.oracle.ojdbc</groupId>
          <artifactId>simplefan</artifactId>
        </exclusion>
        <exclusion>
          <groupId>com.oracle.ojdbc</groupId>
          <artifactId>ons</artifactId>
        </exclusion>
      </exclusions>
    </dependency>
    cs