Shulou(Shulou.com)05/31 Report--

This article introduces the relevant knowledge of "how to use instantclient client to connect to oracle database". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

(1) download instantclient_11_2 first (decompress as follows)

Modify the instantclient_11_2/tnsnames.ora file and write down the address of the oracle server you need to link to. The tnsnames.ora format and some of the file contents are as follows:

LocalDB= (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 127.0.0.1) (PORT = 1521) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)

Note:

HOST = 127.0.0.1-- Server ip (here is the database created locally) SERVICE_NAME=orcl-- instance name of the server. Default is orcl.

LocalDB-- an alias for tns (as long as you can tell it for yourself)

(2) download the plsql tool (decompress)

(3) configure environment variables

TNS_ADMIN D:\ Develop\ PLSQL Developer\ instantclient_11_2---- (path to instantclient_12_2, where I unzip instantclient in the plsql root directory) NLS_LANG SIMPLIFIED CHINESE_CHINA.ZHS16GBK-(set language)

(4) start plsql, because it has not been configured, so cancel first, do not log in, advanced configuration.

(5) go to plsql, and set the oracle home directory path and oci library path in the options bar above-- > preferences-- > link.

(6) then apply, restart plsql, and you will find that the database will display LocalDB, and then enter your user's password to log in.

This is the end of "how to use instantclient client to connect to oracle database". Thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

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.