plsql不安装oracle连接oracle

背景：

本机64位 plsql 32位 ，本机oracle 64位  单独使用本机oracle自带的配置文件，报错

需要用一个32位的客户端才能使用plsql

 

1.

本人上传了本机制作的oracle客户端，以便plsql使用

 

下载客户端：10版本的：http://download.csdn.net/detail/sir_jun/6356927

                      11版本的：http://download.csdn.net/detail/sir_jun/6356979

客户端解压到任意位置:

新建bat文件：内容如下：

--------------------本机未按照oracle-----------------------------

@echo off
set path=D:\oracleclient\instantclient_11_2（解压目录）
set ORACLE_HOME=D:\oracleclient\instantclient_11_2（解压目录）
set TNS_ADMIN=D:\oracleclient\instantclient_11_2（解压目录）
set NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
start D:\Program\plsql\plsqldev.exe （plsql运行程序目录）

-----------------------------------------

----------------------本机已经安装oracle------------------------------ 

@echo off
::set path=D:\oracleclient\instantclient_11_2
::set ORACLE_HOME=D:\oracleclient\instantclient_11_2
::set TNS_ADMIN=D:\oracleclient\instantclient_11_2
set NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
start D:\Program\plsql\plsqldev.exe

---------------------------------------

 

将刚才下载的客户端解压包中的文件：

。。/NETWORK/ADMIN/tnsname.ora 修改成你需要的地址和服务，数据库名字。不会修改的自己百度。我只是贴出来做个备份。

------tnsnames.ora-------

# tnsnames.ora Network Configuration File: D:\Program\oracle11\product\11.2.0\dbhome_1\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.

SDPXYW =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 远程数据库Ip)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = sdpxyw)
    )
  )
HBPXWL =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 另外一个远程Ip)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = hbpxwl)
    )
  )

ORCLDEMO =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcldemo)
    )
  )

ORACLR_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
    (CONNECT_DATA =
      (SID = CLRExtProc)
      (PRESENTATION = RO)
    )
  )

LISTENER_ORCLDEMO =
  (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

 

 --------------------------------------------------------------

 

 

-------=-------sqlnet.ora-------------------------------

# sqlnet.ora Network Configuration File: D:\Program\oracle11\product\11.2.0\dbhome_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.

# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

 

------------------------------------------------------------------

 

 

------------listener.ora----------------

# listener.ora Network Configuration File: D:\Program\oracle11\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = D:\Program\oracle11\product\11.2.0\dbhome_1)
      (PROGRAM = extproc)
      (ENVS = "EXTPROC_DLLS=ONLY:D:\Program\oracle11\product\11.2.0\dbhome_1\bin\oraclr11.dll")
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
  )

ADR_BASE_LISTENER = D:\Program\oracle11

LISTENERSDPXYW =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 本监听ip地址)(PORT = 1521))
  )

ADR_BASE_LISTENERSDPXYW = D:\Program\oracle11\product\11.2.0\dbhome_1\log

LISTENERHBPXWL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 另外一个监听Ip地址)(PORT = 1521))
  )

ADR_BASE_LISTENERHBPXWL = D:\Program\oracle11\product\11.2.0\dbhome_1\log

 

--------------------------------------------------------------------------------

 

-------------------------------------------

 

具体细节问题，百度上有很多，自己找，我只是记下我自己解决需要的东东。。。。

。。。。。。。李林君。。。