数据库无法启动问题就大了,不过你可以通过登录internal用户来实现数据库的启动和修改sys或system的口令,方法如下:1、进入svrmgrl,尝试用connect internal/oracle登录,看看登录成功。也可以试试connect / as sysdba,如果登录成功,就好办了。 2、如果不成功,则要修改internal的口令,internal的口令保存在文件中,文件名为ORACLE_HOME/DATABASE/pwdSID.ora。首先删除这个文件,然后在dos下执行命令: orapwd file=%ORACLE_HOME%/database/pwdSID.ora password=admin 3、然后利用connect internal/admin登录。 4、登录成功后,启动数据库 svrmgrl>startup 5、修改system或sys的口令: alter user system identified by manager; 6、此时可以登录到system用户connect system/manager
to zcs_1(生生不息) : 你这方法是针对nt还是linux?nt下找不到pwdSID.ora文件
除了重新安装oms外,有一个办法 这个密码是存储在一个表中的 然后用一个默认密码 用该密文替换掉你忘记的密码 然后就可以用默认密码重新登陆了OMS password could by reset by running a scripts.4.5 How can I reset the SYSMAN password if I forgot it?To reset the password of SYSMAN to the default oem_temp, you will need to log on to SQL*Plus Worksheet as the OEM Repository ower. Then issue the following:UPDATE SMP_VDU_PRINCIPALS_TABLE SET password = 'E5A264514813C63F09D3A127712E2AE229A8CF88724FF226' WHERE UPPER(principal_name) = 'SYSMAN';A script called vduResetSysman.sql, has been added to the OEMV2 installation, which contains this command. This script resides in the "$ORACLE_HOME\SYSMAN\ADMIN" directory.
sys/change_on_install
system/manager
scott/tigerinternal:sysdba,最高权限,可以启动、关闭数据库
sys:当使用connect sys/change_on_install as sysdba的时候,相当于internal,同时是各种工具包和数据字典的owner
system:dba,但是不能启动、关闭数据库
scott:普通用户权限
在里面用create user sys identified by change_on_install;
commint
你仔细看看sysdba,sysoper,normal各种方式登陆。
还是不行?那就惨了
2、如果不成功,则要修改internal的口令,internal的口令保存在文件中,文件名为ORACLE_HOME/DATABASE/pwdSID.ora。首先删除这个文件,然后在dos下执行命令:
orapwd file=%ORACLE_HOME%/database/pwdSID.ora password=admin
3、然后利用connect internal/admin登录。
4、登录成功后,启动数据库
svrmgrl>startup
5、修改system或sys的口令:
alter user system identified by manager;
6、此时可以登录到system用户connect system/manager
你这方法是针对nt还是linux?nt下找不到pwdSID.ora文件
这个密码是存储在一个表中的
然后用一个默认密码
用该密文替换掉你忘记的密码
然后就可以用默认密码重新登陆了OMS password could by reset by running a scripts.4.5 How can I reset the SYSMAN password if I forgot it?To reset the password of SYSMAN to the default oem_temp, you will need to
log on to SQL*Plus Worksheet as the OEM Repository ower. Then issue the
following:UPDATE SMP_VDU_PRINCIPALS_TABLE
SET password = 'E5A264514813C63F09D3A127712E2AE229A8CF88724FF226'
WHERE UPPER(principal_name) = 'SYSMAN';A script called vduResetSysman.sql, has been added to the OEMV2
installation, which contains this command. This script resides in the
"$ORACLE_HOME\SYSMAN\ADMIN" directory.