Skip to main content
131 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
0 votes
0 answers
38 views

I searched extensively but I couldn't find clarity, whether Primary Key (In this case, composite of Foo1ID and Foo2ID) should be selected into foo_cursor, even if not used in procedure? Is it ...
NenadP's user avatar
  • 657
0 votes
1 answer
177 views

I'm trying to send data from an autonomous database in OCI over this function to a log created in OCI console: DECLARE log_endpoint VARCHAR2(4000); log_body CLOB; CURSOR audit_cursor IS ...
gurbelunder's user avatar
  • 307
0 votes
1 answer
113 views

I can't connect to Oracle Autonomous Database using Oracle Client without a wallet. I am following the instructions as per the documentation. I have configured the network by disabling mTLS. Also, ...
marciel.deg's user avatar
  • 564
-1 votes
1 answer
715 views

I have an Always Free Autonomous Database on Oracle Cloud Infrastructure. I want to access Oracle APEX, but I get the following error: Database Connection Error HTTP Status Code: 571 Request ID: XXX ...
Valentin's user avatar
  • 423
0 votes
2 answers
128 views

I deleted my app and restored it using "Manage backups" option. Everything was fine but now I get error when loading HTML page items. On login page I get this message: I am using Oracle ...
d313's user avatar
  • 15
0 votes
1 answer
104 views

