PLSQL Developer

浏览数：34 / 时间：2015年06月12日

1 intall oracle11gex

start OracleXEClrAgent

start  OracleXETNSListener

2 install C:\Dev Tool\instantclient_11_2

3 config PLSQL developer:

4 config oracle server side:

add following to tnsnames.ora

impactbac2 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = lsdbacdbmq.lbps.ibm.lab)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = impactbac2)
    )
  )
change following sqlnet.ora

#SQLNET.AUTHENTICATION_SERVICES = (NTS)
NAMES.DIRECTORY_PATH= (NONE)

#sqlnet.authentication_services = (NONE)
names.directory_path = (TNSNAMES, HOSTNAME)
automatic_ipc = off

 

listener.ora

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = C:\oracle11gex\app\oracle\product\11.2.0\server)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = C:\oracle11gex\app\oracle\product\11.2.0\server)
      (PROGRAM = extproc)
    )
  )

 
 

DEFAULT_SERVICE_LISTENER = (XE)

 

5 open vpn then connect

 

PLSQL Developer,古老的榕树,5-wow.com

郑重声明：本站内容如果来自互联网及其他传播媒体，其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享，并不代表本站赞同其观点和对其真实性负责，也不构成任何其他建议。

标签： des int src sp Go nb des int src sp Go nb

相关文章

随机文章

您可能还喜欢

您可能还喜欢