Category 219
Discussion List
-
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 . -
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… -
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…
-
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…
-
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…
-
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…
-
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…
-
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 21 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 75 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
-
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…
-
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… -
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…
-
Executing multiple rest api calls in APEXHi Experts, We want to call multiple rest api calls manipulate the data received from these apis and then show it in an apex page. Can you please guide us in the right w…
-
How do I Implement backup of TDE Wallet in a dbcs environment if I'm using custom backup scripts?I've implemented custom backup in rac databases in DBCS and I'd like to know the best/common way to backup the TDE wallet. I'm using DBCS gen-2. Is there any dbcs API to…
-
ORA-01017 error after password resetSQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ---------------- ---------- ------------- 2 PDB$SEED READ ONLY NO 3 TEST READ WRITE NO SQL> alter session …
-
How to prevent a database startup in OCI VMDB/DBCS?Summary: I would like to manually up the database in OCI VMDB after the VM shutdown. Any guideline to do it? Content (required): Version (include the version you are usi…
-
Before I upgrade to PAYG, why are my ADW costs so low?Summary: I'm going to switch to PAYG to take better advantage of WebLogic stacks but need to understand why my ADW costs are far less than shown in the pricing calculato… -
Creating CDB/PDB by importing custom keys is failingSummary: Creating CDB/PDB by importing custom keys is failing Content (required): Customer Scenario: Customer has an existing DBs in on-prem that they are migrating to t…