Oracle First Experience four PL/SQL Developer do not install client connection to remote Oracle database

PL/SQL Developer is an integrated development environment designed specifically for the development of Oracle Database storage program units. Now that more and more business logic and application logic has shifted to Oracle Server, PL/SQL programming has become an important part of the entire development process. PL/SQL developer focuses on ease of use, code quality, and productivity, giving full play to the key benefits of Oracle application development.

1. Download the Agile Client

http://eduunix.ccut.edu.cn/index2/database/Oracle%20Instant%20Client/

Choose the right download for you, my is instantclient-basic-win32-10.2.0.3-20061115 official website can also download, but need to register Oracle account, the above site basically provides all the software related to Oracle database.

2. Download PL/SQL Developer Version 10.0.5.1710

http://down.51cto.com/data/1967074

This package contains the PL/SQL Developer Version 10.0.5.1710, keygen, Chinese pack total of 23M

Installation has been, the next step will be

3. Unzip instantclient-basic-win32-10.2.0.3-20061115 to a specific directory

For example mine is C:\oracleclient after decompression will become C:\oracleclient\instantclient_10_2 so.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/57/7F/wKioL1ScBrDD4pwqAAJHyhT7Nh8582.jpg "title=" jy.png "alt=" Wkiol1scbrdd4pwqaajhyht7nh8582.jpg "/>

4. Configuration  

Create a Tnsnames.ora with a text document that reads as follows:

# tnsnames.ora network configuration file: /u01/app/oracle/product/10.2.0/db_1/ Network/admin/tnsnames.ora# generated by oracle configuration tools. scott =   (description =     (address_list =        (address =  (protocol = tcp) (host = 192.168.1.14) (port =  1521)     )      (connect_data =        (Service_name = scott)     )   ) extproc_connection_data  =   (description =     (address_list =        (address =  (PROTOCOL = IPC) (key = extproc0))      )      (connect_data =       (Sid = plsextproc)        (presentation = ro)     )   ) 

This file can also be downloaded from the ORACLE server # find $ORACLE _home-name tnsnames.ora/u01/app/oracle/product/10.2.0/db_1/network/admin/ Tnsnames.ora/u01/app/oracle/product/10.2.0/db_1/network/admin/samples/tnsnames.ora

The first one is

# Sz/u01/app/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora

When you enter the download command, it will appear

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/57/7E/wKioL1Sb9arCXt4rAADl7Pk3-eI147.jpg "title=" 10.2. PNG "alt=" wkiol1sb9arcxt4raadl7pk3-ei147.jpg "/>

As for the SZ command from the package lrzsz-0.12.20-19.x86_64.rpm, it is very convenient to use this software to download small files from a Linux server. You can also use this small software to upload files to the Linux service straights, Download Save to Instantclient_10_2 directory

In the Instantclient_10_2 directory, create a sqlnet.ora with a text document that reads as follows:

NAMES. Directory_path= (TNSNames) sqlnet. Authentication_services= (NTS)

Add an environment variable to my computer, properties, advanced, environment variables, variable named Tns_admin, and the value is the path of the Tnsnames.ora file.

For example:

C:\oracleclient\instantclient_10_2

5. After the installation plsql is complete, start, Cancel, and click Tools->preferences->connection:

Oracle Home=c:\oracleclient\instantclient_10_2oci Library=c:\oracleclient\instantclient_10_2\oci.dll

Such as:

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/57/81/wKiom1Sb-16BxCXfAACIW5rXahk601.jpg "title=" P.png " alt= "Wkiom1sb-16bxcxfaaciw5rxahk601.jpg"/>

Restart PL/SQL to enter the database.

The problem of Chinese garbled characters may exist in the initial landing

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/57/7F/wKioL1ScBUPSFsNcAAA1m_FNQRU327.jpg "title=" L.png " alt= "Wkiol1scbupsfsncaaa1m_fnqru327.jpg"/>

Here's how to fix it:

Add an environment variable to my computer, properties, advanced, environment variables:

Variable name: Nls_lang

Variable value: American_america. Zhs16gbk

Reconnect to display Chinese correctly.

If you want to convert to the UTF8 character set, you can assign "Nls_lang" to "American_america." UTF8, other codes ibid.

If the login process to force the user name, password and database, log-in Popup the following error:

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/57/7F/wKioL1Sb-M_jdEYBAADzpYLvfII232.jpg "title=" Cuowu.png "alt=" Wkiol1sb-m_jdeybaadzpylvfii232.jpg "/>

Look at my Computer configuration first.

PL/SQL Developer Version 10.0.5.1710Windows 7 (64-bit) 6.1 Build 7601 (Service Pack 1)

I have downloaded the following two versions, but will still pop up the above error:

Instantclient-basiclite-win-x86-64-10.2.0.2.0-20060503.zipinstantclient-basiclite-win-ia64-10.2.0.2.0-20060503.zip

Description Plsql developer does not support 64-bit Agile client connections, download the 32-bit version:

instantclient-basic-win32-10.2.0.3-20061115

6. Verify using the Oracle Sample account Scott landed from PL/sql:

Unlock the Scott account and set the password for the Scott account to Scott

$ sqlplus / as sysdbasql> desc dba_users; Sql> select username,user_id,account_status from dba_users where username= ' SCOTT '; Username  user_id  account_status--------- -------- ---------------scott      54       EXPIRED & LOCKEDSQL>  ALTER USER scott IDENTIFIED BY scott; sql> alter user scott account unlock; Sql> select username,user_id,account_status from dba_users where username= ' SCOTT '; Username  user_id  account_status--------- -------  --------------  Scott     54       open can see that the Scott user is open sql>  DESC v$instance; [email protected]> set linesize 130 [email protected]> select instance_number,instance_name,host_name,version,status from  v$instance;instance_number  instance_name    host_name      version        status--------------- ------------     ---------       --------      --------- 1               scott             oracleserver   10.2.0.1.0    open

DB Instance name is Scott

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/57/7F/wKioL1ScAmmRzyswAAE5V3fv0SA907.jpg "title=" dl.png "alt=" Wkiol1scammrzyswaae5v3fv0sa907.jpg "/>

Username:scott Password:scott Database:scott Connect as:normal Log in as a regular user

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/57/7F/wKioL1ScBD2DWRMoAAKzYkTXujI672.jpg "title=" Ses.png "alt=" Wkiol1scbd2dwrmoaakzyktxuji672.jpg "/>

Complete ~~~~~

This article is from the "attention to Linux technology" blog, please be sure to keep this source http://werewolftj.blog.51cto.com/1606482/1596074

Oracle First Experience four PL/SQL Developer do not install client connection to remote Oracle database