这个有办法 把你的数据库认证设为操作系统认证 然后使用administrator登录(一定是在数据库所在的机器上) 然后connect / as sysdba 修改你的sys密码
密码改了。 在俄system manager server 中改的 可不明白system改不了sys的口令。而sysman可以,为什么?
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 }
把你的数据库认证设为操作系统认证
然后使用administrator登录(一定是在数据库所在的机器上)
然后connect / as sysdba
修改你的sys密码
在俄system manager server 中改的
可不明白system改不了sys的口令。而sysman可以,为什么?
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 }
1、如果知道INTERNAL的口令,就用INTERNAL登录,然后更改SYS口令
2、如果不知道INTERNAL的口令,就用ORAPWD重新生成INTERNAL口令,GOTO STEP 1