Heatwave is a MySQL instance, you can use SQLDeveloper if I remember you need some additional library to add to sqlveloper to connect(mayby this change in recent versions), or use MySQL Workbench to connect. Can you explain your qeustion? I am not sure if I understand how you trying to connect
Thanks for the video. Is it possible to connect the Autonomous Database to an Oracle 11g database that is outside the cloud? I would like to create and use a dblink from autonomous database to a target 11g database. I looked at the documentation and saw that it is necessary to download a wallet, but it is quite difficult to do this. I would like to know if it is really possible to make this connection.
Hi, I am looking into this topic as well. So far documentation looks simple and easy but I was not able to make it working yet even between ATP/ADW. for connection on prem - it should be easier as you don't really need to have a wallet - I mean in connection between ATP adn on prem. base on doc you should be able to setup this using just hostname, username, passwors, SID or service name. Wallet you need for ATP/AWD which have enable requirement of the wallet authentication.
Hi. You can setup a DB link by following this documentation docs.oracle.com/en/cloud/paas/autonomous-database/serverless/adbsb/autonomous-database-links-target-oracle-db.html#GUID-67B611A2-2866-49F2-A580-0D6A6EE83A04 Create credentials BEGIN DBMS_CLOUD.CREATE_CREDENTIAL( credential_name => 'CRED_DB_LINK_ONPREM', username => 'DBUSER', password => 'DBPASS' ); END; /* create db link */ BEGIN DBMS_CLOUD_ADMIN.CREATE_DATABASE_LINK( db_link_name => 'DB_ON_PREM', hostname => 'DNS_NAME_OF_THE_DB.oraclevcn.com', port => '1521', service_name => 'SDD', ssl_server_cert_dn => NULL, credential_name => 'CRED_DB_LINK_SDD', directory_name => NULL, private_target => TRUE); END; / DNS_NAME_OF_THE_DB.oraclevcn.com - this part is important, ATP is resolving DNS from your compartment DNS. you cannot use IP address, procedure is failing when you use IP address. Using this I setup a DB link between ATP and local oracle 12 which is in OCI subnet, but this process should work for connection to your on prem database - remember to add DNS record.
@@cloudinfrastructurearchitect Hi, thanks for responding! I'm getting an error while following the private target instructions in the documentation. The error that appears is: "ORA-20000: private_target => TRUE cannot be specified for a non-PE database". I don't know how to proceed.
@@otavio-bc7jc Hi My DB is in this same network as the ATP. you are going to on prem - network connection is over public or over VPN over private connection What is your link configuration? here is little aditional info docs.oracle.com/en/cloud/paas/autonomous-database/serverless/adbsb/database-links-other-databases-customer-manged-private.html#GUID-0C18D81D-98A1-4EE9-A590-0E3A35C5C061 ther is gateway parameter
@@cloudinfrastructurearchitect Thank you very much for the support. The network connection is over public (There are some firewall rules to manage access.). I think I will need to use a wallet, but I didn't find how to do that. I tried to use "orapki" to create a wallet for my on-premises Oracle 11g, but it’s not working.
