Category 245
Discussion List
-
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 12 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 22 views 12 comments 0 points Most recent by Christian Pitet 2 Autonomous Database
-
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 82 views 1 comment 0 points Most recent by Keith Laker-Oracle Autonomous Database
-
Account has reached maximum limit for Always Free Autonomous Database instancesSummary: I terminated one of my two Free Autonomous DBs earlier today to make room for 23ai. I only see one DB in my list of Autonomous Databases. Despite that, when I a…
-
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…Sunil Gunturu-Oracle 6 views 1 comment 0 points Most recent by Keith Laker-Oracle Autonomous Database
-
May's latest new feature announcements for Autonomous DatabaseSummary: As May comes to a close, here is information about the new features released during the last 2 weeks along with some customer success stories. Don't forget to s… -
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…
-
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…
-
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 13 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 23 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:…