ERROR ORA-12560: TNS: 协议适配器 (急!!!!) 1、查看网络是否畅通?2、查看OracleTNSListener服务是否启动?3、查看服务器ip地址是否正确? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 tnsnames.ora:////ORADB.WORLD = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.121)(PORT = 1521)) (CONNECT_DATA = (SID = ORCL)) )****************listener.ora ////LISTENER = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = oracle.world)) (ADDRESS = (PROTOCOL = IPC)(KEY = ORCL)) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) (ADDRESS = (PROTOCOL = NMP)(SERVER = Titan)(PIPE = ORAPIPE)) (ADDRESS = (PROTOCOL = TCP)(HOST = Titan)(PORT = 1521)) 注:主机名 (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.88)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)) )然后察看oracletnslistener80等服务是否启动 1、查看网络是否畅通?我和朋友建的局域网,我的是主机2、查看OracleTNSListener服务是否启动?已经启动了3、查看服务器ip地址是否正确?这个ip是什么ip??是192.168.0.1吗? to qxksos(冰焰)那该如何查看当前实例是否正确呢?在oracle里什么叫做实例? 可能问题出在这儿sid_name:# LISTENER.ORA Network Configuration File: F:\oracle\ora81\NETWORK\ADMIN\listener.ora# Generated by Oracle configuration tools.LISTENER = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.1)(PORT = 1521)) )SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = F:\oracle\ora81) (PROGRAM = extproc) ) (SID_DESC = (GLOBAL_DBNAME = oraDB) (ORACLE_HOME = F:\oracle\ora81) (SID_NAME = oraDBSID)-->>改为:oradb ) ) 不行,改为oradb后,在注册字符串中输不输入oradb都没有用 问题在于你将oracle数据库的数据库实例名与数据库服务名搞混淆了。 to jerryjam(阿维)那你可以讲讲什么是数据库实例名和数据库服务名吗?谢谢了。 个人觉得这句话“(SID_NAME = oraDBSID)-->>改为:oradb”应该是对的在tnsnames.ora 里ORADB = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.1)(PORT = 1521)) ) (CONNECT_DATA = (SID = ORADB)加上这句 (SERVICE_NAME = oraDB) ) )试试,LUCK 数据库名称和实例名称要一致才行。如果DBNAME = oraDB必须SID_NAME = oraDB还有:# TNSNAMES.ORA Network Configuration File: F:\oracle\ora81\network\admin\tnsnames.ora~~~~~这个分行在文件里也有吗?如果是的话,前面要加一个# # Generated by Oracle configuration tools. 重新启动服务在dos下运行net start oracleservice<sid>,查看服务是否启动。再运行set oracle_sid=<sid>运行svrmgrl,登录数据库,看是否正确 仔细看一下监听的log文件listener.log,在...\network\log\listener.log下。log文件会写出那些listen在什么时候不再被监听。 100分求教 竖改横显示的问题 急:求助:客户端连oracle server,经常会出现连接超时的情况,求解决 SQL语句问题。(100) 面试题知道的大哥说下 求一条sql 语句! 一个简单的查询语句,行列问题!?? 可为空字段的比较(null) 请问:在ORACLE9i中的Enterprise Manager Console启动不起来,怎么解决? 为什么把查询变成view后就报权限不足呢? 关于事务操作中等待时间的设置问题 急!求好的解决方案,不使用LIKE 关键字查询!谢谢! 请教如何在powerDesigner中给字段赋默认值
ORADB.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.121)(PORT = 1521))
(CONNECT_DATA = (SID = ORCL))
)
****************
listener.ora ////
LISTENER =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = oracle.world))
(ADDRESS = (PROTOCOL = IPC)(KEY = ORCL))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
(ADDRESS = (PROTOCOL = NMP)(SERVER = Titan)(PIPE = ORAPIPE))
(ADDRESS = (PROTOCOL = TCP)(HOST = Titan)(PORT = 1521)) 注:主机名
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.88)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)然后察看oracletnslistener80等服务是否启动
我和朋友建的局域网,我的是主机
2、查看OracleTNSListener服务是否启动?
已经启动了
3、查看服务器ip地址是否正确?
这个ip是什么ip??是192.168.0.1吗?
那该如何查看当前实例是否正确呢?在oracle里什么叫做实例?
# LISTENER.ORA Network Configuration File: F:\oracle\ora81\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.1)(PORT = 1521))
)SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = F:\oracle\ora81)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = oraDB)
(ORACLE_HOME = F:\oracle\ora81)
(SID_NAME = oraDBSID)-->>改为:oradb
)
)
那你可以讲讲什么是数据库实例名和数据库服务名吗?谢谢了。
ORADB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.1)(PORT = 1521))
)
(CONNECT_DATA = (SID = ORADB)加上这句
(SERVICE_NAME = oraDB)
)
)
试试,LUCK
如果DBNAME = oraDB
必须
SID_NAME = oraDB
还有:
# TNSNAMES.ORA Network Configuration File: F:\oracle\ora81\network\admin\tnsnames.ora
~~~~~
这个分行在文件里也有吗?如果是的话,前面要加一个#
# Generated by Oracle configuration tools.
net start oracleservice<sid>,查看服务是否启动。再运行
set oracle_sid=<sid>
运行svrmgrl,登录数据库,
看是否正确