oracle错误 本帖最后由 yudengchang 于 2010-06-05 18:43:17 编辑 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 把你的tnsnames.ora中的对应连接项 贴出来看看,肯定配置得有问题。 # TNSNAMES.ORA Network Configuration File: F:\oracle\network\admin\tnsnames.ora# Generated by Oracle configuration tools.DJN = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.2)(PORT = 1521)) ) (CONNECT_DATA = (SID = SJK) ) )INST1_HTTP = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = nis001)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = SHARED) (SERVICE_NAME = MODOSE) (PRESENTATION = http://HRService) ) )EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) ) 建议用net manager 工具来配置。 手动修改tnsnames.ora 文件容易出问题。 参考: Oracle 数据库监听配置http://blog.csdn.net/tianlesoftware/archive/2009/11/25/4861572.aspx------------------------------------------------------------------------------ Blog: http://blog.csdn.net/tianlesoftware 网上资源: http://tianlesoftware.download.csdn.net 相关视频:http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx DBA1 群:62697716(满); DBA2 群:62697977 你测试的是tnsping DJN吗?如果是,应该问题不大,怀疑你测试的不对吧。你测试的时候用的完整命令是什么?不会是:tnsping 192.168.0.2吧 tnsping 192.168.0.2不应该是这个吗??????? 当然不是了。tnsping DJN参数应该是tns的注册项。 SQLNET.ORA 内容如下:# SQLNET.ORA Network Configuration File: F:\oracle\network\admin\sqlnet.ora# Generated by Oracle configuration tools.SQLNET.AUTHENTICATION_SERVICES= (NTS)NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)TNSNAMES.ORA的内容如下:# TNSNAMES.ORA Network Configuration File: F:\oracle\network\admin\tnsnames.ora# Generated by Oracle configuration tools.SJK = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.2)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = SJK) ) )INST1_HTTP = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.2)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = SHARED) (SERVICE_NAME = MODOSE) (PRESENTATION = http://HRService) ) )EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) ) 你的SERVICE_NAME到底是什么 一会MODOSE一会SJKshow parameter instance_name建议用工具配 别手工 晕,上面不是有SJK的服务吗,看清楚呀,大哥 tnsping SJK 4然后把结果帖上来 192.168.0.2上有多实例么 SJK = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.2)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = SJK) ) )你的这个sjk是没有问题的 先ping 192.168.0.2 确保网络是通的然后确认该机器上有 sjk这个实例的监听运行起来了tnsping sjk 看什么结果 oracle有类似sql server的事件探查器么?就是程序前台操作所执行的sql都记录下来了。 oci bind 问题 字符串轉時間類型的問題 求一SQL问题,价值100分,是ORACLE的 数据库创建向导问题( 提示输入 SYS和SYSTEM 密码,当是没有 确定按钮) 安装问题 请问怎样在oracle9i中使用oracle manager service.谢谢! 我在本机上安装了ORACLE 用于学习,还用不用安装ORACLE客户端?? 请问…… Oracle 安装 INS-32025 分类递归的问题,求助! oracle中一条SQL语句中查询出一个记录集的前6条数据?
# Generated by Oracle configuration tools.DJN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.2)(PORT = 1521))
)
(CONNECT_DATA =
(SID = SJK)
)
)
INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = nis001)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
建议用net manager 工具来配置。 手动修改tnsnames.ora 文件容易出问题。 参考: Oracle 数据库监听配置
http://blog.csdn.net/tianlesoftware/archive/2009/11/25/4861572.aspx
------------------------------------------------------------------------------
Blog: http://blog.csdn.net/tianlesoftware
网上资源: http://tianlesoftware.download.csdn.net
相关视频:http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
DBA1 群:62697716(满); DBA2 群:62697977
如果是,应该问题不大,怀疑你测试的不对吧。
你测试的时候用的完整命令是什么?
不会是:tnsping 192.168.0.2吧
不应该是这个吗???????
tnsping DJN
参数应该是tns的注册项。
# Generated by Oracle configuration tools.SQLNET.AUTHENTICATION_SERVICES= (NTS)NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
TNSNAMES.ORA的内容如下:
# TNSNAMES.ORA Network Configuration File: F:\oracle\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.SJK =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = SJK)
)
)INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
SJK =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = SJK)
)
)
你的这个sjk是没有问题的 先ping 192.168.0.2 确保网络是通的
然后确认该机器上有 sjk这个实例的监听运行起来了
tnsping sjk 看什么结果