PL/SQL (x64) Connect Oracle Configuration Tutorial with Oracle Instant Client

PL/SQL is slightly more complex to install under the Windows x64 bit operating system, providing PL/SQL with Oracle Instant client (which is much smaller than Oracle client files) for Oracle libraries to use this handy tool. Can save installation time for users) connection database configuration tutorial One, please take away the necessary pots.

1. Download Oracle INSTANCT Client (Oracle IM)

Log in to the Oracle website and download the Oralce instant client. You can see the clients of different systems, choose the corresponding version according to their needs, after downloading, unzip to a path. such as "D:\Program files\instantclient_12_1".

　　2. Configuring Oracle INSTANCT Client Environment variables

　　2.1 In the System environment variable, add the following environment variables

# Oracle's locale variables (national Language support)

Nls_lang=simplified Chinese_china. Zhs16gbk

#TNS环境变量

Tns_admin=d:\program Files\instantclient_12_1\admin

#Oracle Instant installation directory (append in Path Path)

Path=.;D: \program Files\instantclient_12_1

　　2.2 Creating a Tnsnames.ora database connection file

Under the "D:\Program files\instantclient_12_1\admin" path, create the Tnsnames.ora file and add the database connection configuration information in the format as follows:

FAVBLOG-TST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.100) (PORT = 1521)) (Connect_data = ( SID = favccxx) (SERVER = dedicated))) Favblog-dev = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.16 8.1.101) (PORT = 1521)) (Connect_data = (SID = ORCL) (SERVER = dedicated))

3. Configure PL/SQL

Open PL/SQL and select "Tools", "Perference", "Connection", as shown in.

In Oracle home, enter the installation path for the Oracle Instant client (optional).

In the OCI library, enter the path of the OCI.DDL in the 32-bit Oracle Instant client (required, 32-bit).

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/6F/DA/wKioL1WrnKXwc9iDAAMnbWO3bds282.jpg "title=" Plsql.png "alt=" Wkiol1wrnkxwc9idaamnbwo3bds282.jpg "/>

4. Using PL/SQL

Restart PL/SQL, in the main object window, you can see the "Objects" component in the list on the left, you can switch the administrator account in it, or you can view the tables you have connected to in the Tables menu. Next, you can use PL/SLQ.

This article is from the "This person's IT World" blog, be sure to keep this source http://favccxx.blog.51cto.com/2890523/1676142

PL/SQL (x64) Connect Oracle Configuration Tutorial with Oracle Instant Client