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

Connect to an oracle 11g remote database using instantclient_11_2 and PL/SQL Developer toolkits

1. Go to the Oracle website to download Instant Client:

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

Choose different versions of Instant Client according to your operating system

Download back is a compressed file, the decompressed folder is called: D:/instantclient_11_2. Just put it in your favorite directory. For example: D:/instantclient_11_2

two。 Create a new directory network under the D:/instantclient_11_2 directory, a new admin directory under the network directory, and a new file tnsnames.ora under the admin directory. Use a text editor to open and write the following:

MWDB=

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.0.58) (PORT = 1521))

)

(CONNECT_DATA =

(SERVICE_NAME = MWDB)

)

)

The first × × block: represents the local hostname that defines the remote server

Second × × block: remote database instance name

3. Add an environment variable named TNS_ADMIN, whose value is the path where the tnsnames.ora file is located. For example, my local computer is: D:/instantclient_11_2/network/admin

4. Set the language of ORACLE, add the environment variable NLS_LANG, and the value is SIMPLIFIED CHINESE_CHINA.ZHS16GBK

If you don't know the ORACLE language of the remote database, you can ssh or telnet to the remote machine, enter it in the command interface, and use the command line to connect to the database.

Select * from nls_instance_parameters

View the value of NLS_LANGUAGE

NLS_LANGUAGE

NLS_TERRITORY

5. Download and install the PL.SQL.Developer configuration application

Configure tools- > preferences- > connection

Oracle Home

D:/instantclient_11_2

OCI library

D:/instantclient_11_2/oci.dll

PL/SQL Developer in Chinese is

Tools-- > preferences-- > connections

Oracle home directory

D:/instantclient_11_2

OCI library

D:/instantclient_11_2/oci.dll

6. Close PL/SQL Developer and restart Developer.

The hostname will appear in the PL/SQL Developer list. Enter the user name and password to log in to the remote oracle 11g database.

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.