To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Autonomous Database
Discussion List
-
A quick and easy way to migrate your Always Free 21c instances to 23aiSummary: With the introduction and availability of Oracle’s latest database version, Oracle Database 23ai, in our Always Free tier, you can now migrate your Always Free … -
How to retrieve DB (nonpaid and non-production account) if autonomous db is forbidden.How to retrieve database (nonpaid and non-production account) if autonomous database is forbidden. Need urgent help. Thanks in advance. -
Oracle HCM deep link to access to specific apex page integrated to HCMSummary: Hi Team, We have integrated the oracle apex application in fusion HCM. We have requirement to add the deep link in APEX email notification pointing to a specifi…
-
How to Call Oracle Data Integration (MarketPlace) Scenario from ADWSummary: Hi All, we have Oracle Data Integrator Market Place in Public Subnet and ADW provisioned in same Tenancy. Can someone please let us know the steps to Call ODI S…
-
APEX REST BASED LOV Don't show all valuesSummary: APEX REST BASED LOV Don't show all values Content (please ensure you mask any confidential information): Hi, I have created a Rest Data Source Based LOV and it …
-
How to connect ADB via command line in Mac OSSummary: How to connect ADB via commandline in Mac OS Content (please ensure you mask any confidential information): I am trying to connect to ADB from Mac OS Command li…
-
My application login attempt return 503 error - Service UnavailableSummary: Unable to login into application, error 503 service unavailable Content (please ensure you mask any confidential information): When I look in dashboard, db is n…
-
My free database is always stopped since the trial period has expiredSummary: My free database is always Stopped since the trial period has expired. Content (please ensure you mask any confidential information): I doesn't use more than 20…
-
Converting ATP from OCPU to new ECPU metric defaults to higher ECPU numberSummary: Converting ATP from OCPU to new ECPU metric defaults to higher ECPU number Content (please ensure you mask any confidential information): ATP database from 2 OC…
-
APEX Report with SQL using WITH clause function gives error.Summary: Below query works fine in APEX SQL Workshop, but gives error (ORA-32034: unsupported use of WITH clause) when creating an APEX Interactive report. with FUNCTION…
-
My Always free ADBs just disappeared. What happened?Hi Without receiving any previous notification, my 2 always free ADBs just disappeared, they don't show in my ADBs list in any of my 3 compartments, they're gone. They w…
-
Bucket Name list is empty in Data Pump Import dialog boxHello, I has tried to import direct pump (dmp) file to my autonomous database. I already have this dmp file in my bucket (object storage). So problem is, when I try to s…
-
Troubleshooting DBMS_CLOUD access to object storageSummary: I tried to access the object storage from ADB (free tier) but failed with "ORA-20401: Authorization failed for URI". Is access to object storage supported in fr…
-
ORA-65114 / Usage in container is too high / Problem: Cannot shrink Data Tablespace !Hi, The current situation on my Always Free tenant/Autonomous Transaction Processing DB: jofodb/jofodb1: SQL> select round(sum(bytes/1024/1024/1024),2) Size_gb from dba_… -
Golden Gate reconfiguration after source database RMAN cloneSummary: Customer is using Golden Gate (Cloud) to transfer data from on-prem Peoplesoft database to Oracle ADW. In DEV/UAT environments, the source Peoplesoft database w… -
Why occurs this error "ORA-01841: (full) year must be between -4713 and 9999, and not be 0"?Summary: When I try to do a SQL with a parameter date occurs this error "ORA-01841: (full) year must be between -4713 and 9999, and not be 0" SQL: select * from GL_DAILY… -
How to re-create tenancy in always-free subscriptionSummary: Hi, I have an always-free account on cloud.oracle.com. I wanted to have this account terminated and request a new one in Chicago region, but I was able to termi…
-
ATP Private Endpoint - 502 Bad GatewayHi, Looking for advice on how to troubleshoot further our ADB, which we aren't able to access via our private endpoint URL anymore. Our setup follows this guide, with pr…
-
error in writing a dumpfile with expdp (autonomous cloud db). Can you check this please?error in writing a dumpfile with expdp (autonomous cloud db). Can you check this please? tenant: itbbcloud01 DBMS_METADATA.FETCH_XML_CLOB KUPW: In procedure SEND_MSG. Fa…
-
Insert / Update records in ATP database from CSV File with 1-2 million recordsSummary: Content (please ensure you mask any confidential information): We have scenario as per below : 1) Customer will provide the datafile by using upload button in U…
-
always free cloud DatabaseI'm facing an ora-65114 error too. SYSAUX consumes 11 GB but needs just 7 GB and DATA tablesspace consumes 11GB too, but needs only 1.3 GB. . So how to shrink data? Admi…
-
Need to shrink tablespaces after datapump: ORA-65114 (Always Free APEX)Summary: I have basically the same issue as this other thread: I created schemas with my tables and data from datapump exports (using object storage and dbms_cloud). A t…
-
I keep getting an error to upgrade. Is there a fix for itSummary: I was on a free trial period, and I want to upgrade, but when attempting to upgrade it tells me that it fails due to the below: I have checked the address of my…
-
Disable ACL on Autonomous DatabaseHi, I'm trying to disable ACL on my Autonomous Database, or more specifically, I'm trying to allow access to my APEX Workspace from everywhere, not just from the range o…
-
can administrative user accounts be alteredSummary: I'm advising our internal Audit team about activities in ATP. They see administrative accounts like SYS and ADMIN. I'm trying to find documentation that states …
-
Using Apex with ATP for Building Web AppHi Team, We are assessing Oracle Apex(comes with ATP DB) as a platform to build Web App/extension to Oracle Cloud ERP. There would be around 10 extensions to be built an…
-
Role Assignment not working for ATP Custom UserHi Team, We provisioned a new ATP and using web console created new DB user and assigned unlimited quota, connect, resource and DWRole. We are able to connect from SQL d…
-
Oracle APEX 503 service unavailableSummary: Service Unavailable HTTP Status Code: 503 Request ID: 0ee5370a491db4c7f7674c355fbd8502 Request Timestamp: 2024-01-12T13:59:18.785698Z The connection pool named:…
-
AutoREST POST End-point loses all dataSummary: When using AutoREST on 23C for a specific table, if I POST to it, it loses all data that is sent along with it. This is only for this specific table, but anothe…
-
When will 23C be available on ATP?Summary: When will Oracle Database Version 23C be available on ATP?