我无法登录到oracle系统帐户 [英] I can't login to oracle system account

问题描述

我最近安装了oracle 12c，无法访问系统本地生成的连接. (Ora-01017错误)尽管事实上我知道它是正确的，因为我更改了密码.无论如何，stackoverflow上的其他人将我重定向到了 https://iwikte.wordpress.com/2008/11/28/unlock-oracle-system-account/，而我不知道如何设置这些环境变量.我需要帮助.如果有什么不同，我正在使用Windows 10. 如果未自动设置这些环境变量，请手动进行 (导出ORACLE_HOME =/opt/oracle/VIS/db/tech_st/10.2.0

I recently installed oracle 12c and can't access the system local generated connection. (Ora-01017 error) eventhough I know for a fact its correct because I changed the password. Anyway, someone else on stackoverflow redirected me to this https://iwikte.wordpress.com/2008/11/28/unlock-oracle-system-account/, and I don't know how to set up these environment variables. I need help. If it makes any difference i'm using windows 10. If these environment variables are not set automatically, do it manually (export ORACLE_HOME=/opt/oracle/VIS/db/tech_st/10.2.0

导出ORACLE_SID = VIS

export ORACLE_SID=VIS

export PATH = $ PATH:$ HOME/bin:$ ORACLE_HOME/bin)

export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin)

推荐答案

即使用户的PASSWORD_VERSIONS不是10g，即使SEC_CASE_SENSITIVE_LOGON = FALSE，用户也不能使用不区分大小写的密码登录.

from oracle version 12.2.x users cannot login using case insensitive passwords, even though SEC_CASE_SENSITIVE_LOGON = FALSE if PASSWORD_VERSIONS of user is not 10g.

以下sql应该显示用户的PASSWORD_VERSIONS.

following sql should show the PASSWORD_VERSIONS for a user.

select USERNAME,ACCOUNT_STATUS,PASSWORD_VERSIONS from dba_users;
USERNAME          ACCOUNT_STATUS    PASSWORD_VERSIONS 
---------------   --------------    -----------------
dummyuser         OPEN              11G 12C

使PASSWORD_VERSIONS与10g兼容

to make PASSWORD_VERSIONS compatible with 10g

1. 在数据库的sqlnet.ora中添加/修改行以具有SQLNET.ALLOWED_LOGON_VERSION_SERVER = 8
2. 重新启动数据库
3. 更改/终止现有用户的密码
4. 创建的新用户也将具有相同的设置

在完成上述步骤后，PASSWORD_VERSIONS应该是这样的

after above steps PASSWORD_VERSIONS should be something like this

select USERNAME,ACCOUNT_STATUS,PASSWORD_VERSIONS from dba_users;
USERNAME          ACCOUNT_STATUS    PASSWORD_VERSIONS 
---------------   --------------    -----------------
dummyuser         OPEN              10G 11G 12C

这篇关于我无法登录到oracle系统帐户的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！