|
|
关于更改internal 的密码Meta上如此解释：
Resetting/changing the password of the user internal:
----------------------------------------------------
There are 3 common ways to change to password of internal:
1) Recreate the passwordfile (Read Warning 1 & 2):
You can recreate the password file using the ORAPWDxx command by which you can
specify the password for internal. Before running this command to create the
new password file, make sure to delete the old password file. Otherwise, the
ORAPWDxx utility will give an error message.
D:\> ORAPWD file=D:\ORANT\DATABASE\PWDORCL.ORA password=<password>
entries=5
Verify if the new file has been created.
The passwordfile might be hidden. Hidden files can be seen:
on the DOS-prompt by type :
c:\> dir /A:H
in Windows NT explorer :
use the Windows Explorer View/Option 'show all files' to see the
file.
Remark:
-------
If the value of the "remote_login_passwordfile" parameter in the "init.ora" is
EXCLUSIVE then you must shutdown your database before recreating the password
file.
Failure to do so will result in being unable to connect as internal as long as
you don't stop the database by for example stopping services.
2) Alter the password of the user 'SYS' (Read Warning 1)
a) Verify the values of the "remote_login_passwordfile" in the
"init.ora" parameter file.
If its values is exclusive continue with e) if Shared continue with b)
b) Stop the database if it is started
c) Change the "remote_login_passwordfile" in the Init<SID>.ora to
"exclusive".
d) Startup the database.
e) Alter the user SYS to a new password, now also the password for
internal.
3) Use ORADIMxx (Read Warning 2)
You could drop the instance and recreate it with a new password.
Suppose the SID in question is ORCL:
a) You shutdown the database and stop the services.
b) D:\> ORADIMxx -delete -sid ORCL
c) D:\> ORADIMxx -new -sid ORCL -intpwd <new password> -startmode
auto -pfile D:\ORANT\DATABASE\INITORCL.ORA
-----------
WARNING
-----------
1) (Methods 1 and 2) Changing the password of the internal might prevent
your database from starting up automatically in Oracle7 7.3.x and Oracle8
8.0.x. . When you create your instance with the instance manager and
configure it to startup automatically.
(ORADIMxx -new -sid ORCL -intpwd ORACLE -startmode AUTO -pfile
D:\ORANT\DATABASE\INITORCL.ORA),
a file <ORACLE_HOME>\DATABASE\strt<sid>.cmd is generated. That file contains
(hardcoded) the password of internal. If the password in there does not match
the actual password of internal, the instance will fail to startup
automatically.
When you change the password of internal in one of the above described ways and
if you still want your database to start up automatically, you need to adjust
the password manually.
2) Methods 1 and 3 can result in loosing all previously registered sysdba
and sysoper-users. If you had granted specific users those privileges again,
you will need to grant it again.
g) Updating Windows NT registry when password file moved or renamed
----------------------------------------------------------------
You either renamed or moved your password file. The Registry has an
entry to denote the password file. When the file is moved or renamed
the Registry must be updated.
Solution Description:
=====================
CAUTION:
Editing the REGISTRY could cause severe damage to Windows NT.
If you are not familiar with the Registry, please consult with your System
Administrator. A damaged registry could require a complete reload of the NT
Operating System.
1. Run REGEDT32.EXE to open the Registry.
2. Click on the HKEY_LOCAL_MACHINE on Local Machine hive.
3. Click on the SOFTWARE folder.
4. Click on the ORACLE folder.
If the database is created in the default home, skipt step 5.
5. If the database is not created in the default home, but in HomeXX
(XX is a number from 1 to the number of homes installed on your Server)
Click on the HomeXX folder.
6. Update or Create ORA_<SID>_PWFILE (where <SID> is the database SID).
String with the correct name and path of the password file.
After changing the registry entry, the OracleService<SID> service will
need to be stopped and restarted for the change to take affect.
Solution Explanation:
=====================
The HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\ORA_<SID>_PWFILE or
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HomeXX\ORA_<SID>_PWFILE
registry entry is used to store the name and location of the password file. |
|
楼主: Rick1998
IP卡
狗仔卡
发表于 2001-11-14 17:25
显身卡
