WIXLIB

Installing and Starting SQL DeveloperTo install on a Windows system, follow these steps:1.Go to the Oracle Technology Network page for SQL Developer s/sql-developer/Note: If a Windows 64-bit SQL Developer kit that includes JDK 7 isavailable, you can download and install that on a Windows 64-bitsystem, and SQL Developer will use the embedded JDK that isprovided with that kit.However, if you need or simply want to use a JDK on your Windows64-bit system, you can install the JDK (if it is not already installed) andthe Windows 32/64-bit SQL Developer kit, and SQL Developer willuse the JDK that is installed on your system.2.If you do not need or want to install a suitable Java Development Kit (JDK 7 orlater), go to step 3. Otherwise, download and install the JDK as follows:a.On the SQL Developer Downloads ools/sql-developer/downloads/index.html), click the Download link next to SQL Developerrequires JDK 7 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).3.On the Oracle Technology Network page for SQL Developer s/sql-developer/, clickthe 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 folders inand under it.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 names optionis 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 unzip thekit into C:\, the folder C:\sqldeveloper is created, along with several subfoldersunder it.2.To start SQL Developer, go to sqldeveloper install \sqldeveloper, anddouble-click sqldeveloper.exe.1-4 Oracle Database SQL Developer Installation Guide

Installing and Starting SQL DeveloperIf 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:\ProgramFiles\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 Section 1.4 or Section 1.10),you can import 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 7 or later be installed on the system, and Oraclerecommends that you install the latest available JDK version. If you need to install aJDK, go wnloads/jdk7-downloads-1880260.html.Note: Do not install SQL Developer into an existing sqldeveloperdirectory. Either delete the existing sqldeveloper directory first, orensure that the new SQL Developer version is installed into a differentlocation.Note: On Macintosh systems, a native Macintosh application in theform sqldeveloperxxx.tar.gz is provided. When it is expanded, itappears as a Macintosh application that can be put into theapplications folder. If you choose to expand this file, it will replaceany older sqldeveloper applications 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 many files anddirectories 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 Section 1.4, "MigratingInformation from Previous Releases" or Section 1.10, "Uninstalling SQL Developer"),you can import 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.Installing Oracle SQL Developer 1-5

Migrating User Settings from a Previous Release1.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 sqldeveloper directory.2.When you start the SQL Developer current release, click Yes when asked if youwant to migrate settings from a previous release.3.In the dialog box that is displayed, you can accept the default option to migratethe settings 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 Section 1.4, "Migrating Information from Previous Releases".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,right-click 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 Section 1.5 for information about where these are located. If you haveuser-defined reports and SQL history from Release 1.0, they are modified by any laterSQL Developer release to a format that is different from and incompatible with Release1.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 SQLDeveloper before installing this release, see Section 1.10, "UninstallingSQL Developer".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 most cases,your user-related information is stored outside the SQL Developer installation1-6 Oracle Database SQL Developer Installation Guide

Database Certification for SQL Developer (Oracle and Third-Party)directory 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, which shows thetypical default locations (under a directory or in a file) for specific types of resourceson different operating systems. (Note the period in the name of any directory 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\SQLDeveloper\UserReports.xmlLinux or Mac OS X: Windows: C:\Documents and Settings\ user-name \ApplicationData\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\SQLDeveloper\SqlHistory.xmlLinux: /.sqldeveloper/SqlHistory.xmlMac OS X: /Users/ Your user /Library/Application Support/SQLDeveloper/ SqlHistory.xmlCode templatesWindows: C:\Documents and Settings\ user-name \ApplicationData\SQL Developer\ CodeTemplate.xmlLinux: /.sqldeveloper/CodeTemplate.xmlMac OS X: /Users/ Your user /Library/Application Support/SQLDeveloper/ CodeTemplate.xmlSQL Developeruser preferencesWindows: C:\Documents and Settings\ user-name \ApplicationData\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 Developer folderand the \ user-name \Application Data\SQL Developer folder under Documentsand Settings are not sharable; and on a Linux or Mac OS X system you may want toensure 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 lists the Oracle database certifications.Installing Oracle SQL Developer 1-7

Advanced Security for JDBC Connection to the DatabaseTable 1–5Oracle Database Certification for SQL DeveloperProductReleasesOracle DatabaseOracle10gOracle11gOracle12cOracle Database Express Edition Release 11.2SQL Developer can be used to view metadata and data of several non-Oracle(third-party) databases. Table 1–6 lists the third-party database certifications.Table 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 Access Access 97Access 2000For any Access release: no JDBC driver needed, but youmust ensure read access to system tables in the .mdb file.Access XP (2002)Access 2003Access 2007Microsoft SQLServerSQL Server 7For any Microsoft SQL Server release: JDBC driverjtds-1.2.jar required; included in jtds-1.2-dist.zipSQL Server 2000available from sourceforge.net; also available throughSQL Server 2005 Help, Check for Updates.SQL Server 2008MySQLMySQL 3.xMySQL 4.xMySQL 5.xFor 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; also availablethrough Help, Check for Updates. (Do not use the latestMySQL driver 5.1.)Sybase Adaptive Sybase 12ServerSybase 15For 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.TeradataJDBC driver files tdgssconfig.jar and terajdbc4.jarrequired; included (along with a readme.txt file) in theTeraJDBC indep indep.12.00.00.110.zip or TeraJDBCindep indep.12.00.00.110.tar download.Teradata 12Teradata 13For 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 set1-8 Oracle Database SQL Developer Installation Guide

Using a Screen Reader and Java Access Bridge with SQL Developerrelevant 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.1.8 Finding SQL Developer Accessibility InformationFor the latest configuration information or for information on addressing accessibilityand assistive technology issues, see the Oracle Accessibility FAQ /faqs/.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 alsoapplies to Data Modeler 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, ry/java 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 02-fcs-bin-b06.zip. It is available /tech/index-jsp-136191.html (Refer to the Java Access Bridge documentation available from this website formore information about installation and the Java Access Bridge.) JAWS 12.0.522Follow these steps to set up a screen reader and Java Access Bridge.1.Install the screen reader, if it is not already installed.Refer to the documentation for your screen reader for more information aboutinstallation.2.Install SQL Developer.3.If you are using Java J2SE 1.6.0 24 or higher but before Java 7 Update 6, go toSection 1.9.1, "If You Need to Install Java Access Bridge" and follow theinstructions there.4.Start your screen reader.5.Start SQL Developer by running the file sqldeveloper.exe located in the folder sqldev home \sqldeveloper\sqldev\bin.Installing Oracle SQL Developer 1-9

Using a Screen Reader and Java Access Bridge with SQL DeveloperThe preceding steps assume you are running Windows and using a Windows-basedscreen reader. A console window that contains error information (if any) will open firstand then the main SQL Developer window will appear, after SQL Developer hasstarted. Any messages that appear will

This guide provides information for those installing the Oracle SQL Developer tool on Windows, Linux, and Mac OS X systems. Audience This guide is intended for those who need to install the Oracle SQL Developer tool. Documentation Accessibility For information about Oracle's commitment to accessibility, visit the Oracle