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
-
What is the table name for the destination location in Manage Transfer Order Fusion?Summary: What is the table name for the destination location in Oracle Fusion Cloud Applications' "Manage Transfer Order" section? Content (required): I am currently cre… -
import dmp that has been exported from AR8MSWIN1256 into utf8hi, i have a problem, i have a .dmp file exported from oracle database that uses charset AR8MSWIN1256 and i have a new server with oracle database that uses charset utf8… -
How to stop container database in ExaCS through Cloud ConsoleSummary: We have ExaCS running with container database and we are able to stop the Plugable database from console. kindly let us know how to stop the container database.… -
How do I set the time zone data file in Autonomous Database?Summary: Receiving ORA-30094 error when building OML Model on Autonomous Database Content (required): I am receiving a an error: ORA-30094: failed to find the time zone … -
Why does base DB automatic Backups strategy not cleanup FRASummary: We've setup a base db and configured automatic Backups. The backups are working, however our FRA eben though sized to 200GB cannot hold 30 days (which is our re…
-
How to rollback Database Patch from 19.18 to 19.14 in ExaCS through Cloud Console ?Summary: Customer want to rollback database patch from 19.18 to 19.14 in ExaCS through Cloud Console ? Whether we have option on the exacs cloud console for rollback to …
-
OEM 13c - Installation with OMS active/active load balancingSummary: Got a customer requirement to install OEM 13c - Active/Active on a load balanced OMS Content (required): We want some clarification on configuring the load bala… -
Getting Job Id of DBMS Job in Oracle 12cSummary: We have created a DBMS job to schedule specific PLSLQ procedures. We want to get the Job Id in the PLSQL procedure that is invoked by the same. Main intention i… -
How to identify invalid date values in a varchar columnSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
How to calculate cpu utilization for single pdb database alone.Summary: Any Query to analyze cpu utilization for single pdb database alone. Content (required): Database running on Exacs Version (include the version you are using, if…
-
Not able get correct encrypted password using DBMS_METADATA.get_ddl packageSummary: Trying to extract the user's encrypted password but getting output for 1 user like "S:0000000000000.." For all other users getting out as normal. What might be …
-
ADG configuration failing in ExaCSSummary: In ExaCS environment , when we enable Dataguard between CDB database from primary region to Secondary region it is failing with error reported "Listener port is…
-
slowness in query execution in Active Dataguard (readonly) OCI - DBCS (12.1.0.2.0)Summary: We have ADG for our Production environment and reports are running very slow in this environment, kindly advice how to tune the performance DB Role: PHYSICAL ST…Shanmugam Vellore Thyagarajan-Oracle 214 views 13 comments 0 points Most recent by Shanmugam Vellore Thyagarajan-Oracle -
Base DB Cloud parametersSummary: DBCS database parameters Content (required): Hi, as DBCS customer, how much am I allowed to change instance parameters ? Am I free to change all OR just some of…
-
Network security groupSummary: NSG on VM database Content (required): Hi all I created a database on a VM , on a public subnet. The security list of the subnet allows ssh from everywhere ( 0.… -
Oracle APEX 22.1 Object Browser IssueSummary: Oracle APEX 22.1 Content (required): Object Browser displays a blank screen when developers attempt to view Code of Procedures, Functions, and Packages. To view… -
oracle data version managementhello, i'm wondering is there a way to manage oracle database data, In a way to view, how the data looked t time ago? ex: i want to view the data as if we are a month or…
-
Export data from DB System to Cloud Object Storage as CSV by specifying a querySummary: Facing Issue while using dbms_cloud.export_data in OCI DB System. Content (required): Hi All, I have created a OCI DB system with 21c and have setup DBMS_CLOUD …
-
Changing DB System hostnameSummary: How can I change the hostname for an Oracle Base Database DB System on OCI? Version (include the version you are using, if applicable): Oracle Cloud Infrastruct… -
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… -
How to Factory reset ubuntu instance, like fresh installationSummary: Hello, Actually I want to reset my Ubuntu instance, It's having problem with MySQL, I tried a lot but couldn't able to solve it. Hence decided to set my instanc…
-
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…
-
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…
-
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…
-
Documentation on tuning MDSYS.SDO_GEOMETRY field transfer from Oracle Server to Oracle ClientSummary: I am searching for tuning guides discussing how to tune transfer of MDSYS.SDO_GEOMETRY data from Oracle Server to Oracle Client. Currently we are experiencing e…
-
Why Oracle MySQL with HA only provides single primary node with 3-nodes cluster?Summary: Why Oracle MySQL with HA only provides single primary node with 3-nodes cluster? Content (required): Hi there! I am finding any mysql cloud service which provid…
-
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… -
How to fix Data Guard cannot be created when standard database service port (1521) is blocked?Summary: How to fix Data Guard cannot be created when standard database service port (1521) is blocked? Content (required): Data Guard Association cannot be created when…
-
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… -
Redirect from Post Authentication Procedure in Oracle ApexHi, We have implemented a Social Sign in with Microsoft AD in our Apex application.In the post authentication we are doing a rest api check if the user has a particular …