Database

Get Involved. Join the Conversation.

Topic

    Nazeer Anantha
    APEX in Bare Metal, VM, and ExadataAnswered
    Topic posted August 7, 2019 by Nazeer AnanthaBlue Ribbon: 750+ Points, tagged Apex, DBaaS, DBaaS Monitor, DBCS, Exadata, Express, Notification, Provisioning, REST API, SQL Dev Web, Tip 
    95 Views, 5 Comments
    Title:
    APEX in Bare Metal, VM, and Exadata
    Summary:
    Need APEX Navigation in Bare Metal, VM, and Exadata
    Content:

    Hi All,

    I am just trying to find APEX console in Bare Metal, VM, and Exadata Database. i am not able to find it on on UI. is it available or not. if it's available when i can find it.

    Note: After finding the APEX console i have to expose Database tables as REST API.

    can you please guide me.

    Thanks,

    Nazeer.

     

    Best Comment

    Vladislav Uvarov

    As I mentioned above, you have 2 options for installing APEX (and ORDS) in VM or Bare Metal:

    1. Follow the on-premises installation process as described in APEX documentation. Follow the on-premises installation process for ORDS as described in ORDS documentation. Alternatively, see this blog post for the quickest way to manually deploy both APEX and ORDS.
    2. Use Terraform template that will a) install APEX in your database and b) install ORDS in a new Compute instance. You just have to define some Terraform parameters, download software distributions (APEX, ORDS, optionally Tomcat), and the Terraform template will automatically do everything for you.

    After installing APEX and ORDS, you will have their full functionality available to you, including REST-enabled tables.

    Comment

     

    • Vladislav Uvarov

      Nazeer,

      APEX is not automatically installed in Database Cloud Service on Oracle Cloud Infrastructure. Once your database is available, you can install APEX yourself either using the usual installation steps or using a Terraform template. See APEX documentation for further information and links to additional resources (including the Terraform white paper).

      Note that APEX is preinstalled in Autonomous Database. Perhaps this could be an alternative if you don't want to install and manage APEX yourself in Database Cloud Service.

      • Nazeer Anantha

        Thank you Vladislav Uvarov for the quick response.

        I understood that APEX is not available on DBCS.

        How Can I install in APEX in Bare Metal, VM and Exadata. Can you please point me any document?. so that I will try to install APEX.

        After Installing APEX, Can I expose as Table as a REST API? or do I need to do any configurations for ORDS

         

        Thanks,

        Nazeer.

         

         

        • Vladislav Uvarov

          As I mentioned above, you have 2 options for installing APEX (and ORDS) in VM or Bare Metal:

          1. Follow the on-premises installation process as described in APEX documentation. Follow the on-premises installation process for ORDS as described in ORDS documentation. Alternatively, see this blog post for the quickest way to manually deploy both APEX and ORDS.
          2. Use Terraform template that will a) install APEX in your database and b) install ORDS in a new Compute instance. You just have to define some Terraform parameters, download software distributions (APEX, ORDS, optionally Tomcat), and the Terraform template will automatically do everything for you.

          After installing APEX and ORDS, you will have their full functionality available to you, including REST-enabled tables.