Uploaded image for project: 'Red Hat 3scale API Management'
  1. Red Hat 3scale API Management
  2. THREESCALE-3110

[Test Environment, locally only] Oracle is not working for the test DB

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Not a Bug
    • Icon: Minor Minor
    • None
    • None
    • System
    • None
    • Not Started
    • Not Started
    • Not Started
    • Not Started
    • Not Started
    • Not Started

      When running the seeds or or any test (in `test` environment locally), I see this error:

      This is the reason:

      So this configuration provokes it:
      https://github.com/3scale/porta/blob/c567ceab6a86dd06f1dbdb34d006107e628c2010/config/examples/database.yml#L18

      That 'test' at the end doesn't work. By removing that 'test' at the end, it works well but then we are using the same DB for development than for test and that is a problem.
      So we need to make the 'test' work (and I guess it happens the same for the 'production' one locally), and it is supposed to be done in here:
      https://github.com/3scale/porta/blob/c567ceab6a86dd06f1dbdb34d006107e628c2010/script/oracle/002_setup.sh#L42
      https://github.com/3scale/porta/blob/c567ceab6a86dd06f1dbdb34d006107e628c2010/script/oracle/002_setup.sh#L46
      So that's is where the real bug is and where we need to fix it

        1. image-2019-07-26-19-16-42-516.png
          image-2019-07-26-19-16-42-516.png
          274 kB
        2. image-2019-07-26-19-17-52-541.png
          image-2019-07-26-19-17-52-541.png
          83 kB
        3. docker system prune.png
          docker system prune.png
          36 kB
        4. docker images with oracle.png
          docker images with oracle.png
          94 kB
        5. remove oracle image.png
          remove oracle image.png
          120 kB
        6. docker images without oracle.png
          docker images without oracle.png
          82 kB
        7. docker pull oracle image.png
          docker pull oracle image.png
          253 kB
        8. oracle container is ready to use.png
          oracle container is ready to use.png
          167 kB
        9. tns listener error after reset DB.png
          tns listener error after reset DB.png
          284 kB

              Unassigned Unassigned
              mnoyabon Marta Noya (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated:
                Resolved: