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.
Database
Discussion List
-
ATP DB CPU kpi's not fileld inSummary: The CPU information is missing from the metrics screen Content (required): My always free ATP db is stopping each week. I also get the correct email saying "No … -
Exadata CS: IMPDP ORA-39002: invalid operationSummary Exadata CS: IMPDP ORA-39002: invalid operationContent Hello Team I'm migrating data from ATP to Exadata SC. I've exported dmp file using https://docs.oracle.com/… -
How do I recover a autonomous database instance from Oracle Cloud ?Summary: Recover Oracle Autonomous Database + an Apex instance Content (required): My Oracle Autonomous Database + an Apex instance which I had created in Oracle Cloud (…
-
VM DB System, lost /u01 mount after restartSummary: Created an VM DB System in an Oracle Internal tenancy on 07-Apr. after that 12-Apr, it got rebooted, how it got reboot is we are not getting, as no one initiate… -
Creating Tablespaces in PDB of OCI DB SystemHi everyone I would like to thank Sinan Petrus Toma for his blog post It could be used for managing the CDB of the OCI DB System and creating Tablespaces in CDB Is there… -
MySQL replication between instance and MDSSummary: Is it possible to replicate from mysql running on an compute instance and a DB System (MDS) Content (required): I have mysql running on a OL8 compute instance. …
-
UTL_MAIL : Email from PL/SQL in the Oracle Database in OCISummary: For specific usecases i am looking for a scenario how to be able to send mail from the database in OCI Content (required): For specific usecases (mostly related…Mathijs Bruggink - Oracle-Oracle 32 views 2 comments 0 points Most recent by Mathijs Bruggink - Oracle-Oracle
-
Terminating database from OCI console failed. Where can i find detail messages about this failing?Summary: Terminating database from OCI console failed. Where can i find detail messages about this failing? Content (required): Terminating database from OCI console fai…
-
OutOfHostCapacity when creating a Highly-Available OCI MySQL DB SystemHi everyone, I am trying to create a Highly-Available OCI MySQL DB System. However, whatever the compute shape I select, I am getting the error OutOfHostCapacity Is it a…
-
Importing DMP files into OCI Oracle DB SystemHi everyone, We have Oracle DB System on OCI which is UP and RUNNING Now, we have a requirement to import DMP files into that OCI Oracle DB System How to do that? Any he…
-
Oracle Autonomous Database metrics bugSummary: Hi! A few hours ago, the metrics of my autonomus database began to be fixed with empty intervals (example in the screenshot). What could be the problem? Content…
-
BICC extract - Load to databaseSummary BICC extract - Load to databaseContent Looking for options to pull Receivables transaction data which needs to processed. We have BIP report as an option to extr…
-
Scale mysql databaseSummary: Scale mysql database Content (required): Hello, I just created a Mysql Database. I'd like to scale it in CPU/Memory. From the documentation, I just need to edit…
-
Connecting to Fusion(Saas) using From DB using APEX. Getting Invalid CertificateSummary: Consumption of REST API from Fusion(Saas) From DB using APEX. Wallet Created but Getting Invalid Certificate. How to make it work? Do we have to get the certifi…
-
Creating a bare-bone, "free tier" OCI autonomous databaseSummary: Hello I am using a free tier OCI account. Trying to create a free PaaS OCI autonomous database. However after filling up all the information when I hit "Create …User_2025-02-12-17-56-58-738 21 views 1 comment 0 points Most recent by Kuljeet Singh - Oracle-Oracle -
Can the Put rest api be configured to add new data as well as update existing data?Summary: Can the Put rest api be configured to add new data as well as update existing data Content (required): The put handler currently updates existing but fails to c… -
Your Options for Optimizing Oracle ExadataNovember 9, 2021 8:00 am – 8:45 am| Your Options for Optimizing Oracle Exadata The Oracle Advanced Customer Services team invites you to attend a live webinar on Your Op… -
How to remove duplicate tags from XMLSummary: I am facing some issue while using UTL_HTTP rest service package we are getting some duplicate tags in client xml file which is causing issue to do sql Error : … -
PLS-00201: identifier 'DBMS_CLOUD_OCI_SC_SECRETS_GET_SECRET_BUNDLE_RESPONSE_T' must be declaredSummary: Content (required): We are using a table type variable provided by Oracle 'DBMS_CLOUD_OCI_SC_SECRETS_GET_SECRET_BUNDLE_RESPONSE_T' in Anonymous block. It is wor…
-
backup to ociSummary: I am trying to backup on prem oracle database to oci. Need help with some questions from following the oci documentation. Content (required): 1) I have my cloud…
-
Scaling CPU for DBCSContent Hi, Once a database instance is provisioned, what is the easiest way to scale up or down the CPU? It seems like from the DB console you can only scale up storage…
-
Oracle Application Express 20 to 21Hi Friends, I Developed a application at (apex.oracle.com) Release 21.1.2, but at OCI (cloud.oracle.com/apex/) is running release 20.2.0.00.20, how can I export a applic…
-
How to execute stored procedures from ATP Database accepting UDTs via Mulesoft.Summary: We were able to establish Mulesoft ATP connection using Mule Soft DB Generic config. However, when I am executing my code I am getting an exception "Exception w…
-
Exa CS/CC elastic OCPUs scalingfor Exa system scaling, came across different methods on OCI itself can we configure OCPUs autoscaling based on consumption ? Also saw this blog article explains scaling…
-
DB Systems Target Edition for Active Data Guard DeploymentSummary: We need to know if we plan to have a Active Data Guard Target database, do we have to have the same Edition of Database in the standby/target? For example if ou… -
Time between CPU release to availability in OCI?Summary Critical Patch Updates (CPU) availability timeline query for OCIContent How Long does it take for Critical Patch Updates to be released for them to be available …
-
Upgrade Apex to ver 21.1Summary When will autonomous databases in the Oracle Cloud be upgraded to Apex ver 21.1Content Apex ver 21.1 was released mid May 2021. I read that updates will happen a…
-
Apex Images missing on Default ORDSSummary Getting images missing error when attempting to access Apex in a Cloud Default ORDS environment.Content There is a problem with your environment because the Appl…
-
Access ATP Database from MulesoftSummary Can we access ATP Database from Mulesoft?Content Hi Experts, Please let me know if there is a way to access ATP Database from Mulesoft? I know enabling ORDS coul… -
Update table column based in value occurrenceContent I want to update table A column item_number on basis of table B for all rows that appear till item_location:'GRAND TOTAL:' occurrence in the column. Please check…