(1) Mono Installation
(2) install and configure Apache and xsp
(3) configure and run Castle monorails
These two days, we have been trying to connect our system to Oracle, but we are confused that the system always prompts: system. dllnotfoundexception: libclntsh. So. After Goole, many people on the Internet also encountered this problem. Refer to their instructions and methods, but they still cannot solve it. Later, I had to switch to an operating system and use opensuse. unexpectedly, I successfully connected to Oracle.
In fact, it should be relatively simple to configure oracle in Linux. Take opensuse as an example:
- first download an oracle Instant Client from Oracle, which is very small and only dozens of MB.
- decompress and copy the package to a Linux folder, such as/home/oracleclient.
- copy a tnsnames. ora file to this folder. You can also write a file in the following format:
ora10g =
(description =
(address = (Protocol = TCP) (host = 192.168.1.1) (Port = 1521)
(CONNECT_DATA =
(Server = dedicated)
(SERVICE_NAME = ora10g)
- Add:
export LD_LIBRARY_PATH =/home/oracleclient: $ LD_LIBRARY_PATH
export tns_admin =/home/oracleclient to the Apache configuration file.
- the client folder may have only one libclntsh. so.10.1, so you can create a connection file libclntsh. so, or repair the OCI in/etc/MONO/config to libclntsh. so.10.1
- restart apache
- Start the Program test.
- If the Chinese characters in Oracle are garbled characters, add the following to the Apache configuration file:
export nls_lang = american_america.al32utf8
The preceding installation assumes that Oracle data has been installed on another server. Therefore, this mono server does not need to install complicated Oracle clients. However, these configurations do not work on reahat. As always, the DLL cannot be found. Is it because it is a database server? Or is the Apache installation configuration incorrect? Further verification is required.
In the subsequent Oracle tests, most of them can be used, but errors keep occurring when dbfactory is obtained using oracleclientfactory. instance. Mono hasn't implemented this factory yet?