Introduction In this content, you'll learn how to downIoad, install, and arranged up an Oracle database, therefore that you can begin running SQL queries on your personal pc. Why perform you require these directions?
- Oracle 11g Download Linux
- Oracle Express 11g Download For Mac
- Oracle Xe 11g Download For Mac
- Oracle Database 11g For Mac Download
I have been trying to download Oracle Database 11g release 2 for mac os but in the given link by oracle I can only see Linux x86 and Linux x86-64. Is this ok to use this Linux file for installing. 2- Download Oracle 11g 3- Installing Oracle 11g on Windows 4- Check the installation and install the expansion 4.1- Oracle DB Console 4.2- SQL Plus 4.3- Create new Database 5- Visualization tools to work with Oracle.
How to install Oracle Instant Client Version 12.1.0.2 (64-bit) on a Mac (OS X 10.11.5) I have downloaded version 12.1.0.2 (64-bit) version and unzipped the file. I now have the following files under /downloads/instantclient. The last release of Oracle server for the Mac is version 10. To run 11g you need a VM. I use VMWare, which costs money, but Oracle VirtualBox is free.
Isn'capital t it simply as easy as download, install, and run? Properly, it's not really that right ahead when setting up up an Oracle database. Even if you're also using Oracle Show, which is usually Oracle's edition of their databasé that you cán make use of yourself and the one that I'michael detailing in this information.
There are usually a several factors to watch out fór - which I'Il cover up. Furthermore, Oracle'h website can end up being very confusing. Specifically if you've never ever down loaded anything from generally there before. So, with these instructions, you should end up being capable to obtain Oracle Express running on your personal computer without as well much difficulty. At the period of composing, you can operate Oracle on Windows and Linux devices. There will be no Mac pc version accessible.
How to Download and Set Up Oracle Express 11g. Select 'Oracle Database 11g Express. This is because while you can't install the Oracle database on a Mac. Oracle 11g for mac free download - Apple Mac OS Update 8.6, Apple Mac OS Update 9.0.4, Apple DVD Player Update, and many more programs. Oracle Database 12c download. full free Crack: Oracle Database 12c Download (Oracle Database XE) is a small entry-level database based on Oracle Database 11g Release 2. Oracle 11g free download. SQLTools for Oracle SQLTools is a light weight and robust frontend for Oracle database development. This program is not.
The only method that I understand of to operate Oracle on a Macintosh can be to use a digital machine like as ParaIlels, but ás it's i9000 not really something I've performed, I received't consist of the methods here. Summary The steps we will protect in this tutorial are:. Download and install Oracle client (or Oracle Show, which is definitely the real database). Download and set up Coffee JDK (which is certainly required to operate the development tool). Download and install SQL Developer (which is definitely used to operate SQL concerns). Create a link in SQL Designer (to permit you to run concerns on your set up Oracle database) I gained't be covering how to understand SQL in this write-up, but that would become the following stage to get, if you wear't understand SQL.
Browse Downloads by Product. Java download for mac os x 10.4 11.
Allow's obtain started! Phase 1 - Download Oracle Customer (Oracle Show) The initial step is definitely to download the Oracle customer. This is the real database software program that runs and manages the database. Oracle Express can be a version produced by Oracle thát you can downIoad for free of charge for your own make use of. It will possess some limitations, but it should become more than enough for your own schooling and smaller sized projects.
To begin with, go to the Oracle internet site. Hover over the Downloads menu product at the top of the web page. Choose ' Oracle Database 11g Express Edition'. The download web page will appear. To be capable to download the hyperlink, you'll want to acknowledge the license agreement.
Read that by clicking on the hyperlink, and after that click Accept License Agreement. Select the relevant download for your operating program. If you're also working a 64-bit edition of Home windows, choose the 'Oracle Data source Express Copy 11g Launch 2 for Home windows back button64' document. If you're working a 32-bit edition of Windows, choose the 'Oracle Data source Express Edition 11g Launch 2 for Windows x32' file. If you're also operating Linux, then select the 'Oracle Data source Express Version 11g Discharge 2 for Linux times64' document. If you're not sure which version of Home windows you're running, move to the Begin button, right click on My Computer, and go for Attributes.
This will provide up the Program screen in the Control panel. You can furthermore right click on My Computer within Home windows Explorer and select Qualities to obtain to the exact same display.
In the middle of the display, you'll notice a Program Type tag, and following to it will say either 32-bit or 64-bit Operating Program. Once you click on the correct edition of the Oracle download file, you'll be motivated with a Sign in screen. If you possess an accounts, then get into your details.
If you wear't possess an account (which, if you're also setting up Oracle for the first period, you most likely wear't), click Create Accounts on the ideal. Fill out your details and click Create Account at the bottom level. You don't need to verify the 'Okay, send me emaiIs on Oracle Próducts, Services and Evénts' if you dón't want tó. Once you have got your accounts made, you should be presented with the file download box.
If not, you can record in with your new account details and stick to the tips above to move back again to the download hyperlink. Save the file (which is definitely called 'OracleXE112Win64' or equivalent. This can be the archive document that you draw out and install from. The file will then be downloaded. Now, we require to extract and install the file. Phase 2 - Install Oracle Express To set up Oracle Express from the downloaded file, proceed to the location where you've down loaded it.
Get the document to a place of your option. The procedure for doing this will rely on what acrhive plan you use (7zip, WinZip, WinRAR), but usually you begin by openning the Diddly file. Choose a area to get it to on your difficult travel, and click on Extract. As soon as the remove has finished, proceed to the place you removed to. Open up the Disc1 folder and run set up.exe It should end up being the just document in the foIder. An installer sorcerer will appear up and begin preparing.
Once it has prepared, click on Next. Read and acknowledge the Terms and Problems. On the Choose Destination Location page, guarantee you possess enough space to set up it to the default location. You put on't need to alter the place, but if you want to, you can here. Usually, click Next.
Today, this is usually an essential step. Here, you identify the database password, to end up being used for two system accounts - SYS and SYSTEM. You should choose a safe password, and one thát you'll rémember. You'll want to enter this password afterwards in this process when you log in to thé Oracle database - therefore don't overlook it. Enter the password double, and click Next. Click Install on the last display screen.
The set up will consider a several minutes. As soon as it's completed, click the Finish switch. Phase 3 - Download JDK The following step is usually to download thé JDK or Java JDK as it'h also recognized. JDK stands for Java Development Kit, and you'll need to operate SQL Designer, which is definitely the tool used to run SQL inquiries that we'll be installing next. To install the JDK, proceed back again to the Oracle web site.
Hover over the Downloads menu item and click Java for Designers. On the Coffee SE Downloads web page, click on the Java Platform JDK key. It should be the one on the left. Once once again, you'll need to learn and accept the license contract to continue. If you don't accept, a message will put up when you test to download the file and prvent yóu from downloading.
Aftér you've performed that, choose the right version for your operating system. Focus on the ' Coffee SE Development Package' area, not really on the 2nd section (which provides sample downloads that you put on't want). If you're running Home windows, you should select either the 32 little bit or 64 bit version. If you're also operating Linux, you possess several options here as well. Once you click on the hyperlink, you'll be asked to save the document.
Conserve it to your personal computer. Action 4 - Install the JDK Right now that you've downloaded the document, the following part is definitely to install it. This is definitely pretty straight ahead, but I'll run through the methods anyway. Open the JDK document you downloaded above. If a security warning seems, click Run. On the pleasant screen, click on Next. On the Functions page, click on Next simply because well.
The default settings are usually OK. The JDK will now be set up. This stage can take a few of mins as nicely.
As soon as that has finished, another set up route may be asked for for the JRE. This is definitely the Java Runtime Atmosphere, which can be another component of Coffee you'll need. Click Next on this display. The following component will after that be installed, which may consider a couple of moments. Once the set up has finished, click Close. Action 5 - Download Oracle SQL Builder Alright, we're right now up to the last piece of software program to download.
SQL Developer is definitely a tool developed by Oracle that enables you write SQL questions against the 0racle database. To downIoad it, move back again to the Oracle web site. Hover over the Downloads menu product and click SQL Builder. Once once again, you'll want to go through and acknowledge the license agreement to move forward. Select the appropriate file based on your operating system. You might notice that there is a Mac pc version shown here, even though Oracle is certainly not obtainable for Mac pc.
This can be because while yóu can't install the Oracle database on a Mac, you can still operate SQL Creator to link to directories on other computers or web servers using other operating techniques. It's not restricted to simply linking to your very own computer. Once you click on the document you need, choose a area for the file and click Save. Stage 6 - Fixed Up Oracle SQL Programmer After the SQL Programmer file offers finished downloading, open the file.
This action is various to the previous measures as you put on't need to set up SQL Developer, you simply need to unzip and operate it. So, now you've opened up the document, extract it to the area you would like. This can be where the file will become operate from, so you may want to remove it to Plan Data files or something to end up being consistent. As soon as it provides extracted, proceed to the foIder that you removed it to. Run ' sqldeveloper.exe'.
The system will inquire for the route to coffee.exe. This will be something you set up earlier in the procedure. To discover the path, click on Search, and go to the location it had been set up to. The location will be something like this: C: Plan Files Java jdk1.7.025 bin When you're in the right folder, the java.exe document should end up being visible. Click on on that to select it and click Okay. You might obtain a message saying that the Java version is usually not qualified. This can be usually due to the truth that the SQL Builder has not been up to date to match the most recent Java edition.
I've become this information before and had no troubles with making use of SQL Creator, therefore if you get it, simply click Yes to proceed. SQL Creator will then begin. The Document Type Associations dialog box will appear. You put on't need to choose any of thése, but if yóu wish to have these file types open in SQL Designer, then examine the containers.
SQL Creator is now set up and prepared to move. The last step is certainly to set up a link to your database.
Phase 7 - Produce a Connection in Oracle SQL Creator You've obtained SQL Programmer running, mainly because properly as your Oracle database. Today you just need to connect the two. Click on the natural plus icon on the top still left of the screen, under the Cable connections tabs in the sidébar. The New Database Connection window will appear.
Enter the following details into the home window: Link Name: Something that you can determine it. I generally use 'Regional' Username: program Password: The security password you joined during the install procedure (ideally you appreciated it!) Save Password: Checked Link Kind: Basic Part: Default Hostname: localhost Interface: 1521 SID: xe Once you've came into that info, click Test. The Status in the bottom level remaining should say Achievement. If it doesn't, ensure you've inserted the right details, and have Oracle running.
If it still doesn't function, restart your computer and try out again. Once the check is successful, click Connect. A link called Local (or whatever you called it) will show up in the sidébar, and a new SQL home window will appear in the main section. This is certainly where you enter your queries. To check it, enter a example question. You can test this one: SELECT ' A' FROM DUAL; Press N9, or click on on the natural Have fun with triangle in the home window, to run the concern.
The result will show up at the underside of the screen. You have got now installed Oracle Express and Oracle SQL Designer on your computer! Right now it's prepared to be utilized for your SQL concerns. Background 11/4/15 - Preliminary version.
Oracle Data source 12c Download Total Free Break: Oracle Data source 12c Download (Oracle Database XE) is definitely a little entry-level database centered on Oracle Database 11g Discharge 2. It is usually free of charge to create, set up and disperse; quick to download; and easy to administer With Oracle Data source 12c Split, you can now create and deploy programs with a confirmed high-performance infrastructure and, if essential, improve without complex and costly migrations. Oracle Data source 12c Serial Key can become set up on any CPU dimension (a database by personal computer), but XE stores up to 11 Gigabyte of consumer data, utilizes up to 1 GB of memory space and utilizes a web host computer processor chip.
Oracle Data source 12c Discharge 2 Evaluation: Oracle Data source Download will be a helpful and effective database designed to supply sources to develop, apply and deploy applications. The advancement and administration of directories are actions that are usually for experts. And for like tasks, professionals require a effective tool, such as Oracle Database 12c Total Break, which focuses on producing and directories and associated applications.
Oracle Database 12c Download for linux provides an intuitive user that allows the consumer to notice the status of the storage currently used, the database ánd the startup settings. To create the items in the database, a user is set up and set up. It is usually a job that is certainly performed from the control collection. In general, Oracle Download For home windows 7 will be a really specialized benchmark tool.You can furthermore download here. Oracle Database XE can be an fantastic begin database for:.
Programmers work on Node.js, Python, Java,NET, XML and open up source programs. Database managers who require a free of charge database for training and execution. Independent software program vendors (ISV) and hardware suppliers who want to share a free-bóot database. Educational organizations and college students who require a free database for their study program Key Functions of Oracle Database 12c: These are usually some of the great functions you will find after downloading Oracle Data source 12c Launch 2 for free of charge. The practical and effective database created to enable the co-development, distribution, and execution of programs. Have an intuitive user interface. It enables you to see the present status of the storage, the initialization settings, and the database classes.
System specifications for Oracle Database 12c Launch 2: Before starting Oracle Data source 12c Release 2, make certain your personal computer fulfills the minimal system requirements. Operating program: Windows XP / Vista / 7/8 / 8.1 / 10. Memory (RAM): 1 Gigabyte of Memory is required. Area on the difficult storage: 400 MB of free of charge space is usually required.
Processor: Intel dual-core processor chip or increased. How to DownIoad and Install?. DownIoad and Install thé Programme. Wear't run again if the setup is running.
After the installation run the break setup for a full version. Down load link is here.
Data source Oracle Database Online Paperwork 11 gary the gadget guy Launch 2 (11.2) Installing and Upgrading Installation manuals for Oracle Database 11 gary the gadget guy and accompanying items on numerous platforms are collected right here. Full Set up Guides describe a wider range of situations with more detail.
Customer Installation Instructions describe installing Oracle database customer software on owners where the database server is not installed. Supplementary Set up Guides describe installing items that are incorporated with the database but installed separately.
Note:
This guide assumes that you plan to download the SQL Developer kit (.zip) file and install it as a freestanding tool.If you plan to use SQL Developer as part of the Oracle Database release 11 installation, see the Oracle Database installation documentation.
Please read the information in this chapter before you install Oracle SQL Developer. This chapter contains the following major sections:
1.1 SQL Developer System Recommendations
This section describes the recommended minimum values for CPU, memory, display, disk storage, and other resources on the supported systems.
Note:
If you attempt to use SQL Developer with a Java SDK version 1.7 or higher, a warning message in this form is displayed: 'Java version 1.7.n_nn has not been certified. Only Java versions less than 1.7 are certified. Continue anyway?' However, if you click Yes to continue, an error is displayed.Instead, if you use a Java SDK, use version 1.6.nn where nn is 11 or higher.
Table 1-1 Recommendations for Windows Systems
Resource | Recommended Minimum Value |
---|---|
Operating System | Windows XP-Service Pack 2 Windows 2003 R2 Windows Vista Windows Server 2008 Windows 7 |
CPU Type and Speed | Pentium IV 2 GHz MHz or faster |
Memory | 1 GB RAM |
Display | 65536 colors, set to at least 1024 X 768 resolution |
Hard Drive Space | 42 MB if you already have JDK 1.6.11 or later (but do not use 1.7.n) 110 MB if you do not have JDK 1.6.11 or later (but do not use 1.7.n) |
Java SDK | JDK 1.6.11 or later (but do not use 1.7.n) for Windows, available at: http://www.oracle.com/technetwork/java/javase/downloads/ . If you do not have a suitable SDK installed, you can use SQL Developer, but you must download and install the SQL Developer for Windows kit that includes a JDK. |
Table 1-2 Recommendations for Linux Systems
Resource | Recommended Minimum Value |
---|---|
Operating System | Red Hat Enterprise Linux 3.0 Fedora Core 4 |
CPU Type and Speed | Pentium IV 2 GHz or faster |
Memory | 1 GB RAM |
Display | 65536 colors, set to at least 1024 X 768 resolution |
Hard Drive Space | 110 MB |
Java SDK | JDK 1.6.11 or later (but do not use 1.7.n) for Linux, available at: http://www.oracle.com/technetwork/java/javase/downloads/ |
Table 1-3 Recommendations for Mac OS X Systems
Oracle 11g Download Linux
Resource | Recommended Minimum Value |
---|---|
Operating System | Apple Mac OS X Version 10.4.x |
CPU Type and Speed | Dual 1.25 GHz G4/G5 (1 GHz G4 minimum) |
Memory | 1.5 GB RAM (1 GB minimum) |
Display | 'Thousands' of colors |
Hard Drive Space | 110 MB |
Java SDK | JDK 1.6.11 or later (but do not use 1.7.n) |
1.2 Installing and Starting SQL Developer
This section contains subsections with instructions for installing SQL Developer on all supported systems.
SQL Developer does not require an installer. To install SQL Developer, you will need an unzip tool. You can download a free, cross-platform unzip tool, Info-Zip, available at
http://www.info-zip.org/
.Important:
Do not install SQL Developer into any existing ORACLE_HOME
. You will not be able to uninstall it using Oracle Universal Installer.Important:
If you are using a prerelease (Early Adopter) version of SQL Developer, and if you want to be able to continue to use this prerelease version after installing the official release kit, you must unzip the official release kit into a different directory than the one used for the prerelease version.If Oracle Database (Release 11 or later) is also installed, a version of SQL Developer is also included and is accessible through the menu system under Oracle. This version of SQL Developer is separate from any SQL Developer kit that you download and unzip on your own, so do not confuse the two, and do not unzip a kit over the SQL Developer files that are included with Oracle Database. Suggestion: Create a shortcut for the SQL Developer executable file that you install, and always use it to start SQL Developer.
For Windows systems, there are two kits: one for systems on which the Java SDK release 1.6.11 or later (but do not use 1.7.n) is installed, and another for systems with no Java SDK or a Java SDK release earlier than 1.6.11. Be sure to download the appropriate kit.
Before you install SQL Developer, look at the remaining sections of this guide to see if you need to know or do anything else first.
The steps for installing SQL Developer depend on whether or not you will be using it on a Windows system that does not have the Java SDK release 1.6.11 or later installed:
- For a Windows system with the Java release 1.6.11 or later installed, follow the instructions in Section 1.2.1.
- For all other systems (Linux and Mac OS X systems, and Windows systems with no Java SDK or a Java SDK release earlier than 1.6.11 or later installed), follow the instructions in Section 1.2.2.
1.2.1 Windows Systems with JDK1.6.11 or Later
To install and start SQL Developer on a Windows system on which the Java J2SE JDK 1.6.11 or later (but do not use 1.7.n) is installed, follow these steps:
- Unzip the SQL Developer kit into a folder (directory) of your choice (for example,
C:Program Files
). This folder will be referred to as<sqldeveloper_install>
.Unzipping the SQL Developer kit causes a folder namedsqldeveloper
to be created under the<sqldeveloper_install>
folder (for example,C:Program Filessqldeveloper
). It also causes many files and folders to be placed in and under that directory. - To start SQL Developer, go to <sqldeveloper_install>
sqldeveloper
, and double-clicksqldeveloper.exe
.
If you are asked to enter the full pathname for java.exe, click Browse and find java.exe. For example, the path might have a name similar to
C:Program FilesJavajdk1.6.0_25binjava.exe
.After SQL Developer starts, you can connect to any database by right-clicking the Connections 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, and reading the help topics under SQL Developer Concepts and Usage.
1.2.2 Linux and Mac OS X Systems, and Windows Systems without JDK 1.6.11 or Later
SQL Developer requires that the Java JDK 1.6.0_11 or later (but not 1.7.n) be installed on the system, or that you install a SQL Developer for Windows kit that includes a JDK. If you need to install a JDK, go to
http://www.oracle.com/technetwork/java/javase/downloads/
.Note:
On Macintosh systems, a native Macintosh application in the form sqldeveloper
xxx
.tar.gz
is provided. When it is expanded, it appears as a Macintosh application that can be put into the applications
folder. If you choose to expand this file, it will replace any older sqldeveloper
applications in that folder.To install and start SQL Developer, follow these steps:
- Unzip the SQL Developer kit into a directory (folder) of your choice. This directory location will be referred to as
<sqldeveloper_install>
.Unzipping the SQL Developer kit causes a directory namedsqldeveloper
to be created under the<sqldeveloper_install>
directory. It also causes many files and folders to be placed in and under that directory. - To start SQL Developer, go to the
sqldeveloper
directory under the<sqldeveloper_install>
directory, and do one of the following, as appropriate for your operating system:On Linux and Mac OS X systems, run sh sqldeveloper.sh.On Windows systems, double-clicksqldeveloper.exe
.
After SQL Developer starts, you can connect to any database by right-clicking the Connections node in the Connections Navigator and selecting New Connection. Alternatively, if you have any exported connections (see Section 1.4, 'Migrating Information 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, and reading the help topics under SQL Developer Concepts and Usage.
1.3 Migrating User Settings from a Previous Release
The first time you start SQL Developer after installing it or after adding any extensions, you are asked if you want to migrate your user settings from a previous release. (This occurs regardless of whether there was a previous release on your system.)
These settings refer to database connections, reports, and certain SQL Developer user preferences 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 the new release.
To migrate user settings from a previous SQL Developer release:
- Unzip the kit for the current release into an empty directory (folder). Do not delete or overwrite the directory into which you unzipped the kit for the previous SQL Developer release.
- When you start the SQL Developer current release, click Yes when asked if you want to migrate settings from a previous release.
- In the dialog box that is displayed, you can accept the default option to migrate the settings from the most recent SQL Developer installation. Or, if you want to migrate the settings from an earlier installation, you can click to show all builds and then select the desired one.
See also Section 1.4, 'Migrating Information from Previous Releases'.
1.4 Migrating Information from Previous Releases
If you have used a previous release of SQL Developer, you may want to preserve database 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 Export Connections. After you complete the installation described in this guide, you can use those connections by right-clicking the Connections node in the Connections Navigator and selecting Import Connections
If you want to use any user-defined reports or the SQL history from a previous version, see Section 1.5 for information about where these are located. If you have user-defined reports and SQL history from Release 1.0, they are modified by any later SQL Developer release to a format that is different from and incompatible with Release 1.0.
SQL Developer preferences (specified by clicking Tools and then Preferences) from a prerelease version of the current release cannot currently be saved and reused; you must respecify any desired preferences.
Note:
If you want to uninstall your prerelease version of SQL Developer before installing this release, see Section 1.10, 'Uninstalling SQL Developer'.1.5 Location of User-Related Information
SQL Developer stores user-related information in several places, with the specific location depending on the operating system and certain environment specifications. User-related information includes user-defined reports, user-defined snippets, SQL Worksheet history, code templates, and SQL Developer user preferences. In most cases, your user-related information is stored outside the SQL Developer installation directory hierarchy, so that it is preserved if you delete that directory and install a new version.
The user-related information is stored in or under the
IDE_USER_DIR
environment variable location, if defined; otherwise as indicated in Table 1-4, which shows the typical default locations (under a directory or in a file) for specific types of resources on different operating systems. (Note the period in the name of any directory named .sqldeveloper
.)Table 1-4 Default Locations for User-Related Information
Resource Type | System (Windows, Linux, or Mac OS X) |
---|---|
User-defined reports | Windows: C:Documents and Settings<user-name>Application DataSQL DeveloperUserReports.xml Linux or Mac OS X: ~/.sqldeveloper/UserReports.xml |
User-defined snippets | Windows: C:Documents and Settings<user-name>Application DataSQL DeveloperUserSnippets.xml Linux: ~/.sqldeveloper/UserSnippets.xml Mac OS X: /Users/<Your user>/Library/Application Support/ SQLDeveloper/UserSnippets.xml |
SQL history | Windows: C:Documents and Settings<user-name>Application DataSQL DeveloperSqlHistory.xml Linux: ~/.sqldeveloper/SqlHistory.xml Mac OS X: /Users/<Your user>/Library/Application Support/ SQLDeveloper/ SqlHistory.xml |
Code templates | Windows: C:Documents and Settings<user-name>Application DataSQL Developer CodeTemplate.xml Linux: ~/.sqldeveloper/CodeTemplate.xml Mac OS X: /Users/<Your user>/Library/Application Support/ SQLDeveloper/ CodeTemplate.xml |
SQL Developer user preferences | Windows: C:Documents and Settings<user-name>Application DataSQL Developersystemn.n.n.n.n Linux or Mac OS X: ~/.sqldeveloper/systemn.n.n.n.n |
If you want to prevent other users from accessing your user-specific SQL Developer information, you must ensure that the appropriate permissions are set on the directory where that information is stored or on a directory above it in the path hierarchy. For example, on a Windows system you may want to ensure that the
SQL Developer
folder and the <user-name>Application DataSQL Developer
folder under Documents and Settings
are not shareable; and on a Linux or Mac OS X system you 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 certified for use with SQL Developer.
Table 1-5 lists the Oracle database certifications.
Table 1-5 Oracle Database Certification for SQL Developer
Product | Releases |
---|---|
Oracle Database | Oracle9i (9.2.0.1 and later) Oracle10g Oracle11g |
Oracle Database Express Edition | Release 11.2 |
SQL 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-6 Non-Oracle (Third-Party) Database Certification for SQL Developer
Database | Releases | Notes |
---|---|---|
IBM DB2 | DB2 UDB DB2 7.x DB2 8.x DB2 9.x | For any DB2 release: db2jcc.jar and db2jcc_license_cu.jar files required; available from IBM. |
Microsoft Access | Access 97 Access 2000 Access XP (2002) Access 2003 Access 2007 | For any Access release: no JDBC driver needed, but you must ensure read access to system tables in the .mdb file. |
Microsoft SQL Server | SQL Server 7 SQL Server 2000 SQL Server 2005 SQL Server 2008 | For any Microsoft SQL Server release: JDBC driver jtds-1.2.jar required; included in jtds-1.2-dist.zip available from sourceforge.net; also available through Help, Check for Updates. |
MySQL | MySQL 3.x MySQL 4.x MySQL 5.x | For any MySQL release: JDBC driver required. For MySQL 5.x: mysql-connector-java-5.0.4-bin.jar, which is included in mysql-connector-java-5.0.4.zip; also available through Help, Check for Updates. (Do not use the latest MySQL driver 5.1.) |
Sybase Adaptive Server | Sybase 12 Sybase 15 | For any Sybase Adaptive Server release: JDBC driver jtds-1.2.jar required; included in jtds-1.2-dist.zip available from sourceforge.net; also available through Help, Check for Updates. |
Teradata | Teradata 12 Teradata 13 | JDBC driver files tdgssconfig.jar and terajdbc4.jar required; included (along with a readme.txt file) in the TeraJDBC__indep_indep.12.00.00.110.zip or TeraJDBC__indep_indep.12.00.00.110.tar download. |
![Oracle 11g For Mac Download Oracle 11g For Mac Download](/uploads/1/2/6/4/126438738/399519754.jpg)
For information about creating and using connections to third-party databases, see the information about database connections in the SQL Developer online help or Oracle SQL Developer User's Guide.
1.7 Advanced Security for JDBC Connection to the Database
You are encouraged to use Oracle Advanced Security to secure a JDBC connection to the database. Both the JDBC OCI and the JDBC Thin drivers support at least some of the Oracle Advanced Security features. If you are using the OCI driver, you can set relevant parameters in the same way that you would in any Oracle client setting. The JDBC Thin driver supports the Oracle Advanced Security features through a set of Java classes included with the JDBC classes in a Java Archive (JAR) file and supports security parameter settings through Java properties objects.
Oracle Express 11g Download For Mac
1.8 Finding SQL Developer Accessibility Information
For the latest configuration information or for information on addressing accessibility and assistive technology issues, see the Oracle Accessibility FAQ at
http://www.oracle.com/accessibility/faq.html
.Also, check the SQL Developer release notes (
readme.txt
file) to see if there are any currently known issues regarding accessibility.1.9 Using a Screen Reader and Java Access Bridge with SQL Developer
Note:
Unless otherwise indicated, the information is this section also applies to Data Modeler and Data Miner.To make the best use of our accessibility features, Oracle Corporation recommends the following minimum configuration:
- Windows XP, Windows Vista
- Java J2SE 1.6.0_24
- Java Access Bridge 2.0.1
- JAWS 12.0.522
- Microsoft Internet Explorer 7.0 or later
- Mozilla Firefox 3.5 or later
Follow these steps to set up a screen reader and Java Access Bridge.
- Install the screen reader, if it is not already installed.Refer to the documentation for your screen reader for more information about installation.
- Install SQL Developer.
- Download Java Access Bridge for Windows version 2.0.1. The file you will download is
accessbridge-2_0_1.zip
. It is available from:http://www.oracle.com/technetwork/java/javase/tech/index-jsp-136191.html
.Refer to the Java Access Bridge documentation available from this website for more information about installation and the Java Access Bridge. - Extract (unzip) the contents to a folder, for example,
accessbridge_home
. - Install Java Access Bridge by running
Install.exe
from the<accessbridge_home>installer
folder.The installer first checks the JDK version for compatibility, then the Available Java virtual machines dialog displays. - Click Search Disks. Then select to search only the drive that contains the SQL Developer build and the JDK version in the program files directory (if it exists).The search process can take a long time on a large disk with many instances of JDK or SQL Developer, or when searching multiple disks. However, unless you complete an exhaustive search of your disk, Access Bridge will not be optimally configured, and will not be correctly installed to all of the Java VMs on your system. After selecting the disk to search, click Search.
- Confirm that you want to install the Java Access Bridge into each of the Java virtual machines displayed in the dialog, by clicking Install in All.
- Click OK when you see the Installation Completed message.
- Confirm that the following files have been installed in the
WinntSystem32
directory (or the equivalent Windows XP or Vista directory), or copy them from<accessbridge_home>installerfiles
because they must be in the system path in order to work with SQL Developer:Note that the system directory is required in the PATH system variable.Note:In the remaining steps in this section, if you are using the SQL Developer kit that does not include a JDK (that is, if the kit file name ends in-no-jre-zip
), replace<sqldev_home>
with<jdev_home>
. - Confirm that the following files have been installed in the
<sqldev_home>
jdkjrelibext
directory, or copy them from<accessbridge_home>installerfiles
:Note:For Data Modeler, for this step and any remaining steps in this section that refer to<sqldev_home>
, replace<sqldev_home>
with<datamodeler_home>
. - Confirm that the file
accessibility.properties
has been installed in the<sqldev_home>
jdkjrelib
directory, or copy it frominstallerfiles
. - Start your screen reader.
- Start SQL Developer by running the file
sqldeveloper.exe
located in the folder<sqldev_home>
sqldevelopersqldevbin
.
The preceding steps assume you are running Windows and using a Windows-based screen reader. A console window that contains error information (if any) will open first and then the main SQL Developer window will appear, after SQL Developer has started. Any messages that appear will not affect the functionality of SQL Developer.
Oracle Xe 11g Download For Mac
1.10 Uninstalling SQL Developer
Before you uninstall SQL Developer, if you plan to install SQL Developer (the same or an updated version) later, you may want to save your existing database connections; and if so, see Section 1.4 before uninstalling.
To uninstall SQL Developer, remove the entire SQL Developer installation directory (that is, the directory named
sqldeveloper
and all directories and files under it in the hierarchy).If you also want to remove all user-specific SQL Developer information, you should also delete the directory under which that information is stored (that is, the SQL Developer user information directory). For the location of this directory, see Section 1.5.
If you have created a shortcut for SQL Developer, and if you do not plan to install SQL Developer into the same location again, you should remove that shortcut or modify the shortcut properties to reflect the new location.
1.11 SQL Developer Documentation
Oracle Database 11g For Mac Download
SQL Developer provides user documentation in the Oracle SQL Developer User's Guide and in the online help. To see the help, click the Help menu, or click the Help button or press the F1 key in relevant contexts while you are using SQL Developer.
In addition to the user's guide and installation guide, the following migration-related guides are available:
1.12 Oracle on the Web
Oracle provides a number of resources on the web. These are some sites you may find helpful:
- SQL Developer home page (OTN):
http://www.oracle.com/technetwork/developer-tools/sql-developer/
- SQL Developer discussion forum (OTN):
http://forums.oracle.com/forums/forum.jspa?forumID=260
- Oracle Technology Network (OTN):
http://www.oracle.com/technetwork/index.html
- PL/SQL page on OTN:
http://www.oracle.com/technetwork/database/features/plsql/
- Oracle Accessibility Program:
http://www.oracle.com/us/corporate/accessibility/
- Oracle Corporate site:
http://www.oracle.com/