=(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
本条技术文章来源于互联网,如果无意侵犯您的权益请点击此处反馈版权投诉 本文系统来源:http://www.cnblogs.com/qimao/p/7219079.html