DBaaS
Discussion List
-
Please share sample code that takes Json array as in value and out value in to package procedureSummary: Looking for a sample code that takes Json array as IN parameter into the package using json_array_t Looking for a sample code that takes Json array as OUT param… -
Is database 23c going to available as Standard Edition?Summary: Is database 23c going to available as Standard Edition? Content (required): I have installed 23c DBaaS in our development environment, but noticed that there is… -
How to get the logged user now in Oracle Fusion ?Summary: Is there any REST API to get the user that is logged in right now in Oracle Fusion
-
Where binding variable of a Fusion page is saved ?Summary: Page path: My team --> show more --> Team time card --> enter to anyone time card This is the Time Card page there is a lot of binding variables i want know whi…
-
I want to connect two databases with each other ?Summary: 1) I have one database is Autonomous Database 2) The second one is normal database that i can access it with VPN I want to connect these two with each other how?
-
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 can I change a VM.Standard1.1 Standard Edition VMDB to a more modern shape (e.g. AMD Flex)Summary: How can I change a VM.Standard1.1 Standard Edition VMDB to a more modern shape (e.g. AMD Flex) Content (required): I would like to change the shape of an existi… -
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… -
Autonomous Database keeps stoppingSummary: Always free database stops after a few minutes (all this week) Content (required): I've had my instance for a trial period. The trial expired, the instance carr…
-
The instances disappeared from the Cloudcontent: all week my ADB was stopping for no apparent reason here the info about that: https://community.oracle.com/customerconnect/discussion/648747/503-service-unavail…Christian Osvaldo González 42 views 2 comments 0 points Most recent by Kuljeet Singh - Oracle-Oracle Database -
How to recover/restore SSH keys with correct permission in ExaCSSummary: A POC using EBS Cloud Manager resulted in ExaCS Node-1 corruption and it doesn't allow ssh to OPC or Oracle user. Permission of .ssh directory for respective us…
-
Is it possible to change owner of ORACLE_HOME in ExaCS..!!Summary: We have provisioned ExaCS x8m for customer. Provisioned service will host all Prod and non-Prod instances. There is a requirement to have separate owner(oraxxx …
-
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
-
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…
-
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… -
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… -
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… -
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… -
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. …
-
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… -
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 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 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… -
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…
-
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…
-
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…
-
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 …
-
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…