DBaaS
Discussion List
-
Enable AD Login to Base Database VMSummary: Hi, We are migrating our on prem database to OCI Base Database Service. One of the challenge is that Base Database Service Linux Machine login is allowed only v… -
apex_zip.add_file failed zipping 6.7 GB fileWe have plsql program using apex_zip.add_file utility to zip CSV file. It is working fine in production where the single CSV file size in 3.5 GB around. But it failed in…
-
ATP vs DBCSSummary: I am looking for a comparison between DBCS and ATP DB based on features, pricing, scalability etc. Content (please ensure you mask any confidential information)…
-
migration to OCIHi Team, We have Oracle database 19.17, single node with 150GB size. We have to move this to OCI DBCS VM. We dont have direct connection from Onpremise datacenter to OCI…
-
How can we create a database user in DBaaS and grant superuser privileges to specific users?Summary: How can we create a database user in DBaaS and grant superuser privileges to specific users for all schema objects? We have three schemas: CUSTOM, ERP_CNV, and … -
This file is managed by Chef-Can we safely edit config files under /etc on DBaaS VM Data Guard nodesSummary: Can we safely edit Linux config files under /etc on DBaaS VM Data Guard nodes? At least some files under /etc are managed by Chef from comments within files i.e…
-
23ai database version not shown in always free autonomous databaseSummary: I am trying to spin up an always free autonomous DB with 23ai database but only 19c is available as of 8th May 2024. current region is India South Hyderabad Con…
-
Compute instance configurationHi Experts, Need your expertise. We have created a compute instance with oracle linux 8 image. Is it recommended to enable In-transit encryption? Do we have to enable se…
-
There is no spanish(EN) transulation in Table(FND_APPLICATION_TL)Hi Team, There is a column called error_warning_message from" FUSION_ORA_ESS.REQUEST_HISTORY" customer wants to convert the error warning message column to Spanish langu… -
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… -
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…
-
can one grant references to role?In our environment all developers accounts have the role 'Developer', this role has all the necessary permissions to do what they need to do bar one which seems crazy. I…Ali Mehmet - Turning Point 11 views 3 comments 0 points Most recent by Ali Mehmet - Turning Point Database -
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…
-
rman active duplicate miscalculates sessions & processes parameters to start the auxiliary instanceSummary: When I start "dbaascli database duplicate" to create a duplicate database from a Snapshot Standby database rman active duplicate is miscalculating sessions and … -
How to create global variables like person number on a certain page in Oracle Fusion ?Summary: I want to create variable that holds person number on Time and Leaves page in Oracle Fusion how to do something like this
-
How to secure ATP (DB Layer) in terms of IP Whitelisting but allow access to APEX App (Web Layer)Summary: How to secure ATP DB in terms of IP Whitelisting but allow access to Web Apps layer i.e. ORDS, APEX Content (please ensure you mask any confidential information… -
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… -
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
-
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…
-
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 41 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…