oracle 12c 无法使用 os 认证登录数据库 ERROR: ORA-01017: invalid username/password; logon denied

最新推荐文章于 2024-10-07 12:08:06 发布

desert_xu

最新推荐文章于 2024-10-07 12:08:06 发布

阅读量3.2k

点赞数

文章标签： ORACLE 12C

本文链接：https://blog.csdn.net/xxjj2003/article/details/53485706

版权

最近在使用官方给出的priv-build vm 的 oracle 12c 数据库，使用操作系统认证登录遇到错误：

[oracle@vbgeneric dbs]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Mon Dec 5 23:48:33 2016

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

ERROR:
ORA-01017: invalid username/password; logon denied


Enter user-name:

检查数据库参数 remote_login_passwordfile 都是正确的设置

检查密码文件也是正确，查看sys 密码与密码文件的字符是否一致

密码加密也是一致，查看数据库参数 thread 线程是否为true

查看当前环境变量，发现有个疑问变量 TWO_TASK

# .bashrc

# Source global definitions
if [ -f /etc/bashrc ]; then
        . /etc/bashrc
fi

# Uncomment the following line if you don't like systemctl's auto-paging feature:
# export SYSTEMD_PAGER=

# User specific aliases and functions

if test "m$JAVAENV" = "m"
then
export TMZ="GMT"
export JAVA_HOME=`ls -d /home/oracle/java/jdk*`
export PATH=$JAVA_HOME/bin:/home/oracle/sqlcl/bin:/home/oracle/sqldeveloper:/opt/datamodeler:$PATH:/home/oracle/sqlcl/bin:/home/oracle/sqldeveloper:/home/oracle/bin
export JAVAENV=true
fi
if test "m$DBENV" = "m"
then
export TMP=/tmp
export TMPDIR=$TMP
export ORACLE_UNQNAME=orcl12c
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/12.1.0.2/db_1
export ORACLE_SID=orcl12c
export PATH=$ORACLE_HOME/bin:/usr/sbin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
export DBENV=true
#export SQL_OR_SQLPLUS=sql -oci
export SQL_OR_SQLPLUS=sqlplus
fi
if test "m$DONOTSETTWO_TASK" = "m"
then
export TWO_TASK=ORCL
fi

尝试取消 unset TWO_TASK

unset TWO_TASK


  
  
   
   [oracle@vbgeneric ~]$ echo $TWO_TASK
ORCL
[oracle@vbgeneric ~]$ echo $ORACLE_SID
orcl12c
[oracle@vbgeneric ~]$ unset TWO_TASK
[oracle@vbgeneric ~]$ echo $TWO_TASK
  
  
  
  

  
  
  
  
   
   [oracle@vbgeneric ~]$ sqlplus / as sysdba
  
  
  
  

  
  
  
  
   
   SQL*Plus: Release 12.1.0.2.0 Production on Mon Dec 5 23:47:26 2016
  
  
  
  

  
  
  
  
   
   Copyright (c) 1982, 2014, Oracle.  All rights reserved.
  
  
  
  

  
  
  
  
   
   
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
  
  
  
  

  
  
  
  
   
   SQL> show con_name
  
  
  
  

  
  
  
  
   
   CON_NAME
------------------------------
CDB$ROOT