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
-
Single Instance Database deployment on ExaCCSummary Single Instance Database deployment on ExaCCContent Hi, I want to know if "single instance" option is supported on ExaCC for a database deployment. I know that t… -
Migration from ATP to Exadata CSSummary How to migrate data from ATP to Exadata CSContent Hello Team Could you please help me with correct way of data migration from Autonomous Transaction Processing t…
-
Unable to connect to Autonomous Database from SQL DeveloperSummary Unable to connect to Autonomous Database from SQL DeveloperContent I am unable to connect to an ATP or ADW from SQL Developer. I have downloaded the wallet and h…
-
Easy automate Scale up and down of your Oacle DB on BaremetalSummary A simple script that allows you to automate scale up and downContent If you want to easily automate the scale up and down of your Oracle Database based on bareme… -
Temp TablespaceContent Temp tablespace in bigfile tablespace is this expected behaviour in Cloud at Customer CDB/PDBs? Thanks Version 18c -
compress multiple files using APEX_ZIPSummary compress multiple files using APEX_ZIPContent Hi everyone, I am trying to zip the contents of a table where I use four fields. My code gives an error when trying…
-
REST API's Need to Build on "Bare Metal, VM, and Exadata" DatabaseSummary REST API's CreationContent Hi All, I want to build REST API's on Bare Metal, VM, and Exadata Database. APEX is not available on this Database. is there any way t… -
APEX in Bare Metal, VM, and ExadataSummary Need APEX Navigation in Bare Metal, VM, and ExadataContent Hi All, I am just trying to find APEX console in Bare Metal, VM, and Exadata Database. i am not able t…
-
What to look for in brand new Oracle Database 19cSummary New features in Oracle Database 19cContent Oracle database 19c builds on top of the innovation and improvements of previous releases such as Multitenant, In-memo… -
Backup solutionSummary Backup solutionContent Hello Mates, Hope you all doing good! Can any one please shed a light on few current backup solutions & strategies. We are using Oracle PC…
-
RMAN Cross transport PDBSummary rman transportContent hi all I want to migrate a local PDB 12.2 database to a VM database 18.6 using rman bakup for transport . i will follow the metalink 230821… -
Public IP of Database not showingSummary I have provisioned VCN and Database VM according to documentation, but Public IP is not showing anywhere.Georgios Chatzimilioudis-Oracle 5 views 2 comments 0 points Most recent by Georgios Chatzimilioudis-Oracle -
DB on VM question (password for oracle OS user ? )Content Hello , I have created a DB on VM in an OCI tenancy what is the password for oracle OS user ? I didn't recall being asked for it when creating the DB on VM in th…
-
Restoring RMAN backup from object storageSummary Need to restore a RMAN backup in object storage from old DBCS instanceContent I had done full backup using RMAN into object storage. That DBCS instance was delet…
-
Fatal SSL Error when calling web service in oracle apexSummary Fatal SSL Error when calling web service in oracle apexContent I am trying to call a web service in my oracle apex cloud but I am getting HTTPS/SSL certificate e…
-
Connect Oracle cloud Database service with Microsoft sql server without Oracle Integration Cloud tooSummary Connect Oracle cloud Database service with Microsoft sql server without Oracle Integration Cloud toolContent Hi, Good day! Need help in connectivity We have crea…
-
Database restore failedSummary Tried to perform a restore from a full backup on a new system but it failedContent Hi, I tried to perform a database restore along with creation of a new DBCS an…
-
Unable to create database instance on oracle cloudSummary The Create DB Instance button is not available (greyed out) in my accountContent I have a new cloud trial account and am enjoying working with all the services v…
-
Is there any way to get Guaranteed IOPS in DBCS apart from dense io/high ioSummary IOPS sizing in DBCSContent Hi As per Oracle documentation the iOPS provided per block volume is available at a rate of around 60 iops per Gb until a ceiling of 2… -
SQL Developer Web Db UserSummary Who is the 'database user'?Content In order to use SQL Developer Web, the docs say 'Before signing in, enable the database user’s schema for SQL Developer Web'. … -
What is cloud at customer ?Content Hi, Can someone explain what is Oracle cloud at customer ? Can the Oracle ERP cloud ( Financials cloud, Procurement cloud, etc) be enabled with Oracle cloud at c…
-
PL/SQL Boolean Type in JDBCSummary PL/SQL Boolean Type in JDBCContent We are looking for a way to handle PL/SQL Boolean type in stored procedures. PL/SQL Boolean type types can be present in below…
-
SQL Developer Web - 404 errorSummary The request could not be mapped to any database. Check the request URL is correct, and that URL to database mappings have been correctly configuredContent Hello,…
-
How to reset login password of an instance?Content Is there a way to reset the login password for an instance? I have an instance where opc user had a password set. That password is no longer working. Is there a …
-
(OAC)- Oracle database cloud service, DB cloningSummary want to clone DB PROD to DEVContent Hi, I was asked to refresh OAC database on lower environment with data from PROD. To refresh application tier I will use OAC …
-
Recovery Catalog in DBCSContent How do we configure centralized recovery catalog for multiple production DBCS databases?
-
SQL Developer Web Tool (not the client/desktop version)Summary SQL developer web tool not available in DB Cloud service in OCIContent Hello, I have a question on SQL Developer Web tool and nothing on the functionality of it.…
-
DBCS as a RESTful ServiceSummary Looking for a means to increase the session time out of DBCS RESTful serviceContent Hi, We have exposed our DBCS as a REST service using Oracle APEX. Now when we…
-
Power On/Off your Oracle Databases in 1 minute and save $$$Summary Did you know you can power On/Off your DBCS VM instancesContent I only recently discovered that you can actually power On/Off your database VM instances. This is…
-
How to access DBCS instance from local machine?Summary How to access DBCS instance from local machine?Content Hi, I'm trying to access the DBCS instance from my local machine but I'm getting "Status : Failure -Test f…