WIN7 64-bit configuration Oracle SQL Developer tools

In the process of using Oracle SQL, a lot of reference materials, guidance agencies, the vast majority of books are used in PL/SQL to explain, but the problem is PL/SQL to WIN7 64-bit system support is not good, there are a variety of online configuration tutorials, I tried a lot, have not been able to solve, The best solution is to use Oracle SQL Developer, which is downloaded from the Oracle SQL website, to configure Oracle SQL Developer, and MOM will never have to worry about me being able to use the database.

Detailed installation configuration steps are now described:

Step 1, install Oracle 11g (server side and client)

1, Oracle official website download Oracle 11g Release 2 for Microsoft Windows (64x), download the successful decompression of two compressed files;

2, click Setup.exe to start the installation, set the path you need to install, I choose to install the version is the standard version. When configuring the global database password, be aware that the Oracle password requires a combination of uppercase + lowercase + digits (integral) and is greater than 8 bits, set up successfully after the installation is complete;

3. Install the Oracle 11g client program. My installation path is set to: c:\Software\oracle\product\11.2.0. (c-Disk partition 100G is wayward.) ）

PS: In fact, the installation of the configuration process can be completely in accordance with the official instructions to install the configuration, in fact, many problems on the official website of the solution are very good.

Step 2. Installing Oracle SQL Developer

1. Download and install the development tools Oracle SQL Developer from Oracle official website, and remember to download the version that matches your operating system.

2, to determine their own computer installation and configuration of the JDK, the specific installation and environment variable configuration on the Internet has a variety of information; Click Sqldeveloper.exe and select your computer's JDK installation directory.

3, after the installation of the JDK and successfully configured environment variables, restart Sqldeveloper.exe, login success!

Step 3. Oracle SQL Developer New Connection Configuration 1. After startup, create a new Oracle SQL Developer connection in the left window earlier, as shown in:

This process is important, directly determine the success or failure, the specific considerations are as follows:

(1), the connection name can be arbitrarily named

(2), the user name is the global user name of the Oracle database

(3), password is global password

(4), hostname default is localhost, it is recommended to use the default, the host name is usually set by the Net Manager tool, the default is localhost, often, some computers the local IP address is automatically assigned each time, This will change every time a new connection is created, affecting the connection.

(5), the port is 1521, the service name is ORCL, as for the service name, if not sure, you can see through the View Net Manager, as shown in:

2. Configuration complete, test success, click Save, successfully add a new connection, happy start your Oracle database tour! There is a picture of the truth, as shown in:

WIN7 64-bit configuration Oracle SQL Developer tools