To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Database
Discussion List
-
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. -
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… -
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… -
Most suitable database option to support OICSummary Most suitable database option to support OICContent Hello Experts, I am looking for a suitable Database option to support Oracle Integration Cloud service. I hav… -
Unable to deploy always free ADB resources (Apex)Summary Fails on step 2 - launch resourcesContent I got a cloud console - free for employees - last month. Did some labs. Trying to re-connect. Error screenshot uploaded…
-
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…
-
Upgrading Free Tier account to Paid account - how long does this take?Summary: Upgrading Free Tier account to Paid account - how long does this take ? Content (required): I have had the free tier account, the trial period has expired and I…
-
Unable to grant role as SYSDBA to system user from dropdown option in SQL Dev.Summary: Content (required): Hi team, I am unable to grant role as SYSDBA to the system user having been granted as DBA role from the SQL query. But when I am trying to …
-
SYSDBA Privileges for DBCS serviceSummary SYSDBA Privileges for DBCS serviceContent Could someone please let me know how I could assign SYSDBA privileges to the default "system" user when i create a DBCS…
-
Cannot create Oracle Database Cloud Service (DBCS)Summary Cannot create Oracle Database Cloud Service (DBCS)Content Hi, I just requested a trial version of DBCS and follow these steps to create database cloud service ht…User_2025-01-31-16-19-28-244 17 views 2 comments 1 point Most recent by Kuljeet Singh - Oracle-Oracle -
Is flashback really needed for upgradeContent Hi guys, It's a DB System, VM, built on Oracle 12.2. According to documentation, we must have flashback enabled in the database in order to be able to upgrade th…User_2025-02-01-05-36-16-781 21 views 6 comments 0 points Most recent by Kuljeet Singh - Oracle-Oracle
-
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… -
Regarding Oracle database cloud service free trial accessSummary Regarding Oracle database cloud service free trial accessContent Dear All, I registered for Oracle database cloud service free trial for database 12cr2 access. i…
-
difference between Data guard and Active data guard features in 19c dbSummary difference between Data guard and Active data guard features in 19c dbContent Data guard is a subset of Active data guard. Data guard is a feature and ADG is lic…
-
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…
-
Anyone else having trouble with the rest Api to their Apex database tables?Summary: My Auto rest Rest Api only responses to get the Post returns a 555 error to Postman it was working great but it stopped working and I cannot seem to find an ans… -
ATP DB CPU kpi's not fileld inSummary: The CPU information is missing from the metrics screen Content (required): My always free ATP db is stopping each week. I also get the correct email saying "No … -
Exadata CS: IMPDP ORA-39002: invalid operationSummary Exadata CS: IMPDP ORA-39002: invalid operationContent Hello Team I'm migrating data from ATP to Exadata SC. I've exported dmp file using https://docs.oracle.com/…
-
How do I recover a autonomous database instance from Oracle Cloud ?Summary: Recover Oracle Autonomous Database + an Apex instance Content (required): My Oracle Autonomous Database + an Apex instance which I had created in Oracle Cloud (…
-
VM DB System, lost /u01 mount after restartSummary: Created an VM DB System in an Oracle Internal tenancy on 07-Apr. after that 12-Apr, it got rebooted, how it got reboot is we are not getting, as no one initiate… -
Creating Tablespaces in PDB of OCI DB SystemHi everyone I would like to thank Sinan Petrus Toma for his blog post It could be used for managing the CDB of the OCI DB System and creating Tablespaces in CDB Is there…