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 存储过程速度慢 主外键的锁等待问题 oracle 11g 怎么移动表空间? 刚接触oracle,问个存储过程中loop用法的问题 这样写不对吗?(关于PL/SQL的) 如何用sql取二级域名?急100分 Oracle OLAP 9.0.1.0.1 服务启动提示:“在本地计算机无法启动Oracle OLAP 9.0.1.0.1服务。错误3:系统找不到指定路径。” 关于用imp工具导入dmp文件的问题? 好奇怪的问题!急! 为什么无法执行DBMS_LOGMNR_D??? 有关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