Oracle Daily Practice free to install Oracle clients using PL/SQL

Source: Internet
Author: User

Free installation of Oracle clients using PL/SQL

The Oracle client is annoying, and deploying a connection to it usually requires the client to install it, and the installer requires the registry to be written on the target machine, assuming you're not a neat freak, you could still be stuck with something like this: when other programs on your machine rely on x64 's Oracle program, And they're probably not written by you at all, so you don't have the guts to tamper with the server, but you may need a PL/SQL to execute the query in the same environment, and you'll need a no-install method to handle the problem.

1. Download Oracle Instant Client (32-bit)

Because my PL/SQL only supports 32-bit Oracle, you must download the corresponding 32-bit.

Just download the Instantclient-basic-nt-11.2.0.3.0.zip, and the rest is a package that expands according to different needs.

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

2, unzip to the target machine (assuming that the new installation of Windows can be)

Here I have selected this folder: C:\instantclient_11_2_x86\

3, Configuration Tnsnames.ora

Save the new Tnsnames.ora file in Notepad under this path:

C:\instantclient_11_2_x86\NETWORK\ADMIN\tnsnames.ora

The content reference is configured below:

My_xxxserver =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = 10.199.200.102) (PORT = 1521))
(Connect_data =
(SID = ORAVM)
(SERVER = dedicated)
)
)

4, extract PL/SQL to the target machine, such as: C:\Program Files (x86) \plsql Developer 9.0.0.1601\

5, open PL/SQL, log in when, "Cancel" can.

Go to Preferences (tool-〉 Preferences), select Oracle on the left, fill in the "Oracle home Directory Name" and the OCI library address on the right:

6, complete the above steps, re-open Plsql, enter the user name password, select the correct database.

7, Chinese garbled problem

7.1 Method 1: Set Environment variables (global, may affect other Oracle clients)

Computer, System Properties, advanced system settings, System Properties/advanced tabs, environment variables, system variables, new, and so on
Variable name: Nls_lang
Variable value: Simplified Chinese_china. Zhs16gbk

7.2 Method 2: Set the registry (not applicable to instant client or other XCOPY clients) (global, may have an impact on other Oracle clients)

[Hkey_local_machine\software\oracle\key_xe]
"Nls_lang" = "Simplified Chinese_china. ZHS16GBK "

Where Key_xe may be different from different Oracle installation packages, adjust according to your own situation.

7.3 Method 3: Set before starting Plsql (independent, no impact on other Oracle clients)

7.3.1 in the Plsql installation folder, create a new bat file with the following contents:

Set Nls_lang=simplified Chinese_china. Zhs16gbk
Plsqldev.exe

Where Plsqldev.exe runs the file for Plsql. After the bat is executed, the Plsql developer is automatically opened, the user name password is entered, and the Chinese garbled problem is usually resolved. But directly executing this BAT file will cause a black command-line window to write a VBScript file Plsqldev.vbs in the installation directory with the following:

CreateObject ("Wscript.Shell"). Run "Setchinesecharset.bat", 0

Run Plsqldev.vbs later (you can right-click to send the shortcut to the desktop and modify the icon to Http://files.cnblogs.com/volnet/plsqldev.ico)

7.3.2 to eliminate the black command-line window, you can also write the following bat file directly:

set nls_lang=simplified Chinese_china. Zhs16gbk
Start plsqldev.exe

This will not show a black command-line window. The same way to modify the icon.

I'm also in the study of how applications that you write can be deployed in a free-to-install manner, and this link is worth referencing: http://www.oracle.com/technetwork/issue-archive/2008/08-nov/o68odpnet-101744.html

For the results of the final study, please refer to: http://www.cnblogs.com/volnet/archive/2012/05/22/2513968.html, which also updates the installation of PL/SQL developer.

This article turns from http://www.cnblogs.com/volnet/archive/2012/05/22/2513728.html

Oracle Daily Practice free to install Oracle clients using PL/SQL

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.