从9i客户端连接到11g数据库时，ORA-01017用户名/密码无效 [英] ORA-01017 Invalid Username/Password when connecting to 11g database from 9i client

问题描述

我正在尝试从具有9i(v9.2.0.1)客户端的PC连接到11g(v11.2.0.1.0)上的架构.似乎可以很好地连接到某些模式，但是不能连接到这种模式-每次都返回一个ORA-01017 Invalid Username/Password错误.

I'm trying to connect to a schema on 11g (v11.2.0.1.0) from a PC with 9i (v9.2.0.1) client. It seems to connect fine to some schemas, but not this one - it comes back with a ORA-01017 Invalid Username/Password error every time.

用户名和密码绝对正确-有人能想到导致其无效的原因吗?

The username and password are DEFINITELY correct - can anyone think of a reason why this wouldn't work?

9i和11g之间是否存在根本的不兼容性?

Are there any fundamental incompatibilities between 9i and 11g?

推荐答案

用户和密码肯定不正确. Oracle 11g凭据区分大小写.

The user and password are DEFINITELY incorrect. Oracle 11g credentials are case sensitive.

尝试ALTER SYSTEM SET SEC_CASE_SENSITIVE_LOGON = FALSE； 并更改密码.

Try ALTER SYSTEM SET SEC_CASE_SENSITIVE_LOGON = FALSE; and alter password.

http://oracle-base.com/articles/11g/case-sensitive-passwords-11gr1.php

这篇关于从9i客户端连接到11g数据库时，ORA-01017用户名/密码无效的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！