DBCS
Discussion List
-
standby log apply pauseSummary: Hi, I have a critical activity to perform and part of the plan is to disable standby´s log apply temporarily : if everything goes well at primary site, log appl… -
Flashback feature usage in OCISummary: Hi, I have a critical change to do in my application and I would like to know if it is allowed to use flashback database feature on my vm dbsystem instance. Con…
-
Reduce minimum storage for DB on VMIs it possible to request a smaller DB than the options you get when provisioning a Standard Edition v21.8 on a VM: Shape: VM.Standard.E4.Flex CPU core count: 1 The mini… -
Getting ORA-918 column ambiguously defined errorSummary: We have a script for creating product related views which is working fine on lower environment but while setting up production environment we are getting ORA-91…
-
0ra-29024 certificate validation failure,Oracle DBMS 12.1.0.1 on virtual machine in oci or as file sSummary: 0ra-29024 certificate validation failure Content (required): Hello there!! after I have installed the client certificate with a wallet in my dbms installed type…
-
Does DB Management support PDB?Summary: Hi, I was setting up DB Management with DBCS, and CDB was successfully shown on dashboard as follows. It is great to have all the capabilities of SQL monitoring… -
RAC option in single node VM DB systems (DBCS)Summary: I have freshly created new single Node VM DB systems of version 19.15 with DB software edition (Enterprise Edition High Performance). But I found Real Applicati…
-
Active Dataguard in single node VM DB systemsSummary: We have enabled the DR for the DB (19.15) in Ashburn region with "Dataguard" option in SanJose Region, But after enabling the DR , the active Dataguard is autom…
-
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…
-
ORA-01017 error after password resetSQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ---------------- ---------- ------------- 2 PDB$SEED READ ONLY NO 3 TEST READ WRITE NO SQL> alter session … -
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…
-
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/…
-
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 2 views 2 comments 0 points Most recent by Mathijs Bruggink - Oracle-Oracle Database
-
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…
-
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…
-
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…
-
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…
-
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… -
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…
-
Need Suggestion to choose the database for SaaS Extensions in Paas using vbcs ,it should be DBAAS orSummary Need Suggestion to choose the database for SaaS Extension ,it should be DBAAS or Autonomous databaseContent Need Suggestion to choose the database for SaaS Exten…
-
non-CDB Database in VM DB systemsContent Hi guys, To best of my knowledge, the following is true: "Unless it is 11g R2, we cannot create a non-CDB Database in a VM DB system" Could you please confirm? I… -
OCI VM DB system licensingContent Currently Customer in onPremise has 10 Online Virtual CPU's one each node in a 2 Node RAC DB on AIX. Considering a core factor of 1 as per licensing policy of Or…
-
Advisor Webcast: Exadata Cloud: Optimizing the Support Experience on April 8, 2021Summary Exadata Cloud: Optimizing the Support ExperienceContent Advisor Webcast Title: Exadata Cloud: Optimizing the Support Experience April 8, 2021 Description: This o… -
DBMS_RANDOM package is invalidSummary DBMS_RANDOM package is invalid and due to which our EBS url is not working.Content DBMS_RANDOM package is Invalid in our EBS R12.1.3 environment. This is causing…
-
Oracle Maximum Availability Architecture (MAA) Webcast SeriesSummary Oracle Maximum Availability Architecture (MAA) Webcast SeriesContent Please register to below Webcast on 6th OCT 2020 10:00 PDT time. Oracle Active Data Guard - …Anilkumar Bhagavatula-Oracle 16 views 0 comments 1 point Started by Anilkumar Bhagavatula-Oracle Database -
Block Volumes in VM DBCSSummary Attaching Block Volumes to VM DBCSContent Is there a way via OCI console or oci-cli to attach a Block volume to VM DBCS? Alternatively, can the block volumes att…
-
Starting/Stopping DB System, Database & underlying VM via OCI CLISummary OCI cli commands for stopping VM DB systemContent Are there OCI CLI commands that can be used to stop DB System (along with underlying database & compute) to sto…