Database
Discussion List
-
What is IP range of the Toronto data center for DB connectionsSummary Trying to connect to ATP instance with Wallet, our network admin needs to unblock IP rangeContent Hello, Cannot open an SR yet, we are on Trial but will be upgra… -
Monitoring PaaS db system'sSummary Best practice solutions for monitoring PaaS db systemsContent Hi All, We are looking to migrate on-prem DEV, RLSE, PROD and DR to PaaS DB systems VM's for 19c an…
-
How to get files from external SFTP in Oracle APEX hosted in cloud.Summary Getting the files from SFTP and store it in APEX DB tables.Content The requirement was get the files from external SFTP and store it in the BLOB Column of a tabl…
-
Error 503 while accessing APEX and SQL DeveloperSummary Error 503Content Hi all, I'm facing an issue while trying to access APEX and SQL Developer Web through the OCI interface (I'm on the Always Free Tier); Whenever …
-
Exacs Database Automatic Backup Configuration failingSummary we have Exadata.Half3.200 at OCI . After database creation we are trying to configure automatic backup from console but it is failingContent we have Exadata.Half…
-
RMAN with HPE Data ProtectorSummary RMAN with HPE Data ProtectorContent Hi guys, I'm facing a problem when running a backup database full online with the controlfile and SPFILE Autobackup is config…
-
Rman on-premise to cloudSummary trying to take backup from on-premise to cloudContent Hi, I am trying to take a backup from on-premise to cloud following this document : https://docs.cloud.orac… -
how to enable supplemental logging?Content (pardon the double posting - I originally posted this in the ATP forum, but I discovered this forum appears to be more active) how do I enable supplemental loggi…
-
How to assign secondar IP to DB-System?Summary How to assign secondar IP to DB-System?Content A database system gets automatically a private ip assigned from the CIDR block of the underlying subnet. We have n…
-
How to load data from a file on local computer to E business suite staging table?Content I want to load data into E Business Suite staging table from a file placed on my local system. E Business Suite is installed on a remote server. I want to know, …
-
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 8 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…