Use Oracle Instant Client connection

2010-08-22  来源:本站原创  分类:Database  人气:170 

Instant Client Download: http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html

Once downloaded unzip to a specified directory, the directory in a folder called NETWORK, then under this folder and then build ADMIN folder, and then set up tnsnames.ora file, the contents of the following format:

ORACLECONNECTNAME =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = SERVERIP) (PORT = 1521))
)

(CONNECT_DATA =
(SERVICE_NAME = SERVERSID)
)

)
Configuration according to their actual situation; you can also Copy over the previous tnsnames.ora file.

Then open the PL / SQL, the connection need to enter a user name and password when the Cancel, and then set the OCI Library perference inside and Oracle_home, OCI Library = unpack directory \ oci.dll, Oracle_home = unpack directory.

This can be connected to the query, but the inquiry found that when the Chinese will show garbled ...

Then need to set the client character set, so check out the data will not be garbled.

However, to avoid registry changes, we'll write a batch PLSQLDevelop. Bat to achieve the client's character set to set, then the batch file into PLSQLDevelop directory, which reads as follows:

set nls_lang = SIMPLIFIED CHINESE_CHINA.ZHS16GBK (server configured character set)
PLSQLDevelop.exe

Finally execute the batch file can be a normal use PLSQLDevelop (and registry changes compared to the implementation of the batch of flaws that after the completion of each man will have to close the batch window, or let him go, until the PLSQLDevelop.exe off).

相关文章
  • Use Oracle Instant Client connection 2010-08-22

    Instant Client Download: http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html Once downloaded unzip to a specified directory, the directory in a folder called NETWORK, then under this folder and then build ADMIN folder

  • install Oracle instant client for linux HOWTO 2010-07-28

    install Oracle instant client for linux HOWTO Guide for: 1.install oracle instant client 2.install cx_oracle for python wget http://prdownloads.sourceforge.net/cx-oracle/cx_Oracle-5.0.4.tar.gz?download download instantclient-basic-linux-x86-64-10.2.0

  • ORACLE Instant Client 11.2 configuration 2011-05-11

    Today suddenly the task of learning oracle database, it began, but found a lot of information online, or not fully, or that is a lot, we all copy plus copy, I'll try this side of distribution transformer, the temporary record under the plan for the f

  • Use oracle instant client, do not install the client remotely connect to the database using plsql 2011-08-03

    Win7 64-bit operating system to install oracle client encounters a problem, then try the instant client, the installation is complete, PL / SQL to connect oracle database successfully, the following summarize the installation and configuration. First

  • Oracle instant client setup on RHEL 2011-04-13

    Download rpms for Oracle 11g R2 instant client from Oracle. You need at least: instantclient-basic-linux Install the rpms. Add the "/usr/lib/oracle/11.2/client/lib" to "/etc/ld.so.conf" as root and run /sbin/ldconfig. With this step yo

  • Oracle instant client的使用 2012-05-29

    最近重装了操作系统,使用的是Windows7 x64的版本,不准备安装Oracle,于是从官网上看到了Instant Client. 兴冲冲下载了一个64位的版本,instantclient-basic-windows.x64-11.2.0.3.0.zip,配置好后,使用PL/SQL Develpoer却提示无法连接,原因是PLSQLDev是32位的,没有64位的版本,因此使用的Oracle的dll也还是32位的.于是再次下载32位的版本instantclient-basic-nt-11.2.0

  • [Reserved] Oracle RAC client connection unstable solution 2010-10-10

    Oracle RAC installation is complete, monitoring, tnsname.ora After the default configuration according to Oracle, sqlplus connection with the server side is no problem, but the connection with the client, there will sometimes Rom error, the solution:

  • navicat Oracle Instant Client Light: unsupported server character set CHS16GBK solution 2011-09-02

    1 First, we open the "tools "-->" options" menu, see the following screen, according to the OCI library (oci.dll) path, navigate to the navicat oci directory, backup the files inside. (2) in the oracle client installation directory

  • The unit does not install the Oracle client, use the PL / SQL Developer kit connection and Instant Client 2011-05-04

    1, the first site to download Oracle Instant Client: http://www.oracle.com/technology/global/cn/software/tech/oci/instantclient/index.html Depending on your operating system to select a different version of Instant Client Download back is a compresse

  • Oracle 11g client configuration 2011-01-13

    Windows, Oracle 11G - ODAC 11.2 Release 3 Installation and Configuration Download the Oracle 11G client tools: ODAC 11.2 Release 3 (11.2.0.2.1) with Oracle Developer Tools for Visual Studio , the components included: - Oracle Developer Tools for Visu

  • Oracle instant clent for ruby / rails on cygwin 2009-02-27

    Environment: XP: oracle full client, ruby, rails, gem cygwin: ruby rails, gem (the version with the XP version) Needs: for cygwin is installed under the rails platform support oci Steps: <1> download oracle instant client (10.2.0.3 Instant Client Pa

  • Oracle's instant Client 2011-08-25

    Sometimes or very easy to use Instant Client, do not install the client directly to more than 10 packages of M extract. Then in the directory to establish a tnsname.ora Then look at the system variable settings, you can use the OCI method call. LD_LI

  • Integrated with ORACLE PLSQL client to connect ORACLE server description and abnormal (ORA-12154.ORA-01031.ORA-12737) summary. 2011-01-06

    Configure ORACLE PLSQL client integrated with ORACLE server connection 1 Download Oracle Client Package. 2 local preservation Oracle Client Package: Create a folder, such as oracle client, plus the downloaded compressed file to this folder. (My direc

  • ORA-12518: TNS: listener could not hand off client connection 2010-04-20

    Transfer from http://blog.sina.com.cn/s/blog_5904ea280100g614.html ORA-12518: TNS: listener could not hand off client connection Cause: The process of handing off a client connection to another process failed. Action: Turn on listener tracing and re-

  • oracle 9i client can not seem to access the server 10g 2010-06-01

    Original, allowing reproduced, but please indicate the source. Thank you Words in the field debugging environment, users log on the database server no problem, the remote access client using java program no problem, can use the client login is not, m

  • [Change] Windows following Oracle10g Instant Client Configuration - Installation and Configuration 2010-08-16

    Installation guide Installation steps: 1. For your platform, download the appropriate instant client package. Require the installation of all the Basic or Basic Lite package. 2. Will extract the package into a single directory, such as "instantclient

  • The way to learn Linux - Oracle. MySQL client management tools navicat9 2010-11-25

    Download free version: http://download.navicat.com/download/navicat9_lite_cs.tar.gz No installation, simply double-click start_navicat after decompression to start. Problems: Link to a remote oracle database using navicat encountered 12737 error, Int

  • TNS-12518: TNS: listener could not hand off client connection 2011-01-06

    Stress tests to make a background that the following questions: Database using c3p0, reported the following exception: [2010/12/31 00:00:02] [WARN] (BasicResourcePool.java: 1841) - com.mchange.v2.resourcepool.BasicResourcePool $ AcquireTask @ 12a10be

  • Linux Learning Path - Oracle. MySQL client management tools navicat9 2010-11-25

    Download free version: http://download.navicat.com/download/navicat9_lite_cs.tar.gz Not installed, unpacked direct double start_navicat to start. Problems: Link to remote oracle database using navicat error 12737 encountered, Internet search, said th

  • Windows, installed Oracle 10G Client 2011-04-10

    Original: http://www.cnblogs.com/kevinsun/archive/2007/10/19/930623.html 1 in the Oracle website http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html download instantclient-basic-win32-10.2.0.3-20061115.zip (34,469,920