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
-
Problem Connecting to Autonomous DatabaseSummary: Signed up for free trial → created database (instance type free) → trying to connect from desktop sql developer Never thought this would be so difficult - was s…
-
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…
-
ORA-20401: Authorization failed for URI-dbms_cloud.put_object - Error While Creating Object—Create Credential ; BEGIN DBMS_CLOUD.CREATE_CREDENTIAL( credential_name => 'XXOBJ_CDN', username => 'xxemail@oracle.com', password => 'fjWXSIb_5;.N]nceHZ' ); END; —Put …
-
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…
-
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…
-
Exadata Fleet Update OCI CLI command to perform the Patching/Update at ExaC@CSummary: Need assistance for Exadata Fleet Update OCI CLI command to perform the Patching/Update at ExaC@C As we are planning to Intergrate the Exadata Fleet Update with…
-
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…
-
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…
-
Help Understanding Binary Vectors and Jaccard Distance in Oracle DatabaseDear Team, Could you please help me understand the concept of binary vectors in the context of Oracle Database? Additionally, I would appreciate it if you could provide …
-
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…
-
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…
-
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. …
-
ORDS - Bad gatewayHi Experts, we have installed ORDS(23.4) in server in private subnet and currently accessible with ipadress with http://172.******:8080/ords We have created OCI load bal…
-
403 - Forbidden Post APIHi Team, We are using OCI load balancer. We have created 2 listeners, one for handling application users traffic and the other for API traffic. Created a rule set within…
-
How to Connect Power BI Desktop to Oracle Fusion Cloud 24c FSCM databaseSummary: I would like to know the steps to Connect Power BI Desktop to Oracle Fusion Cloud 24c FSCM database. Content (please ensure you mask any confidential informatio…
-
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…
-
need advice on switching off oci dev database outside working hoursSummary: have oracle database service on oracle OCI; need to save costs by installing automated process to shutdown database system outside weekday working hours and of …
-
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…
-
Back up post termination of Oracle FusionHi all, Please guide me in relation to obtaining data back up from Oracle Fusion once the license gets expired. Queries How to get back up for the accounting data from O…
-
Question raised by mistakeQuestion raised by mistake — please remove
-
Standby database creation while Migrating Primary Database using RMAN XTTS (Cross PlatformMigration)Summary: Is it feasible to concurrently build a standby database for the new target database while performing XTTS migration and activate Data Guard on OCI Content (requ…
-
DCS-10326:Failed to perform database upgrade prechecks for DBHi Team, During the database upgrade for OCI DBaaS (12c to 19c), we encountered a failure in the database upgrade job, as indicated by the error in the trace log file. U…
-
Scaling up CPU/memory & Storage - Oracle Base Database ServiceHi Experts, We are using OCI paas DBCS. We have a query. We have Database on VM version 19.22 ASM as storage later Single node. We have Intel X9 flexible shape. Do we ne…
-
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…