Database
Discussion List
-
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?
-
Oracle Database Exadata Express Cloud ServiceSummary How to install Oracle Database Exadata Express Cloud Service in trial?Content We develop applications in Oracle Application Express. I found that Apex is contain…
-
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…
-
Recovering data from an on-demand backup using dbaasapiContent Summmary We are running a production instance of Oracle Integration Cloud Classic (User Managed) v19.2 which uses Oracle DBaaS 12.2 Standard Edition. Two weeks a…
-
What are the DBaaS OSS backup piecesContent I forced a full backup up my DBaaS instance to an OSS container using the /var/opt/oracle/bkup_api utility. We are having an issue restoring these files (using d…
-
Adding comments to featured itemsSummary Can we add comments to featured items?Content Hello Is there a way to add comments to featured items on the storefront?
-
Oracle OEM 13.2: Database Radius AuthenticationSummary Oracle OEM 13.2: Database Radius AuthenticationContent Is OEM 13.2 Release 2 configurable in a radius/external authentication environment? Our DBAs use RSA keys …
-
Migrating Oracle Database & Non Oracle Database to Oracle CloudSummary Database Cloud service MigrationContent You can directly move / migrate various source databases into different target cloud deployments running the Oracle Cloud…
-
ORA-10260: limit size (1048576) of the PGA heap set by event 10261 exceeded in DataLoad WizardSummary Dataload Wizard, into Oracle APEX with Oracle Database Cloud Schema Service, shows this error when I upload a file wit *.csv extension: ORA-10260Content Hi I hav…
-
New Document: : Restoring Pluggable Database (PDB) Failed With "ORASummary Restoring Pluggable Database (PDB) Failed With "ORA-46680 : master keys of the container database must be exported" (Doc ID 2526879.1)Content Dear Communities Pa…
-
Difference between User Managed DBCS and Autonomous DBCSSummary Need key differences between User Managed DBCS and Autonomous DBCS.Content Need key differences between User Managed DBCS and Autonomous DBCS.
-
How to restore Oracle 8 back up to latest Oracle Database 18 Express Edition?Summary How to restore and backupContent I have backup of Oracle 8 database, which is released 20 year ago. I would like to create POC with latest Oracle free database o…
-
OSS (Storage Cloud) backups not workingContent We have nightly backups running that save both to storage cloud and on disk. I originally created the storage container with a user called System. However we dec…
-
OCC X6: Oracle Database Backup Cloud Service Vs. Oracle Storage Cloud ServiceSummary Are these two synonymous?Content Has any Oracle customer purchased the "Oracle Database Backup Cloud Service" as part of their OCC? If we have purchased this, is…
-
Install Apex for CloudSummary How Can Run Apex On CloudContent Hi I create VCN and DB System (Oracle 12.2.0.1 SE) I connect to node upload apex and install apex in PDB this normally work in c…
-
Multirack Exadata Configurations in EXACS or EXACMContent Are multiack configurations with more than 8 nodes possible in Exadata cloud service or Exadata cloud at customer ? does this need to be negotiated beforehand in…
-
Exadata CS with custom DNS resolver.Content Hi Our client would like to create exadata databases using their own dns names however we faced an issue where choosing customer dns resolver at VCN level preven…
-
SQL Plus Connection to the cloudContent Hi, i can connect with SQL*Dev and SQLcl but not with SQL*Plus. All the docs I found describe solutions with screenshots that doesn´t match anymore. I don´t know…
-
Create TABLESPACE ends with ORA-01031Content Hi, it´s my second day in the cloud, so please be patient with me. And sorry if that may be a stupid question.... I´m connect with user ADMIN User ADMIN has the …
-
Read Write files from ATP DBSummary Is it possible to use UTL_FILE to read/write files from ATP DB?Content Hello Everyone, We have existing PL/SQL packages that read write files using UTL_FILE. We …
-
DBaaS CLOB - Long StringSummary Need to store a long string to a DBaaS but can't pass as an argument to an INSERT instruction nor StoreProc as the string is longer than 4000xContent Hi all, I'v…
-
PL/SQL Record/Table types in 18c databaseContent There is a difference in the way metadata is populated in "USER_ARGUMENTS" (SYS table) for RECORD and TABLE types between 12c and 18c databases. For same stored …
-
Supported way of running long scripts - vnc or screen?Summary Need for no-frills way of running long scripts on ExaCSContent I have a large database and the data is already copied into the cloud but I need to execute long o…
-
Difference between DBaaS(Database as a Service) and DBSaS(Database Schema as a Service)Summary Difference between DBaaS(Database as a Service) and DBSaS(Database Schema as a Service)Content Hi, Can anyone please let us know the difference between DBaaS(Dat…