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
-
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… -
Upgrading Free Tier account to Paid account - how long does this take?Summary: Upgrading Free Tier account to Paid account - how long does this take ? Content (required): I have had the free tier account, the trial period has expired and I… -
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…
-
How to Automate shutdown and startup of VMDB boxSummary: Automated shutdown and startup of my non-prod VMDB box. Content (required): I want to schedule the shutdown and startup of my non-prod VMDB box. Can anyone plea… -
How to prevent a database startup in OCI VMDB/DBCS?Summary: I would like to manually up the database in OCI VMDB after the VM shutdown. Any guideline to do it? Content (required): Version (include the version you are usi…
-
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 (…
-
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…
-
No Performance Data in Enterprise Manager for DBCSSummary: No Performance Data in Enterprise Manager for DBCS Content (required): I need to analyze sql statement for OCI DBCS 19C's performance tuning. However there is n…
-
How To Login With SYS User As SYSDBA In Oracle Autonomy Database Using SQLDeveloperSummary: How To Login With SYS User As SYSDBA In Oracle Autonomy Database Using SQLDeveloper I Try To Log With Next Methods and It Refuses To Login Database Password Cre… -
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 23 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… -
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 … -
How to connect Oracle Cloud ATP/ADW database from jasper report version installed with in the OCI VMSummary: Content (required): Connection With OCI ATP/ADW From With In the OCI VM instance using jasper report server Version (include the version you are using, if appli… -
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… -
Connect ATP Database with compute instance of linuxSummary: We are looking for option to connect ATP database using compute instance and wanted to perform sql loader kind of operations, is it possible to achieve the same…
-
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…
-
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…
-
Anyone else having trouble with the rest Api to their Apex database tables?Summary: My Auto rest Rest Api only responses to get the Post returns a 555 error to Postman it was working great but it stopped working and I cannot seem to find an ans…
-
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… -
MySQL DB Systems HA - connect to secondary instances for backupSummary Would like to know if it is possible to run backups using the secundary instances of an HA MySQL DB System in OCIContent Hi! I've setup a HA MySQL Database Servi…
-
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…
-
Unable to deploy always free ADB resources (Apex)Summary Fails on step 2 - launch resourcesContent I got a cloud console - free for employees - last month. Did some labs. Trying to re-connect. Error screenshot uploaded…
-
Security setup for VMDB/DBCSSummary Security setup for VMDB/DBCSContent I have created a VM database in cloud with default public subnet in VCN. I want to restrict access to the DB and VM OS from l…
-
How to check status of Governance Limit, Quota increase request for ExaCS with tracking number?Summary How to check status of Governance Limit, Quota increase request for ExaCS with tracking number?Content How to check status of Governance Limit, Quota increase re…
-
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…
-
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 …