Shulou(Shulou.com)06/01 Report--

Windows server 2008 R2 RAC environment, which installed oracle 11.2.0.1 version, later upgraded to oracle 11.2.0.4 version, restart the computer found that the database can not start, analysis steps are as follows:

1 Enter cmd:

set ORACLE_HOME=e:\app\

set ORACLE_SID=sid_name

2 Error reported with sqlplus / as sysdba connection:

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 a username password error, when the message file is missing directly here;

3 Check ORACLESERVICESIDNAME, it is normal startup, check alert_sid.log without any error;

Enter $ORACLE_HOME\sqlplus\mesg to check mesg information,msb files are all there, and it should not be a problem caused by msb missing;

4 Check oracle registry location:

HKEY_LOCAL_MACHINE\SOLUTE\ORACLE\KEY_OraDb11g_home1 Check the corresponding environment variables, which point to the original version 11.2.0.1, changed to oracle 11.2.0.4 path;

5 Restart the computer,sqlplus / as sysdba, still report 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 that its pointer is bin\ORAEVRUS11.DLL,ORACLE_HOME all dropped;

Replace them all as follows:

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, start the database automatically,OVER.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.