Oracle客户端
在F:\app\xKF60448\product\11.1.0\client_2\network\admin目录下,新建立两个文件,sqlnet.ora和tnsnames.ora然后再手动配置sqlnet.ora和tnsnames.ora
比如这里是:
sqlnet.ora文件内容:
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
tnsnames.ora文件内容:
10.166.113.200 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.166.113.200)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ora11)
)
)
在F:\app\xKF60448\product\11.1.0\client_2\network\admin目录下,新建立两个文件,sqlnet.ora和tnsnames.ora然后再手动配置sqlnet.ora和tnsnames.ora
比如这里是:
sqlnet.ora文件内容:
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
tnsnames.ora文件内容:
10.166.113.200 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.166.113.200)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ora11)
)
)
PL/SQL配置
选择pl/sql的工具/首选项(too/ preference/)里的连接,在右面设置Oracle主目录名(即安装目录)和OCI库.
Oracle主目录名: D:\oracle_client\instantclient_10_2
OCI库: D:\oracle_client\instantclient_10_2\oci.dll