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->启动关闭选项->服务启动时启动例程,把该项取消就可以了。