1 Reply Latest reply on Dec 1, 2015 3:47 PM by jeffb1

    Help with ORDS 3 and a second database configuration

    Emilio Ocon

      Hello

       

      I have this issue for several days with ORDS, this is what happen, I already have this installation in the same MS Windows sandbox

       

      Win 7 64bits

      Oracle Glassfish 3.1.2.2

      ORDS 3.0.1.177

      local Oracle DB 11G R2 64bits

      Apex 5.0.2

       

      so far so good, everything runs smoothly but... when I tried to add a new database (in another server based in map-url) to original ORDS configuration, something really bad happen, first the original configuration goes off and give me this:

       

      Sin título.png

      after a little while my Glassfish instance goes offline and start to drop messages in log like this:

       

      [#|2015-11-27T12:17:28.062-0600|WARNING|oracle-glassfish3.1.2|com.sun.grizzly.config.GrizzlyServiceListener|_ThreadID=49;_ThreadName=Thread-2;|GRIZZLY0023: Interrupting idle Thread: http-thread-pool-8080(4).|#]
      ...
      [#|2015-11-27T13:42:40.668-0600|WARNING|oracle-glassfish3.1.2|com.sun.grizzly.config.GrizzlyServiceListener|_ThreadID=26;_ThreadName=Thread-2;|GRIZZLY0023: Interrupting idle Thread: http-thread-pool-8080(2).|#]
      

       

       

       

      besides my CPU usage goes up, and up almost 99%. So I have to shutdown Glassfish return to only my original configuration in ORDS (without a second DB) and everything returns to normal, what I've done so far: check users and passwords in both databases, static content, in Glassfish I read about a patch to solve this problem  (https://java.net/jira/browse/GLASSFISH-18705) but when I applied it, like the post said, Glassfish dies and I have to reinstall it. I also installed a Linux VM with Glassfish but happens exactly the same.

       

      this is what I did to configure my second DB, sorry is in spanish I hope that doesn't care:

       

      Sin título.png

       

      I don't know what else to do? Any advise or recommendation would be appreciate

       

      Best Regards