Database
Discussion List
-
Start/stop an OCI DBCS node through terraformContent I have a single-node database service instance(DBaaS) in OCI; I am able to provision is with Terraform Oracle provider. I'd like to also start/stop it through te… -
Authenticate a web service using Single Sign On in a PL / SQL blockSummary Authenticate a web service using Single Sign On in a PL / SQL blockContent Hi everyone, I have created a PL / SQL block to manipulate fusion web services (UCM fo…
-
RESTful on Cloud Database Schema Service - Origins AllowedSummary RESTful, Oracle Database Cloud - Database Schema ServiceContent Hi. I've delveoped few RESTful web services on Cloud Database Schema Service and I want to implem…
-
Plsql Cloud DeveloperSummary Plsql Cloud DeveloperContent Hi I am a PLsql developer working form 9i/ then 10g 11g. and 12c databases and migration projects. As now things are changing. What …
-
ORDS - PUT failing with 403 Forbidden errorSummary Rest enabled table's PUT works but custom ORDS in a module doesnt workContent PUT api created via custom ORDS service with a simple UPDATE statement is failing w…
-
Connect Oracle Autonomous DB in Talend Open StudioSummary Connect Oracle Autonomous DB through wallet in Talend Open Studio 7.2Content Hi all, Did anyone here already have this scenario? I am trying to connect in Talend…
-
Unable to access PUT or POST method using ORDS in Oracle Database Cloud ServiceSummary Unable to access PUT or POST method using ORDS in Oracle Database Cloud ServiceContent Experts, I have created DBCS instance, created a workspace schema and enab…
-
APEX - ORDS - OAuth - Client CredentialSummary APEX - ORDS - OAuth - Client CredentialContent Hi Experts, I have created DBaaS Instance and using the ORDS feature in Application Express. I can able to use GET…Gokulnath Muruganantham-184698 68 views 2 comments 0 points Most recent by Gokulnath Muruganantham-184698
-
How to call an ODI Scenario from APEX?Summary How to call an ODI Scenario from APEX?Content Hi Team, Could please suggest on the better approaches to call an ODI scenario from APEX. Thanks, Vempati Version 1… -
Add SSH to Baremetal DB System in OCISummary How to add or update SSH to Baremetal DB serverContent Hi Team, Could you please help me with an approach to add more ssh keys to Baremetal server which is alrea…
-
java.lang.IllegalStateException: Interrupt task is already scheduled for the thread and the type SO_Content When using an older jdbc driver (ojdbc6-11.2.0.3.0.jar) and when a query times out, we will get a SQLTimeoutException. However, when using the ojdbc8.jar (18.3) … -
APEX Page AuthorizationSummary APEX Page AuthorizationContent Hi Team, I would like to restrict the access to some pages for only Admins, So, I have created Authorization Schemes and applied t…
-
ORA-28759: Problem connect to Oracle cloud (ADW) via sqlplusSummary connect to ADW with SQLcl is okay, but not sqlplusContent Hi, I am having a strange problem when connect to Oracle cloud (ADW) Connect using SQLcl and SQLDevelop…
-
Bfile using NFS for DBSystemSummary is possible tu use BFILE on an NFS using a DBSystemContent I´m having a client that have 4TB of files on a filesystem that gets accessed via BFILE from the DB. W… -
Storage DBAASSummary add storage DBAASContent I need to allocate more disk space on DBAAS mount point / u01 than I provisioned in OCI, not using an instance but a DBAAS as mentioned …
-
Data Guard configuration with OCI Database with RAC clustersSummary Data Guard switchover hung; now having trouble terminating my test database instancesContent I configured a two node RAC cluster database on OCI using cloud dash… -
OCI DB on VM : access to Object StorageSummary OCI DB on VM : access to Object StorageContent Hi , While on Autonomous Data Warehouse there is a PL/SQL package named DBMS_CLOUD (that can be used to access / l…
-
BareMetal DB provisioning in OCISummary No Shape available for mumbai region for BareMetal DB provisioning in OCIContent Hi Team, Can anyone please suggest , why there are no shapes available to create…
-
datafile location on a "DB on VM"Summary datafile location on a "DB on VM"Content Hello, I want to create a new tablespaces on a DB on VM, but I don't know where is the location for the datafiles. if I …
-
Not able to Upload files using Page in oracle apex applicationSummary Not able to Upload files using Page in oracle apex applicationContent Hi, We are trying to upload files using page which has file browser and submit. We are reff… -
Do ojdbc8.jar supports connectivity to Oracle 12c, 11g & 10g databases?Content Using ojdbc8.jar we connect to autonomous databases. Will it provides backward compatibility to older versions?
-
How to monitor databases created using user managed DB systems like the same way we do for autonomouContent For monitoring Oracle Autonomous databases, we use SummarizeMetricsData API to collect the metrics listed here (https://docs.cloud.oracle.com/iaas/Content/Databa…
-
Few Database metrics are not populating the valuesContent https://docs.cloud.oracle.com/iaas/Content/Database/References/databasemetrics.htm#metrics-keys I have tried connecting to Autonomous database with wrong credent…
-
Need inputs to get the access to DBCS internal file systemContent Hi All, We need to know how to get the access to DBCS's internal file system and write files to that file system (custom directories in it) from BI report in Fus…
-
Unable to connect to Autonomous data warehouse database where I am able to connect to Autonomous traContent I think this is weird. I am trying to connect to Autonomous databases from java application and also using SQL developer. ATP database final static String DB_URL…
-
Not able to connect to Autonomous database using Oracle SQL developerContent I am getting the below error: IO Error: The Network Adapter could not establish the connection Any inputs?
-
How to connect to Autonomous Database from Java Application?Content I have referred this article https://docs.oracle.com/en/cloud/paas/atp-cloud/atpug/connect-preparing.html#GUID-3667EC68-930E-4566-95B3-DFA24203A8FF. Referred Sam…
-
What is the difference between dataStorageSizeInTBs and usedDataStorageSizeInTBs ?Content As per the doc, definitions are as below: dataStorageSizeInTBs - The quantity of data in the database, in terabytes. usedDataStorageSizeInTBs - The amount of sto…
-
Which statements will be under monitored SQL tab ?Content I have created few tables using Oracle Apex. Will these queries/statements listed here in monitored SQL tab?
-
What are the differences between Exadata DB Systems & Exadata cloud at customer?Content Are these referring the same?