Today, using Navicat to connect to the Oracle database, the following error was reported: "ORA-12737 Instant Client light:unsupported server character Set ZHS16GBK"From this error, it can be known that the client does not support the server-side character set caused, but to modify the server-side character set is not r
Tags: enterprise RAM fill using the English OCI directory contains catToday, using Navicat to connect to the Oracle database, the following error was reported: "ORA-12737 Instant Client light:unsupported server character Set ZHS16GBK"From this error, it can be known that the client does not support the server-side char
Preface does not remember, Baidu all have.
Problem 1: Unable to find dynamic library libsqlplus.so, this library is present under the Lib folder, if there is no wrong version, this problem should be unable to find dynamic link library.
On-line general advice in/etc/profile
Export ld_library_path= $ORACLE _home/lib: $LD _library_path
In general, this configuration can solve the problem, but depending on the version, there is a problem of ld_library
1, the first to download the instant client for their own system, can be downloaded through the address below.
Http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html
2, directly extract to the directory you want to store, such as: c:instantclient_11_2
3. Edit Environment variables:
Tns
Error message:Official Download Instant client Download:Http://www.oracle.com/technetwork/cn/topics/intel-macsoft-102027-zhs.htmlMacos+navicat+instantclient Implementing Oracle Connectivity:http://blog.csdn.net/lei32323/article/details/75196404Extended:For Mac OS X 10.11 El Capitan users, the root user does not have permission to modify the/usr/bin directory beca
; American _ America. al32utf8
From the composition of nls_lang, we can see that the real impact on the database character set is actually the third part.
Therefore, if the character set between the two databases is the same as that in the third part, data can be imported and exported to each other. The preceding information is only prompted in Chinese or English.
2. view database character sets
This involves three character sets,
The first is the character set of the kernel El server;
The secon
1. Download the corresponding version of the instant Client from the Oracle Web site and extract it to e:/instantclient_11_2
2. Copy the Network/admin directory on the installed Oracle machine to E:/instantclient_11_2
Tns_admin=e:/instantclient_11_2/network/admin
This step path must be set correctly, a lot of online
Install Oracle Instant client locally, download, extract, configure environment variables, execute sqlplus, and the error is as follows:
[Root@abc ~]# SqlplusSqlplus:error while loading shared libraries:libaio.so.1:cannot open Shared object file:no such file or directory[Root@abc ~]# which sqlplus/usr/local/instantclient_11_2/sqlplus[Root@abc ~]# Ldd/usr/local/i
, it must be to let the system understand them. The main environment variables are:Oracle_homeNls_languageNls_adminConcrete meaning, everyone to understand it, here is not much to say.
Installing the ODBC driverAs shown, run its install ODBC driver, this EXE is a console application, too fast to see the results of execution, I have done this, edit a bat file, the content is:In this way, the finished results can be seen in the 1.txt file.
To see if the driver was successfully installedN
Do a C # and Oracle system, think of each client also install Oracle client is really troublesome, so the Internet search, whether there is no way to install the client, is really good, Oracle has already thought of this problem.
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
First, download the Oracle client: http://www.oracle.com/technetwork/topics/winsoft-085727.htmlCurrent Latest VersionVersion 12.1.0.2.0Select the first instant Client for Microsoft Windows (32-bit) to download it,Please do not download 64bit, I have tried, can not achieve the connection.Unzip the downloaded Instantclie
Http://www.oracle.com/technetwork/cn/database/features/instant-client/index-092699-zhs.htmlDownload the corresponding Instant Client package on the official website and solution to C: \.Run the following batch.REG ADD "HKLM\SYSTEM\CurrentControlSet\Control\Session manager\environment"/V oracle_home/t reg_sz/d "c \ Inst
Dollars instant chat client application source code, dollars instant chat
This source code project is a Dollars instant chat client application source code, the source code is also relatively simple, hope this case can help you learn and use.
Source code download: http://cod
1. Build server-Installation sequence-(Mysql->openfire->spark)Database: MySQLServer Management tools: OpenFireTest tool: SparkMySQL installation http://www.cnblogs.com/xiaodao/archive/2013/04/04/2999426.htmlNote: At the end of the terminal to execute the MySQL command, the last to be sealed number (;)OpenFire installation http://www.cnblogs.com/xiaodao/archive/2013/04/05/3000554.htmlBackground Management interface: http://localhost:9090/index.jspLogin name and password default is Admin adminServ
Instant-client (Database Instant client)Official note: The instant client is available under a separate OTN development and distribution license for Instant
In some cases, for example, you only want to install some client software to connect to the database for basic operations or testing. To achieve the connection, you need to install the oracle client, for this orac
In some cases, for example, you only want to install some client software to connect to the database for b
Use Instant Client to configure PL/SQL Developer, instantpl
Previously PL/SQL Developer was used to directly install the full version of Oracle Database on the local machine. One was easy to use, and the other was able to perform some demo tests on the local machine. Recently, I changed my computer, it seems that the Instant
used. Finally, it introduces the XMPP Java open-source solution: openfire + smack + spark.
Location Awareness Service Based on instant messaging and LBS technology (III): Building an openfire SERVER + testing two IM clients (Internet address)
The third article explains in detail the XMPP-based openfire service setup and the use of two heterogeneous XMPP-based desktop clients to test instant messaging.
Note
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.