本地不安装oracle，plsql照样用起来

= (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) ) EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) )

sqlnet.ora文件

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

三、添加系统变量：TNS_ADMIN
　　　　变量值：D:\Oracle\instantclient_11_2（放置instantclient_11_2这个客户包的位置）

四、打开plsql：Tools-->Preferences

　　　　设置俩变量Oracle Home:instantclient的路径
　　　　　　　　　OCI library：instantclient的路径\oci.dll

五、请重启下plsql，是不是好啦是不是好啦，好啦啦

 

　　

 

本地不安装oracle，plsql照样用起来

标签：ora   文件   host   instant   services   http   server   配置   names