Connectivity and Networking
Discussion List
-
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… -
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…
-
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 37 views 2 comments 0 points Most recent by Kuljeet Singh - Oracle-Oracle Autonomous Database
-
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…
-
apex_web_service.make_rest_request always gives error insufficient privilegesSummary: I am trying to set up a small API with my home automation and the Oracle cloud. To do this, I want to send an HTTP request from the autonomous data warehouse to…
-
Connect Microsoft Excel to an ADW databaseSummary: Do we have option to connect excel to an ADW database? Content (required): Ability to connect Microsoft Excel to ADW Database Version (include the version you a… -
Do I need to update Wallet after service disruption?Summary: Oracle Cloud Toronto area has been disrupted for more than 24hr. My application still cannot connect to Oracle DB even https://ocistatus.oraclecloud.com/ says A…
-
InstantClient ODBC throws "Oracle Cloud: ORA-00018 maximum number of sessions exceeded" in ExcelContent (required): I have a Always-Free instance of Oralce Autonomous Database. I've installed Oralce InstantClient ODBC. I have been using Excel to connect to Oracle D…
-
Cross-Region Autonomous Data Guard Is Now GAContent Each region has one or a few nearby "paired regions" in which a remote standby may be created. Make sure your tenancy is subscribed to the remote region in which…Keith Laker-Oracle 4 views 2 comments 0 points Most recent by Nick_CloudEngineer-Oracle Autonomous Database -
How do we form a connection between PowerApps and ADW?Summary: We are receiving TNS connection errors when forming a connection to ADW Content (required): We have a requirement to create a connection between Azure PowerApps… -
How to connect Oracle ADW with JDBC url in data management using EPM Agent?Content Hi Team, We had the data and metadata integration with DBCS (Database cloud services) using EPM Agent. But, now we have opt for Oracle ADW (Oracle Autonomous Dat… -
ORA-00018: maximum number of sessions exceededSummary Getting ORA-00018 when trying to connect to ADWContent Hi all, I was wondering if you could help/point me in the right direction. I have been getting the "ORA-00…
-
DBLink to be created from ADW to a OCI DBContent WE are trying to create a DBLink from ADW to OCI DB but failed. We followed the following two documents: 1. Create and Configure Database Link in Autonomous Data…Rehan Ahmed Khan-Oracle 15 views 1 comment 1 point Most recent by Keith Laker-Oracle Autonomous Database
-
Can an APEX page generate a URL link?Content Hi team, I just want to know, can an APEX page generate a URL link so that an external application can redirect to that particular APEX page? So there…
-
ORA-01035: ORACLE only available to users with RESTRICTED SESSION privilegeSummary Trying to access my ADW today but getting ORA-01035 when trying to connect as any user other than ADMINContent Hi, I hope you can help. When I try and log into m…
-
to integrate MS SQL Server dB with ADWContent Can we integrate SQL Server dB with Oracle ADW using Oracle Application Integration where operations like POST,GET,PUT can take place between ADW and SQL Server …
-
Accessing ADW without using APEX or SQL Dev tool to create REST APIsContent Hi team, Can we access Oracle ADW through some other tools and by not using its own components like Oracle APEX or Oracle SQL Web Developer tool to make REST API…
-
To extract hostname, port name, service name from Oracle Autonomous Data WarehouseContent How can we extract hostname, portname , service name of Oracle ADW cloud as we are trying to connect a database using Python scripts and the Python script is dem…
-
GA ANNOUNCEMENT - APEX 20.2 Now Available In Autonomous Database-SharedContent The version of APEX within Autonomous Database has been upgraded to version 20.2. This release of APEX introduces several new features and enhancements to help d…
-
Changing Home Region for Oracle CloudSummary Changing home region and unsubscribing old regionContent Hi, Currently,we are running on UK region and that is our home region But now we have subscribed Saudi a… -
GA ANNOUNCEMENT - Modify Network Settings for Existing ADB InstancesContent Autonomous Database now supports switching network access type. This feature enables customers to perform an in-place switch from public endpoint to private endp…
-
GA ANNOUNCEMENT - ADB Supports Connecting to non-Oracle DatabasesContent Autonomous Database now supports using connections that are enabled via Oracle Database Gateway. Gateways are designed for accessing a specific non-Oracle Databa…
-
GA ANNOUNCEMENT - Reference Architecture Patterns and Solution Playbooks Now AvailableContent The Architecture Center has been u[dated to include a new series of data warehouse patterns: Each reference architecture pattern will come with the following: be…
-
GA ANNOUNCEMENT - Workload Metrics on Performance HubSummary Performance Hub has been expanded to include a new tab, "Workload". This can be used to monitor the workload in the database and helps the user identify performa…
-
GA ANNOUNCEMENT - Support For Customer Managed Oracle REST Data ServicesSummary You can now use a customer managed environment if you want manual control of the configuration and management of Oracle REST Data Services.Content NEW - ADB now …
-
GA Announcement: ADB ACLs Now Support OCI VCNsSummary (Serverless only) If the client machines reside in an Oracle Cloud Infrastructure Virtual Cloud Network (VCN), you can configure a Service Gateway to connect to …
-
Maximum number of connection (session)Content Currently the maximum number of session seems to be limited by 100 x # of ocpu. Is there any plan to increase this number or support DRCP/Shared Server connectio…
-
Can we connect to Autonomous Database using ojdbc6.jar (11.2.0.4 JDBC Driver) ? If yes, can you provContent Note: I am able to connect to ATP/ADW using ojdbc8.jar I have referred this doc https://www.oracle.com/technetwork/database/application-development/jdbc/document… -
What are the passwords for administrative user accounts in Autonomous databases?Content I have referred this link https://docs.oracle.com/en/database/oracle/oracle-database/18/admin/creating-and-configuring-an-oracle-database.html#GUID-55208EEE-5B31…
-
GA Announcement - 19c Preview for ADB now availableSummary You create a preview version of Autonomous Database either by provisioning a new database or by cloning an existing databaseContent You create a "19c Preview" ve…