Statistics server Test No problem, just the last time the system has a problem, so reload, configure security policy (recently in the study of how to configure a new server, the first time to configure the relevant security settings, and then write down).
For easy, direct cold backup Oracle data files, installed Oracle, directly restore to the original directory.
To start, to appear:
Sql> Startup
The ORACLE routine has started.
Total System Global area 135338868 bytes
Fixed Size 453492 bytes
Variable Size 109051904 bytes
Database buffers 25165824 bytes
Redo buffers 667648 bytes
ORA-01991:??????? ' D:\oracle\ora92\DATABASE\PWDora9.ORA '
Workaround, the Oracle password file is rebuilt using ORAPWD because it is not running in archive mode:
C:\>orapwd/help
Usage:orapwd file= password=entries=
where
File-name of password file (mand),
Password-password for SYS (Mand),
Entries-maximum number of distinct DBA and opers (opt),
There are no spaces around the equal-to (=) character.
Sql> Host del D:\oracle\ora92\DATABASE\PWDora9.ORA
Sql> host Orapwd File=d:\oracle\ora92\database\pwdora9.ora Password=oraclepass E
ntries=10
sql> ALTER DATABASE open;
The database has changed.
When you log in again, you should enter the old database password;
More specific and complete recovery can refer to:
Http://www.dbonline.cn/source/oracle/20031214/resume%20database%20example.html
In fact, more than a year to solve a lot of similar problems, including Linux, Oracle, Windows Server, Cisco routing, switches, application server ..., but many, online already have ready-made solutions can be found, it is rarely posted.