ORA-01017 invalid username/password;logon denied" (密码丢失解决方案)
来源:互联网 发布:风险矩阵图 编辑:程序博客网 时间:2024/06/06 18:10
ORA-01017 invalid username/password;logon denied" (密码丢失解决方案)
1、先确认是否输错 用户名和密码
2、如果的确是丢失密码的话:
查看ORACLE_BASE\ORACLE_HOME\NETWORK\ADMIN的sqlnet.ora文件
sqlnet.ora 如果是 SQLNET.AUTHENTICATION_SERVICES= (NONE) ,
需更改为SQLNET.AUTHENTICATION_SERVICES= (NTS)
在PLPlus中执行如下命令:
SQL>conn/as sysdba (操作系统认证登录)
或者在cmd命令行窗口输入
sqlplus /nolog
connect username/password as sysdba
无论哪种方法连接后执行
SQL>alter user system identified by password; (回车后用户system的密码会更改为system)
=============================================================================
注意:在执行更改语句“SQL>alter user system identified by system; (回车后用户system的密码会更改为system) ”的时候,如果所改的秘密为一串数字的话,要用引号括起来哦~
1、先确认是否输错 用户名和密码
2、如果的确是丢失密码的话:
查看ORACLE_BASE\ORACLE_HOME\NETWORK\ADMIN的sqlnet.ora文件
sqlnet.ora 如果是 SQLNET.AUTHENTICATION_SERVICES= (NONE) ,
需更改为SQLNET.AUTHENTICATION_SERVICES= (NTS)
在PLPlus中执行如下命令:
SQL>conn/as sysdba (操作系统认证登录)
或者在cmd命令行窗口输入
sqlplus /nolog
connect username/password as sysdba
无论哪种方法连接后执行
SQL>alter user system identified by password; (回车后用户system的密码会更改为system)
=============================================================================
注意:在执行更改语句“SQL>alter user system identified by system; (回车后用户system的密码会更改为system) ”的时候,如果所改的秘密为一串数字的话,要用引号括起来哦~
eg:SQL>alter user system identified by “12345678”;
参考网址:http://blog.csdn.net/antoniochan/article/details/14091203
阅读全文
0 0
- ORA-01017 invalid username/password;logon denied (密码丢失解决方案)
- ORA-01017 invalid username/password;logon denied" (密码丢失解决方案)
- ORA-01017 invalid username/password;logon denied" (密码丢失解决方案)
- ORA-01017 invalid username/password;logon denied" (密码丢失解决方案)
- ORA-01017 invalid username/password;logon denied" (密码丢失解决方案)
- ORA-01017 invalid username/password;logon denied" (密码丢失解决方案)
- ORA-01017 invalid username/password;logon denied" (密码丢失解决方案)
- ORA-01017 invalid username/password;logon denied" (密码丢失解决方案)
- ORA-01017: invalid username/password; logon denied 解决方案
- ORA-01017: invalid username /password;logon denied
- ORA-01017: invalid username/password; logon denied
- ORA-01017: invalid username /password;logon denied
- ORA-01017: invalid username/password; logon denied
- ORA-01017 invalid username/password; logon denied
- ORA-01017: invalid username/password; logon denied
- ORA-01017: invalid username/password; logon denied
- ORA-01017: invalid username/password; logon denied
- ORA-01017:invalid username/password; logon denied
- 知识系统的梳理
- MySQL This function has none of DETERMINISTIC, NO SQL...错误1418 的原因分析及解决方法
- java不使用递归 将一个有层级结构的集合还原成一棵树
- 百度地图:为标记添加点击事件显示标注
- easyUI简易进度条
- ORA-01017 invalid username/password;logon denied" (密码丢失解决方案)
- java 多线程 避免死锁 哲学家就餐问题
- 多线程FMDB操作sqlite时候出现 EXC_BAD_ACCESS
- EasyCamera开源摄像机接入海康威视摄像机PS流转ES流
- jQuery部分事件
- 关于cypress3014开发uvc+vitual com组合设备的体会
- TensorFlow配置
- 传智前端与移动开发14期培训教程 基础+就业班视频
- BZOJ3190[JLOI2013]赛车 半平面交