WIXLIB

Installing and Starting SQL Developer For all other systems (Linux and Mac OS X systems, and Windows systems with noJDK release 7 or later installed), follow the instructions in Linux and Mac OS XSystems (page 1-5).1.2.1 Windows SystemsIf a Windows 64-bit SQL Developer kit that includes JDK 8 is available, you candownload and install that on a Windows 64-bit system, and SQL Developer will usethe embedded JDK that is provided with that kit.However, if you need or simply want to use a JDK on your Windows 64-bit system,you can install the JDK (if it is not already installed) and the Windows 32/64-bit SQLDeveloper kit, and SQL Developer will use the JDK that is installed on your system.Note:Do not install SQL Developer into an existing sqldeveloper folder. Eitherdelete the existing sqldeveloper folder first, or ensure that the new SQLDeveloper version is installed into a different location.To install on a Windows system, follow these steps:1.Go to the Oracle Technology Network page for SQL Developer at sql-developer/Note:If a Windows 64-bit SQL Developer kit that includes JDK 8 is available, youcan download and install that on a Windows 64-bit system, and SQLDeveloper will use the embedded JDK that is provided with that kit.However, if you need or simply want to use a JDK on your Windows 64-bitsystem, you can install the JDK (if it is not already installed) and the Windows32/64-bit SQL Developer kit, and SQL Developer will use the JDK that isinstalled on your system.2.If you do not need or want to install a suitable Java Development Kit (JDK 8 orlater), go to step 3. Otherwise, download and install the JDK as follows:a.On the SQL Developer Downloads page /sql-developer/downloads/index.html), click the Download link next to SQL Developer requires JDK8 or above.b.On the Java SE Development Kit 7 Downloads page, in the table of Java SEDevelopment Kits, accept the Oracle Binary Code License Agreement for JavaSE.c.Click the link for the download that you need (for example, the Windows x64link for a Windows 64-bit system).d.Save the file anywhere on your system (such as a "temp" folder).e.Install the JDK (for example, on Windows, double-click the .exe file name andfollow the displayed instructions).1-4 SQL Developer Installation Guide

Installing and Starting SQL Developer3.On the Oracle Technology Network page for SQL Developer at sql-developer/,click the Downloads tab (next to Overview).4.Read and accept the license agreement.5.Follow the instructions for downloading and installing SQL Developer.The installation itself is simple. For example, on a Windows PC you can unzip thedownloaded file into C:\, which will create C:\sqldeveloper with files and foldersin and under it.To start SQL Developer, go to the sqldeveloper directory under the SQL Developerinstallation directory (for example, on a Windows system this might be C:\sqldeveloper), and do one of the following: On Linux systems, type: sh sqldeveloper.sh On Windows systems, double-click sqldeveloper.exe.If you are asked to enter the full pathname for the JDK, click Browse and find it. Forexample, on a Windows system the path might have a name similar to C:\ProgramFiles\Java\jdk1.7.0 51.1.Unzip the SQL Developer kit into a folder (directory) of your choice, which will bereferred to as sqldeveloper install . Ensure that the Use folder namesoption is checked when unzipping the kit.Unzipping the SQL Developer kit causes a folder named sqldeveloper to becreated under the sqldeveloper install folder. For example, if you unzipthe kit into C:\, the folder C:\sqldeveloper is created, along with severalsubfolders under it.2.To start SQL Developer, go to sqldeveloper install \sqldeveloper,and double-click sqldeveloper.exe.If you are asked to enter the full pathname for the JDK, click Browse and find java.exe.For example, the path might have a name similar to C:\Program Files\Java\jdk1.7.0 51.After SQL Developer starts, you can connect to any database by right-clicking theConnections node in the Connections Navigator and selecting New Connection.Alternatively, if you have any exported connections (see Migrating Information fromPrevious Releases (page 1-7) or Uninstalling SQL Developer (page 1-12)), you canimport these connections and use them.You can learn about SQL Developer by clicking Help, then Table of Contents, andreading the help topics under SQL Developer Concepts and Usage.1.2.2 Linux and Mac OS X SystemsSQL Developer requires that JDK 8 or later be installed on the system, and Oraclerecommends that you install the latest available JDK version. If you need to install aJDK, go to loads/jdk7-downloads-1880260.html.Installing Oracle SQL Developer 1-5

