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

(1) do not install Oracle,plsql remote connection database locally

1. First, go to the Oracle website to download Instant Client:

Http://www.oracle.com/us/solutions/index-097480.html

The decompressed folder is called instantclient_11_2. You can put it in any directory on your local disk. For example: D:/instantclient_11_2

2. Create a new directory network under the D:/instantclient_11_2 directory, create an admin directory under the network directory, create a new file tnsnames.ora under the admin directory, and open and write the following:

ORCL =

(DESCRIPTION =

(ADDRESS_LIST =

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

)

(CONNECT_DATA =

(SERVICE_NAME = orcl)

)

)

Where ORCL is the local hostname of the remote database, 10.6.8.10 is the IP address of the remote server, and orcl is the name of the remote database.

3. Add an environment variable named TNS_ADMIN, whose value is the path where the tnsnames.ora file is located.

Add environment variables through (my computer-properties-advanced-environment variables-new).

4. 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

After the configuration is complete, shut down PL/SQL and restart.

The hostname appears in the PL/SQL Developer list, enter the user name and password, and you can log in to the remote oracle database.

When we connect successfully, sometimes the queried data will be garbled. This is because the local code is inconsistent with the server-side code. In this case, we can use the SQL statement:

Select userenv ('language') from dual

Query the server-side code, such as my own query result is

USERENV ('LANGUAGE')

AMERICAN_AMERICA.ZHS16GBK

We need to add an environment variable NLS_LANG with a value of: AMERICAN_AMERICA.ZHS16GBK and then restart PL/SQL so that there is no garbled problem.

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.