Database Tools
Discussion List
-
Can DBMS_CLOUD.COPY_DATA function picks up all the columns from the target table automatically?Summary: Hi Team, I am trying to load a JSON zipped file placed in Object Storage to a ADW DB Table using the DBMS_CLOUD package. Below is the sample code - DECLARE tabl…Partha Kar-Oracle 105 views 2 comments 0 points Most recent by Partha Kar-Oracle Autonomous Database -
How to dump data from one ATP database to other ATP databaseSummary: How to dump/Clone data from one ATP database to other ATP database Content (required): We have production ATP database and we want to clone/dump the data from A…
-
Connecting to autonomous database using Jupyter oracledb, getting SSL: SSLV3_ALERT_HANDSHAKE_FAILURESummary: I am attempting to connect to my oracle cloud autonomous database using Jupyter notebook. I downloaded the wallet from Oracle Autonomous page. However, using or…
-
Cannot access Database Actions at Marseille RegionSummary: I get an error message when I press the "Database Actions" button The error message is: "Launch DB actions Failed to auto sign-in. Close this dialog and log-in …
-
Why does my database always free keep stopping every timeI was have new account on OCI, after my Free Tier accounts finished IN the database stop automatically ,and when I start it it's stop within 1 Minute again, and I can't …
-
503 Service Unavailable - ATP Keeps shutting downContent 503 Service Unavailable - ATP Keeps shutting down503 Service Unavailable - ATP Keeps shutting down Have restarted atleast 10 times and it keeps shutting down. Ea…
-
How to enable supplemental logging on Autonomous ATP or ADW on Shared InfrastructureSummary: Per the latest documentation, it shows that Goldengate should be able to extract from ATP or ADW. In order for GoldenGate to do this we need to add supplemental…
-
One of my autonomous DB is not listed in the OCISummary: Content (required): I had an 'Always free' autonomous DB (ocid1.autonomousdatabase.oc1.ap-seoul-1.anuwgljrvqohgdyaod27ibh52gzviktqeaaghwl5eq3ywh4757sk7p57xfja) …Cijo M Jose-Oracle 31 views 4 comments 0 points Most recent by Cijo M Jose-Oracle Autonomous Database
-
How do I deal with an ORA-01924 error on my Oracle Autonomous DB?Summary: Error starting at line : 10 in command - GRANT "DBA" TO "ADBSNMP" Error report - ORA-01924: role 'DBA' not granted or does not exist 01924. 00000 - "role '%s' n…User9152064-Oracle 2.4K views 1 comment 0 points Most recent by Kuljeet Singh - Oracle-Oracle Autonomous Database
-
To insert values from one table to anotherContent Hi team, So there is this table having 4-5 columns in which we will insert the ID and another column name, (say names) , values , into the child table where the …
-
ORDS on ATP how to enable Basic AuthSummary ORDS on ATP using Postman, how to enable Basic AuthContent I have an ATP database with a REST enabled table. I can successfully run a GET and POST (Insert) from …
-
ORDS on ATP basic Postman GET and PUTContent I am trying to perform a basic PUT from Postman to insert a record. I cannot figure out the proper syntax. I am just learning about ORDS and ATP. We have an ATP …
-
Get 503 Service Unavailable when trying to access APEX or SQL Dev WebContent Created two new ATP databases Always Free today. One works fine the other fails when trying to access APEX or SQL Dev Web: 503 Service Unavailable 2021-03-03T01:…
-
Getting 404 error when trying to access SQL Developer Web from Autonomous Database Service ConsoleContent Hi, I have been using an Autonomous ATP Database since the end of last year. I had connected to this database via SQL Developer Web from the service console as r…Michael Farren-257976 9 views 0 comments 0 points Most recent by Michael Farren-257976 Autonomous Database
-
APEX suddenly 404s with "The request could not be mapped to any database"Summary I have a free ATP instance and sudden neither the APEX nor the SQL Developer link workContent I have a free instance of Autonomous Transaction Processing. I have…
-
ATP - receiving 503 Service Unavailable while starting sql developer or ApexSummary not able to access sql developer and ApexContent ATP Database is up and previously both sql developer and Apex were connecting to it with no problem. currently r…
-
Everything is broken. 503 ErrorSummary APEX, SQL Developer, Admin Reset, Restart, Stop, Start.... all do not workContent ------ EDIT: SOLVED ISSUE ------- This was not an APEX issue, but an Always-Fre…Josh Monson-227082 41 views 9 comments 0 points Most recent by Trond Enstad-230472 Autonomous Database
-
Oracle Cloud Free Tier - Autonomous DB - ORDS 503 error, cannot connectSummary 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 Infrast…
-
APEX and SQL Developer not running on ATP Database when using "Always free"Summary APEX and SQL Developer not running on ATP Database when using "Always free" Content Im using ATP DB Cloud "Always Free" with APEX. Suddenly its not working and t…
-
404 Not FoundSummary Getting 404 Not Found error while trying to open APEX or SQL Developer WebContent Took cloud always free and created an ATP database, went to service console > a…
-
How to connect standalone ORDS with ATP database?Summary How to connect standalone ORDS with ATP databaseContent Hello, I have created OC Instance with installed ORDS (run as standalone). I have created ATP Database, w…
-
Not able to access bad file created by DBMS_CLOUD.validate_external_tableSummary KUP-04040: file VALIDATE$137_320200.bad in DATA_PUMP_DIR not foundContent We are trying to validate external table using dbms_cloud.validate_external_table proce…
-
Apex and SQL Developer Web on ATP 19c previewSummary Getting error trying to start either Apex or SQL developer Web on ATP 19c previewContent Here is the error when I try to open Apex 503 Service Unavailable * The …
-
APEX and SQLDeveloper Web fails on ATP Database when using "Always free" DBSummary APEX and SQLDeveloper Web fails on ATP Database when using "Always free" DBContent I have created two ATP Databases, one using the "Always free" config, the othe…