Category 219
Discussion List
-
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,… -
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 14 views 1 comment 1 point Most recent by Shanmugam Vellore Thyagarajan-Oracle Database
-
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…
-
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 34 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 124 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 204 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 84 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):…
-
Rman Backup is too slowSummary: Full database rman backup is too slow in windows machine. How to find out the bottleneck ? Content (required): run{ ALLOCATE CHANNEL d1 DEVICE TYPE DISK; ALLOCA…
-
How to identify invalid date values in a varchar columnSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, 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… -
How can I change a VM.Standard1.1 Standard Edition VMDB to a more modern shape (e.g. AMD Flex)Summary: How can I change a VM.Standard1.1 Standard Edition VMDB to a more modern shape (e.g. AMD Flex) Content (required): I would like to change the shape of an existi…
-
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…
-
Oracle APEX 22.1 Object Browser IssueSummary: Oracle APEX 22.1 Content (required): Object Browser displays a blank screen when developers attempt to view Code of Procedures, Functions, and Packages. To view… -
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…