ORACLE 客户端连接问题。大家帮我看看啊。
ORACLE 10G 10.1.1
官网下载的10g_win32_db.zip文件(server)
安装完,在server上可连接。
可在别的机器上安装完client后。
不能连接,错误号ORA-12170
下面是server的文件(tnsnames.ora文件server client一样)
#LISTENER.ORA
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxx)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = C:\oracle\product\10.1.0\Db_1)
(SID_NAME = orcl)
)
)
#sqlnet.ora
SQLNET.AUTHENTICATION_SERVICES = (NTS)
#tnsnames.ora
BRDBSVR =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ABS0626.center.abeamsystems.local)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
[解决办法]
按照你提供的错误提示,主要可能在网络方面.