Autonomous Transaction Processing

Get Involved. Join the Conversation.

Comments

  • enrique ortiz

    ok

    there is a way in order to not expire the user password in ATP ?

  • Simon Law

    The error indicates this is related to the connection pool, please open a support ticket, so they can investigate this further.

    -Simon 

  • Simon Law

    Similar to a regular oracle database, there are many ways to access the ATP database.
    You can use SQL*Plus, SQL Developer (Desktop and Web), APEX, any JDBC/ODBC/OCI client applications such as Java, node.js, .NET etc.
    Check out this chapter "Connecting to Autonomous Transaction Processing" and the Getting Started labs for more details.

    -Simon

  • Connor McDonald

    Thanks, saw it. Maybe I'm just to used to APEX which has filter and titling/breadcrumbs at the top of the region rather than off to the side.

  • Robert Greene
    • posted via email reply July 3, 2019
    • Permalink
    It does display both. There is a filter below the compartment selector. 
    
  • Connor McDonald

    It just feel counter-intuitive to me.  If it said something like:

    Autonomous Databases, Workload = ADW | ATP then its more concrete, because otherwise someone looks at just the title and goes "OMG!!! Where is my warehouse??!?!" (when they're looking at ATP and vice-versa).

    And utopia would be the ability to display them all (ATP + ADW)

     

  • Robert Greene
    • posted via email reply July 3, 2019
    • Permalink
    Thanks for the feedback.   The title currently reflects the fact that 
    both the workload types run on the same autonomous database technology 
    and importantly the fact that they are represented by a single API end 
    point.   In your opinion would it be better to separate the API end 
    points as well?
    
    -Robert
    
  • Simon Law

    Since this is not a newly provisioned instance, one thing you could try is to clear the browser cache and restart the instance. This worked for me previously.

    If that doesn't help, please reach out to support.

    -Simon  

  • Maria Colgan

    If this is an ongoing problem, please file an SR.

     

    Thanks,

    Maria

  • Robert Greene

    1)  Physics at play here, latency will be a function of distance, e.g. it's ~112ms from east to west coast of US.   There are no currently read replicas to localize copies.

    2) I think you are asking this in the context of multiple read replicas, so answer is N/A

    3) & 4) there should be a different forum for these questions related to Application Container Cloud,  I don't know the answers and you may not get much help in this area here in this database forum. 

  • Aleksandr Kupriyanov

    Maria, The ATP instance was created on June 24, two days ago APEX was available.
    Every time I try to connect to the apex, but without success.

  • Maria Colgan

    Aleksandr,

    How soon after you provisioned the ATP-S instance did you click on Apex button?

    Unfortunately due to a bug it make take 15 - 20 minutes for Apex to become Available for a newly provisioned database.

    Can you try again?

    Thanks,

    Maria

  • Charles Hausmann

    OK...will drop and create it now and see if those services come back to life. Hopefully we're operational in 30 mins of less now!

    I will also open an SR...

    Thanks!

  • Robert Greene
    • posted via email reply July 2, 2019
    • Permalink
    Yes, to get moving, create a new instance.  However, please do file an SR with your tenancy, OCID and instance name so Operations can take a look as we do want to know the root cause. 
    
    Thanks,
    -Robert 
    
  • Charles Hausmann

    Hi, I created a new ATP instance yesterday afternoon and this morning both the APEX and SQL DEV WEB are still throwing a 503 error? What is the fix for this? Should I drop and re-create the instance? I have developers standing by that need access today.

     

    Thanks!

    -Charles