Database
Discussion List
-
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… -
VM DB recovery from automatic backups to new DB systemSummary: Hi We have an automatic backup setup for production oracle DB system and this works well. Now we are trying to setup a process, to create new DB system on test …
-
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…
-
Maximum number of connections in vmdb bmdbSummary:What is the maximum number of connection allowed in VMDB or BM DB what are the parameters in OCI deciding on same. What is the maximum concurrent sessions allowed
-
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… -
Intermittent performance issue with ATP DatabaseHello, We are seeing intermittent performance issue with ATP DB. Due to that OIC service is taking much time to process requests. How to monitor the database to find the…
-
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… -
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…
-
Creating CDB/PDB by importing custom keys is failingSummary: Creating CDB/PDB by importing custom keys is failing Content (required): Customer Scenario: Customer has an existing DBs in on-prem that they are migrating to t…
-
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… -
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…
-
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 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…
-
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 …
-
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… -
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…
-
MDS NEWS: 19c Adoption WorkshopsOracle Advanced Customer Services (ACS) continues the series of Database 19c Adoption Workshops. These live webinars are available to Market-Driven Support customers at … -
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…
-
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…