Migrating User Settings from a Previous ReleaseNote:Do not install SQL Developer into an existing sqldeveloper directory.Either delete the existing sqldeveloper directory first, or ensure that thenew SQL Developer version is installed into a different location.Note:On Macintosh systems, a native Macintosh application in the formsqldeveloperxxx.tar.gz is provided. When it is expanded, it appears asa Macintosh application that can be put into the applications folder. If youchoose to expand this file, it will replace any older sqldeveloperapplications in that folder.To install and start SQL Developer, follow these steps:1.Unzip the SQL Developer kit into a directory (folder) of your choice. (Ensure thatthe Use folder names option is checked when unzipping the kit.) This directorylocation will be referred to as sqldeveloper install .Unzipping the SQL Developer kit causes a directory named sqldeveloper to becreated under the sqldeveloper install directory. It also causes manyfiles and directories to be placed in and under that directory.2.To start SQL Developer, go to the sqldeveloper directory under the sqldeveloper install directory, and run sh sqldeveloper.sh.After SQL Developer starts, you can connect to any database by right-clicking theConnections node in the Connections Navigator and selecting New Connection.Alternatively, if you have any exported connections (see Migrating Information fromPrevious Releases (page 1-7) or Uninstalling SQL Developer (page 1-12)), you canimport these connections and use them.You can learn about SQL Developer by clicking Help, then Table of Contents, andreading the help topics under SQL Developer Concepts and Usage.1.3 Migrating User Settings from a Previous ReleaseThe first time you start SQL Developer after installing it or after adding anyextensions, you are asked if you want to migrate your user settings from a previousrelease. (This occurs regardless of whether there was a previous release on yoursystem.)These settings refer to database connections, reports, and certain SQL Developer userpreferences that you set in a previous version by clicking Tools and then Preferences.However, some user preferences are not saved, and you must respecify these using thenew release.To migrate user settings from a previous SQL Developer release:1. Unzip the kit for the current release so as to create a new sqldeveloperdirectory.2. When you start the SQL Developer current release, click Yes when asked if youwant to migrate settings from a previous release.1-6 SQL Developer Installation Guide

Migrating Information from Previous Releases3. In the dialog box that is displayed, you can accept the default option to migrate thesettings from the most recent SQL Developer installation. Or, if you want tomigrate the settings from an earlier installation, you can click to show all buildsand then select the desired one.See also Migrating Information from Previous Releases (page 1-7).1.4 Migrating Information from Previous ReleasesIf you have used a previous release of SQL Developer, you may want to preservedatabase connections that you have been using. To preserve database connections,save your existing database connections in an XML file. To save the connections, rightclick the Connections node in the Connections Navigator and select ExportConnections. After you complete the installation described in this guide, you can usethose connections by right-clicking the Connections node in the ConnectionsNavigator and selecting Import ConnectionsIf you want to use any user-defined reports or the SQL history from a previousversion, see Location of User-Related Information (page 1-7) for information aboutwhere these are located. If you have user-defined reports and SQL history fromRelease 1.0, they are modified by any later SQL Developer release to a format that isdifferent from and incompatible with Release 1.0.SQL Developer preferences (specified by clicking Tools and then Preferences) from aprerelease version of the current release cannot currently be saved and reused; youmust respecify any desired preferences.Note:If you want to uninstall your prerelease version of SQL Developer beforeinstalling this release, see Uninstalling SQL Developer (page 1-12).1.5 Location of User-Related InformationSQL Developer stores user-related information in several places, with the specificlocation depending on the operating system and certain environment specifications.User-related information includes user-defined reports, user-defined snippets, SQLWorksheet history, code templates, and SQL Developer user preferences. In mostcases, your user-related information is stored outside the SQL Developer installationdirectory hierarchy, so that it is preserved if you delete that directory and install a newversion.The user-related information is stored in or under the IDE USER DIR environmentvariable location, if defined; otherwise as indicated in Table 1-4 (page 1-7), whichshows the typical default locations (under a directory or in a file) for specific types ofresources on different operating systems. (Note the period in the name of anydirectory named .sqldeveloper.)Table 1-4Default Locations for User-Related InformationResource TypeSystem (Windows, Linux, or Mac OS X)User-definedreportsWindows: C:\Documents and Settings\ user-name \Application Data\SQL Developer\UserReports.xmlLinux or Mac OS X: /.sqldeveloper/UserReports.xmlInstalling Oracle SQL Developer 1-7

Database Certification for SQL Developer (Oracle and Third-Party)Table 1-4(Cont.) Default Locations for User-Related InformationResource TypeSystem (Windows, Linux, or Mac OS X)User-definedsnippetsWindows: C:\Documents and Settings\ user-name \Application Data\SQL Developer\UserSnippets.xmlLinux: /.sqldeveloper/UserSnippets.xmlMac OS X: /Users/ Your user /Library/Application Support/SQLDeveloper/UserSnippets.xmlSQL historyWindows: C:\Documents and Settings\ user-name \Application Data\SQL Developer\SqlHistory.xmlLinux: /.sqldeveloper/SqlHistory.xmlMac OS X: /Users/ Your user /Library/Application Support/SQLDeveloper/ SqlHistory.xmlCode templatesWindows: C:\Documents and Settings\ user-name \Application Data\SQL Developer\ CodeTemplate.xmlLinux: /.sqldeveloper/CodeTemplate.xmlMac OS X: /Users/ Your user /Library/Application Support/SQLDeveloper/ CodeTemplate.xmlSQL DeveloperuserpreferencesWindows: C:\Documents and Settings\ user-name \Application Data\SQL Developer\systemn.n.n.n.nLinux or Mac OS X: /.sqldeveloper/systemn.n.n.n.nIf you want to prevent other users from accessing your user-specific SQL Developerinformation, you must ensure that the appropriate permissions are set on the directorywhere that information is stored or on a directory above it in the path hierarchy. Forexample, on a Windows system you may want to ensure that the SQL Developerfolder and the \ user-name \Application Data\SQL Developer folder underDocuments and Settings are not sharable; and on a Linux or Mac OS X systemyou may want to ensure that the /.sqldeveloper directory is not world-readable.1.6 Database Certification for SQL Developer (Oracle and Third-Party)This section describes Oracle and non-Oracle (third-party) databases that are certifiedfor use with SQL Developer.Table 1-5 (page 1-8) lists the Oracle database certifications.Table 1-5Oracle Database Certification for SQL DeveloperProductReleasesOracle DatabaseOracle10gOracle11gOracle12cOracle Database Express EditionRelease 11.2SQL Developer can be used to view metadata and data of several non-Oracle (thirdparty) databases. Table 1-6 (page 1-9) lists the third-party database certifications.1-8 SQL Developer Installation Guide

