Category 245
Discussion List
-
Can DBMS_CLOUD.COPY_DATA function picks up all the columns from the target table automatically?Summary: Hi Team, I am trying to load a JSON zipped file placed in Object Storage to a ADW DB Table using the DBMS_CLOUD package. Below is the sample code - DECLARE tabl…Partha Kar-Oracle 102 views 2 comments 0 points Most recent by Partha Kar-Oracle Autonomous Database -
APEX how to enable dev & instance admin auth via oracle identity cloud serviceSummary: Content (required): I'm running the apex instance on ADW. I can't figure the correct configuration for setting up developer and instance admin login via OICS. I… -
Production Live with Free Tier ATPSummary: Hi Team, Has anyone gone LIVE in production with Free Tier ATP. Do you see any challenge with that. Our data volume is less and 20 GB is enough. So just looking… -
All APEX Links given by App Builder, to start an App, are suddenly wrong (400 Bad request)Summary: Wrong URL generated from the App Builder in APEX. It adds the workspace name before the /r/ Content (required): Suddenly the link to run any of my developed app…
-
Compilation error using PL/SQL Object Storage API in a program unitSummary: Setup: We are using an OCI ATP database and running APEX 22.2.1. The database user that owns the application objects has been granted the DWROLE. I can referenc…
-
Missing Oracle NoSQL Database Cloud ServiceI am trying to enable the Free Tier for Oracle NoSQL Database Cloud Service, but I am unable to find the 'always free configuration' option under reserved capacity as sh…
-
python-oracledb thin client returns DPY-6005Summary: Connection to ATP 21c and ADP 19c (free tier, both TLS enabled) using Python thin client fails with DPY-6005! Content: I'm trying to connect to a 21c ATP and 19…
-
How to dump data from one ATP database to other ATP databaseSummary: How to dump/Clone data from one ATP database to other ATP database Content (required): We have production ATP database and we want to clone/dump the data from A…
-
How to call a SOAP request in PLSQLSummary:Hello ,I have created a SOAP request which is working fine when I am using SOAP UI .But how to invoke the same SOAP request through PLSQL ?Can someone pls give s… -
Star TransformationIn a shared ADW instance, does the Star Transformation works? If yes, then how can we make sure that the same can be enable for the SELECT statements. Is it by setting v…SaurabhJaiswal-Oracle 61 views 1 comment 0 points Most recent by Sarma NS-Oracle Autonomous Database -
Connecting to autonomous database using Jupyter oracledb, getting SSL: SSLV3_ALERT_HANDSHAKE_FAILURESummary: I am attempting to connect to my oracle cloud autonomous database using Jupyter notebook. I downloaded the wallet from Oracle Autonomous page. However, using or…
-
Cannot create table clusters on ADB shared infrastructureSummary: Cannot create table clusters on ADB shared infrastructure Content (required): Is it intended that u cannot assign tables to clusters on adb? Instead Oracle is c…
-
Cannot access Database Actions at Marseille RegionSummary: I get an error message when I press the "Database Actions" button The error message is: "Launch DB actions Failed to auto sign-in. Close this dialog and log-in …
-
Why does my database always free keep stopping every timeI was have new account on OCI, after my Free Tier accounts finished IN the database stop automatically ,and when I start it it's stop within 1 Minute again, and I can't …
-
Connect Private ATP database to SQL Developer using Cloud WalletSummary: Connect Private ATP database to SQL Developer using Cloud Wallet Content (required): We have configured ATP database in a Private Subnet and RDP in a Public sub…MadhuMullangi 124 views 2 comments 0 points Most recent by Kuljeet Singh - Oracle-Oracle Autonomous Database
-
Unable to launch Data Transforms tool inside Database Actions of Oracle ADW after deploying ODI Web.Summary: Content (required): Hi team, After successful provision of Oracle Data Transforms instance, I am able to access the Data transforms from the web browser and aft…
-
Why does my ADB keep stopping?Summary: I am using an Always Free tier Autonomous Database with workload type Data Warehouse. It keeps stopping and every time I start it again it will stay up for 1-5 …
-
503 Service Unavailable - ATP Keeps shutting downContent 503 Service Unavailable - ATP Keeps shutting down503 Service Unavailable - ATP Keeps shutting down Have restarted atleast 10 times and it keeps shutting down. Ea…
-
503 Service Unavailable: Cant access my Oracle Cloud ATP databaseSummary Cant find my Oracle Cloud ATP databaseContent Hi Everyone. I have been using the ATP database free-tier and I suddenly couldn't access it on 16-Apr-2021 around 1…
-
Free accounts provided by OracleSummary: Is anyone aware if Oracle provides any free OCI accounts to help support applications which have been built to support Oracle's volunteer programs? We would onl…Amrita Gupta-Oracle 31 views 2 comments 0 points Most recent by Amrita Gupta-Oracle Autonomous Database -
Inactive TenancySummary: Unable to create any VM or ATP due to inactive tenancy Content (required): Suddenly, I'm no longer able to create VMs or ATPs or any other thing. Checked the ac…
-
How to prettify Autonomous Database(ATP) event notification emailSummary: Hello , the default email we receive for ATP events are not well formatted including email header. Is there any option we have in OCI to customize email subject… -
NAVersion 18c
-
How to enable supplemental logging on Autonomous ATP or ADW on Shared InfrastructureSummary: Per the latest documentation, it shows that Goldengate should be able to extract from ATP or ADW. In order for GoldenGate to do this we need to add supplemental…
-
Automatic Indexing enabled?Content https://cloudcustomerconnect.oracle.com/resources/ae46f0cd09/posts/create?type=6 According to the document, Automatic Indexing is enabled in ATP. By default does…
-
Migrate data from Oracle DB 11.2.0.1 to ADWSummary: How migrate data from Oracle DB 11.2.0.1 to ADW Content (required): Hi, How can migrate data from Oracle DB 11.2.0.1 to ADW in the simplest way? I try with db-l…
-
Launch APEX button results in 400 Bad Request Error on newly provisioned Autonomous DatabaseSummary: Can't launch APEX on a newly created Autonomous Database on OCI Free Tier. Content (required): I am following the tutorial here: https://docs.oracle.com/en/lear…
-
APEX version upgrade (22.1.1)Summary: Oracle APEX version upgrade (22.1.1) was not performed on the planned date - OCI APEX as a Service Content (required): Hi, I received an email informing me of t…Jorge Andres Gonzalez Uribe 31 views 0 comments 0 points Started by Jorge Andres Gonzalez Uribe Autonomous Database
-
Oracle Autonomous Database - check used storage spaceSummary: Content (required): Hello. I recently noticed that my Autonomous Database is running out of free storage space. This is strange since I store a small amount of …