installation of Oracle PL/SQL

In front of Oracle database Learning 1 It has already been written, but I write a note about it, the original: http://www.cnblogs.com/zhangmingzhao/p/7172209.html

installation of PL/SQL tools

The first installation did not succeed, under the CSDN resources, now think of it should be tnsnames.ora there is a Sqlnet.ora two files are not configured, resulting in the connection when the detection of the database is only a 222222222, go in to say no listening program. Later on the Internet to check and change, change my DOS box of Oracle can not go. Then unloading load, Baidu Tutorial, the registry each to delete, in fact, it is not very troublesome, and then reloaded. The second time follows another tutorial:

Install PL/SQL Developer:
1.plsqldev1104.exe, follow the prompts to complete the installation
2. Click the Cancel button after launch, according to Plsqldev1104code hack

pl/sql Developer Connect local Oracle 11g 64-bit database:
1. Extracting instantclient-basic-win32-11.2.0.1.0 to Oracle under
2. Create a folder under Instantclient_11_2 network\admin
3. Copy from Oracle_home\network\admin
sqlnet.ora/tnsnames.ora
To Instantclient_11_2\network\admin
4. Configuring Oracle Home and OCI for PL/SQL developer libaray 

oci Libaray path is the oci.dll of the Oracle Client directory (D : \instantclient_11_2\oci.dll)

Click "OK", now the configuration is complete, exit PL/SQL Developer
5. Re-login PL/SQL Developer done.

Solve Pl\sql Developer Query Chinese table appear question mark garbled problem:
Set environment variables, after restarting the computer, the later inserted Chinese will not garbled

Variable name: Nls_lang
Variable value: Simplified Chinese_china. Zhs16gbk

Then I found that the re-installed Oracle did not have tnsnames.ora files, only a sqlnet.ora, but the DOS box of Oracle is still in the go. I didn't know exactly what I was doing. Who can tell me so much? And then read the online tutorial is a lot of ways. I directly copied and pasted the friend's Tnsnames.ora file, opened, changed the inside path, put in the above instantclient_11_2 and their own Oracle installation directory. Then configure PL/SQL. Sure enough, Scott was detected, select, log in, enter their own installation time set the password, go in, eh ha. (For the installation this has been a few days =-=)

Then create a new SQL window, and the file list below has the system and the database you created, which you can view.

PL/SQL can also perform visual operations on Oracle.

So the first time I installed PL/SQL, I said no listener, think about it. There should be no new folders and configuration of these two files, because these two tutorials are different in the final step, to see what this tutorial says:

I. Directory structure

D:\install\PLSQL
|--instantclient_11_2
|--Tnsnames.ora
|--Plsql Developer
|--Readme.txt

Two. Environment variables

Nls_lang = Simplified Chinese_china. Zhs16gbk

Tns_admin = D:\install\PLSQL\instantclient_11_2

three. PL/SQL Developer environment settings

1. Location

Connections, preferences, tools

2. Settings

Oracle Home Directory name = D:\install\PLSQL\instantclient_11_2

OCI Library = D:\install\PLSQL\instantclient_11_2\oci.dll

Four. Supplement

Tnsnames.ora files need to be created manually and set accordingly, refer to the online tutorial.

Pit Daddy, the key fourth part of this is a few words. Add that you should create your own Netword folder and paste the Tnsnames.ora and sqlnet.sql files in the Oracle installation directory so that the database can be detected when PL is logged in.

Sure enough, the first download of the 64-bit Green Chinese version of PL/SQL is logged in.

Want a resource message or contact me Oh ~~64 Chinese Green edition and 32-digit English version

installation of Oracle PL/SQL