Category 245
Discussion List
-
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… -
Advantage of ORDS service call in vbcs and cons of OIC call in vbcsHi experts advantage of ORDS api over OIC calls in vbcs . suppose ORDS being called in OIC for VBCS services what is the disadvantage its better approach or not? what is… -
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…
-
You are attempting to use a feature that's not currently enabled for this tenancySummary: Hello, I have an ever free OCI account, now I have an virtual machine instances enable (Ubuntu) and now I was trying to create an ATP DBA for free but I receive… -
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_… -
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…
-
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…
-
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…
-
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…Debadrita Ghosh-Oracle 12 views 1 comment 0 points Most recent by Keith Laker-Oracle Autonomous Database -
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…Franklin_Cardozo-Oracle 21 views 1 comment 0 points Most recent by Debadrita Ghosh-Oracle Autonomous Database -
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…
-
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…
-
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…
-
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 …Aaron Baker - Hanger, Inc 31 views 4 comments 0 points Most recent by Keith Laker-Oracle Autonomous Database
-
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…
-
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…
-
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:…
-
Unable to import APEX Application including backup filesSummary: I have a newly created OCI account for our school and I cannot import an APEX application from a different workspace. Content (please ensure you mask any confid…
-
When will 23C be available on ATP?Summary: When will Oracle Database Version 23C be available on ATP?
-
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 33 views 6 comments 1 point 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 43 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…