数据库连接问题 oracle10g
鼓捣了一天也没搞定。
今天在我的linux上装了oracle10g
装完后在本机用sqlplus连接没有什么问题
但是用另外一台windows机器(也装了10g)的客户端连就连不上,
报的错是 ora-12560:tns 协议适配器错误
目标很明显了吧,可是我调了好长事件也没法搞定。请各位帮忙
-------------附1:linux 上的listener.ora 文件内容--------------
LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.4.111)(PORT = 1521))
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = /home/oracle)
(SID_NAME = ORCL)
)
)
-----------------------附2:win 客户端上的本地服务设置----------
linux10G =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.4.111)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)