在win7的操作系统下安装Oracle11R2

Bertha 。 2021-11-17 16:38 209阅读 0赞

## 转：[http://blog.sina.com.cn/s/blog\_4054cfa30100o6ls.html][http_blog.sina.com.cn_s_blog_4054cfa30100o6ls.html]  ##

![此博文包含图片][sg_trans.gif] (2010-11-09 17:49:00)

[![sg_trans.gif][]转载][http_blog.sina.com.cn_s_blog_4054cfa30100o6ls.html]

<table style="margin-left:0px;line-height:normal;"> 
 <tbody> 
  <tr> 
   <td style="margin-left:0px;font-size:12px;font-family:Verdana, '宋体', sans-serif;line-height:18px;"> 
    <div> 
     <div>
       在win7的操作系统下安装Oracle11R2 
     </div> 
     <div> 
      <p style="margin-left:0px;border-top-width:0px;border-right-width:0px;border-bottom-width:0px;border-left-width:0px;list-style-type:none;line-height:18px;">在win7的操作环境中大部分的Oracle安装都显得那么的困难，这段时间我也在学Oracle，下了Oracle9却无法安装就去，查了一天的资料，只好去下64位的Oracle11R2，大家可以到<a href="http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html" style="text-decoration:none;color:#6a6352;" rel="nofollow">http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html</a>去下载如下的两个压缩的文件（win64_11gR2_database_1of2.zip和win64_11gR2_database_2of2.zip），注意这连个文件一定要解压到同一个文件里面，不要分解窑到连个文件夹里面，不让在安装的时候就会出错先先前的错误：</p> 
      <p style="margin-left:0px;border-top-width:0px;border-right-width:0px;border-bottom-width:0px;border-left-width:0px;list-style-type:none;line-height:18px;">racle11g for windows2008&nbsp;安装错误:未找到文件WFMLRSVCApp.ear<br>将win64_11gR2_database_1of2.zip和win64_11gR2_database_2of2.zip分别解压后，<br>点开始安装，过程很顺利，到54%时杯具出现了：未找到文件&nbsp;c:oracle....WFMLRSVCApp.ear。<br>查看install guide找不到解决方法，最后，把两个文件解压到同一个目录下面，再安装，终于顺利完成了。</p> 
      <div> 
       <p style="margin-left:0px;border-top-width:0px;border-right-width:0px;border-bottom-width:0px;border-left-width:0px;list-style-type:none;line-height:18px;">在解压的时候你会发现解药的文件有许多后缀名为（jad）的文件，那就是预告你这个安装程序是基于Java的，意思就是要安装Java的jdk（jdk-6u18-windows-i586_java_SE.exe）Java SE，可以到<a href="http://java.com/zh_CN/" style="text-decoration:none;color:#6a6352;" rel="nofollow">http://java.com/zh_CN/</a>下载安装后，我门就可以安装oracle了，双击setup.exe就可以一路安装下去了</p> 
       <p style="margin-left:0px;border-top-width:0px;border-right-width:0px;border-bottom-width:0px;border-left-width:0px;list-style-type:none;line-height:18px;">&nbsp;</p> 
      </div> 
      <p style="margin-left:0px;border-top-width:0px;border-right-width:0px;border-bottom-width:0px;border-left-width:0px;list-style-type:none;line-height:18px;">下载一个PL/SQL &nbsp;Developer8.04下来进行安装，按住后但是无法使用，查了一天的资料总算找到了结果；</p> 
      <p style="margin-left:0px;border-top-width:0px;border-right-width:0px;border-bottom-width:0px;border-left-width:0px;list-style-type:none;line-height:18px;">1、要想使用PL/SQL需要先安装oracle客户端（这个是必须的，要不然plsql就用不了，</p> 
      <p style="margin-left:0px;border-top-width:0px;border-right-width:0px;border-bottom-width:0px;border-left-width:0px;list-style-type:none;line-height:18px;">这个客户端可以去oracle官网上下载，名字叫instance client（全名instantclient-basic-win32-11.2.0.1.0，我安装的oracle 11是64为的，但是PL/SQL &nbsp;Developer8.04是32&nbsp;位的，那就是要下载一个32&nbsp;位的instance client）,尽量用较新的版本就可以了</p> 
      <p style="margin-left:0px;border-top-width:0px;border-right-width:0px;border-bottom-width:0px;border-left-width:0px;list-style-type:none;line-height:18px;">，windows版的大的也就50多M，还有精简版的20多M，</p> 
      <p style="margin-left:0px;border-top-width:0px;border-right-width:0px;border-bottom-width:0px;border-left-width:0px;list-style-type:none;line-height:18px;">地址：<span style="line-height:18px;"><a href="http://www.oracle.com/technology/global/cn/software/tech/oci/instantclient/index.html" style="text-decoration:none;color:#6a6352;" rel="nofollow">http://www.oracle.com/technology/global/cn/software/tech/oci/instantclient/index.html</a></span>，</p> 
      <p style="margin-left:0px;border-top-width:0px;border-right-width:0px;border-bottom-width:0px;border-left-width:0px;list-style-type:none;line-height:18px;">挑个适合你的系统的版本的。）</p> 
      <p style="margin-left:0px;border-top-width:0px;border-right-width:0px;border-bottom-width:0px;border-left-width:0px;list-style-type:none;line-height:18px;">oracle客户端的安装很简单，直接解压出来，放到你oracle所安装的x:\app\Administrator\product目录下，我的oracle是按在F盘，所以我就解压到F:\app\Administrator\product目录下如图：</p> 
      <p style="margin-left:0px;border-top-width:0px;border-right-width:0px;border-bottom-width:0px;border-left-width:0px;list-style-type:none;line-height:18px;"><a href="http://photo.blog.sina.com.cn/showpic.html#blogid=4054cfa30100o6ls&amp;url=http://s14.sinaimg.cn/orignal/4054cfa3x7542c50cfbbd" style="text-decoration:none;color:#6a6352;" rel="nofollow"><img src="http://s14.sinaimg.cn/middle/4054cfa3x7542c50cfbbd&amp;690" width="269" height="149" alt="在win7的操作系统下安装Oracle11R2" title="在win7的操作系统下安装Oracle11R2" style="margin-left:0px;border-top-width:0px;border-right-width:0px;border-bottom-width:0px;border-left-width:0px;list-style-type:none;"></a><br><br><a href="http://b58.photo.store.qq.com/http_imgload.cgi?/rurl4_b=7cd9efa1327a3efc8cb14afc67da46605de49e8d16e72d9ff4d047c6ae5f7d21dbabd1acf9f7081934c5bbc6195088b17fdf4a2c83416889ec1649669baad9dd3333ec188cb11d86929b58be6a7e446ee08cf2c8&amp;a=46&amp;b=58" style="text-decoration:none;color:#6a6352;" rel="nofollow"></a></p> 
      <p style="margin-left:0px;border-top-width:0px;border-right-width:0px;border-bottom-width:0px;border-left-width:0px;list-style-type:none;line-height:18px;">&nbsp;</p> 
      <p style="margin-left:0px;border-top-width:0px;border-right-width:0px;border-bottom-width:0px;border-left-width:0px;list-style-type:none;line-height:18px;">（被选择的就是解压出来，被我去掉了最顶层文件的文件夹所以名字有点不一样）</p> 
      <p style="margin-left:0px;border-top-width:0px;border-right-width:0px;border-bottom-width:0px;border-left-width:0px;list-style-type:none;line-height:18px;">在oracle的安装路径F:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN的文件夹里找到tnsnames.ora，并拷贝到文件到InstantClient解压目录F:\app\Administrator\product\instantclient_11_2下，这一下就算大功完成了一般哟，呵呵呵呵</p> 
      <p style="margin-left:0px;border-top-width:0px;border-right-width:0px;border-bottom-width:0px;border-left-width:0px;list-style-type:none;line-height:18px;">接下来就是配置PL/SQL &nbsp;Developer8.04：</p> 
      <p style="margin-left:0px;border-top-width:0px;border-right-width:0px;border-bottom-width:0px;border-left-width:0px;list-style-type:none;line-height:18px;">在非登录状态下进入PL/SQL developer,进入首选项,在connection中设置Oracle_Home和OCI Library,其中</p> 
      <p style="margin-left:0px;border-top-width:0px;border-right-width:0px;border-bottom-width:0px;border-left-width:0px;list-style-type:none;line-height:18px;">Oracle_Home设置为InstantClient的解压目录,OCI Library设置为该目录下的oci.dll.如图：</p> 
      <p style="margin-left:0px;border-top-width:0px;border-right-width:0px;border-bottom-width:0px;border-left-width:0px;list-style-type:none;line-height:18px;"><a href="http://photo.blog.sina.com.cn/showpic.html#blogid=4054cfa30100o6ls&amp;url=http://s1.sinaimg.cn/orignal/4054cfa3x949bb580a970" style="text-decoration:none;color:#6a6352;" rel="nofollow"><img src="/images/20211116/c6a79b7a97bf4042b7fa35c142ed5968.png" width="408" height="186" alt="在win7的操作系统下安装Oracle11R2" title="在win7的操作系统下安装Oracle11R2" style="margin-left:0px;border-top-width:0px;border-right-width:0px;border-bottom-width:0px;border-left-width:0px;list-style-type:none;"></a><br><br><br><a href="http://b52.photo.store.qq.com/http_imgload.cgi?/rurl4_b=7cd9efa1327a3efc8cb14afc67da466061fcbb414d04b151cc55dad78a682fe081b3e6e36e64ed85ec3fce9ffc1e3344c923f0edb998e13530e3514bb4b158147632bb65fe2b4a44c57556198c838c1cc92dadd9&amp;a=51&amp;b=52" style="text-decoration:none;color:#6a6352;" rel="nofollow"></a></p> 
      <p style="margin-left:0px;border-top-width:0px;border-right-width:0px;border-bottom-width:0px;border-left-width:0px;list-style-type:none;line-height:18px;">&nbsp;</p> 
      <p style="margin-left:0px;border-top-width:0px;border-right-width:0px;border-bottom-width:0px;border-left-width:0px;list-style-type:none;line-height:18px;">单击确定。</p> 
      <p style="margin-left:0px;border-top-width:0px;border-right-width:0px;border-bottom-width:0px;border-left-width:0px;list-style-type:none;line-height:18px;">&nbsp;</p> 
      <p style="margin-left:0px;border-top-width:0px;border-right-width:0px;border-bottom-width:0px;border-left-width:0px;list-style-type:none;line-height:18px;">接下来到win7的桌面上右键单击我的电脑-》属性》高级系统设置》环境变量</p> 
      <p style="margin-left:0px;border-top-width:0px;border-right-width:0px;border-bottom-width:0px;border-left-width:0px;list-style-type:none;line-height:18px;">在Administration的用户变量中新建如下的环境变量：</p> 
      <p style="margin-left:0px;border-top-width:0px;border-right-width:0px;border-bottom-width:0px;border-left-width:0px;list-style-type:none;line-height:18px;">添加的变量&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;变量的值</p> 
      <p style="margin-left:0px;border-top-width:0px;border-right-width:0px;border-bottom-width:0px;border-left-width:0px;list-style-type:none;line-height:18px;">NLS_LANG&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;AMERICAN_AMERICA.ZHS16GBK</p> 
      <p style="margin-left:0px;border-top-width:0px;border-right-width:0px;border-bottom-width:0px;border-left-width:0px;list-style-type:none;line-height:18px;">ORACLE_HOME&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;F:\app\Administrator\product\instantclient_11_2</p> 
      <p style="margin-left:0px;border-top-width:0px;border-right-width:0px;border-bottom-width:0px;border-left-width:0px;list-style-type:none;line-height:18px;">path &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;F:\app\Administrator\product\instantclient_11_2</p> 
      <p style="margin-left:0px;border-top-width:0px;border-right-width:0px;border-bottom-width:0px;border-left-width:0px;list-style-type:none;line-height:18px;">TNS_ADMIN&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;F:\app\Administrator\product\instantclient_11_2</p> 
      <p style="margin-left:0px;border-top-width:0px;border-right-width:0px;border-bottom-width:0px;border-left-width:0px;list-style-type:none;line-height:18px;">单击确定后就可以启动PL/SQL developer，输入密码就可以进入了。</p> 
      <p style="margin-left:0px;border-top-width:0px;border-right-width:0px;border-bottom-width:0px;border-left-width:0px;list-style-type:none;line-height:18px;">&nbsp;</p> 
      <p style="margin-left:0px;border-top-width:0px;border-right-width:0px;border-bottom-width:0px;border-left-width:0px;list-style-type:none;line-height:18px;">用一段时间后你会发现在oracle应用程序自带的sqlplus无法启动如下图，如果你不用PL/SQL developer，要用sqlplus，直接报上面建立的环境变量都删除掉就行了，但是就无法应用了。</p> 
     </div> 
    </div></td> 
  </tr> 
 </tbody> 
</table>

转载于:https://www.cnblogs.com/miaomiaoga/archive/2011/04/06/2006413.html

[http_blog.sina.com.cn_s_blog_4054cfa30100o6ls.html]: http://blog.sina.com.cn/s/blog_4054cfa30100o6ls.html
[sg_trans.gif]: /images/20211116/c6a79b7a97bf4042b7fa35c142ed5968.png