12c meet sysdba meet ORA-01017: invalid username/password; logon denied
checklist:
1.12c: threaded_execution=true Prevents OS Login As Sysdba
2. The following database parameter should be set either to SHARED or EXCLUSIVE and not NONE : remote_login_passwordfile=EXCLUSIVE
3. On Windows, Set the following Sqlnet parameter in <ORACLE_HOME>/network/admin/sqlnet.ora file: SQLNET.AUTHENTICATION_SERVICES=(NTS)
4. ues install user to loging () On MS Windows NT/2000/2003/XP:
On MS Windows the OSOPER and OSDBA groups are hard coded groups thus: Group Name Oracle uses this as... ~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~ ORA_OPER OSOPER group for all instances ORA_DBA OSDBA group for all instances or ORA_sid_OPER OSOPER group for a specific Oracle SID ORA_sid_DBA OSDBA group for a specific Oracle SID When you issue a 'CONNECT / AS SYSDBA' , Oracle checks if your MS Windows logon is a member of the 'ORA_sid_DBA' or 'ORA_DBA' group.
最新文章
- [C#] Linq To Objects - 如何操作字符串
- python 通用 修饰器
- CentOS操作记录
- Nginx系列一：信号与配置
- js-比较两个日期的大小
- abcd
- 4、android之actionbar用法
- 《JS高程》事件类型学习笔记
- RSA的密钥把JAVA格式转换成C#的格式
- iOS 开发者计划申请 2014 年最新心得[转]
- 实现多文件上传在iOS开发中
- QF——iOS第三方登录和社会化分享
- 【leetcode】LRU
- EF如何操作内存中的数据和加载外键数据：延迟加载、贪婪加载、显示加载
- 批量查询sql脚本
- WCF跨域解决方法及一些零碎的东西。
- net core 随笔
- Java实现AES加密,异常java.security.InvalidKeyException: Illegal key size 的解决
- printf()格式化输出详解
- CentOS6.5 安装openssl