![]() ![]() The listener port (TCP 1521) is not open on the firewall of target DB server.When failed to connect to target database, here are some common reasons, just for your reference. If the test connection is OK, then press " Connect" button set up the connection. Save Password: If checked, you can skip entering the password the next time you connect. If you are not sure about the DB Service Name, please check this: How to get the Service Name of OCI DBCS. (Enter PDB service name if you want to connect to PDB.) SID or Service Name: Enter either DB SID or the service name. Hostname: Enter the Hostname or the Host IP address. Username, Password: Enter your username and password. This test uses a DBCS instance(19c VM) on OCI public subnet.ĭatabase Type: Select "Oracle" (By default) In such case, setting up SQL Developer is very easy. When connecting from the client side, you can connect directly via public access or VPN/Fastconnect respectively. When you're using Oracle Cloud, the target Oracle DB (DBCS or IaaS DB) is stored in a public or private subnet. Please refer to the last part of this blog.Ī-2. You can change the Language Setting and Font Size in SQL Developer. Here is a step-by-step guide on how to run SQL Developer on Oracle Linux (OCI instance). Of course, you can run SQL Developer on Linux too. If you want to import the settings of the previous version, click Yes and proceed. (An Oracle account is required to download.)Īfter unzipping the Zip file, you can start it by running sqldeveloper.exe (No installation required). I am using Windows version (with JDK8) for this test. ※ JDBC driver version is as of March 2021. The driver is also applicable to MariaDB. It would be very encouraging if you could give me a "LIKE"(LGTM).įor 11gR2, 12c, 18c, 19c, 20c (On-P/Cloud)Ĭonnect to DBCS(IaaS DB) in a private subnet. I will continue to introduce other target DBs in the future. On April 2022, I added how to connect to "Oracle DB Cloud Service", "Autonous DB" and "MySQL DB Servcie" via OCI Bation service. Now I'd like to show you how to connect to various DBs with it. It supports not only Oracle DB but also other various DBs. SQL Developer is a very useful GUI tool provided by Oracle. ![]()
0 Comments
Leave a Reply. |