..\oracle\ora92\network\admin\TNSNAMES.ORA中
有型如下面的东东,就填它ORCL(用你自已的)
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = fred)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
有型如下面的东东,就填它ORCL(用你自已的)
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = fred)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
需要连接的是另外一台的ora9i服务器。
aaaa
btn5
可以登陆。但是在PLSQLDev中就不行,提示:could not locate oci dll
假如你的配置以下:
..\oracle\ora92\network\admin\TNSNAMES.ORA中
有型如下面的东东,就填它ORCL(用你自已的)
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = fred)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
则可以这样测试一下.
>sqlplus /nolog
>conn user/pass@orcl
若连接OK,则是你的PLSQLDev问题.否则是你是client配置还有问题.
自己分析去解决吧.
我的那个
username:后面的那个选择用户的按钮是灰色的。每次都会提示"could not locate OCI DLL"
是不是oracle没有安装好啊
我从网上下了一个oci.dll,拷贝到bin下,pl\sql可以连接了。