Category 245
Discussion List
-
Create DBLINK from ATP to onprem on port different than 1522Hello, I tried to create a dblink from an ATP instance to a onprem db, and it works fine (mTLS) on port 1522. However if I try to change the port (eg: 6666) the connecti… -
ORA-20000: No Oracle File System mounted (DATA_PUMP_DIR)Summary: We are facing the same issue with, p3consulting - https://community.oracle.com/customerconnect/discussion/722932/no-oracle-file-system-mounted for both our free…
-
Migrate on-premise database to ADBSummary: We have a requirement to migrate DB 19c on-premise to ADW. We have exported the dump on the source DB server but the size is 280 GB, so uploading to object stor…Debadrita Ghosh-Oracle 31 views 6 comments 0 points Most recent by Shanmugam Vellore Thyagarajan-Oracle Autonomous Database -
Data Transform: in the Create Data Flow Popup Window, the save button is disableSummary: I try to follow the livelab: Data Studio - Self-service tools for everyone using Oracle Autonomous Database In the Lab 7, Step 3. After I choose the connection …
-
Account has reached maximum limit for Always Free Autonomous Database instancesSummary: Hi to all, we are not able to create an Autonomous Database even though we have only 1 ADW. The error we get is: "Account has reached maximum limit for Always F…
-
No Oracle File System mountedSummary: Can't backup one of my free ATP database (21c) since today and when executing SELECT * FROM DBMS_CLOUD.LIST_FILES('DATA_PUMP_DIR'); I got the error: ERROR at li…
-
Difference between provisioned, allocated and used storageSummary: We provisioned an ADW instance with 1 TB storage and imported some data. Now, the allocated storage = 626 GB, while used storage = 547 GB, which indicates that …Debadrita Ghosh-Oracle 14 views 1 comment 0 points Most recent by Keith Laker-Oracle Autonomous Database
-
Connect MYSQL Database in APEXSummary: I have a requirement to connect with external MYSQL database and bring the data to Oracle Database Cloud. Content (please ensure you mask any confidential infor…
-
ANNOUNCEMENT - FREE 1-DAY AI WORKSHOP FOR ARCHITECTS AND PRACTITIONERSSign up for our free 1-day workshop to learn more about Oracle's self-service modern data platform architecture. The Oracle Autonomous Database Product Management team i… -
ANNOUNCEMENT - ORACLE-MANAGED CONNECTIVITY TO SERVICENOWOVERVIEW Autonomous Database support for Oracle-managed heterogeneous connectivity makes it easy to create database links to non-Oracle databases. When you use database …
-
dbms_cloud.list_objects not returning data as other user than ADMINSummary: As ADMIN dbms_cloud.list_objects returns a list of objetcs; As other DB user with same credentials not returning data and not returning errors. Content (please …Stéphane Lamy-Bouchard 24 views 4 comments 0 points Most recent by Stéphane Lamy-Bouchard Autonomous Database
-
cloning a database is failing at 18%Summary Trying to create a autonomous database clone and is constantly stuck at 18% and then fails.Content I'm trying to create a clone of my autonomous database (via da…
-
SQL developer web with Multiple TabsSummary: When using SQL developer WEB upon a ADB, only one tab of SQL code is allowed; my organization needs possibility to have multiple tabs to launch queries in paral… -
retrieving old version of code ( database package)Summary: how can I retrieve the old version of the code ( database package)? Content (required): I have compiled the wrong version of a database package and lost the rig…
-
MongoDB API access disable for Always Free Cloud?Summary: Can't re-enable MongoDB API in Oracle Cloud -> AD -> Autonomous Database details -> Tool configuration tab. It was working for more than year prior todays patch…
-
Trouble with Build Analytic Applications using APEX and Analytic Views Live LabSummary: Content (required): When trying to login as MOVIESTREAM user, I get this error. This is under Lab 3 Task 1 of the "Build Analytic Applications using APEX and An… -
Backup Retention blocking Clone?I have a single Apex database on the free tier (about a gig in size) and I'm trying to make a clone. Based on all the documentation I've read, I should be allowed two fr…
-
Unable to clone a databaseSummary: I'm working with an autonomous database (Apex type) in the Free Tier. I only have one database and I'm trying to clone to a new DB for testing. On the clone pag…
-
Storage limit allocated x storage used.Hello. I am a user of the Autonomous Database with APEX for just over 1 year in the Always Free layer, and I realized that the allocated storage increases significantly …
-
ATP auto indexing consumes more than 16GB in SYSAUXDear valued Oracle DBA community, after enabling Oracle Autonomous auto indexing feature some months ago for testing purposes, I recently realized that since this time S…
-
How to solve this error of Oracle apex- 1403-no data found - rest data sourceSummary: Hi Experts, we are trying to upload file into OCI Object storage from Apex, so we created web credentials, rest data source and pages for uploading file. when u…
-
How to access DBMS_CLOUD package on Autonomous DB free tier?Summary: I'm on Always free Autonomous DB. The DB version is 19c. However I cannot find / use the DBMS_CLOUD package Content (required): The DBMS_CLOUD package seems mis…
-
Cannot login to Autonomous JSON database - Login page doesn't allow to press submitSummary: When trying to login to my AJD on my "Always Free" account, I'm not able to sign in. I am trying to login to access "All Database Actions", but not successful. …
-
Continuous Autonomous Database Stopping Issue (Always Free Tier)Hello Oracle community, I'm facing an issue with my Autonomous Database using the Always Free tier. The database keeps stopping continuously, and I'm unable to restart i…
-
ADB Excel add-in : Error Add-in could not be started . Re-install does not work.Summary: Hi - From the Autonomous database tab in MS excel and then clicking on About or Connections givers an internal add-in error "Add-in could not be started" See at…
-
Cannot create Autonomous DB (ATP)Summary: I am trying to create a Autonomous DB as a part of the course. However, when I'm trying to create it, its not letting me create. The create button doesn't do an…
-
ORA-01031: insufficient privileges when attempting to SFTP to OIC File serverSummary: Unable to FTP to OIC SFTP server from ATP Database Content (required): I am trying to connect to the OIC SFTP Server from ATP databse, something like below. But…
-
How do I get around the ORA-30094 error in Autonomous Database?Summary: Receiving ORA-30094 error when building OML Model on Autonomous Database Content (required): Trying to begin using OML4SQL but when following the example below,… -
Cannot create Data Share on Autonomous Data WarehouseSummary: I am trying to create a Data Share in ADW but when I try to select the Cloud Location the dropdown list button does not work. I tried creating different Cloud S…
-
I can't find my database and apex applications anymore. How can I recover Cloud error?Summary: I search for my database in my tenant but I get an error from the cloud. Content (required): After login I try to click to open my database on cloud from cloud …