I am trying to write PySpark DataFrames to ADW (Oracle Autonomous Data Warehouse) using JDBC in a Jupyter Lab environment, but the performance is low. dataframe.format("jdbc").mode('...
danmo41's user avatar
  • 3
0 votes
0 answers
40 views

I am testing Oracle Autonomous Json Database REST using Soda for access via c# (Unity3d) and all works good. The process I use is: Create a json document with a time stamp, works Update the time-...
PeterK's user avatar
  • 4,289
1 vote
1 answer
227 views

I'm using the Oracle API for MongoDB with the Autonomous Database. Some queries/aggregation pipelines aren't performing as well as I'd like. How do I improve the performance?
Josh's user avatar
  • 513
0 votes
1 answer
275 views

In Production Environment, we need to provide View only access to Package Spec, Package Body and Procedures. Any time we need to change the queries, we need to reach out to the admin to get the latest ...
Sivabalanarayanan L's user avatar
  • 124
0 votes
1 answer
199 views

I am using Oracle Autonomous Database on OCI. I want to create a foreign key in one of my schemas that references a view in APEX_230200 schema. I executed the statement below using ADMIN user (which ...
Hawk's user avatar
  • 5,180
0 votes
0 answers
197 views

I have an Python application that connects to an Oracle Autonomous database. This application was working correctly until I had to migrate my Oracle Autonomous database from 23c to 23ai. The app ...
Jeremy's user avatar
  • 11
0 votes
1 answer
1k views

I followed all the steps in this forum and let's say that from the autonomous sql developer it worked in these two ways: ORA-29024: Certificate validation failure When Using UTL_HTTP.REQUEST in ...
Edisson Gabriel López's user avatar
  • 77
1 vote
2 answers
842 views

I have a Autonomous database which I want to connect via Springboot but I am facing the following error even when ACL is turned off on Oracle Database. java.sql.SQLException: Listener refused the ...
Sam's user avatar
  • 79
1 vote
1 answer
362 views

Issue: How to disable flashback on a table, in Oracle free tier autonomous database 21c? Seems to be a lack of privilege problem, there is no ability to raise a support ticket in the OCI free tier. ...
Rax's user avatar
  • 888
0 votes
1 answer
82 views

I have a Unity3d based mobile game where I send REST API's to an Oracle Autonomous JSON database. I realise that hard coding client secret in the client code is not good and I have been researching ...
PeterK's user avatar
  • 4,289
1 vote
0 answers
273 views

The thing which I want to achieve is using Oracle Pl/sql stored procedure - I want to compress a blob data and put that in a json. The structure will be like. - {"Client_id" : "12345&...
Debarshi Bhattacharyya's user avatar
  • 31
0 votes
1 answer
351 views

Oracle has provided DBMS_CLOUD package to create external tables for Parquet and other type of files stored in cloud storage. I can create an external table for a parquet file in the same schema. ...
Suhel's user avatar
  • 13
1 vote
1 answer
376 views

I'm looking to calculate free space, used space, and allocated storage as percentages for our Oracle Autonomous Database (ADB). Additionally, I'd like to set up an alert in Datadog to notify us when ...
Baba's user avatar
  • 11
1 vote
1 answer
685 views

I'm working in a 19c Autonomous Database trying to create a user “analyst” to do text and entity extraction of documents. When granting CTXSYS privileges, some work and some fail. From lines 7-14 ...
Robert Orlando's user avatar
  • 11
0 votes
1 answer
125 views

I would like to use SQL + Python + OML4PY code to do ETL on Oracle Autonomous Database (ADB) tables. In particular I would like this ETL code of script to execute daily. What is the best way to ...
Joe Hahn's user avatar
  • 7
0 votes
1 answer
472 views

I am trying to setup my first app in Oracle OCI. I have created a VM, and created an Autonomous database. I started with a simple Java/JDBC-app and try connect to the database with mTLS and "...
Rop's user avatar
  • 3,449
0 votes
1 answer
169 views

I'm trying to send a mail from Oracle Autonomous DB (version 19c) using DBMS_CLOUD_NOTIFICATION functionality (https://docs.oracle.com/en/learn/send-email-autonomous-database/index.html#task-4-send-...
Alex's user avatar
  • 127
0 votes
1 answer
71 views

Can we create a reinforcement learning model using the OML4Py feature of the Oracle Autonomous Database? I am unable to figure out whether reinforcement learning model can be developed using the ...
Ravi Shankar Prasad's user avatar
  • 1
0 votes
1 answer
888 views

I would like to create an event-based scheduled job. This job should stop whenever a scheduler generates an event of type JOB_OVER_MAX_DUR. I have written the following code, which currently only ...
Zurich's user avatar
  • 1
0 votes
0 answers
126 views

I've been trying various methods to establish a connection between Tableau Desktop and Oracle Autonomous JSON Database, but unfortunately, none of them have been successful so far. I'm seeking ...
ziyad 's user avatar
  • 1
1 vote
1 answer
177 views

I've got some JSON collections in the Autonomous Database (ATP/AJD) and I'd like to copy them to another instance.
Josh's user avatar
  • 513
2 votes
0 answers
1k views

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', ...
Lukas Korous's user avatar
  • 81
0 votes
1 answer
181 views

When I go to deploy my Python Django app to Heroku. I get the following error/build log output. -----> Building on the Heroku-22 stack -----> Determining which buildpack to use for this app -----...
XmalevolentX's user avatar
  • 163
2 votes
3 answers
10k views

not able to connect to the DB hosted on oracle cloud: Autonomous Data Base (Warehousing) from python from sqlalchemy import create_engine user = 'admin' password = '****' tns = <string from the ...
Vaibhavkrishna Bhosle's user avatar
  • 39
0 votes
1 answer
56 views

We received notice that our production AJD database has exceeded the maximum allowed 20GB of Exadata storage for non-JSON data. We want to know if this will result in any production outage for us. Do ...
Andy's user avatar
  • 1
1 vote
1 answer
1k views

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's user avatar
  • 31
0 votes
1 answer
106 views

I create an Autonomous database instance and database user, APEX user, Machine learning users via the OCI java SDK API. However, i can not find API which allow me to retrieve the URL for these users. ...
Jian's user avatar
  • 31
2 votes
0 answers
160 views

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, ...
madol's user avatar
  • 627
1 vote
1 answer
1k views

dbInfo := DbInfo{ Username: "ADMIN", Password: "Ddbstjrld1!a", Server: "adb.ap-seoul-1.oraclecloud.com", Port: "1522", Service: ...
madol's user avatar
  • 627
1 vote
1 answer
753 views

dsn := ` user=ADMIN, password=temp1!a, (description= (retry_count=20)(retry_delay=3)(address=(protocol=tcps)(port=1522)(host=adb.ap-seoul-1.oraclecloud.com))(connect_data=(service_name=...
madol's user avatar
  • 627
0 votes
1 answer
627 views

on attempting to import a schema from OCI object storage using dbms_datapump DECLARE -- replace with your values exported_schema VARCHAR2(64) := 'DEMO'; import_schema VARCHAR2(64) := '...
Vitor Mira's user avatar
  • 93
1 vote
1 answer
2k views

I'm trying to run a Python app packaged in a Docker container on an OCI Ampere node. Environment: base image: python:3.10.9-slim built using buildx for arm64 client library: oracledb==1.2.1 Docker ...
Babak Tourani's user avatar
  • 609
1 vote
2 answers
681 views

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/...
Knut's user avatar
  • 41
0 votes
2 answers
1k views

I am trying to connect to Autonomous database from kubernetes cluster. In my shell script I am giving the syntax as sqlplus admin/pwd@adb_low. Before this, I also download the wallet. Can anyone tell ...
Meenal's user avatar
  • 147
-1 votes
1 answer
224 views

I'm looking for any specific architecture information with regard to how the APEX ORDS middle-tier layer scales on an ADB implementation. Specifically, as a factor of changing the OCPUs for the ADB, ...
RayC1's user avatar
  • 1
0 votes
1 answer
447 views

I have a strange problem with Select statement. It's returning a 10-min average values from 3 tables between given timestamps. The strange part is that it's working fast (0.1s) for some date ranges ...
r3vo91's user avatar
  • 23
0 votes
1 answer
245 views

I am using the Oracle autonomous cloud database and creating a couple of database username with ethe restful web enabled, along with the database schema, i also create some Apex workspace based on ...
Jian's user avatar
  • 31
0 votes
2 answers
536 views

How can I use the PL/SQL hierarchical profiler in an Oracle autonomous database? When I try to run the following code, I get the error "PLS-00201: identifier 'DBMS_HPROF' must be declared": ...
Jon Heller's user avatar
  • 36.9k
0 votes
1 answer
209 views

I have an ADB compartment in Shared ADB infrastructure with cross region standby. And I will have multiple ADB instances within the compartment. I understand that when i switchover from primary to ...
Niraj's user avatar
  • 1
0 votes
1 answer
5k views

I want to use oracle cloud autonomous database but not able to see time in IST Timezone. Is there any way to change timezone from UTC to IST at system level in oracle autonomous database in oracle ...
Yagnik Gondaliya's user avatar
  • 21
0 votes
1 answer
1k views

When I test ORDS POST works perfectly but I get "555 User Defined Resource Error" when running PUT and I cannot figure out what is wrong. PUT Received: { "code": "...
PeterK's user avatar
  • 4,289
0 votes
0 answers
592 views

I'm trying to understand where is the problem of a connection issue I'm having. Recently I've built a Java system with multitenant database connection with plain communication (unsecure). As part of ...
Alejandro Cortizo's user avatar
  • 1
0 votes
2 answers
2k views

I have an ORDS 'PUT' procedure called "update_player". When I run my code (C#) I get the following message: "cause": "An error occurred when evaluating the SQL statement ...
PeterK's user avatar
  • 4,289
0 votes
2 answers
820 views

I am trying to download specific files from the Object Storage in the Oracle Cloud in my Oracle Visual Builder App (my visual builder is inside OIC, Oracle Integration Cloud). I'd like to use the ...
Alex's user avatar
  • 51
0 votes
0 answers
142 views

I want to connect my grails server to an autonomous ORACLE database but when using the following configuration as dataSource: dataSource { dbCreate = "none" ...
joe1531's user avatar
  • 534

1
2 3