忘记了sys的密码
?
机器已经很久前安装的,忘记了sys和system的密码;
?
登陆到oracle数据库的机器上
?
sqlplus '/ as sysdba'
?
像一个普通用户一样,修改sys或者system的密码
?
alter user sys identified by newpasswd;
?
-----------------------------------------------
再具体一些:
?
设置参数REMOTE_LOGIN_PASSWORDFILE=NONE
设置sqlnet.ora文件中的SQLNET.AUTHENTICATION_SERVICES= (NTS)
用conn / as sysdba进去
然后alter user sys identified by oracle
alter user system identified by oracle