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
-
How do I configure DbVisualizer to connect to Oracle Fusion by URL?Summary: I am trying to install DBVisualizer to help analyze some SQL coding and need to configure the driver. Does anyone have experience in this and how to successfull…
-
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…
-
DBCS grid and database patchingSummary: I have some queries what are pre checks and post checks we need to perform. As we are going to patch via OCI console where we need to check logs for grid and da…
-
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 …
-
Ability to change the initialization parameters for ATPWe need to change the PGA_AGGREGATE_LIMIT for an autonomous database - how can this be done? I have tried to find the parameter sing this link - But i cant see the link …
-
What functionalities in DBCS I might lose access to after the support period expires on Sep 30, 24?Summary: Hi Experts, I need your help, please. There is a customer running Oracle Database Enterprise Edition 12.2.0.1 on DBCS in OCI. The customer is concerned about so…
-
databaseHi Experts, DBCS-VM Oracle Base Database Service Version 19.17 single node ASM storage We have created a new db system using console. During initial provisioning of DB s…
-
How to register a Oracle Database in a instance on Oracle Cloud ConsoleSummary: In OCI instance, cloned Oracle Database in traditional way (RMAN). But in OCI console, we are unable to see the new database and daily backup is NOT running on …
-
Golden Gate REST API Authentication without username/passwordSummary: Hi all, We are using REST API calls in Linux to start/stop Golden Gate services. All the administrator accounts in our OCI tenancy are federated with an Active …
-
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…
-
How to place the extract of a job sets which is using a seeded report "Asset Cost Reserve Report".I have created a job sets which will be running in parallel using the same report, but with different parameters. The only delivery channels present are Fax, Printers, E…
-
Performance issues to consider using Golden Gate against Oracle e-Business databaseSummary: A project is underway to use Golden Gate (GG) replication from a production Oracle e-Business Financials database (vs. 12.2.12) to a newly built OCI data wareho…
-
Migration of schema from onpremise to OCIHi team, I have a requirement to download an OCI storage object(export dmp file) from OCI VM using curl command with pre authenticated url. The size of dmp file is 50GB.…
-
23ai database version not shown in always free autonomous databaseSummary: I'm trying to provision an always free database instance to try out the features of Oracle Database version 23ai But I'm only getting the option of version 19c.…
-
Encrypting/Wrapping code in ATP DBI want to wrap code of procedure, function, package in ATP DB . I tried Wrap utility but it is not working. Can you please help here ?
-
Error while creating Web ServiceWe have an issue related to data transfer from the APEX application to Oracle Fusion Application and vice versa using webservice (). This issue has been present since Ma…
-
Oracle Database Exadata Express Cloud ServiceSummary How to install Oracle Database Exadata Express Cloud Service in trial?Content We develop applications in Oracle Application Express. I found that Apex is contain…
-
Oracle Database Schema Cloud Service in Trial versionSummary Oracle Database Schema Cloud Service in Trial versionContent Hello, I created the free trial account and I want to get the Oracle Database SCHEMA Cloud Service b…
-
clone DBCS VMHi Experts, Our DB version 19C. We have two OCI database systems PRODDB and TESTDB, each contains only one pluggable database. Is there any option to clone pdbproddb int…
-
Oracle Base Database Service - DBCS VMHi Team, We have provisioned a DB system- VM in OCI. We have got CDB with single PDB. We have created one more PDB from the console. Is it possible to have unique names …
-
How to solve this error of Oracle apex- 1403-no data found - rest data sourceSummary: Hi Experts, we are trying to upload file into OCI Object storage from Apex, so we created web credentials, rest data source and pages for uploading file. when u…
-
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…
-
available MySQL DBs at Free Tier accountI need MySQL DB and I have a Free Tier account. How can I see a list of DBs available for me?
-
Formatting & Partioning disk - DBCSHi Experts, Our team created compute instance with block voume size 200GB. Now Attaching blcok volume to instance. Please let us know if below approach looks good or any…
-
OCI-Oracle Base Database ServiceHello Experts, We are using Oracle Base Database Service. We have created a database system. We are trying to connect to database host, to connect as sysdba and run some…
-
Oracle Base Database Service - DBCS VMHi Team, We are installing Oracle Database Cloud Backup Module in OCI VM DB system,but failed. DB version 19.22 →We have created a bucket in object storage →[oracle@apex…
-
Compute instance creation - Block Volume BackupHi Team, We are creating a compute instance in DBCS. While we create the instance,we have an option select backup policy with gold,silver and bronze. Taken below stateme…
-
Invalid Oracle Home ORACLE_HOME : /opt/oracle/product/23c/dbhomeFreeSummary: I tried to run typical healthcheck tools `orachk` in oracle 23c developer free edition The command itself is available out-of-box, but I see execution result as…
-
Database - NetworkHi experts, We have dev,uat and prod. We are in POC. Do we need to create seperate vcn for prod and test environments. OR Can we use same vcn for all environments. Pls s…