Posts

Posts

  • Bshah
    Not able to access bad file created by...
    Topic posted December 3, 2019 by Bshah Blue Ribbon: 750+ Points, tagged SQL Dev Web, Transaction Processing in Data Management > Autonomous Transaction Processing public
    Title:
    Not able to access bad file created by DBMS_CLOUD.validate_external_table
    Summary:
    KUP-04040: file VALIDATE$137_320200.bad in DATA_PUMP_DIR not found
    Content:

    We are trying to validate external table using dbms_cloud.validate_external_table procedure. The statement runs fine and as per documentation bad file and log file tables are also created. But whenever we try to select from those tables, Getting below error. Our csv file on which external table is based is on a bucket in Oracle cloud storage. Appreciate if there is any pointers to solve this error?

    KUP-04040: file VALIDATE$137_320200.bad in DATA_PUMP_DIR not found

     

     

    Code Snippet:
  • leckj
    PDF printing is disabled in APEX on autonomous database
    Topic posted November 28, 2019 by leckj, tagged Apex, Transaction Processing in Data Management > Autonomous Transaction Processing public
    Title:
    PDF printing is disabled in APEX on autonomous database
    Summary:
    Cannot print pdf documents from XSL-FO layout
    Content:

    Failed to read  this for autonomous database:

    PDF, Excel, and Word printing options are disabled. You may be able to configure a 3rd party print server within Application Express apps.

    Used XSL-FO report layouts for printing in my APEX applications.

    Spend 2 weeks getting to know how the oracle cloud works, imported my tables and APEX apps  from my oracle schema service, everything working ok, until I started printing when I got the error:

    ORA-20001: The printing engine could not be reached because either the URL specified is incorrect or a proxy URL needs to be specified.
    

    So if you are one of those developing applications that need a printout,bad luck it wont work on the APEX installed on the autonomous database.

    Oracle is telling us to send our data to a third party for printing, and what once was free now becomes an additional paid service, with a lot of hassle.

    Since the oracle cloud is a metered service, why not set a print server on the cloud, if our customers need to print 100000 pages or more, just charge us.

     

     

     

    Version:
    18c
  • Ravi Bhat K
    Getting ORA-12154 error while connecting from SQL developer...1
    Topic posted November 10, 2019 by Ravi Bhat KGreen Ribbon: 100+ Points, tagged Transaction Processing in Data Management > Autonomous Transaction Processing public
    Title:
    Getting ORA-12154 error while connecting from SQL developer to Autonomous DB
    Summary:
    I have setup my ADB successfully and able to connect to it from local windows 10 machine using connection type as wallet. However, when I try from SQLPLUS and use tns enties, I get ORA-12154 error,
    Content:

    I have setup my ADB successfully and able to connect to it from local windows 10 machine using connection type as wallet. However, when I try from SQLPLUS and use tns enties, I get ORA-12154 error.

    TNSPING Is successfully executed,

    sqlnet.ora is updated with correct path of wallet location where unzipped content are present.

    Please let me know if anyone has suggestions to resolve this.

    My oracle client is 12c and I need this working to call my DB from a python script.

    Regards

    Ravi

     

  • Afonso Fernandes
    Connect to autonomous database from jersey service
    Topic posted November 4, 2019 by Afonso Fernandes, tagged Transaction Processing in Data Management > Autonomous Transaction Processing public
    Title:
    Connect to autonomous database from jersey service
    Summary:
    How to connect to an autonomous database from a jersey service?
  • Rick Kelder
    ORDS CRUD Generator tool on ATP / APEX
    Topic posted October 20, 2019 by Rick KelderRed Ribbon: 250+ Points, tagged Apex, REST API, Transaction Processing in Data Management > Autonomous Transaction Processing public
    Title:
    ORDS CRUD Generator tool on ATP / APEX
    Summary:
    I've made a CRUD Generator tool that can create an SQL script that creates a complete CRUD operation and a PATCH procedure
    Content:

    I would like to share something that can benefit everyone working with ATP and Oracle Rest Data Services (ORDS), being: the ORDS CRUD Generator.

    It can automagically create all CRUD operations in the REST layer of Oracle's new Autonomous Transaction Processing database (ATP). Check out my blog how and also the link to the working JSFiddle.

    We are working towards a real database under the Process and Rapid Application Development layers, and this tool makes life a lot easier for us. The reason to use this tool for us is twofold, extensibility (easily can add / edit REST services) and a better CI/CD strategy. I just wanted to share this post so others can freely use the tool if they need it.

    https://bricks.blog/2019/10/20/oracle-ords-crud-generator/

    Version:
    autonomous
  • 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
  • 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
  • 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:
  • 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
  • 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....