Stack Overflow
Stack Overflow

Questions tagged [oracle-autonomous-db]

Autonomous Data Database is a cloud database service optimized for various workloads. It automatically scales compute and storage, delivers fast query performance, and requires no database administration.

Oracle Autonomous Database is an Oracle Cloud PaaS, offering various shapes which are tuned for specific use cases and workloads.

This tag is not for general Oracle Database questions, please use the for those queries.

When posting questions with the tag, please be sure to always include type of Autonomous Database Service you are using:

Autonomous Data Warehouse is a cloud database service optimized for analytical processing.

Autonomous Transaction Processing is a cloud database service that simplifies database operations for OLTP and real-time analytical application.

Oracle Autonomous JSON Database is a cloud document database service that makes it simple to develop JSON-centric applications. It features simple document APIs, serverless scaling, high performance ACID transactions, comprehensive security, and low pay-per-use pricing.

Useful links:

116 questions
3
votes
1 answer

Passing in a JSON_OBJECT_T into SODA_DOCUMENT_T

I have a PL/SQL handler using the SODA package to manipulate a JSON database. I want to: Read the value for key id in the payload Write the payload JSON into a new document in the database. To do step 1, The handler takes :body to be parsed as a…
David Min
  • 1,246
  • 8
  • 27
2
votes
0 answers

For large files, DBMS_CLOUD.COPY_DATA fails on Autonomous DB with ORA-30094: failed to find the time zone data file for version 39 in $ORACLE_HOME/

When I execute the following in order to load data to my Oracle Cloud Autonomous DB from Oracle Cloud bucket object (a CSV file): DBMS_CLOUD.COPY_DATA( table_name =>'test_landing_zone', credential_name =>'test2', file_uri_list =>…
Lukas Korous
  • 81
  • 6
2
votes
0 answers

Why can't oracle autonomously return the id of inserted data?

I confirmed that the data of the id column of the data inserted with the above sql was returned to the Oracle console window. declare tmp_id number; begin insert into users(nickname, platform, socialKey) values('test', 'test', 'test') …
madol
  • 551
  • 2
  • 17
2
votes
1 answer

How can I compare files in two object store buckets using an Oracle Autonomous Database?

I have two buckets in different regions in OCI object store. I want to compare files in the two buckets using Oracle Autonomous Database, to detect missing files and copy them over and synchronize the two buckets. I use the two buckets in different…
sanketdjain
  • 111
  • 9
1
vote
1 answer

How to know if my oracle DB is on premise or cloud

How to know if my oracle DB (19c) is on premise or running on cloud? This DB is connected with Apex as well. I have searched in Google but could not get any solution.
Baidarvi Roy
  • 31
  • 2
1
vote
1 answer

I get an error when trying to connect to an oracle database. How to fix it?

dbInfo := DbInfo{ Username: "ADMIN", Password: "Ddbstjrld1!a", Server: "adb.ap-seoul-1.oraclecloud.com", Port: "1522", Service: "gee9edfb92f3cf6_redglqwayxqefhhf_high.adb.oraclecloud.com", WalletLocation:…
madol
  • 551
  • 2
  • 17
1
vote
1 answer

Why is it failing to connect with oracle Autonomous Database from golang?

dsn := ` user=ADMIN, password=temp1!a, (description=…
madol
  • 551
  • 2
  • 17
1
vote
1 answer

Problems with setting up the jooq Generator 3.17.5 for PRO Version

I currently have the problem that I cannot get the jooq Generator to run. As a template I used the example from Etienne Studer (see https://github.com/etiennestuder/gradle-jooq-plugin/tree/master/example/configure_toolchain_gradle_dsl). That means I…
Knut
  • 41
  • 3
1
vote
1 answer

Nodejs oracledb different result with query executer and direct query from DBMS

When I execute my oracle query from the DBMS it returns correct data. But when i run the same query from from the nodejs oracledb code, results are wrong. I've searched this everywhere. but didn't get any solution. please help me. oracledb version…
Chathuranga Kasthuriarachchi
  • 1,221
  • 10
  • 13
1
vote
0 answers

Web request returns "ORA-01031: insufficient privileges" on OCI AutonomousDB

I am trying to set up a small Rest API and connect to it from an OCI Autonomous DB. But I am stuck. This request works: SELECT apex_web_service.make_rest_request( p_url =>…
N.Bri
  • 86
  • 5
1
vote
1 answer

Can users access and manage cloud code repositories from Oracle Autonomous Database?

Today, users can access data and scripts like in object stores (OCI object store, AWS S3, Azure Blob Storage etc.) from Autonomous Database. Is it possible to also manage and access cloud code repositories like GitHub, Azure Repos and AWS CodeCommit…
Nilay Panchal
  • 541
  • 6
  • 17
1
vote
1 answer

in Oracle Autonomous database try to create an workspace in the plsql program by using the apex_util.create_user. but failed

APEX_UTIL.SET_SECURITY_GROUP_ID( APEX_UTIL.FIND_SECURITY_GROUP_ID( p_workspace => 'teacher' )); apex_util.create_user( p_user_name => 'teacher', p_web_password => 'ChangeMe@1234', p_developer_privs =>…
Jian
  • 21
  • 3
1
vote
1 answer

What happens to the queries when concurrency limits is reached in Autonomous Database?

Autonomous Database has pre-defined database services that users can connect to to run their queries. These services have assigned concurrency levels to run multiple queries at the same time. What happens when these concurrency levels are…
Yasin B
  • 362
  • 1
  • 7
1
vote
1 answer

What are the options to replicate Autonomous Database manual or automatic backups to other Availability Domains (AD) or Regions?

Are Autonomous Database backups replicated by Oracle to other ADs or region or is there a way for the user to do it?
ctuzla
  • 33
  • 1
  • 6
1
vote
1 answer

Autonomous Database (Shared) OCPU and storage limits?

The user interface for Autonomous Database (Shared) seems to have an OCPU and storage limitation of 128 OCPUs and 128 TB. Is there a way to provision a database with more OCPU or TB than this?
Nilay Panchal
  • 541
  • 6
  • 17
1
2 3 4 5 6 7 8