刚刚查到这样一端资料:
To change the password of internal: Make sure that you have shutdown the database before you change the password. Do not remove or modify the password file if you have a database or instance mounted using
REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE(or SHARED). If you do, you will be unable to reconnect remotely using the password file. Even if you replace it, you cannot use the new password file, because the timestamp and checksums will be wrong.
The ORACLE_HOME\DATABASE\PWD.ORA file contains the internalpassword. This is a binary file and cannot be manually edited. The ORAPWDxx.EXE utility was created for DBAs who need to change the INTERNAL login password.
From the DOS prompt run:
orapwd file=c:\oracle_home\database\pwd.ora
In your case, for example it would be something like:
orapwd8 file=c:\orant\database\pwdorcl.ora password=oracle entries=5
FILE = Path and name of the password file. (mandatory)
Password = Password for SYS and INTERNAL. (Mandatory)
Entries = Maximum number of distinct DBAs and OPERs. (Optional, default=5)
There are no spaces around the equal-to <=> character.
如果是Unix,那你必须有Oracle DBA组的password,以便能修改INIT.ORA文件和运行orapwd.在你决定修改internal的password的时候,你必须先shutdown db.否则下次你将不能启动Oracle.
1, shutdown db
2, delete or rename the old password file.(在$Oracle_Home/dbs/下有个文件,类似PWD.ora这样的文件)
3,运行
orapwd file=$Oracle_Home/dbs/pwdxxx.ora password=oracle entries=5
4, ensure to set REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE in init.ora file
5, $>svrmgrl
svrmgrl>connect internal/oracle as sysdba
svrmgrl>startup
svrmgrl>alter sys (或则是system)都可以了。
这样你就可以完全修改以前的dba的password.
实现方法:
用法:orapwd file= password= entries=
参数解释:
file - name of password file (mand),
password - password for SYS and INTERNAL (mand),
entries - maximum number of distinct DBA and OPERs (opt),
There are no spaces around the equal-to (=) character.
参数解释:
file - name of password file (mand),
password - password for SYS and INTERNAL (mand),
entries - maximum number of distinct DBA and OPERs (opt),
There are no spaces around the equal-to (=) character.