Category 219
Discussion List
-
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… -
Flashback feature usage in OCISummary: Hi, I have a critical change to do in my application and I would like to know if it is allowed to use flashback database feature on my vm dbsystem instance. Con…
-
Network security groupSummary: NSG on VM database Content (required): Hi all I created a database on a VM , on a public subnet. The security list of the subnet allows ssh from everywhere ( 0.… -
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…
-
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… -
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 …
-
Why Oracle MySQL with HA only provides single primary node with 3-nodes cluster?Summary: Why Oracle MySQL with HA only provides single primary node with 3-nodes cluster? Content (required): Hi there! I am finding any mysql cloud service which provid…
-
Not able to edit SQL commands page in SQL workshop in Apex 22.2 VersionSummary: I am not able to edit SQL commands page in SQL workshop after upgrading apex from version 21.1 to 22.2 . -
Documentation on tuning MDSYS.SDO_GEOMETRY field transfer from Oracle Server to Oracle ClientSummary: I am searching for tuning guides discussing how to tune transfer of MDSYS.SDO_GEOMETRY data from Oracle Server to Oracle Client. Currently we are experiencing e…
-
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… -
Reduce minimum storage for DB on VMIs it possible to request a smaller DB than the options you get when provisioning a Standard Edition v21.8 on a VM: Shape: VM.Standard.E4.Flex CPU core count: 1 The mini… -
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…
-
Getting ORA-918 column ambiguously defined errorSummary: We have a script for creating product related views which is working fine on lower environment but while setting up production environment we are getting ORA-91…
-
How to fix Data Guard cannot be created when standard database service port (1521) is blocked?Summary: How to fix Data Guard cannot be created when standard database service port (1521) is blocked? Content (required): Data Guard Association cannot be created when…
-
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…
-
Does DB Management support PDB?Summary: Hi, I was setting up DB Management with DBCS, and CDB was successfully shown on dashboard as follows. It is great to have all the capabilities of SQL monitoring… -
Connect ATP Database with compute instance of linuxSummary: We are looking for option to connect ATP database using compute instance and wanted to perform sql loader kind of operations, is it possible to achieve the same…
-
Autonomous Database keeps stoppingSummary: Always free database stops after a few minutes (all this week) Content (required): I've had my instance for a trial period. The trial expired, the instance carr…
-
The instances disappeared from the Cloudcontent: all week my ADB was stopping for no apparent reason here the info about that: https://community.oracle.com/customerconnect/discussion/648747/503-service-unavail…Christian Osvaldo González 26 views 2 comments 0 points Most recent by Kuljeet Singh - Oracle-Oracle Database -
503 Service Unavailable - OCI APEXHi, I'm having the following problem with the OCI when trying to run APEX from it. I have the always free version. I would appreciate any help.Christian Osvaldo González 76 views 5 comments 0 points Most recent by Christian Osvaldo González Database
-
How to recover/restore SSH keys with correct permission in ExaCSSummary: A POC using EBS Cloud Manager resulted in ExaCS Node-1 corruption and it doesn't allow ssh to OPC or Oracle user. Permission of .ssh directory for respective us…
-
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 change owner of ORACLE_HOME in ExaCS..!!Summary: We have provisioned ExaCS x8m for customer. Provisioned service will host all Prod and non-Prod instances. There is a requirement to have separate owner(oraxxx …
-
Maximum number of connections in vmdb bmdbSummary:What is the maximum number of connection allowed in VMDB or BM DB what are the parameters in OCI deciding on same. What is the maximum concurrent sessions allowed
-
Debug in APEX codeHi, We have done a social sign in integration with Azure AD.We have called a function in the Post Authentication event.We need to debug and see as part of development wh…
-
RAC option in single node VM DB systems (DBCS)Summary: I have freshly created new single Node VM DB systems of version 19.15 with DB software edition (Enterprise Edition High Performance). But I found Real Applicati…
-
Active Dataguard in single node VM DB systemsSummary: We have enabled the DR for the DB (19.15) in Ashburn region with "Dataguard" option in SanJose Region, But after enabling the DR , the active Dataguard is autom…
-
VM DB recovery from automatic backups to new DB systemSummary: Hi We have an automatic backup setup for production oracle DB system and this works well. Now we are trying to setup a process, to create new DB system on test …
-
How to Automate shutdown and startup of VMDB boxSummary: Automated shutdown and startup of my non-prod VMDB box. Content (required): I want to schedule the shutdown and startup of my non-prod VMDB box. Can anyone plea…