Windows Server R2 RAC Environment, which has the Oracle 11.2.0.1 version, later upgraded to Oracle 11.2.0.4 version, restart the computer discovery dtabase failed to start, the analysis steps are as follows:
1 Enter cmd:
Set Oracle_home=e:\app\
Set Oracle_sid=sid_name
2 using Sqlplus/as SYSDBA connection error:
ora-01017 message file for product=RDBMS, facility=ORA
View with Oerr
Oerr Ora 01017
01017, 00000, "Invalid Username/password; Logon Denied "
01017 should be caused by the user name password error, when the message file is directly reported missing;
3 Check oracleservicesidname, it is normal start, check alert_sid.log without any error;
Enter $ORACLE_HOME\SQLPLUS\MESG check mesg information, MSB files are in, should not be the problem caused by the absence of MSB;
4 Check the Oracle registry location:
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraDb11g_home1
Check the corresponding environment variables, which point to the original 11.2.0.1 version, and change to the path of Oracle 11.2.0.4;
5 Restart the computer, Sqlplus/as SYSDBA, still error
6 copy 11.2.0.1 database password file to the new directory, still error
7 Check the Registry event log information:
[HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\services\eventlog\Application\ORACLE.tcis2]
Find it pointing to BIN\ORAEVRUS11. The dll,oracle_home all dropped;
Replace all of the following:
Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\services\eventlog\Application\ORACLE.tcis2]
"EventMessagefile"="E:\\app\\Administrator\\product\\11.2.0\\dbhome_2\\BIN\\ORAEVRUS11.DLL"
Restart the computer, the database from the start, over.
ORA-01017 no message file for Product=rdbms