DBaaS
Discussion List
-
ORA-20401: Authorization failed for URI using dbms_cloud access to object storageSummary: Getting authorization failed error connecting to the object storage from oci base 23 ai db. ORA-20401: Authorization failed for URI - https://objectstorage.us-c… -
Oracle Database AIHi Team, We are planning to upgrade DBCS Oracle Base Database Service from19c to 23. Please kindly share with us about which version of 23 have AI features. Thanks, Sati…
-
dbbackup (sku B91628) on my bill even though I have terminated the databaseSummary I am being billed for a database backup in object storage even though I terminated the database, and I can neither see nor delete this from the OCI consoleConten… -
For OCI 2-node DBCS can we manually assign private IP address?Summary: For an Oracle cloud Infrastructure 2-node DBCS, is it possible to manually assign a private IP address during provisioning? Alternatively, is there an option to…
-
dataguardHi Team, We are using DBCS VM - Oracle Base Database Service. We are enabling datagaurd to the primary database from OCI console. We are getting failed to fetch error me…
-
Creating DB system with Custom Grid Infrastructure ImageHi Team, We are trying to create a DB system using the custom Grid Infrastructure image: Navigate to DB Systems: From the navigation menu, select Oracle Database and the…
-
Procedure to rollback applied OS patches in DBCS/DB systemSummary: Hello Team, We have a 19.25.0.0 Version DB system/DBCS. We have applied OS patches through DBCLI using below command : dbcli get-availableospatches dbcli update…
-
MySQL dbas giving too many cconnections errorWe have a node.js microservices based application running against MySQL DBAS service in OCI cloud. MySQlL version is 8.0.41 and we upgraded to this version 2 weeks ago. …
-
NFS PermissionsHi Team, We are using OCI DBCS VM which is Base Database Service. We have a requirement to place application files daily in some location in DB server. But as per note i…
-
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…
-
How to enable ORDS service on a database hosted on private subnet of a VCN?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
DBCS restoreHi Experts, We have DBCS VM with 19.23 version. From OCI console, we are unable to initiate the restore, due to some html error. Can we do it manually from rman using be…
-
TCPS Sql Developer and OCI Base database - unable to connect TCPSI just set the Oracle base database using TLS by following this article - Authenticate Oracle Database 23ai with Microsoft Entra ID and Brad's Blog: Entra ID Integration…
-
Unable to download wallet file of autonomous database in OCISummary: Created a new Autonomous database. Under Autonomouse Database > Database Connection, the Download Client Credentials > Download Wallet is disabled. Need this to…
-
Unable to provision 2-Node DBCS using custom DNS domainSummary: Hello Team, I am facing an issue while trying to create a 2-Node DB system (DBCS) using an on-premise custom DNS. However, within the same subnet (configured wi…
-
DBCS - Base DBHi Team, Our DB version is 19.23 Multi-tenant having single CDB with single PDB. New DB system version will be 19.25. We have few queries and need your expertise answers…
-
APEX - ORDS - OAuth - Client CredentialSummary APEX - ORDS - OAuth - Client CredentialContent Hi Experts, I have created DBaaS Instance and using the ORDS feature in Application Express. I can able to use GET… -
Storing application files in dbcs systemHello experts, We are using OCI DBCS VM which is Base Database Service. We have a requirement to place application files daily in some location in DB server. But as per …
-
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 15 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…