Database
Discussion List
-
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… -
""The proxy could not connect to the destination in time." ORDS Page errorHI Team, While accessing ORDS URL , I am getting below error. I am getting same for using self-signed certificate and Certificate Authority (CA) certificates too. Apex a… -
How to get the endpoint URL for ORDS API for table with SQL querySummary: Hi Experts How to get the endpoint URL for ORDS API for table with SQL query? Is this possible or we have to goto everytime OCI console. Please help. Content (p… -
Datapump Export of DDL is extremely slow on On-PREMSummary: Datapump Export of DDL is extremely slow on On-PREM Content (required): Source Database size : 4.5 TB Platform: AIX DB Version : 12.2.0.4 For Migration purpose,…
-
How to remote cloning pdb method between on-premise to cloudSummary How to remote cloning pdb method between on-premise to cloudContent As per my knowledge we are not able to ping from cloud database from on premise http://docs.o…
-
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
-
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…
-
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… -
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…
-
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…
-
Can you recommend a free to enroll rdbms 19c (or higher) courseSummary: for one of our DBA's who is still working on 11g we need a 19c course He needs: ASM RAC and admin Content (required): on premise - rdbms Version (include the ve…
-
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 … -
import dmp that has been exported from AR8MSWIN1256 into utf8hi, i have a problem, i have a .dmp file exported from oracle database that uses charset AR8MSWIN1256 and i have a new server with oracle database that uses charset utf8…
-
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…