If you are asked to enter the full pathname for the JDK, click Browse and find java. Alternatively, if you have any exported connections see Section 1.
Unzip the SQL Developer kit into a directory folder of your choice. It also causes many files and directories to be placed in and under that directory. 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. 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. 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. If you have user-defined reports and SQL history from Release 1. 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. 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.
Note the period in the name of any directory named. 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. SQL Developer can be used to view metadata and data of several non-Oracle third-party databases.
Table lists the third-party database certifications. For any Access release: no JDBC driver needed, but you must ensure read access to system tables in the. For MySQL 5. Do not use the latest MySQL driver 5.
JDBC driver files tdgssconfig. If you are using the OCI driver, you can set relevant parameters in the same way that you would in any Oracle client setting. It will take a few minutes to complete, depending on your computer. You will see the Database Configuration Assistant window.
Click the Password management… button to enter the password for Oracle database accounts. Step 9. Once installation completes successfully, the installer will inform you as shown in the following screenshot. Click the Close button to close the window. Second, right-click the connections node and choose New Connection … menu item to create a new connection.
Third, enter the information that you provided during the installation process as shown in the following screenshot.
Click the Connect button to connect to the Oracle Database. You first open the tnsnames. Then, you need to add the following lines at the end of the file:. After that, you can save the file and close it. Use My Oracle Support credentials for download to download and apply the latest software updates. Provide the proxy server information for your site, along with a user account that has access to the local area network through which the server is connecting.
The proxy realm information is case-sensitive. If you do not have a proxy realm, then you do not need to provide an entry for the Proxy Username, Proxy Password, and Proxy Realm fields. Click Test Connection to ensure that your proxy settings are correctly entered, and the installer can download the updates.
The Apply Software Updates screen is displayed if you select to download the software updates or provide the pre-downloaded software downloads location. If you selected Use My Oracle Support credentials for download in the previous screen, then select Download and apply all updates , and click Next.
If you selected Use pre-downloaded software updates, then select Apply all updates , and click Next. The Select Product Languages screen enables you to select the language in which you want to run the product. Select the product language from the Available Languages list, transfer it to the Selected Languages list.
Click Next. This screen is not displayed if you select Instant Client as the type of installation in step 5. Oracle Base : This path appears by default. You can change the path based on your requirement.
The Oracle Base section is not displayed if you select Instant Client as the type of installation in step 5. In the Software Location section, accept the default value or enter the Oracle home directory path in which you want to install Oracle components.
The directory path should not contain spaces. If you selected Custom as the type of installation in step 5 , then the Available Product Components screen is displayed. Select the products that you want to install and click Next. In step 10 , if you select Oracle Scheduler Agent as one of the components that you want to install, then the Oracle Database Scheduler Agent screen is displayed. The Perform Prerequisite Checks screen verifies if your computer meets the minimum system requirements to install the desired product.
Review the information displayed in the Summary screen, and click Install. The Install Product screen shows the progress of a client installation. If you are performing a Custom installation, and selected Oracle Net Listener from the list of components to install in step 10 , then go to "Using Oracle Net Configuration Assistant" for instructions.
Using Oracle Net Configuration Assistant. Perform the following to configure the listener and naming methods using Oracle Net Configuration Assistant:. In the Listener Configuration screen, enter a Listener name or accept the default value.
In the Listener Configuration, Select Protocol screen, select one or more protocols from the Available Protocols list, and move it to the Selected Protocols list. Select No if you do not want to configure an additional listener, and click Next. In the Naming Methods Configuration screen, select Yes to configure naming methods.
In the Naming Methods Configuration screen, select the naming method you want from the list of Available Naming Methods and then click Next. In the Net Service Name Configuration screen, select the protocol for the database you want to access, and click Next. In the Net Service Name Configuration screen, enter the Host name of the computer where the Oracle database is installed.
Use the standard port number, or specify a different port number, and click Next. In most cases, the test fails only because the default user name and password Oracle Universal Installer supplies in the dialog box do not match the user name and password for the target database. Click Change Login , reenter the user name and password, and then click OK. You can also run Oracle Net Configuration Assistant after the installation in standalone mode to configure the listener, naming methods, net service names, and directory server usage.
Select Upgrade to upgrade the existing Oracle Database Client software to the latest version. In the Specify Installation Location screen, accept the default Software Location value or enter the Oracle home directory path in which you want to install Oracle components. The Apply Software Updates screen is displayed if you select to download the software updates or provide the pre-downloaded software updates location.
Select either Download and apply all updates or Apply all updates , as applicable, and click Next. Note: You can choose to create a new Oracle base directory, even if other Oracle base directories exist on the system. Consider the following before selecting this option: This upgrade is only possible in a client home and not in any other Oracle home that contains non-client installations, such as Database installations.
To set this up, perform these steps on the remote computer that has the DVD drive: Log in to the remote computer as an Administrator user. Start Windows Explorer. Click the Sharing tab and do the following: Select Share this folder. Click OK when you are finished. Start Windows Explorer on the local computer. Select a drive letter to use for the remote DVD drive.
Click Finish. You can install Oracle Database Client on the remote computer in one of two ways: If you have copied the contents of the Oracle Database Client DVD to a hard drive, you can install from the hard drive. The steps that must complete are: Make sure that the remote access software is installed and running on the remote and local computers. The steps that you need to complete are: Make sure that the remote access software is installed and running on the remote and local computers.
On the local computer, share the DVD drive. Go to Section 3.
0コメント