oracle服务器客户端安装过程中遇到的问题汇总

错误一：

Initialization error
Could not initialize "E:\app\18239\product\11.2.0\dbhome_1\bin\oci.dll"
Make sure you have the 32 bits Oracle Client installed.

OCIDLL forced to E:\app\18239\product\11.2.0\dbhome_1\bin\oci.dll
LoadLibrary(E:\app\18239\product\11.2.0\dbhome_1\bin\oci.dll) returned 0

解决一：安装完后Oracle的 oci.dll 是64位的，而32位应用程序 PLSQL Developer 无法加载。

1. 从 http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html 下载Oracle Client Package。 我下载的是Instant Client for Microsoft Windows (32-bit) 【instantclient-basic-nt-11.2.0.2.0.zip】
2. 将 instantclient-basic-nt-11.2.0.2.0.zip 解压至 E:\app\18239\oracle, oci.dll 所在目录为：E:\app\18239\instantclient_11_2\
3. 设置环境变量
   TNS_ADMIN=\E:\app\18239\product\11.2.0\dbhome_1\NETWORK\ADMIN
4. 启动PL/SQL Developer ，点击“取消”不要登录，菜单 --> Tools --> Perferences --> Connection 修改 Oracle_Home 和 OCI Library 的配置：
   OracleHome: E:\app\18239\instantclient_11_2
   OCI library: E:\app\18239\instantclient_11_2\oci.dll
   原文链接：https://blog.csdn.net/hemingwang0902/article/details/7027543

错误二：ORA-12505：TNS:监听程序当前无法识别连接描述符中所给出的SID

解决二：考虑到是否是本机电脑上的tnsnames.ora配置是否正确：
…\product\11.2.0\client_1\network\admin\tnsnames.ora

orcl_192 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.31.228)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID =orcl)
      (SERVER = DEDICATED)
    )
  )

…\product\11.2.0\dbhome_1\NETWORK\ADMIN\tnsnames.ora

orcl=
  (description=
      (address=(protocol=tcp)(port=1521)(host=192.168.31.228))# 自己的ip
      (connect_data=
           (SERVER=dedicated )
           (service_name=orcl)
       )
   )