oracle 密码文件在哪里看,oracle 关于--密码文件
[oracle@dongyang admin]$vi $ORACLE_HOME/network/admin/sqlnet.oraSQLNET.AUTHENTICATION_SERVICES=none[oracle@dongyang admin]$sqlplus /nologSQL*Plus: Release 10.2.0.1.0 - Productionon Fri Mar 21 15:21:57
[oracle@dongyang admin]$vi $ORACLE_HOME/network/admin/sqlnet.ora
SQLNET.AUTHENTICATION_SERVICES=none
[oracle@dongyang admin]$sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production
on Fri Mar 21 15:21:57 2014
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL>conn sys/oracle111 as sysdba
Connected.
SQL>conn sys/qwer as sysdba
ERROR:
ORA-01017: invalid
username/password; logon denied
Warning: You are no longer
connected to ORACLE.
SQL>conn / as sysdba
ERROR:
ORA-01031: insufficient
privileges
SQL>
[oracle@dongyang admin]$sqlplus sys/oracle111@orcl as sysdba
SQL*Plus: Release 10.2.0.1.0
- Production on Fri Mar 21 15:34:48 2014
Copyright (c) 1982, 2005,
Oracle. All rights reserved.
Connected to:
Oracle Database 10g
Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP
and Data Mining options
SQL>
[oracle@dongyang admin]$sqlplus sys/qwer@orcl as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production
on Fri Mar 21 15:35:34 2014
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR:
ORA-01017: invalid
username/password; logon denied
Enter user-name:
可以看到,关闭操作系统认证就需要使用密码文件认证,密码错误就登录不了
魔乐社区(Modelers.cn) 是一个中立、公益的人工智能社区,提供人工智能工具、模型、数据的托管、展示与应用协同服务,为人工智能开发及爱好者搭建开放的学习交流平台。社区通过理事会方式运作,由全产业链共同建设、共同运营、共同享有,推动国产AI生态繁荣发展。
更多推荐

所有评论(0)