ORA-01017: invalid username/password; logon denied 解决方案
来源:互联网 发布:美国仓库淘宝网 编辑:程序博客网 时间:2024/05/31 19:23
在SQLPLUS窗口下进行用户登录,出现ORA-01017:invalid username/password;logon denied 。如下图:
在网上找了很久,发现一个实用的解决方案,操作如下:
1.打开cmd,输入:
del C:\app\Administrator\product\12.1.0\dbhome_1\database\pwdorcl.ora(本人安装在了C盘)
这个操作就是删除oracle安装路径下的pwdorl.ora文件。如图:
2.然后自己重新创建一个.ora文件,在cmd下输入:
orapwd file=C:\app\Administrator\product\12.1.0\dbhome_1\database\pwdorcl.ora password=abcd entries=10;
输入过后,再C:\app\Administrator\product\12.1.0\dbhome_1\database文件下,会新创建出一个ora文件,并为sys创建了密码为abcd。如图:
3.win+R输入sqlplus或者在cmd中输入sqlplus进入sqlplus,这下就能够成功登陆进去了。如图:
看,密码abcd就是刚刚修改的。
4.然后可以根据需要修改system、和dbsnmp的密码,只需要在登陆进去的sqlplus中输入:
alter user system identified by abcd;
alter user dbsnmp identified by abcd;
阅读全文
1 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-0107 invalid username/password;logon denied
- 解决方法:ORA-01017: invalid username/password; logon denied错误
- Cannot create PoolableConnectionFactory (ORA-01017: invalid username/password; logon denied
- java.sql.SQLException: ORA-01017: invalid username/password; logon denied
- 路由控制
- Android破解与防破解
- LeetCode Kth Largest Element in an Array
- sass的编译
- 【语言-C++】Win7 64位系统下出现无法启动屏幕键盘的bug
- ORA-01017: invalid username/password; logon denied 解决方案
- echartz常用的图形Demo
- mysql在window机器下的双机备份
- DAY3 网络协议
- 开发时碰到的问题: java.lang.IllegalStateException: Unable to create directory: /storage/sdcard0/Trinea/aa
- navicate注册码
- dlopen(), dlsym(), respondsToSelector:, performSelector:, method_exchan关于苹果禁用JSPatch(热修复一类),上架审核被拒问题
- Linux查看物理CPU、内存、硬盘等基本信息命令
- 山东大学项目实训——5月21日