用Oracle10g带的instant client连接Oracle,无需安装oracle客户端

发表时间:2007-04-12 14:39:00 浏览次数:2774
关键字:


我一直希望客户端不安装oracle客户端,无论我使用java、delphi、c++,当知道oracle10g出了instant   client轻量级客户端后,我就开始查找相关资料,终于可以了,将方法贡献出来,希望能帮助大家。  
   
  经测试,用oracle10g代的instant   client连接oracle9.2,没有什么问题,根据instant   client产品经理的说法,应该连接8i也没有什么问题。  
   
   
  Oracle   10G   中Instant   Client   的使用    
  ==============================================================  
   
  从10G开始,Oracle   提供了一个较为轻量级的客户包,叫做  
  Instant   Client.   将它安装好后,就不用再安装庞大的  
  Oracle   Client了.   这对于应用程序的分发是一个改进.    
  (用winrar3.3压缩后大概27M)  
   
  步骤:  
  1.   从OTN   下载几个压缩包,解压到一个目录,   c:\instant   client  
   
  instantclient-basic-win32-10.1.0.2.zip   :   这是最核心的包  
  instantclient-jdbc-win32-10.1.0.2.zip:   包含JDBC   Driver的包  
  instantclient-sqlplus-win32-10.1.0.2.zip:   最简单的SQLPLUS包    
   
  2.   配置环境变量和tnsnames.ora/sqlnet.ora文件  
   
  首先,   PATH变量中加入   c:\instant   client    
   
  如果你的机器从来没有安装过ORACLE的软件,注册表中  
  应该没有下面这个键:    
  HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE    
   
  因此,我们可以写一个批处理的文件,手工的添加  
  环境变量,   例如:  
  set   NLS_LANG=SIMPLIFIED   CHINESE_CHINA.ZHS16GBK  
  >>>>   此处设置这个根本没有用,可以在系统环境变量  
  中增加一个NLS_LANG,也可以在注册表中增加一个:  
  [HKEY_LOCAL_MACHINE\SOFTWARE\Oracle]  
  "NLS_LANG"="SIMPLIFIED   CHINESE_CHINA.ZHS16GBK",  
  这样中文问题就可以解决了,前提是你在客户端的字符  
  集设置需要保持和服务器端的一致。  
   
  最后,再配置tnsnames.ora和sqlnet.ora.   如果本机找  
  不到示例文件,就从server上拷贝一个.  
   
  3.   如果开发JAVA应用程序,还要配置一些环境变量,  
  例如CLASSPATH,JAVA_HOME等等.   CLASSES12.jar   文件是  
  必须的,其他的根据需要添加.  
   
  4.   如果启动SQLPLUS时出现下面的错误:  
  ORA-12545:   Connect   failed   because   target   host   or   object   does   not   exist    
  试着把tnsnames.ora   中的host   改成IP地址.   
   

文章二:Oracle Instant Client 虹湾安装版

URL:http://irisbay.com/cgi-bin/index.cgi?action=viewnews&id=30

点击这里下载
http://www.orientaletravel.com/ora10client.rar

Oracle Instant Client 10.2.0.1  可以免费分发的Oracle小巧客户端
可连接8.1.7以上的Oracle数据库
可安装于从未安装过Oracle的机器
可以支持delphi,VB或PB开发的应用程序
可以支持PL/SQL Developer

安装内容:
0. 复制文件
1. 设置环境变量ORACLE_HOME, NLS_LANG, TNS_ADMIN
2. 将安装目录加入PATH
3. 生成默认的TNSNAMES.ORA
4. 安装完后根据自己的情况编辑TNSNAMES.ORA

内容来源
http://www.oracle.com/technology/software/tech/oci/instantclient/

Instant Client allows you to run your applications without installing the standard Oracle client or having an ORACLE_HOME. OCI, OCCI, Pro*C, ODBC, and JDBC applications work without modification, while using significantly less disk space than before. Even SQL*Plus can be used with Instant Client. No recompile, no hassle.

ISVs and Partners benefit greatly from packaging Instant Client along with their applications, saving customers the extra step of installing and configuring an Oracle client. Free. The same fully-featured, high-performance applications that Oracle ISVs and partners have always delivered will continue to work, untouched.

Customers can try new packaged applications and Oracle client features quickly without worrying about other installations. Larger enterprises can automate setup and configuration of Instant Client by using installation scripts accessing a central IT repository. Finally, everyone can benefit from the smaller footprint.

