oracle management server SYSMAN密码丢失怎么办?

OMS oracle management server SYSMAN密码丢失怎么办?[@more@]

使用如下脚本$oracle_home/sysman/admin/vduresetSysman.sql

rem -------------------------------------------------------------------
rem
rem NAME
rem resetSysman.sql
rem
rem Copyright (c) 1997, 1999 by Oracle Corporation
rem
rem FUNCTION
rem Script for resetting the superuser password
rem
rem NOTES
rem This script should be run from the Enterprise Manager
rem Master account.
rem
rem MODIFICATION
rem $Log: $
rem
rem 1 8/28/98 9:25a Ndutko
rem Initial entry
rem
rem -------------------------------------------------------------------

update SMP_VDU_PRINCIPALS_TABLE set password = '9ed0fa64a76b4bd912310580f74926ca'
where principal_name = UPPER('SYSMAN');
commit;
有个疑问?

这个SMP_VDU_PRINCIPALS_TABLE 表在哪里呢?

又是谁的呢?是SYSMAN的?那SYS总该可以访问吧/

可是用SYS登陆OEMREP库,却找不到这个表,不知道为什么

晚上回去再研究

'execute smp_maintenance.reset_sysman();'执行这个好象也可以重置密码

默认口令oem_temp,密码可是区分大小写的哦

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/9194732/viewspace-912598/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/9194732/viewspace-912598/