远程连接Oracle报ORA-12545错误解决方案
最近局域网的oracle监听服务出了一点问题，本地连接正常，但是远程访问的时候总是报ora-12545错误。ORA-12545: 因目标主机或对象不存在,连接失败现已解决，修改后的配置文件如下
#listener.ora# listener.ora Network Configuration File: D:\oracle\product\10.2.0\db_1\network\admin\listener.ora# Generated by Oracle configuration tools.SID_LIST_LISTENER =(SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = D:\oracle\product\10.2.0\db_1) (PROGRAM = extproc) ) (SID_DESC = (SID_NAME = orcl) (ORACLE_HOME = D:\oracle\product\10.2.0\db_1) ))LISTENER =(DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) ) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = ecss-dev)(PORT = 1521)) ) ))
#sqlnet.ora# This file is actually generated by netca. But if customers choose to # install "Software Only", this file wont exist and without the native # authentication, they will not be able to connect to the database on NT.SQLNET.AUTHENTICATION_SERVICES = (NTS)NAMES.DIRECTORY_PATH= (EZCONNECT)
#tnsnames.oraorcl =(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = ecss-dev)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ))
页:
[1]