Database
Discussion List
-
Most suitable database option to support OICSummary Most suitable database option to support OICContent Hello Experts, I am looking for a suitable Database option to support Oracle Integration Cloud service. I hav… -
Oracle database replicationSummary Oracle database replicationContent I have a oracle 12c database and was wandering can i replicate this database to a offsite location ? -
Cannot create Oracle Database Cloud Service (DBCS)Summary Cannot create Oracle Database Cloud Service (DBCS)Content Hi, I just requested a trial version of DBCS and follow these steps to create database cloud service ht…
-
Autonomous Database stuck in starting modeSummary stopped and autonomous database and when tried to start the dba , now it is stuck in starting mode for 24 hoursContent Below is the error displayed unable to per…
-
Rman Backup is too slowSummary: Full database rman backup is too slow in windows machine. How to find out the bottleneck ? Content (required): run{ ALLOCATE CHANNEL d1 DEVICE TYPE DISK; ALLOCA… -
Is flashback really needed for upgradeContent Hi guys, It's a DB System, VM, built on Oracle 12.2. According to documentation, we must have flashback enabled in the database in order to be able to upgrade th… -
Before I upgrade to PAYG, why are my ADW costs so low?Summary: I'm going to switch to PAYG to take better advantage of WebLogic stacks but need to understand why my ADW costs are far less than shown in the pricing calculato… -
Regarding Oracle database cloud service free trial accessSummary Regarding Oracle database cloud service free trial accessContent Dear All, I registered for Oracle database cloud service free trial for database 12cr2 access. i…
-
difference between Data guard and Active data guard features in 19c dbSummary difference between Data guard and Active data guard features in 19c dbContent Data guard is a subset of Active data guard. Data guard is a feature and ADG is lic…
-
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…
-
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… -
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 … -
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…
-
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…
-
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 Implement backup of TDE Wallet in a dbcs environment if I'm using custom backup scripts?I've implemented custom backup in rac databases in DBCS and I'd like to know the best/common way to backup the TDE wallet. I'm using DBCS gen-2. Is there any dbcs API to…
-
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… -
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 …
-
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…
-
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…
-
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…