oracle 中的口令更改,如何更改internal的口令？oracle8中。

如果是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.

如果是NT，步骤基本一样，但第3不可以运行别的工具。例如：

ORADIM80 -delete -sid sid

ORADIM80 -new -sid sid -intpwd your_newpasswrd -maxuser n

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.