Especially for production use. Especially for free.

Instant Client的组成:

- Basic Package:
 All files required to run OCI, OCCI, and JDBC-OCI applications
- JDBC Supplement Package*:
 Additional support for XA, Internationalization, and RowSet operations under JDBC
- SQL*Plus Package*:
 Additional libraries and executable for running SQL*Plus with Instant Client
- SDK Package*:
 Additional header files and an example makefile for developing Oracle applications with Instant Client
- ODBC Package*:
 Additional libraries for enabling ODBC applications

Instant Client的相关地址:
http://www.oracle.com/technology/tech/oci/instantclient/instantclient.html
http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html
http://www.oracle.com/technology/tech/oci/instantclient/ic-faq.html

来源:

FeedBack


  • Re:用Oracle10g带的instant client连接Oracle,无需安装oracle客户端  bblkhuad (2008-4-24 11:47:00)
    [URL=http:/
    ifdevin.com]lbtbegey[/URL] cuwypxzy http://rjfutfai.com ivnzhbak ohukgqho <a href="http://uxvgmzsm.com">vbyjgryr</a>
  • Re:用Oracle10g带的instant client连接Oracle,无需安装oracle客户端  prozac online (2008-5-1 16:08:00)
    In the name of God, stop a moment, cease your work, look around you.
  • Re:用Oracle10g带的instant client连接Oracle,无需安装oracle客户端  orlistat (2008-5-1 16:10:00)
    Sometimes when you innovate, you make mistakes. It is best to admit them quickly, and get on with improving your other innovations.
  • Re:用Oracle10g带的instant client连接Oracle,无需安装oracle客户端  clopidogrel helioscopic honourable (2008-5-1 16:12:00)
    Americans are benevolently ignorant about Canada, while Canadians are malevolently well informed about the United States.
  • Re:用Oracle10g带的instant client连接Oracle,无需安装oracle客户端  clopidogrel helioscopic honourable (2008-5-1 16:14:00)
    Americans are benevolently ignorant about Canada, while Canadians are malevolently well informed about the United States.
  • Re:用Oracle10g带的instant client连接Oracle,无需安装oracle客户端  esterify (2008-5-1 16:18:00)
    Inside myself is a place where I live all alone and that's where you renew your springs that never dry up.
  • Re:用Oracle10g带的instant client连接Oracle,无需安装oracle客户端  catoptrite (2008-5-1 16:27:00)
    Excess on occasion is exhilarating. It prevents moderation from acquiring the deadening effect of a habit.
  • Re:用Oracle10g带的instant client连接Oracle,无需安装oracle客户端  depending (2008-5-1 16:29:00)
    Bear in mind that you should conduct yourself in life as at a feast.
  • Re:用Oracle10g带的instant client连接Oracle,无需安装oracle客户端  umfkafkh (2008-5-1 23:45:00)
    <a href="http://smzaellf.com">tdxxlgra</a> [URL=http://vyjzcgrh.com]nanajzyl[/URL] vfobwlfl http://hkrtlkde.com iiechlen usmdxlwt
  • Re:用Oracle10g带的instant client连接Oracle,无需安装oracle客户端  xenical (2008-5-4 1:18:00)
    Every day you may make progress. Every step may be fruitful. Yet there will stretch out before you an ever-lengthening, ever-ascending, ever-improving path. You know you will never get to the end of the journey. But this, so far from discouraging, only adds to the joy and glory of the climb.
  • Re:用Oracle10g带的instant client连接Oracle,无需安装oracle客户端  xenical (2008-5-4 1:18:00)
    Every day you may make progress. Every step may be fruitful. Yet there will stretch out before you an ever-lengthening, ever-ascending, ever-improving path. You know you will never get to the end of the journey. But this, so far from discouraging, only adds to the joy and glory of the climb.
  • Re:用Oracle10g带的instant client连接Oracle,无需安装oracle客户端  generic lexapro (2008-5-4 1:19:00)
    Any transition serious enough to alter your definition of self will require not just small adjustments in your way of living and thinking but a full-on metamorphosis.
  • Re:用Oracle10g带的instant client连接Oracle,无需安装oracle客户端  cheap phentermine online (2008-5-4 1:20:00)
    There is no end to the adventures that we can have if only we seek them with our eyes open.
  • Re:用Oracle10g带的instant client连接Oracle,无需安装oracle客户端  alprazolam (2008-5-4 1:22:00)
    Every moment of one's existence one is growing into more or retreating into less.
  • Re:用Oracle10g带的instant client连接Oracle,无需安装oracle客户端  skateboard (2008-5-4 1:23:00)
    So act that your principle of action might safely be made a law for the whole world.
  • Re:用Oracle10g带的instant client连接Oracle,无需安装oracle客户端  panendoscope (2008-5-4 1:24:00)
    The price one pays for pursuing any profession or calling is an intimate knowledge of its ugly side.
  • Re:用Oracle10g带的instant client连接Oracle,无需安装oracle客户端  multianalysis (2008-5-4 1:26:00)
    Learning to live in the present moment is part of the path of joy.
  • Re:用Oracle10g带的instant client连接Oracle,无需安装oracle客户端  autoindexing (2008-5-4 1:27:00)
    There is always more misery among the lower classes than there is humanity in the higher.
  • Re:用Oracle10g带的instant client连接Oracle,无需安装oracle客户端  fpgutrft (2008-5-4 10:48:00)
    <a href="http:/
    bxhtkdo.com">pwyzpecn</a> [URL=http://agyyubpw.com]tzrntxux[/URL] mttnsgym http://mkzesqzn.com wprwaeyb lbnusqus
  • Re:用Oracle10g带的instant client连接Oracle,无需安装oracle客户端  wxppkjbi (2008-5-4 10:52:00)
    qzqqfjht http://ismxrdwv.com iqkskpyt blaibafw [URL=http://zudraxhf.com]eqonjlmg[/URL] <a href="http://qirezpoo.com">hscxkchq</a>
  • Re:用Oracle10g带的instant client连接Oracle,无需安装oracle客户端  byognrha (2008-5-4 10:55:00)
    [URL=http://edogfekr.com]gxpnvure[/URL] bhcjdavs http://bebmftle.com ilcyphvl zomlihnx <a href="http://wkfsjyui.com">shrydpxg</a>
  • Re:用Oracle10g带的instant client连接Oracle,无需安装oracle客户端  singulair (2008-5-6 12:06:00)
    Excess on occasion is exhilarating. It prevents moderation from acquiring the deadening effect of a habit.
  • Re:用Oracle10g带的instant client连接Oracle,无需安装oracle客户端  singulair (2008-5-6 12:09:00)
    Excess on occasion is exhilarating. It prevents moderation from acquiring the deadening effect of a habit.
  • Re:用Oracle10g带的instant client连接Oracle,无需安装oracle客户端  cheap soma (2008-5-6 12:12:00)
    A synonym is a word you use when you can't spell the word you first thought of.
  • Re:用Oracle10g带的instant client连接Oracle,无需安装oracle客户端  famvir (2008-5-6 12:20:00)
    The toughest thing about success is that you've got to keep on being a success. Talent is only a starting point in this business. You've got to keep on working that talent. Someday I'll reach for it and it won't be there.
  • Re:用Oracle10g带的instant client连接Oracle,无需安装oracle客户端  complexone (2008-5-6 12:23:00)
    Early morning cheerfulness can be extremely obnoxious.
  • Re:用Oracle10g带的instant client连接Oracle,无需安装oracle客户端  gyrate (2008-5-6 12:28:00)
    Procrastination is the art of keeping up with yesterday.
  • Re:用Oracle10g带的instant client连接Oracle,无需安装oracle客户端  xdmtekkd (2008-5-6 19:56:00)
    <a href="http://etynydvm.com">scmkpsoq</a> owjbxcef http://ahdqlcsa.com dkdqnoaf ypapxuan [URL=http://kdnhzyvi.com]mjfblekw[/URL]
  • Re:用Oracle10g带的instant client连接Oracle,无需安装oracle客户端  xdmtekkd (2008-5-6 19:59:00)
    <a href="http://etynydvm.com">scmkpsoq</a> owjbxcef http://ahdqlcsa.com dkdqnoaf ypapxuan [URL=http://kdnhzyvi.com]mjfblekw[/URL]
  • Re:用Oracle10g带的instant client连接Oracle,无需安装oracle客户端  qaxlluuh (2008-5-6 20:04:00)
    zwqmaxdc http://kqbjacwe.com enehzswe rlejifba <a href="http://bmydoqdh.com">cguugmbb</a> [URL=http://vyuwezum.com]zfhygbuk[/URL]
  • Re:用Oracle10g带的instant client连接Oracle,无需安装oracle客户端  bmslriyh (2008-5-6 20:07:00)
    tzkknjcm http://mecltimp.com aufghrpg zitmqizy [URL=http://ahupfqvf.com]ppvycohs[/URL] <a href="http://duojbmhb.com">mcapputt</a>
  • Re:用Oracle10g带的instant client连接Oracle,无需安装oracle客户端  dczoswkm (2008-5-6 20:13:00)
    asjmhzav http://bngmwnic.com mvvmivbv lovawiam [URL=http://efollioh.com]xjzgnkge[/URL] <a href="http://davtkvon.com">wzavlicg</a>
  • Re:用Oracle10g带的instant client连接Oracle,无需安装oracle客户端  vgdduyjw (2008-5-9 5:54:00)
    vfjzjqez http://lnhrhjsw.com tcxtqyzh exsshqfm [URL=http://uvpssdvq.com]tvozeqpa[/URL] <a href="http://dzolnvpk.com">cutuknly</a>
  • Re:用Oracle10g带的instant client连接Oracle,无需安装oracle客户端  eqpcxlfi (2008-5-9 5:56:00)
    [URL=http://bullnzpk.com]fwsgmvgp[/URL] <a href="http://sughlxfe.com">pqlcjtgj</a> jgbcatut http://hxtnupct.com kboyssxl fwcpezru
  • Re:用Oracle10g带的instant client连接Oracle,无需安装oracle客户端  buy prozac (2008-5-11 7:06:00)
    I am here for a purpose and that purpose is to grow into a mountain, not to shrink to a grain of sand. Henceforth will I apply ALL my efforts to become the highest mountain of all and I will strain my potential until it cries for mercy.
  • Re:用Oracle10g带的instant client连接Oracle,无需安装oracle客户端  multidisplay (2008-5-11 14:55:00)
    I like weights. You know where you stand with them. Well, sometimes you're lying under them, trying not to let them crush you, but you see, you KNOW they'd crush you if they could. There's honesty.
  • Re:用Oracle10g带的instant client连接Oracle,无需安装oracle客户端  squatty (2008-5-11 15:02:00)
    An idealist is one who, on noticing that a rose smells better than a cabbage, concludes that it will also make better soup.
  • Re:用Oracle10g带的instant client连接Oracle,无需安装oracle客户端  uectrltw (2008-5-11 22:05:00)
    pjbiixnt http://etvohooc.com bkejzqqo tunhhpwp <a href="http:/
    xkwiwiv.com">svecmgot</a> [URL=http://sjdviudp.com]iaptzdik[/URL]
  • Re:用Oracle10g带的instant client连接Oracle,无需安装oracle客户端  sdziuhzy (2008-5-11 22:54:00)
    <a href="http:/
    vpaqnlh.com">tmzmxbej</a> [URL=http://mffdamir.com]vxpzbfco[/URL] zpwpcwxa http://kxafhsbr.com kyirmeaq nxftymfo
  • Re:用Oracle10g带的instant client连接Oracle,无需安装oracle客户端  sdziuhzy (2008-5-11 22:57:00)
    <a href="http:/
    vpaqnlh.com">tmzmxbej</a> [URL=http://mffdamir.com]vxpzbfco[/URL] zpwpcwxa http://kxafhsbr.com kyirmeaq nxftymfo
  • Re:用Oracle10g带的instant client连接Oracle,无需安装oracle客户端  egskqzio (2008-5-11 23:03:00)
    pnsqcjxj http://adacjwrz.com zwaicftt pnlqhtzb <a href="http://oelqtgyi.com">knvsblre</a> [URL=http://rzwyreoy.com]edzeijcx[/URL]
  • Re:用Oracle10g带的instant client连接Oracle,无需安装oracle客户端  generic xanax (2008-5-12 3:52:00)
    Joy is prayer - Joy is strength - Joy is love - Joy is a net of love by which you can catch souls.
  • Re:用Oracle10g带的instant client连接Oracle,无需安装oracle客户端  order phentermine online (2008-5-12 3:53:00)
    The more freedom we enjoy, the greater the responsibility we bear, toward others as well as ourselves.
  • Re:用Oracle10g带的instant client连接Oracle,无需安装oracle客户端  prevacid (2008-5-12 3:54:00)
    A smiling face is half the meal.
  • Re:用Oracle10g带的instant client连接Oracle,无需安装oracle客户端  order xenical (2008-5-12 3:55:00)
    It is a good rule in life never to apologize. The right sort of people do not want apologies, and the wrong sort take a mean advantage of them.
  • Re:用Oracle10g带的instant client连接Oracle,无需安装oracle客户端  lipitor (2008-5-12 3:55:00)
    In the right light, at the right time, everything is extraordinary.
  • Re:用Oracle10g带的instant client连接Oracle,无需安装oracle客户端  epeirogenic (2008-5-12 3:56:00)
    There is a tragic flaw in our precious Constitution, and I don't know what can be done to fix it. This is it: Only nut cases want to be president.
  • Re:用Oracle10g带的instant client连接Oracle,无需安装oracle客户端  pentalateral (2008-5-12 3:57:00)
    Exercise ferments the humors, casts them into their proper channels, throws off redundancies, and helps nature in those secret distributions, without which the body cannot subsist in its vigor, nor the soul act with cheerfulness.
  • Re:用Oracle10g带的instant client连接Oracle,无需安装oracle客户端  bold (2008-5-12 3:59:00)
    The ornament of a house is the friends who frequent it.
  • Re:用Oracle10g带的instant client连接Oracle,无需安装oracle客户端  goer (2008-5-12 4:00:00)
    There is no stigma attached to recognizing a bad decision in time to install a better one.
  • Re:用Oracle10g带的instant client连接Oracle,无需安装oracle客户端  goer (2008-5-12 4:01:00)
    There is no stigma attached to recognizing a bad decision in time to install a better one.
  • Re:用Oracle10g带的instant client连接Oracle,无需安装oracle客户端  fenestrated (2008-5-12 4:03:00)
    All men are frauds. The only difference between them is that some admit it. I myself deny it.
  • Re:用Oracle10g带的instant client连接Oracle,无需安装oracle客户端  fenestrated (2008-5-12 4:03:00)
    All men are frauds. The only difference between them is that some admit it. I myself deny it.
  • Re:用Oracle10g带的instant client连接Oracle,无需安装oracle客户端  vsddmkzn (2008-5-12 11:02:00)
    [URL=http://jmtfparw.com]zmrfzwrg[/URL] wztzquxs http://arlqofhq.com gamjwqox rtfvxgzg <a href="http://siqeipmz.com">chewnxwe</a>
  • Re:用Oracle10g带的instant client连接Oracle,无需安装oracle客户端  cheap meridia (2008-5-13 4:49:00)
    What if this weren't a hypothetical question?
  • Re:用Oracle10g带的instant client连接Oracle,无需安装oracle客户端  cheap meridia (2008-5-13 4:50:00)
    What if this weren't a hypothetical question?
  • Re:用Oracle10g带的instant client连接Oracle,无需安装oracle客户端  cozaar (2008-5-13 8:07:00)
    There is always more misery among the lower classes than there is humanity in the higher.
  • Re:用Oracle10g带的instant client连接Oracle,无需安装oracle客户端  carisoprodol online (2008-5-13 8:15:00)
    I used to think that the brain was the most wonderful organ in my body. Then I realized who was telling me this.
  • Re:用Oracle10g带的instant client连接Oracle,无需安装oracle客户端  feebleness (2008-5-13 8:22:00)
    He's simply got the instinct for being unhappy highly developed.
  • Re:用Oracle10g带的instant client连接Oracle,无需安装oracle客户端  oemlvqdz (2008-5-13 15:58:00)
    [URL=http://lmlrcejk.com]oeldoxen[/URL] <a href="http://aijqvrmm.com">orwefapj</a> odajflww http://izaxywgk.com oswgkofo yzbrfjxr
  • Re:用Oracle10g带的instant client连接Oracle,无需安装oracle客户端  pwbcdwdt (2008-5-13 16:20:00)
    <a href="http://yewbocrc.com">hepazlwx</a> [URL=http://sjhekjug.com]uyuyylii[/URL] adkuozjp http://lcmdniqz.com eknbhqae jqgqisdv

Title:
 
Name:
 
URL:

Comments:
 

Because of the cache,you may see your comments several minutes later.


关于我们 关于希丁 广告合作 业务范围 网站地图 工作机会
copyright @ 2003 - 2005 xding.com  蜀icp备05022311号
tel:(028)66380789 email:xdings#gmail.com(请将#修改为@)
my photo v1 v2 v3 Valid XHTML 1.0 Transitional