Category 245
Discussion List
-
Issue connecting to 23ai autonomous data warehouse "Always Free" instance - ORDS HTTP Status 571Summary: Due to 21c "Always Free" instances being imminently decommissioned, I rebuilt a database in 23ai. The original 21c database was an APEX instance, and I decided … -
Issues running Oracle Apex on ATPSummary Apex shows blank page when trying to access via tools menuContent Hi,I have an Autonomous Transaction Processing Database instance set up on the Oracle cloud. Th…
-
The extended JSON data type REGULAR_EXPRESSION is not supportedSummary: I have an application that uses the MongoDB API for Autonomous JSON Database. I was attempting to do a case-insensitive find query on a collection using regex b… -
How Do I Access Files Created In Autonomous Database DATA_PUMP_DIR DirectorySummary: My OCI account is using an Autonomous Database and it came with an Oracle directory object called 'DATA_PUMP_DIR' which points to a specific file system directo…
-
How to replace new line character in one of the value in CSV during DBMS_CLOUD.COPY_DATA call?Summary: This DBMS_CLOUD.COPY_DATA API is failing during importing data from Object storage to ATP that is having a new line characters in one if its value. We are tryin…
-
Your Free Guide to Everything Autonomous at Cloudworld 2024To get you ready for CloudWorld 2024 in Las Vegas, I have put together a quick must-see guide covering all the important sessions, workshops, and tutorials by the Autono… -
Include the start_date and end_date OFS properties in the Oracle Autonomous DatabaseIs it possible to include the start_date and end_date OFS properties in the Oracle Autonomous Database configuration ? If not, how can I get this information?Jonathan Ivani-Oracle 21 views 0 comments 0 points Started by Jonathan Ivani-Oracle Autonomous Database
-
Autonomous Database on OCI and Oracle EBS version 12.2.10Summary: Is the current version of the Autonomous Database on OCI offering compatible with Oracle EBS version 12.2.10, which operates on Oracle 19C? Content (please ensu…
-
ATP in Private subnet, how to access database action (sql developer web) and Apex over internetSummary: Hi Team, We have an ATP provisioned in private subnet, how can we access the APEX and Database Action over internet, any pointer to that would be helpful? Thank…
-
Why are my newly created 23ai databases going straight from "Provisioning" to "Unavailable" ?Summary: I can't migrate my 21c DB to 23ai simply because I can't create and start a 23ai DB. Content (please ensure you mask any confidential information): I'm trying t…
-
Database link between ADW and on-prem Oracle DatabaseSummary: Database link between ADW and on-prem Oracle Database How to configure dblink on ADW to on-prem Oracle Database? Networking is ok, path analyzer return view val…
-
IP address of public ADWSummary: Hi, We wish to connect to a compute instance (ODI MP) from ADW via Apex. For this ADW, network type is set to 'Allow secure access from anywhere', so there's no…Debadrita Ghosh-Oracle 11 views 1 comment 0 points Most recent by Keith Laker-Oracle Autonomous Database -
ORDS cannot be reached using public IPSummary: We have several BIP reports where we have defined the data source for ORDS (see definition below) and they were working fine until around 19-Jul when the consol…Humberto Martin-Oracle 11 views 1 comment 0 points Most recent by Keith Laker-Oracle Autonomous Database
-
How to configure emailhi, I am using Always free database APEX on OCI version 24. I need to configure my OCI account and APEX to send emails. Is there an how-to ? Best regards. -
How to Migrate Autonomous Database with Workload type: APEXSummary: I am following This does not work for Autonomous Database with Workload type: APEX As Oracle Doesn't allow external connection Content (please ensure you mask a…
-
[URGENT] Please move all Always Free 21c instances to 23ai as soon as possible!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 21c datab…Keith Laker-Oracle 41 views 2 comments 1 point Most recent by Fernando Molla user11049640 Autonomous Database
-
Apex not working after update, invalid packagesSummary: Apex is not working after its update . I cant even see Apex instance, i can use database. I see 2 invalid packages bodies APEX_240100.WWV_FLOW_CGI APEX_240100.W…
-
AI Assistant button not visibleHi, I have upgraded to APEX 24.1 on OCI. I cannot see the button AI Assistant in the SQL code editor. The bottom page of APEX shows relase 24.1 is installed :
-
How to rollback a tableHi, I am on always free offer on OCI. I have made a big mistake I have deleted records from a table. is it possible to rollback the table 24 hours ago ? Best regards. Ch…Christian Pitet 2 31 views 11 comments 0 points Most recent by Christian Pitet 2 Autonomous Database
-
how to send email from data transform service in ADBSummary: Data Transform Service in ADB allows to create dataflow, group dataflow to create workflow then schedule workflow to run specific schedule. But it does not have…
-
Unable to log inHi, I am using Alwaye free OCI Database and APEX. I am developing software under APEX on the platform, every day. I received this mail that "Your inactive Always Free Or…Christian Pitet 2 51 views 10 comments 0 points Most recent by Christian Pitet 2 Autonomous Database
-
Update for Autonomous Database Severless for July, 2024We are continually adding new features and enhancements to Autonomous Database, and here are the latest updates along with information about the most recent sales wins: …
-
My Oracle Free Tier-database-instance has disappeared.Summary: Last connections might be 2 weeks ago, but certainly not 90 days. Why did it disappear and, more important, how can I recover the instance? Content (please ensu…
-
Security of a stored procedure enabled as a REST service in Oracle Autonomous DatabaseHello, I created a stored procedure on Oracle Autonomous Database and marked it as REST enabled. When I do not require authentication, the service works correctly, but w…
-
A Drive like One Drive ?Hi, I would like to know if there is a system to store data on the OCI for free accounts ? We would like to secure our data there. Best regards.
-
invalid credentials.I am using Always Free AD on the free OCI. I have installed Oracle. But when I try to connect to APEX on the cloud, I get an error message "invalid credentials." How to …Christian Pitet 2 11 views 13 comments 0 points Most recent by Christian Pitet 2 Autonomous Database
-
English language on Interactive reports options instead of frenchHi, I am using APEX 24.1 on OCI. The interactive Report button is "Actions" and the Actions are in english. And the systems messages "Row updated" for example, are in En…Christian Pitet 2 21 views 12 comments 0 points Most recent by Christian Pitet 2 Autonomous Database
-
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 …
-
ORA-12530, TNS:listener: rate limit reachedSummary: How do I trouble shoot this error ? Content (please ensure you mask any confidential information): I observe this error in following configuration Automomous da…
-
Getting ORA-43912 whilst trying to create a page as a copy on Apex using 23aiSummary: I've created a new 23ai Apex instance and imported three applications from an Apex instance running on 21c. When trying to copy a page between two of these appl…Martin Bocutt-Oracle 33 views 1 comment 0 points Most recent by Keith Laker-Oracle Autonomous Database