Oracle SQL Developer安装使用
Tags： OracleSQL Developer客户端连接工具工具
Oracle SQL Developer 是一个免费非开源的用以开发数据库应用程序的图形化工具，使用 SQL Developer 可以浏览数据库对象、运行 SQL 语句和脚本、编辑和调试 PL/SQL 语句。另外还可以创建执行和保存报表。该工具可以连接任何 Oracle 22.214.171.124 或者以上版本的 Oracle 数据库，支持 Windows、Linux 和 Mac OS X 系统。
在Oracle 19c之前， SQL Developer集成在Oracle数据库软件中，默认位置为
从Oracle 19c版本开始， SQL Developer不再集成在Oracle数据库软件中，若想使用SQL Developer，则必须单独下载该软件。
- Oracle SQL Developer Release 22.2
- Oracle SQL Developer Release 21.4
- Oracle SQL Developer Release 20.4
- Oracle SQL Developer Release 20.2
- Oracle SQL Developer Release 19.4
- Oracle SQL Developer Release 19.2
- Oracle SQL Developer Release 19.1
- Oracle SQL Developer Release 18.4
- Oracle SQL Developer Release 18.3
- Oracle SQL Developer Release 18.2
- Oracle SQL Developer Release 18.1
- Oracle SQL Developer Release 17.4
- Oracle SQL Developer Release 17.3
- Oracle SQL Developer Release 17.2
- Oracle SQL Developer Release 4.2
SQL Developer Web
Oracle SQL Developer Support FAQ (Doc ID 2345874.1)
Oracle SQL Developer - Version 1.0 to 22.2.1
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Information in this document applies to any platform.
This FAQ answers the most common questions concerning installation, licensing, and support for Oracle SQL Developer.
QUESTIONS AND ANSWERS
1. Is SQL Developer a "Free" product?
Oracle SQL Developer is offered as a free product. Any user with a certified client platform may download the latest version from OTN (Oracle Tech Network). Developers should install on their personal Workstations (Windows, MAC, or Linux) since this is a GUI product and requires a display.
2. How to install SQL Developer?
In a nutshell for Windows, the most popular OS platform for the product:
Installation Process For Windows 7 and higher (64-bit):
\1. Locate the download page for SQL Developer via Search Engine Keywords [ "sql developer" technetwork downloads ]
\2. For Windows 64-bit OSes, download the SQL Developer that comes with the JDK already included. This is the best choice for 64-bit windows since it is a self-contained unzipped folder with its own JDK ready to run. The included JDK has been pretested and certified with SQL Developer.
\3. Unzip that file and it will become a folder on your desktop or current download folder (just copy the unzipped folder to where you want it since that folder and subfolders are the product and its contents. Do not unzip it into "Program Files" nor into an existing legacy SQL Developer version-specific folder (e.g. do not unzip 17.4 into the folder for 17.3.1)
\4. Drill down into the folders until you see the sqldeveloper.exe file
\5. Double-click on that module and SQL Developer will come up.
\6. It will automatically find all previous connection info and ask to import it and/or the user can make new connections
3. What are the Support guidelines and limits for this "Free" product?
Official Oracle Support is available via the Oracle Database Licensing for our customers.
SQL Developer official Oracle Support is available via Service Requests (SRs) consisting of two areas:
Help with the installation process
Help configuring a connection to the database
and the special setup for advanced connections using Client Software
Bugging and testcase reproduction
Support will use customer test cases to verify and bug internally reproduced issues. Problems experienced in older versions are not fixed in legacy versions, therefore Development requires the latest OTN released version for bug test cases. There are no one-off fixes for this free product.
Oracle Tech Network
The OTN Forum is the best way to get help:
Search Engine Keywords [ "sql developer" technetwork forum ] then go to the Community tab and the Forum selection on that page.
For all "how to" type questions, the OTN forum exists for all users of the SQL Developer product - customers and non-customers.
4. Can SQL Developer connect to non-Oracle databases for migration purposes?
SQL Developer is intended to be used against Oracle databases and non-Oracle database connections are limited to current migrations from non-Oracle databases to Oracle databases.
5. Can I use the SQL Developer included with Oracle Database or Client Software products?
SQL Developer is included with the Oracle database and Client Software but is a release version that is older than the current version of the product. It can be used, but all problems must be reproduced using the current version of the software (as found on OTN), since all patches and enhancements only appear in the latest version - there is no one-off patching for this product.
6. How are patches and enhancements (new features) handled in SQL Developer?
The product has a new release schedule each quarter of the calendar year. (For example, release 17.4 is the 4th quarter of 2017.) All bug fixes and enhancements that have been incorporated into the code-base, as of the official release date for that quarter, will be included in the new release. To see if a bug or enhancement has been included, see the release notes and/or track the bugs via the MOS portal.
7. If there are no patches released for older versions, how are fixes for older versions implemented?
Always install the latest version of SQL Developer from OTN. The users can keep as many versions as required for archive, testing, and historical purposes (each in its own unique folder). Each installation is an unzip into a new folder for that version, so successive generations of the product can be kept in a primary folder on the user's desktop (or via any other archiving scheme).