Windows 64-bit installation Oracle Instantclient official Green Edition and PL/SQL Developer summary

Source: Internet
Author: User
Tags create directory

Original: http://blog.csdn.net/kimsoft/article/details/8751267

Operating system: Windows 7 64-bit flagship

requirements, install PL/SQL developer for development

First, download the official Oracle Lite Green Edition

Http://www.oracle.com/technetwork/topics/winsoft-085727.html

Special note To download the 32-bit, because PL/SQL developer currently has only 32-bit versions

Second, installation configuration instantclient

After downloading, unzip to D:\Oracle\instantclient_11_2 (especially note that this directory can only be a combination of alphanumeric underscores, otherwise problems may occur)

Create Directory D:\Oracle\instantclient_11_2\network\admin

Put a Tnsnames.ora, the contents are as follows:

# TNSNames. ORA Network Configuration File:%oracle_home%\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
eoa_249 =
(DESCRIPTION =
(Address_list =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.3.249) (PORT = 1521))
)
(Connect_data =
(service_name = devdb)
)
)

Note the points:

Service_Name as Sid seems to be possible.

All the characters note shelf write, otherwise there may be unexpected problems

Set the following environment variables

Oracle_home=d:\oracle\instantclient_11_2

Tns_admin=%oracle_home%\network\admin

Nls_lang=simplified Chinese_china. Zhs16gbk

The path variable is prefixed with%oracle_home%;

III. installation of PL/SQL Developer and Configuration

http://allroundautomations.com/

Special note that installation cannot be installed in a folder with (x86)

Set up the Oracle_home and OCI Library in Plsql Developer:
Connection, Oracle, Tools-Preferences
Oracle_home:d:\oracle\instantclient_11_2
OCI Library:d:\oracle\instantclient_11_2\oci.dll

Plsql Developer Extension Probation method, 30 days Delete registry
Delete the following registry content:
Hkey_current_user\software\allround automations
Hkey_current_user\software\microsoft\security

Finally, a friend who doesn't want to configure environment variables can write a batch

You can create a. bat file in the same directory as the PL/SQL developer, as follows (the path references the client path that you installed):


@echo off

Set Oracle_home=d:\oracle\instantclient_11_2
Set path=%oracle_home%;%path%;
Set Tns_admin=%oracle_home%\network\admin
Set Nls_lang=simplified Chinese_china. Zhs16gbk
Start Plsqldev.exe

Windows 64-bit installation Oracle Instantclient official Green Edition and PL/SQL Developer summary

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.