对照下看看 ORA-12560: TNS:protocol adapter error Cause: A generic protocol adapter error occurred. Action: Check addresses used for proper protocol specification. Before reporting this error, look at the error stack and check for lower level transport errors. For further details, turn on tracing and reexecute the operation. Turn off tracing when the operation is complete.
程序中实例名指定没有?tnsping SID能ping通吗?
------------------------------------------------------------------------------
Blog: http://blog.csdn.net/tianlesoftware
网上资源: http://tianlesoftware.download.csdn.net
相关视频:http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
Q Q 群:62697716
ORA-12560: TNS:protocol adapter error
Cause: A generic protocol adapter error occurred.
Action: Check addresses used for proper protocol specification. Before reporting this error, look at the error stack and check for lower level transport errors. For further details, turn on tracing and reexecute the operation. Turn off tracing when the operation is complete.
程序中实例名指定没有?tnsping SID能ping通吗?
------------------------------------------------------------------------------
这个在那里如何ping?
C:\Documents and Settings\Administrator>tnsping newccsTNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 11-2月 -
2010 15:56:29Copyright (c) 1997, 2005, Oracle. All rights reserved.已使用的参数文件:
D:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora
已使用 TNSNAMES 适配器来解析别名
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = 10.85.8.203)(PORT = 1521))) (CONNECT_DATA = (SERVER = dedicated) (SERVIC
E_NAME = newccs)))
OK (0 毫秒)C:\Documents and Settings\Administrator>如果能ping通,应该就能连上。 客户段的监听也要配好...Oracle 数据库监听配置
http://blog.csdn.net/tianlesoftware/archive/2009/11/25/4861572.aspx
刚测试了!
啥都是正常的看来,就是asp.net程序连接数据库报这个错误!
要不你把连接的代码贴出来??
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = gxy-tyxvqf1al98)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = gxyora2)
)
)
这里HOST是主机名,我改成ip就不行了
--修改成这个试下
GXYORA2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = gxy-tyxvqf1al98)(PORT = 1521))
)
(CONNECT_DATA =
(SID = gxyora2)
(SERVER = DEDICATED)
)
)
选择数据源 -> 测试网络连接(输入用户名和密码)如果连接能成就说明没问题 说明连接串没问题
Password=abc; User ID=gxy; Data Source=GXYORA2
GXYORA2 部分严格区分大小写
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = IP地址)(PORT = 1521))
)
(CONNECT_DATA =
(SID = gxyora2)
(SERVER = DEDICATED)
)
)