ORACLE10G Client connection remote database configuration diagram

yuanwen:http://blog.csdn.net/dkzhu/article/details/6027933

First, install the Oracle client

1, running Setup.exe, appeared

2.

3.

4.

5.

6.

7.

8.

9.

10.

11.

12.

13.

14.

15.

16.

17.

18.

19, if the cancellation is directly selected in Figure 9, the Oracle client is not configured, you can click the Start > Program >oracle-oraclient10g_home1> Configuration and Migration Tool >netmanager menu,

20, the presence (local configuration) interface to add the amount of data, first select the Oracle NET Configuration > Local > service naming, and then click the upper left corner of the window + or click "Edit" "create", open the (Net Service Name Wizard: Welcome) interface Enter "NET service name" and click Next (Note: The Network service name should be set consistent with the server's service name, otherwise the process form will not be opened)

21. Appear (select protocol) interface, set up TCP/IP (Internet Protocol), and click Next

22, appear (Service settings) interface, enter the hostname drink port number, and then next.

Hostname represents the machine name installed on Oracle server, port number is default, no change required

23, appear (service) interface, enter the service name, let's finish click Next

Service represents Oracle Service instance name

24, appear (test) interface, first click (Test) button, if prompted to successfully indicate a successful configuration, and then click (Finish)

25.

Second, the configuration Plsql

1. Search for the Tnsnames.ora file in the installed Oracle folder, usually under the D:\oracle\product\10.2.0\client_1\NETWORK\ADMIN path

To configure the Tnsnames.ora file, simply modify the alias, server address, service name, and port in front of the = sign. Similar:

ORA10 =

(DESCRIPTION =

(Address_list =

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

)

(Connect_data =

(service_name = ora10)

)

)

2. View environment variables

Variable name: If there is an Oracle variable value in path, if there is no need to add it,

e.g. D:\oracle\product\10.2.0\client_1\bin;

Variable name: tns_admin,

Correlation variable value: D:\oracle\product\10.2.0\client_1\bin;

Variable name: oracle_home

Variable value: D:\oracle\product\10.2.0\client_1\bin;

Variable name: Nls_lang

Variable value: Simplified Chinese_china. Zhs16gbk

3, modify Plsql Connection, open tool >preferences, can set oraclehome and OCI Library

4. Start Plsql

III. Oracle Client Offload

1. Start-Settings-control Panel-management tools-services, stop all Oracle services.

2. Start-Setup-Control Panel, uninstall Oracle client, and delete all the Oracle installation directory files.

3. Delete \program Files\oracle Directory

4. Run regedit, select Hkey_local_machine\software\oracle, and press Del to delete this entry.

5. Run regedit, select HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services, scroll through this list, and delete all Oracle portals.

6. Run regedit, select HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services, scroll through this list, and delete all Oracle portals.

7. Run regedit, select Hkey_local_machine\system\currentcontrolset\services\eventlog\application, delete all Oracle portals.

8. Right-click My Computer-Properties-advanced-environment variables to remove the settings for Oracle in Classpath and path in the environment variables. (note: Instead of erasing both the classpath and PATH environment variables, delete the Oracle-related information from the 2 environment variables)

ORACLE10G Client connection remote database configuration diagram