ORA-01017 no message file for Product=rdbms

Source: Internet
Author: User
Tags sqlplus

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.