Advanced Security for JDBC Connection to the DatabaseTable 1-6Non-Oracle (Third-Party) Database Certification for SQL DeveloperDatabaseReleasesNotesIBM DB2DB2 UDBFor any DB2 release: db2jcc.jar and db2jcc license cu.jarfiles required; available from IBM.DB2 7.xDB2 8.xDB2 9.xMicrosoft SQLServerSQL Server 7SQL Server 2000SQL Server 2005SQL Server 2008MySQLMySQL 3.xMySQL 4.xMySQL 5.xSybaseAdaptive ServerSybase 12TeradataTeradata 12Sybase 15Teradata 13For any Microsoft SQL Server release: JDBC driverjtds-1.2.jar required; included in jtds-1.2-dist.zipavailable from sourceforge.net; also available throughHelp, Check for Updates.For any MySQL release: JDBC driver required. ForMySQL 5.x: mysql-connector-java-5.0.4-bin.jar, which isincluded in mysql-connector-java-5.0.4.zip; alsoavailable through Help, Check for Updates. (Do not usethe latest MySQL driver 5.1.)For any Sybase Adaptive Server release: JDBC driverjtds-1.2.jar required; included in jtds-1.2-dist.zipavailable from sourceforge.net; also available throughHelp, Check for Updates.JDBC driver files tdgssconfig.jar and terajdbc4.jarrequired; included (along with a readme.txt file) in theTeraJDBC indep indep.12.00.00.110.zip orTeraJDBC indep indep.12.00.00.110.tar download.Note:If you need to use SQL Developer to migrate a Microsoft Access database. usethe previous version of SQL Developer (4.0.3) and the 32-bit version of theJava 7 JDK.For information about creating and using connections to third-party databases, see theinformation about database connections in the SQL Developer online help or OracleSQL Developer User's Guide.1.7 Advanced Security for JDBC Connection to the DatabaseYou are encouraged to use Oracle Advanced Security to secure a JDBC connection tothe database. Both the JDBC OCI and the JDBC Thin drivers support at least some ofthe Oracle Advanced Security features. If you are using the OCI driver, you can setrelevant parameters in the same way that you would in any Oracle client setting. TheJDBC Thin driver supports the Oracle Advanced Security features through a set ofJava classes included with the JDBC classes in a Java Archive (JAR) file and supportssecurity parameter settings through Java properties objects.For more information about using Oracle Advanced Security, see Oracle Database JDBCDeveloper's Guide.Installing Oracle SQL Developer 1-9

Finding SQL Developer Accessibility Information1.8 Finding SQL Developer Accessibility InformationFor the latest configuration information or for information on addressing accessibilityand assistive technology issues, see the Oracle Accessibility FAQ at aqs/.Also, check the SQL Developer release notes (readme.txt file) to see if there are anycurrently known issues regarding accessibility.1.9 Using a Screen Reader and Java Access Bridge with SQL DeveloperNote:Unless otherwise indicated, the information is this section also applies to DataModeler and Data Miner.To make the best use of our accessibility features, Oracle Corporation recommends thefollowing minimum configuration: Windows XP, Windows Vista Java 7 Update 6Java 7 Update 6 includes the Java Access Bridge. For more information, includinghow to enable the Java Access Bridge, see: ava se 7 update 6However, if you are using Java J2SE 1.6.0 24 or higher but before Java 7 Update 6,you must manually install Java Access Bridge 2.0.2 after you install the screenreader (if it is not already installed). Download Java Access Bridge for Windowsversion 2.0.2. The file you will download is accessbridge-2 0 2-fcs-binb06.zip. It is available from: /index-jsp-136191.html (Refer to the Java Access Bridgedocumentation avai

Database Certification for SQL Developer (Oracle and Third-Party) (page 1-8) Advanced Security for JDBC Connection to the Database (page 1-9) Finding SQL Developer Accessibility Information (page 1-10) Using a Screen Reader and Java Access Bridge with SQL Developer (page 1-10)