ORA-01017 从 9i 客户端连接到 11g 数据库时无效的用户名/密码 [英] 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

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