关于SQLP LUS客户端连接问题 建立完成数据库以后,在服务器端使用sql plus可以正常登陆,但是在客户端使用sql plus登陆的时候总是提示ORA-12560:TNS:协议适配器错误。请问各位这个是怎么回事,我检查过ORA文件,没有发现问题,并且使用TOAD连接没有问题,请指点,谢谢!! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 查看你 TNSNAMES.ORA文件,编辑它 TNSNAMES.ORA文件我检查过了,没有感觉那么有问题。楼下是文件请参看 TESTDB = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.20)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = testdb.192.168.0.20) ) )PRODDB = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.22)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ProdDB) ) )PRDB = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.24)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = PRDB.192.168.0.40) ) ) 服务端 lsnrctl status 查看监听状态,估计是没启动。或者没配置。 连接运行正常。我的情况是使用别的都可以,在CMD命令提示符窗口中使用SQLPLUS都可以登录,但是使用SQLPLUS工具就不行。郁闷的很! oracle数据库同步问题 存储过程怎么授权 花钱让Oracle同仁们给我解决Oracle的作业 如何将dmp文件导入oracle数据库 oracle表结构设计问题 这个索引怎么无论如何也不能生效呢? ORACLE中如何以下以下的功能阿,求救 关于物理地址 求助! 请教高级update 的写法。 我的oracle的存储过程总报错,请高手帮帮忙! 关于季度的sql语句问题
TNSNAMES.ORA文件我检查过了,没有感觉那么有问题。楼下是文件请参看
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.20)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = testdb.192.168.0.20)
)
)PRODDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.22)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ProdDB)
)
)PRDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.24)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = PRDB.192.168.0.40)
)
)