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
-
PLS-00487: Invalid reference to variable 'INT'Summary: I am trying to execute the PL/SQL proc within Package but getting error while execution as schema name is 'INT' which is a reserved keyword. when I alter the se… -
Essbase error 1020098总结： 内容（必填）：Essbase 错误1020098 版本（包括您正在使用的版本，如果适用）：Oracle Fusion Financials Common Module Cloud ServiceEssbase 错误1020098 代码片段（添加支… -
Autonomous database restart hangs on OCIHangs up 3 hours and more. What to do ?
-
Is database 23c going to available as Standard Edition?Summary: Is database 23c going to available as Standard Edition? Content (required): I have installed 23c DBaaS in our development environment, but noticed that there is… -
How to get the logged user now in Oracle Fusion ?Summary: Is there any REST API to get the user that is logged in right now in Oracle Fusion
-
string literal longer than 32767 bytes.Summary: Hi Team I am trying to load JSON File content into DB table, but my block is throwing me an error as "string literal too long." set define off; DECLARE v_json_d…
-
get java error on installing rman OSBWS ModulOracle Secure Backup Web Service Install Tool, build 12.2.0.1.0DBBKPCSBP_2018-06-12 i tried to install the OSBWS Modul with oracle user on Linux 4.18.0-372.41.1.el8_6.x8… -
OTM Migration path from AWS to OCISummary: OTM Migration path from AWS to OCI Content (required): Looking for OTM 6.5.1 Migration path from AWS to OCI Version (include the version you are using, if appli…
-
Error Message: Operation failed because the OCI tenancy with OCID xxxx is not in the Active state !Summary Facing above error message if I try to create an "always free" ATP DatabaseContent please see screenshot
-
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…
-
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 stop container database in ExaCS through Cloud ConsoleSummary: We have ExaCS running with container database and we are able to stop the Plugable database from console. kindly let us know how to stop the container database.… -
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…
-
How to load data from a file on local computer to E business suite staging table?Content I want to load data into E Business Suite staging table from a file placed on my local system. E Business Suite is installed on a remote server. I want to know, …
-
What is the table name for the destination location in Manage Transfer Order Fusion?Summary: What is the table name for the destination location in Oracle Fusion Cloud Applications' "Manage Transfer Order" section? Content (required): I am currently cre… -
How do I set the time zone data file in Autonomous Database?Summary: Receiving ORA-30094 error when building OML Model on Autonomous Database Content (required): I am receiving a an error: ORA-30094: failed to find the time zone …
-
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-… -
Slow Database Upgrade from 11g to 19cSummary: We recently attempted to upgrade a copy of our Production database from 11g to 19c in preparation of actual Production upgrade to be done in few weeks. The Upgr…
-
DB 19c upgrade and java programs in DBSummary: DB 19c upgrade caused disappearance of java programs from DB Content (required): We recently upgraded an on-prem Oracle 12.1.0.2 DB to 19C (Non RAC). It was fou… -
Intermittent performance issue with ATP DatabaseHello, We are seeing intermittent performance issue with ATP DB. Due to that OIC service is taking much time to process requests. How to monitor the database to find the…
-
Getting Job Id of DBMS Job in Oracle 12cSummary: We have created a DBMS job to schedule specific PLSLQ procedures. We want to get the Job Id in the PLSQL procedure that is invoked by the same. Main intention i… -
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 202 views 13 comments 0 points Most recent by Shanmugam Vellore Thyagarajan-Oracle -
How to reclaim space in .dbf file?Summary: After purging or cleanup activities, how to reclaim space in .dbf file at OS end? Content (required): At the time of cleanup activities we dropped 500 GB space … -
Why does base DB automatic Backups strategy not cleanup FRASummary: We've setup a base db and configured automatic Backups. The backups are working, however our FRA eben though sized to 200GB cannot hold 30 days (which is our re…
-
How to calculate cpu utilization for single pdb database alone.Summary: Any Query to analyze cpu utilization for single pdb database alone. Content (required): Database running on Exacs Version (include the version you are using, if…Ravikumar.V-Oracle 361 views 7 comments 0 points Most recent by Shanmugam Vellore Thyagarajan-Oracle
-
resources fail to deploySummary trying to build apex app in demo mode, fails on second stepContent Hello, I am an Oracle employee trying to learn APEX. I logged into my account, and selected th… -
How to rollback Database Patch from 19.18 to 19.14 in ExaCS through Cloud Console ?Summary: Customer want to rollback database patch from 19.18 to 19.14 in ExaCS through Cloud Console ? Whether we have option on the exacs cloud console for rollback to …
-
OEM 13c - Installation with OMS active/active load balancingSummary: Got a customer requirement to install OEM 13c - Active/Active on a load balanced OMS Content (required): We want some clarification on configuring the load bala… -
Redirect from Post Authentication Procedure in Oracle ApexHi, We have implemented a Social Sign in with Microsoft AD in our Apex application.In the post authentication we are doing a rest api check if the user has a particular …
-
Is it possible to increase datafiles if it reaches to maximum limit 1022 per tablespace?Summary: If the datafiles in a tablespace reached to 1022, is it possible to increase. Content (required): NA Version (include the version you are using, if applicable):…