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
-
I want to understand how OTM database (GLOGOWNER) is aligned with OAC database (HDOWNER)Summary: HOW OTM data is mapped in OAC, I want to understand this, because data in OTM database have different tables and in HDOWNER have diff hierarchy, wanted to under… -
I want to understand how OTM database (GLOGOWNER) is aligned with OAC database (HDOWNER)Summary: HOW OTM data is mapped in OAC, I want to understand this, because data in OTM database have different tables and in HDOWNER have diff hierarchy, wanted to under…
-
DBMS_CLOUD_AI_AGENTSummary: we are at 23.26 DB version OCI DBaaS Content (please ensure you mask any confidential information): How do we install DBMS_CLOUD_AI_AGENT? We have tried: 274836…
-
ORDS standalone port running on tcp6 port unable to connectSummary: ORDS standalone port running on tcp6 port unable to connect. ORDS version is 25.3 and how to make standalone port to run on tcp(IPV4) port. Content (please ensu…
-
sizing from X86 to EXACC with EXADB RAC modeSummary: I'm suffering about the sizing what migration X86 oracle 19c EE to EXACC with EXADB(not CDB), not only the DB level sizing, but also include VM Cluster level si…
-
Is Oracle RAC databases supported in AzureHello, I am looking more clarity about support of Oracle RAC in Azure cloud. I have seen many articles and found some of them saying, RAC is not supported or certified b…
-
conversion error loading table due to character set mismatchexported(using expdp) schema from oracle database that uses charset WE8MSWIN1252, and while import huge schema which has 1.5TB using impdp to Target where character set …
-
DBMS_CLOUD Synonym No Longer Valid Autonomous Database 23AISummary: Attempting to execute a subprogram from DBMS_CLOUD and getting error that the synonym is no longer valid. Content (please ensure you mask any confidential infor…
-
a query or tableneed a query or the tabke names to link between work confirmations and ap invoices through receipts
-
How to call EFFs in Fast formulaswe have created the custom pages in Person EIT and used EFF's, however now I am unable to call EFFs in Fast formula
-
How to restore spfile from an RMAN backup stored in OCI Object Storage?Hello everyone, I’m currently working with an Oracle Database hosted on OCI, and I need to restore the spfile from a backup that resides in an Object Storage bucket (RMA…
-
Oracle APEX Account on OCI lockedSummary: Hello Support Team, I need your help to unlock my APEX workspace account on OCI. I am trying to log in to my APEX Workspace on Always Free OCI but it says my ac…
-
Problem while intergrating OCI (DRCC) with external SMTPSummary: I need assistance in configuring SMTP for sending emails via Oracle APEX 24.2 on our Oracle 23ai Autonomous Database (ADB). I have followed the documentation pr…
-
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…
-
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 => '112121' ); END; —Put Object Proce…
-
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 …
-
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…
-
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…
-
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…
-
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. …
-
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…
-
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…
-
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…
-
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 …
-
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…
-
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…
-
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…
-
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…
-
Question raised by mistakeQuestion raised by mistake — please remove