Shulou(Shulou.com)06/01 Report--

Download InstantClient

Address:

Http://www.oracle.com/technology/software/tech/oci/instantclient/index.html

Instantclient-basic-nt-12.1.0.1.0 (clients that must have the win32 bit down)

2. Decompression

Extract to C:\ instantclient_12_1

Third, set variables

Computer, right-click "Properties"-Advanced system Settings-Advanced-Click "Environment variables"

Click "New"-enter the following content-click "OK" when you are finished

NLS_lANG=SIMPLIFIED CHINESE_CHINA.ZHS16GBK (note that there is a space in the middle. If this is not set, the Chinese of the toad query will be garbled)

TNS_ADMIN=C:\ instantclient_12_1\ network\ admin (mentioned below in the network and admin directories)

Path=C:\ instantclient_12_1

Import the registry

Save the following as a registry file and import it into the registry (path section, please modify it yourself). If the Oracle is automatically generated after installation, there is no need to modify it. If there is no automatic generation, you need to modify it manually.

[HKEY_LOCAL_MACHINE\ SOFTWARE\ ORACLE\ KEY_OraDb11g_home1]

"NLS_LANG" = "SIMPLIFIEDCHINESE_CHINA.ZHS16GBK"

"ORACLE_BUNDLE_NAME" = "Enterprise"

"ORACLE_GROUP_NAME" = "Oracle-OraDb11g_home1"

"ORACLE_HOME" = "c:\\ instantclient_12_1"

"ORACLE_HOME_KEY" = "SOFTWARE\ ORACLE\ KEY_OraDb11g_home1"

"ORACLE_HOME_NAME" = "OraDb11g_home1"

Fifth, establish tnsnames.ora document

Create the network directory under the C:\ instantclient_12_1 directory, then the admin directory under network, and finally the tnsnames.ora file, enter the following contents in the file and save it.

ORCL =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP) (HOST = WIN-DCSEMHVDHGU) (PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = orcl)

)

)

According to the individual configuration, the red part needs to be modified. The first piece of red is the host name or address. The second red is the service name of the database.

6. Install PL/SQL Developer tools

Download and install the x64-bit PL/SQLDeveloper tool. What I have installed here is

PLSQLDeveloper10.0.3.1701 version.

Login for the first time needs to be configured, double-click to appear a dialog box and click "cancel" to enter the PL/SQL interface. Then click the menu bar "tools"-"preferences"-set "Oracle Home Directory and OCI Library"-apply-"OK".

Oracle home directory: C:\ instantclient_12_1

OCI library: C:\ instantclient_12_1\ oci.dll

As shown in the figure:

VII. Testing

Close the PL/SQLDeveloper tool and reopen it, and then a dialog box will appear, enter the appropriate username, password and database, and choose the right connection method, otherwise the login will fail.

Login succeeded.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.