I made a C # And Oracle system, and it was really troublesome to install an Oracle client on each client. So I searched the internet and checked whether there was a method for not installing the client, oracle has long thought of this problem. He has provided simplified clients of various versions on his website. The client can be connected only with dozens of megabytes of size and simple configuration. Next I will talk about the implementation process.
First, build the following directory structure
Download instantclient-basic-win32-10.2.0.3-20061115.zip from the oracle's website. The specific version can be selected based on your server. Decompress the file.
Put these files in the Bin directory above and copy Oracle from the machine where oracle is installed. the key file is required and can be copied from the bin directory of the installed oracle database.
The files sqlnet. ora and tnsnames. ora in the admin folder can be copied from the machine where Oracle is installed.
Configure tnsnames. ora as follows:
ORADB = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.6.31)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = oradb) ) ) |
Change HOST and SERVICE_NAME to your server address and Instance name.
Edit the Registry file:
Windows Registry Editor Version 5.00 [HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE] "ORACLE_HOME"="D:"\\Oracle_Client" [HKEY_LOCAL_MACHINE"SOFTWARE\ORACLE\KEY_OraClient10g_home1] "ORACLE_HOME"="D:\\Oracle_Client" "NLS_LANG"="SIMPLIFIED CHINESE_CHINA.ZHS16GBK"
"ORACLE_HOME_KEY"="SOFTWARE\\ORACLE\\KEY_OraClient10g_home1"
|
Import the Registry file to the Registry.
Finally, add the oracle Path: D: \ Oracle_Client \ bin to the environment variable Path;
After the operation is complete, you 'd better restart it to make the settings take effect, so that you can enjoy the joy of connecting to Oracle.
- Auto-tuning in Oracle 11g
- Use Oracle database for Python data persistence
- Oracle PL/SQL process debugging Output Method