oracle9i精简版登陆提示“ORA-01017:invalidusername/password;logondenied” 问题很奇怪,公司的很多电脑都正常使用,可是有其中的几台,登陆oarcle数据库服务器的时候,出现“ORA-01017:invalidusername/password;logondenied”,把客户端重新卸载了安装也不行,每个电脑的配置文件都是相同的。重装系统以后,再重新安装oracle客户端就又没问题了。请高手解答。 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 这个ora配置文件,所有电脑客户端都是这个文件,但是有的客户端可以登陆,有的提示 如标题的错误。# TNSNAMES.ORA Network Configuration File: C:\oracle\ora90\network\admin\tnsnames.ora# Generated by Oracle configuration tools.#sample#DATABASENAME =# (DESCRIPTION =# (ADDRESS_LIST =# (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))# )# (CONNECT_DATA =# (SERVICE_NAME = servicename)# )# )ORACLE = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 130.81.100.101)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = scbus) ) )ORACLEBCV = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 130.81.100.136)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = scbus) ) )REPORT = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 9.83.70.14)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = report) ) )JDSNTX = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.29.0.113)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = jdsntx) ) ) 其中的几台 除了 不能登录oracle 数据库服务器以外,无任何 其它问题。所以应该不是病毒的问题。 注意:前面不能有空格,比如:ORACLE = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 130.81.100.101)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = scbus) ) )在ORACLE前面不能有空格 卸载干净了,oracle安装文件夹也删了,结果也不行。不知道是不是因为注册表妹清理干净的原因。只有重装系统好使,悲剧了 你看看你的环境变量。path里面的oracle路径是不是指向你新安装的客户端 楼主不妨动手DIY一把精简的客户端,详见我的文章:http://blog.csdn.net/iihero/archive/2009/03/08/3968564.aspx ora22922错误 怎么删除oracle磁盘数据 一个关于视图的问题请教大家,谢谢 在redhat 企业版 5.4 上安装oracle9204出现问题 一个sql问题,请进 oracle存储过程执行文件的问题, csdn上的高手都到那里去了?(100分) 大家来看看这条语句该怎么写 如何增大回滚段? 急! ora-03113 ora-01041 错误怎么解决? 有关ORACLE备份还原数据 谁有oracle 10g plsql高级编程
# TNSNAMES.ORA Network Configuration File: C:\oracle\ora90\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.#sample#DATABASENAME =
# (DESCRIPTION =
# (ADDRESS_LIST =
# (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
# )
# (CONNECT_DATA =
# (SERVICE_NAME = servicename)
# )
# )ORACLE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 130.81.100.101)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = scbus)
)
)ORACLEBCV =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 130.81.100.136)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = scbus)
)
)
REPORT =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 9.83.70.14)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = report)
)
)
JDSNTX =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.29.0.113)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = jdsntx)
)
)
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 130.81.100.101)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = scbus)
)
)在ORACLE前面不能有空格
http://blog.csdn.net/iihero/archive/2009/03/08/3968564.aspx