DBCS
Discussion List
-
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… -
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…Bryan Diaz Dreyfus-Oracle 13 views 2 comments 0 points Most recent by Bryan Diaz Dreyfus-Oracle Database
-
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…
-
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…
-
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…
-
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.…
-
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 …
-
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 …
-
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…
-
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…
-
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…
-
-
-
No Performance Data in Enterprise Manager for DBCSSummary: No Performance Data in Enterprise Manager for DBCS Content (required): I need to analyze sql statement for OCI DBCS 19C's performance tuning. However there is n…
-
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… -
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…
-
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…
-
Oracle Certifications for Beginner VBCS Developers using pl/sql , apexBeginner level oracle certifications for VBCS Developers using pl/sql , apex for career growth.Koda V V Satya Sai Surya Ramakrishna 21 views 1 comment 0 points Most recent by Masiuddin Ahmed-Oracle Database -
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…
-
How to create global variables like person number on a certain page in Oracle Fusion ?Summary: I want to create variable that holds person number on Time and Leaves page in Oracle Fusion how to do something like this
-
When will upgrade of existing Base Database Service databases to 23c become available?Summary: When will upgrade of existing Base Database Service databases to 23c become available? Content (please ensure you mask any confidential information): We have ex… -
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…Subashini-Oracle 151 views 1 comment 1 point Most recent by Shanmugam Vellore Thyagarajan-Oracle Database
-
I want to connect two databases with each other ?Summary: 1) I have one database is Autonomous Database 2) The second one is normal database that i can access it with VPN I want to connect these two with each other how?
-
How to Configure connectivity between Oracle DBCS database to Azure SQL Server using Oracle GatewaySummary we need to configure connectivity between Oracle DBCS database to Azure SQL Server using Oracle Gateway ODBC Driver. Content (required): Looking for document for… -
Java exception: java.lang.OutOfMemoryError while generating validation report in Excel formatSummary: We are getting java.lang.OutOfMemoryError error while generating validation report in Excel format. Apex and ORDS has been installed. Run ID : ->112340 : 14848-… -
slowness in query execution in Active Dataguard (readonly) OCI - DBCS (12.1.0.2.0)Summary: We have ADG for our Production environment and reports are running very slow in this environment, kindly advice how to tune the performance DB Role: PHYSICAL ST…Shanmugam Vellore Thyagarajan-Oracle 191 views 13 comments 0 points Most recent by Shanmugam Vellore Thyagarajan-Oracle Database