ORACLE11G Remote Connection Configuration Visual Studio 2003

Server-side configuration: oracle11g R2 x64

1. Setting Up Monitoring

A. Net Manager, configuration and migration tools, start-up bar, starting with program-ORACLE-ORADB11G_HOME1

B.oracle Net Configuration--------local listener, LISTENER, to see if there is a local address on the listener, no Add, Host: "LocalHost", Port: 1521, Protocol: TCP/IP

2. Turn off all firewalls (including window firewall)

3. Start the TNS Monitoring service: LSNRCTL start (This program LSNRCTL.exe is located in the Oracle_path/product/11.2.0/dbhome_1/bin directory

Client (Windows)

1. Download instant Client for Microsoft Windows (32bit) and install, Address: Instant client Download

2. Add the Instant Client installation directory to the PATH environment variable

3. Create the Tnsnames.ora configuration file with the following format:

[Plain]View Plaincopy

2. #  Tnsnames.ora network configuration file: c:\e\orcldb\product\11.2.0\dbhome_1\network\admin \tnsnames.ora  
4. # Generated by Oracle configuration tools.
8. WSR =
10. (DESCRIPTION =
12. (Address_list =
14. (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.112) (PORT = 1521))
16. )
18. (Connect_data =
20. (service_name = ORCL)
22. )
24. )
28. Oraclr_connection_data =
30. (DESCRIPTION =
32. (Address_list =
34. (ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1521))
36. )
38. (Connect_data =
40. (SID = Clrextproc)
42. (PRESENTATION = RO)
44. )
46. )
50. LISTENER_ORCL =
52. (ADDRESS = (PROTOCOL = TCP) (HOST = localhost) (PORT = 1521))
56. ORCL =
58. (DESCRIPTION =
60. (Address_list =
62. (ADDRESS = (PROTOCOL = TCP) (HOST = localhost) (PORT = 1521))
64. )
66. (Connect_data =
68. (SERVER = dedicated)
70. (service_name = ORCL)
72. )
74. )

For example, this file, I created the TNS service named Wrs,oracle server address is 192.168.1.112,oracle server listening port is 1521, the connected Oracle database name is ORCL, can be replaced in this format.

4. Add the Tns_admin environment variable and point to the created Tnsnames.ora configuration file.

Now that the configuration is complete, you can connect to the remote Oracle database with tools such as PL/SQL developer, which is the added TNS service name (WSR here)

If you want to use ODBC to connect to the database, also add ODBC data source, 64-bit system with c:\windows\syswow64\odbcad32.exe,32 bit system with C:\Windows\System32\odbcad32.exe

ORACLE11G Remote Connection Configuration Visual Studio 2003