1 Create a new local Windows NT users’ group called ORA_<SID>_DBA and ORA_<SID>_OPER that is specific to an instance, or ORA_DBA and ORA_OPER that is not specific to an instance. 2 Add a Windows NT operating system user to that group. Once you access this domain, you are automatically validated as an authorized DBA. 3 Ensure that you have the following line in your sqlnet.ora file: SQLNET.AUTHENTICATION_SERVICES = (NTS) 4 Set the REMOTE_LOGIN_PASSWORDFILE parameter to NONE. 5 Connect to the database with the privilege SYSDBA or SYSOPER: CONNECT / AS { SYSDBA|SYSOPER }关键是第3、4步
internal也可认为是超级用户,默认口令是internal或oracle
你用超级用户登录看看。
在init<sid>.ora中修改
REMOTE_LOGIN_PASSWORDFILE = NONE
重启一下Oracle就可以了
我连connect internal再密码:oracle或者internal,或者其他任意的字符都出现insufficient privilige的提示
sys/change_on_install以sysdba身份登陆,也出现同样的提示
并重启了操作系统,还是不行!
还请各位帮忙!谢谢
ORA_<SID>_OPER that is specific to an instance, or ORA_DBA and
ORA_OPER that is not specific to an instance.
2 Add a Windows NT operating system user to that group. Once you access this
domain, you are automatically validated as an authorized DBA.
3 Ensure that you have the following line in your sqlnet.ora file:
SQLNET.AUTHENTICATION_SERVICES = (NTS)
4 Set the REMOTE_LOGIN_PASSWORDFILE parameter to NONE.
5 Connect to the database with the privilege SYSDBA or SYSOPER:
CONNECT / AS { SYSDBA|SYSOPER }关键是第3、4步
试一下吧。