DBCS
Discussion List
-
Best database option in oracle cloud i.e. optimal in cost? Executed via Oracle Integration CloudSummary: I would like to know what is best database option we have in oracle cloud that is optimal in cost? Content (please ensure you mask any confidential information)… -
Master tables and employees transactions tableSummary: We need to Archive all information of the system so want to know which all Master tables which stored configuration details and which all tables stores employee…
-
backup destination of DBCS system from object storage to autonomous recovery serviceHi Team, We have changed backup destination of DBCS system from object storage to autonomous recovery service yesterday. After the change, in oci screen, it showed a mes…
-
Apex files uploadTeam, We are building one application in apex where customers use it to upload files and retrieve files. There will be multiple files around 100 per day and there will c…
-
Backup size in DBCS object storageDear Team, We are using oracle dbcs with automatic configured backups to object storage. We are trying to find the size of the backups in object storage. But looks like …
-
Index - Performance queryHi Team, We are using Oracle Database 19.28 version. We need your support in fixing the below SQL query appeared in SQL ordered by Elapsed Time in AWR report. CPU consum…
-
DBMS_CLOUD.CREATE_EXTERNAL_TABLE for csv with newline inside fieldSummary: I have a standard comma-separated csv file stored in a bucket, with header composed by the first 2 rows. Some text contains \n (newline) that is not the end of …
-
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…
-
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…
-
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…
-
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…
-
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…
-
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 …Sridhar Gupta Yerram-Oracle 15 views 4 comments 0 points Most recent by Avishek Mazumdar-Oracle Database
-
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…
-
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…
-
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 …
-
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…
-
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…
-
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…
-
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…
-
Increasing space in Base Database Service - DBCSHi Team, We are using OCI DBCS VM which is Base Database Service. We have a requirement to place files daily in some location in DB server. But as per note id 2704132.1 …
-
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 …