Original pl/sql8.0.4 Download/install

Pl/sql8.0.4cn

: Http://pan.baidu.com/s/1gSokX

Unzip the installation.

Opening the software will prompt you:

Windows 64-bit installed Oracle 11g 64-bit, Plsql developer uses the following issues:

1. The Database drop-down box is empty:

2, mandatory input user name, password and database, login popup:

Initialzation errorcould not Initialize "...." Make sure you have the-bits Oracle Client installed. Oraclehomekey:oraclehomedir: ... Found:oci.dllUsing: ... Loadlibrary (...) Returned 0

Description Plsql developer does not support Oracle 64-bit client connections.

Workaround:

1. Download 32-bit Oracle Client

In fact, you can download the installation-free version,http://www.oracle.com/technetwork/topics/ winsoft-085727.html, I downloaded the instantclient-basic-nt-11.2.0.2.0.zip.

2. Decompression

Unzip the Instantclient-basic-nt-11.2.0.2.0.zip, for example to D:\instantclient_11_2

3, set Plsql Developer

Start Plsql Developer, no sign-in point to cancel into Plsql developer,tools->>preferences:

Oracle Home :oradb11g_home1 (found here seems to be able to write casually, I filled in the installation of Oracle 11g 64-bit)

OCI Library :D:\instantclient_11_2\oci.dll

4. Add Environment variables

Tns_admin->> D:\app\YangJin\product\11.2.0\dbhome_1\NETWORK\ADMIN

Chinese garbled problem:

Start Plsql Developer, login found Chinese table name garbled:

Workaround:

Add environment variable: Nls_lang->> American_america. UTF8

If you encounter a previously installed database character set that is not UTF8, but GBK, then you need to adjust the database server's character set encoding.

Workaround:

The reason for modifying the DB is because my DB does not support Chinese, so whenever I insert a piece of data into a database table, Chinese is changed to resemble "? (Is the anti-question mark) "garbled, in order to successfully insert the success, so did this modification;

System: Windows 7 Ultimate Edition 64-bit

Oracle DB version:10.2.0.4

Gets the initial encoding of the DB: Select Userenv (' language ') from dual;

American_america. we8mswin1252

Modify the method (to change to UTF8 as an example)

To modify the registry:

Regedit---> Open registry: Hkey_local_machine/software/oracle/key_xe

Double-click Nls_lang, and modify its value to UTF8

Then run-->cmd--> sqlplus-->

Log in with the privileges of the advanced administrator

Conn as sysdba/

USERNAME:SYSDBA;

Password:admin (PC-based);

(Here I am logged in as system, then switch to SYSDBA identity.)

Use command: Conn SYSTEM/ORCL as SYSDBA;

)

First look at your DB code select USERENV (' language ') from dual;

Then one sentence executes the following code:

sql> shutdown immediate; sql> startup Mount; Sql> alter system enable restricted session; Sql> alter system set job_queue_processes=0; sql> ALTER DATABASE open; Sql> ALTER DATABASE Character set Internal_use Al32utf8 (or UTF8); sql> shutdown immediate; Sql> Startupsql>alter system Disable restricted session; Note: Do not forget to execute the last sentence, or you may follow a lot of things can not be done above if successful, the DB code is queried again Select Userenv (' language ') from dual; My query results are: American_america. Al32utf8 proves that the encoding of DB has been changed to UTF-8;after the second Test, do not modify the registry seems to be able to modify the success!! Modified successfully!

In development we need to install PL/SQL development software:

Original pl/sql8.0.4 Download/install