Category 219
Discussion List
-
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…
-
Essbase error 1020098总结: 内容(必填):Essbase 错误1020098 版本(包括您正在使用的版本,如果适用):Oracle Fusion Financials Common Module Cloud ServiceEssbase 错误1020098 代码片段(添加支…
-
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
-
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…
-
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 154 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 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.…Ravikumar.V-Oracle 31 views 4 comments 0 points Most recent by Shanmugam Vellore Thyagarajan-Oracle 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…
-
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…
-
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 196 views 13 comments 0 points Most recent by Shanmugam Vellore Thyagarajan-Oracle Database
-
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 …Bapiraju Swamy Vuda-Oracle 233 views 21 comments 1 point Most recent by Himanshu Nayak-Oracle Database
-
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 330 views 7 comments 0 points Most recent by Shanmugam Vellore Thyagarajan-Oracle Database
-
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):…
-
0ra-29024 certificate validation failure,Oracle DBMS 12.1.0.1 on virtual machine in oci or as file sSummary: 0ra-29024 certificate validation failure Content (required): Hello there!! after I have installed the client certificate with a wallet in my dbms installed type…
-
Not able get correct encrypted password using DBMS_METADATA.get_ddl packageSummary: Trying to extract the user's encrypted password but getting output for 1 user like "S:0000000000000.." For all other users getting out as normal. What might be …
-
ADG configuration failing in ExaCSSummary: In ExaCS environment , when we enable Dataguard between CDB database from primary region to Secondary region it is failing with error reported "Listener port is…
-
MDS NEWS: 19c Adoption WorkshopsOracle Advanced Customer Services (ACS) continues the series of Database 19c Adoption Workshops. These live webinars are available to Market-Driven Support customers at …
-
Changing DB System hostnameSummary: How can I change the hostname for an Oracle Base Database DB System on OCI? Version (include the version you are using, if applicable): Oracle Cloud Infrastruct…
-
Export data from DB System to Cloud Object Storage as CSV by specifying a querySummary: Facing Issue while using dbms_cloud.export_data in OCI DB System. Content (required): Hi All, I have created a OCI DB system with 21c and have setup DBMS_CLOUD …
-
Base DB Cloud parametersSummary: DBCS database parameters Content (required): Hi, as DBCS customer, how much am I allowed to change instance parameters ? Am I free to change all OR just some of…