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)

or

SQLNET.AUTHENTICATION_SERVICES= (NONE,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.

 

 

issue2:

Oracle的window服务启动时并不启动实例的方法

 

racle的window服务启动时并不启动实例的方法

 

(1)通过oradim startup 参数设定：oradim -startup -sid orcl -starttype srvc

      1. 仅启动服务(starttype参数指定，经测试10g版本仍然启动实例，可以连接数据库)

　　C:Documents and SettingsAdministrator>oradim -startup -sid mydb -starttype srvc

　　2.登录SQLPLUS

　　C:Documents and SettingsAdministrator>sqlplus /nolog

 

 

　　3.连接数据库

 

　　SQL> conn / as sysdba [conn / as sysdba 使用的是系统用户，只能在服务器本机上使用。]

　　已连接(到空闲例程)。[如果不启动服务则提示：ORA-12560: TNS: 协议适配器错误]

　　然后执行数据库分步启动就OK了.

(2)通过Oracle Administration Assistant for Windows NT工具进行设置

　　a.开始->程序->Oracle->Configuration and Migration Tools->Oracle Administration Assistant for Windows NT

　　b.数据库->orcl->启动关闭选项->服务启动时启动例程,把该项取消就可以了。