请教:ORA-12545 连接因对象主机或对象不存在而失败 在前台用tnsping ip能通吗? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 TNS-12545连接失败,因为目标主人或者对象不存在原因: 地址指定不是有效的,或者计划连接到不存在。行动: 保证参数正确地已被进入的ADDRESS; 可能不正确的参数是节点名称。 保证可执行因为服务器存在(或许“ORACLE”是丢失的)。 如果规约是TCP与IP,编辑TNSNAMES.ORA文件到变化主人名称一个数字的IP地址和试图再一次。还是配置的问题,你把IP地址改为你服务器名,还有你的实例名是否写正确。 to yangsanshao:tnsping connect_string 能通的;ADDR我用的是实际的IP地址不知有人遇到过没有 数据库端可以操作吗?你需要验证oracle数据库是否已经启动。另外将tnsnames.ora的文件相关内容贴上来看看。按照你说的如果能ping通,数据库已经启动,listener已经启动。tns配置没有错误的话,出现这种现象是没有道理的。 小哥是不是配置完以后没有退出net8呀?我以前也遇到过这种情况,配好了以后就急者去联结,结果连不上,后来关了net8才发现还提示我是否保存配置。 把你的SQLNET.ORA、TNSNAMES.ORA、LISTENER.ORA贴出来看看吧 sqlnet.ora:# SQLNET.ORA Network Configuration File: D:\oracle\ora817\network\admin\sqlnet.ora# Generated by Oracle configuration tools.SQLNET.AUTHENTICATION_SERVICES= (NTS)NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)tnsnames.ora:EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) )hfcx = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 130.30.10.17)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = hfcx) ) )listener.ora:# LISTENER.ORA Network Configuration File: D:\oracle\ora81\network\admin\listener.ora# Generated by Oracle configuration tools.LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) ) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = xxdddhfcx)(PORT = 1521)) ) ) (DESCRIPTION = (PROTOCOL_STACK = (PRESENTATION = GIOP) (SESSION = RAW) ) (ADDRESS = (PROTOCOL = TCP)(HOST = xxdddhfcx)(PORT = 2481)) ) )SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = D:\oracle\ora81) (PROGRAM = extproc) ) (SID_DESC = (GLOBAL_DBNAME = hfcx) (ORACLE_HOME = D:\oracle\ora81) (SID_NAME = hfcx) ) ) SQL SERVER连接oracle问题(为什么不能做更新操作) 64位客户端连32服务器的问题。 oracle存储过程查错 求助:pl/sql 连接oracle错误ORA-01034,ORA-27101:谢谢 oracle时间查询 请问如何根据表里的日期字段按年月进行记录统计. 简单的一个问题,关于Oracle8 的INTERNAL PASSWORD 高分求助:oracle9i的data guaid实例或技术文档 讨论:买的oracle和从网上下载的oracle有什么不同? 急用,在线等待!! 在线等待:重复记录如何再次操作??? [que] Oracle为何如此慢??
存在。行动: 保证参数正确地已被进入的ADDRESS; 可能
不正确的参数是节点名称。 保证可执行因为服务器存在
(或许“ORACLE”是丢失的)。 如果规约是TCP与IP,编辑TNSNAMES.ORA文件到
变化主人名称一个数字的IP地址和试图再一次。
还是配置的问题,你把IP地址改为你服务器名,还有你的实例名是否写正确。
ADDR我用的是实际的IP地址
不知有人遇到过没有
另外将tnsnames.ora的文件相关内容贴上来看看。
按照你说的如果能ping通,数据库已经启动,listener已经启动。
tns配置没有错误的话,出现这种现象是没有道理的。
# SQLNET.ORA Network Configuration File: D:\oracle\ora817\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.SQLNET.AUTHENTICATION_SERVICES= (NTS)NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)tnsnames.ora:
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
hfcx =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 130.30.10.17)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = hfcx)
)
)listener.ora:
# LISTENER.ORA Network Configuration File: D:\oracle\ora81\network\admin\listener.ora
# Generated by Oracle configuration tools.LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxdddhfcx)(PORT = 1521))
)
)
(DESCRIPTION =
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
(ADDRESS = (PROTOCOL = TCP)(HOST = xxdddhfcx)(PORT = 2481))
)
)SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\ora81)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = hfcx)
(ORACLE_HOME = D:\oracle\ora81)
(SID_NAME = hfcx)
)
)