Posts

Posts

  • Peter Schneider
    Oracle Cloud Free Tier - Autonomous DB - ORDS 503 error,...115.0
    Topic posted September 30, 2019 by Peter SchneiderGreen Ribbon: 100+ Points, tagged Apex, Provisioning, SQL Dev Web, Transaction Processing in Data Management > Autonomous Transaction Processing public
    Title:
    Oracle Cloud Free Tier - Autonomous DB - ORDS 503 error, cannot connect
    Summary:
    ATP - Neither APEX Link, nor SQL Dev Web Link, nor connect using local SQL Dev 19.2 works
    Content:

    Hi all,

    I alrready posted this yesterday in the general Infrastructure forum, but as per Richard Garsthagen's suggestion, I'm reposting this here as well.

    I just wanted to give Oracle Cloud a test drive using the newly announced Always Free tier. But sadly, after provisioning ATP DB instance (serverless), I found that I cannot use it at all.

    In the service console (Development), neither of the APEX link nor the SQL Developer Web links work. Both give the below error message (see image)

    Furthermore, when I try to connect with a locally installed SQL Developer 19.2 using the connect option "Cloud Wallet" and specifying the download wallet.zip, SQL Developer displays the error message (in german): "Status: Nicht erfolgreich - Test nicht erfolgreich: I/O Fehler: Remote host closed connection during handshake".

    Now lastly, when I try to use a locally installed 11.2.0.4 client (I merged sqlnet.ora and tnsnames.ora from wallet.zip with my already present files residing in my TNS_ADMIN directory, I have unzipped wallet.zip, and in sqlnet.ora I have modified: "WALLET_LOCATION = (SOURCE = (METHOD = file) (METHOD_DATA = (DIRECTORY="D:\\Oracle\\tnsadmin\\Wallet_PS1")))"...

    Now when I tnsping my instance, it gives:

    d:\Users\Peter>tnsping ps1_high

    TNS Ping Utility for 64-bit Windows: Version 11.2.0.4.0 - Production on 29-SEP-2019 17:36:50

    Copyright (c) 1997, 2013, Oracle.  All rights reserved.

    Used parameter files:
    D:\Oracle\tnsadmin\sqlnet.ora


    Used TNSNAMES adapter to resolve the alias
    Attempting to contact (description= (address=(protocol=tcps)(port=1522)(host=adb.eu-frankfurt-1.oraclecloud.com))(connect_data=(service_name=slfrbg3r0ej3ocb_ps1_high.atp.oraclecloud.com))(security=(ssl_server_cert_dn= CN=adwc.eucom-central-1.oraclecloud.com,OU=Oracle BMCS FRANKFURT,O=Oracle Corporation,L=Redwood City,ST=California,C=US)))
    TNS-12560: TNS:protocol adapter error

     

    So, nothing seems to work at all, and I'm completey lost. Stopping and restarting did not help.

    Can anyone help, please?

    Thanks and regards,

    Peter

    Image:
  • Gleb Otochkin
    Apex and SQL Developer Web on ATP 19c preview6
    Topic posted October 15, 2019 by Gleb OtochkinGreen Ribbon: 100+ Points, tagged Apex, SQL Dev Web, Transaction Processing in Data Management > Autonomous Transaction Processing public
    Title:
    Apex and SQL Developer Web on ATP 19c preview
    Summary:
    Getting error trying to start either Apex or SQL developer Web on ATP 19c preview
    Content:

    Here is the error when I try to open Apex 

    503 Service Unavailable

    • The connection pool named: |ocid1.tenancy.oc1.......-orcl|re| is not correctly configured, due to the following error(s): Exception occurred while getting connection: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLException: Listener refused the connection with the following error: ORA-12529, TNS:connect request rejected based on current filtering rules

    And the same when I try to run SQL Dev Web (as expected)

    • The connection pool named: |ocid1.tenancy.oc1.......-orcl|re| is not correctly configured, due to the following error(s): Exception occurred while getting connection: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLException: Listener refused the connection with the following error: ORA-12529, TNS:connect request rejected based on current filtering rules
    Version:
    19
  • andreml
    Autonomous Transaction Processing APEX/ORDS error message6
    Topic posted September 29, 2019 by andremlRed Ribbon: 250+ Points, tagged Apex, Transaction Processing in Data Management > Autonomous Transaction Processing public
    Title:
    Autonomous Transaction Processing APEX/ORDS error message
    Summary:
    Autonomous Transaction Processing APEX/ORDS error message
    Content:

    Hi,

    in: https://adb.eu-frankfurt-1.oraclecloud.com/console/?service

    Autonomous Transaction Processing

    When I click Oracle APEX I'm getting this error.
    What shall I do  in order to be able to access APEX?

    503 Service Unavailable

    • Der Verbindungspool namens |ocid1.tenancy.oc1..aaaaaaaasi7bxuooligdpymmy5hjm2bz5eeew3pal5gfqpq7vqljpbwzqwfq-dbxxxxxxxx|re| ist aufgrund der folgenden Fehler nicht korrekt konfiguriert: No more data to read from socket
    Version:
    https://adb.eu-frankfurt-1.oraclecloud.com/console/?service
  • Subrahmanyam Vempati
    Oracle ATP -DB Password55.0
    Topic posted October 17, 2019 by Subrahmanyam VempatiBronze Trophy: 5,000+ Points, tagged DBCS, Transaction Processing in Data Management > Autonomous Transaction Processing public
    Title:
    Oracle ATP -DB Password
    Summary:
    Oracle ATP -DB Password
    Content:
    Hi Experts, Is it possible to get Password for SYS user. Any default password to access as sysdba? Thanks, Vempati
  • sriram iyer
    Unable to connect to ATP Database44.0
    Topic posted January 11, 2019 by sriram iyerRed Ribbon: 250+ Points, tagged Transaction Processing in Data Management > Autonomous Transaction Processing public
    Title:
    Unable to connect to ATP Database
    Summary:
    Am unable to connect to newly provisioned ATP Database
    Content:

    I have provisioned 2 ATP and one ADW Databases and have downloaded the Wallet files for each of them. However, I am not able to connect to any of the databases using SQL Developer. I am using SQL Developer version 18.3 and I know it supports connections using Cloud wallet. I have connected to ATP databases in the past.

    The attached images show that the DB is up and running and the connection error in SQL Developer.

     

    Image:
    Document:
  • Sam Cumarasamy
    I'm having issues provisioning an instance of ATP in my...2
    Topic posted September 26, 2019 by Sam Cumarasamy, tagged Provisioning, Transaction Processing in Data Management > Autonomous Transaction Processing public
    Title:
    I'm having issues provisioning an instance of ATP in my free tenancy
    Summary:
    Every time I provision my ATPfree instance, it becomes unavailable
    Content:

    I get this error message every time I provision an ATP instance:

    The Autonomous Database Operation Failed Due To An Unknown Error. Refer To JobId 9170004d-71d3-400f-bc1e-312797fe2caf And WorkRequestId Ffa82987-0d52-41e1-bffb-b107ec1a46c2 When Opening A Service Request At My Oracle Support.

    Can anyone help as I don't have an Oracle Support account as I'm just signed up for free credits for Oracle Cloud?

    Thanks in advance....

  • Pramoda Vyasarao
    Object storage access via Cloud console to business users2
    Topic posted June 30, 2019 by Pramoda VyasaraoGreen Ribbon: 100+ Points, tagged Transaction Processing in Data Management > Autonomous Transaction Processing public
    Title:
    Object storage access via Cloud console to business users
    Content:

    Hello,

    Allow group Data_Team to manage objects in compartment ABC where all {target.bucket.name='BucketA', any {request.permission='OBJECT_CREATE', request.permission='OBJECT_INSPECT’}}
     
    With this policy defined, I plan to create business users and assign them to the group Data_Team. Here is my question, appreciate any insights on this.
     
     Can users of Data_Team (group) use cloud console UI to upload files to the object storage bucket? Or is it just via APIs / CLI ?
    In this  use case , business users procure large lists of external data in XLS/CSV files.  If we can achieve the above, I'm thinking of allowing business users to upload files to Object storage via a browser and then developers can access & load them to tables. In Cloud console UI, Data_Team should just see Object storage link enabled (no other option).
     
     
    Regards,
    Pramoda 
  • Ranveer Tiwari
    How to deploy DB Code in ATP, as we dont have OS Access...2
    Topic posted June 26, 2019 by Ranveer TiwariRed Ribbon: 250+ Points, tagged DBCS, Transaction Processing in Data Management > Autonomous Transaction Processing public
    Title:
    How to deploy DB Code in ATP, as we dont have OS Access where we can use Shell Script?
    Summary:
    How to deploy DB Code in ATP, as we dont have OS Access where we can use Shell Script?
    Content:

    How to deploy DB Code in ATP, as we don't have OS Access where we can deploy bulk code using a Shell Script?

    Version:
    Code Deployment, ATP, OS Access, DBCS
  • Pramoda Vyasarao
    Max size of files on Object storage2
    Topic posted June 20, 2019 by Pramoda VyasaraoGreen Ribbon: 100+ Points, tagged Storage, Transaction Processing in Data Management > Autonomous Transaction Processing public
    Title:
    Max size of files on Object storage
    Summary:
    Maximum file size
    Content:

    Hello,

    I am downloading large files from https://www.data.gov for my Machine learning use cases. The plan is to load these into Object store and access them as external tables. What's the maximum file size? I remember it as 2GB in a training , please confirm?

    Regards,

     

  • Cyrille Cailloux
    audit actions on ATP2
    Topic posted February 20, 2019 by Cyrille Cailloux, tagged Security, Transaction Processing in Data Management > Autonomous Transaction Processing public
    Title:
    audit actions on ATP
    Content:

    Hello,

    is there a way to see what actions has been done on a database like restore, stop, start etc? I did a restore today and I can't find anywhere a log telling me that the database has been restored, at what date, how much time it took, who did it etc.

    thank you

    Cyrille