Category 245-2
Discussion List
-
how to do loadjava in ATP- Java stored procedure in ADB ?-Summary: Hi Could someone please guide how to use the loadjava tool as per the documentation to create the java files as stored procedure into ADB. I have the java sourc… -
ATP: dbms_cloud.put_object returns ORA-28862: SSL connection failedSummary: We are in the process of uploading a significant dmp file from the database directory (DATA_PUMP_DIR) to an AWS S3 bucket using the dbms_cloud.put_objectAPI. Us…
-
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…
-
Uncommited Multipart Uploads - Storage BucketHi Team, We have uploaded files from onpremise linux server to OCI object storage bucket using below commands. sample :. oci os object bulk-upload --namespace-name axqui…
-
Is there an up-to-date Product Roadmap available for ADB/ADW?Summary: My organization would like to understand the product/feature roadmap for Autonomous Database, in particular the ADW flavor of it. I've looked but couldn't find …
-
ATP DB Schema RenameSummary: I am seeking your expert advice on a significant change that we are planning to take. Could you kindly share any recommendations regarding the following scenari…
-
How to create a read-only user in an ATP databaseSummary: Our customers request to create read-only users in the ATP databases they have, basically they want to have a user who can only inquiry tables and check databas…Humberto Martín-Oracle 18 views 1 comment 0 points Most recent by Keith Laker-Oracle Autonomous Database
-
[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 211 views 18 comments 1 point Most recent by Keith Laker-Oracle Autonomous Database -
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…
-
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…
-
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…
-
How do I know when the unplanned maintenance (and possible interruptions ) will occur?Summary: I received the message last night that my Autonomous database needed to undergo maintenance however it did not give me a date or time. How do I know when this m…
-
Space Usage in container is too high on ATP DBSummary: Hi, I'm having an issue with my (Always Free) Autonomous Data (Transaction Processing workload type) where for some reason it thinks that it is full but I haven…
-
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…
-
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… -
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…
-
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… -
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…
-
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 14 views 1 comment 0 points Most recent by Keith Laker-Oracle Autonomous Database -
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…
-
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…
-
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 0 points Most recent by Shanmugam Vellore Thyagarajan-Oracle 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…
-
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…
-
Cannot SSH to instance & How to connect to the ATP from linuxContent Problem: I am getting error when I try to SSH to the instance from Mac computer. IP address and the user id that I am using were provided on the Instance Detail …User_H95GN 143 views 7 comments 1 point Most recent by Kuljeet Singh - Oracle-Oracle Autonomous Database
-
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…
-
Unable to write file on OCI bucket with Header row from DBMS_CLOUD.EXPORT_DATASummary: Hi, I am writing a file from ATP (table) to the bucket in the OCI object storage it's working fine but the header row is not inserted. Please help to export the…
-
ORA-30094: failed to find the time zone data file for version 36 in $ORACLE_HOME/oracore/zoneinfoSummary: Getting error while running select statement Content (required):ORA-30094: failed to find the time zone data file for version 36 in $ORACLE_HOME/oracore/zoneinf…
-
Authorization failed while exporting to Object storage from ATPSummary: Hi I am getting authorize failed error while exporting data from ATP to bucket using dbsm_cloud.export_data package. ORA-20401: Authorization failed for URI - h…
-
503 service unavailable errors after creating ATPSummary After creating a new ATP, I try and go to SqlDeveloper for Web or Apex I get a 593 service unavailable error.Content This is the error details after I have creat…