Shulou(Shulou.com)05/31 Report--

ORACLE ORA-01017&SP2-0157 and sys password reset example analysis, I believe that many inexperienced people are helpless, for this reason this article summarizes the causes of the problem and solutions, through this article I hope you can solve this problem.

Environment:

Operating system version: Windows Server 2012R2

Database version: oracle 11.2.0.3 Single instance

Problem description: recently, for a new city deployment inspection script, found sys can not log in with the default mode of operating system authentication, error as shown in the figure

Problem analysis: ORA-01017&SP2-0157 is caused by two reasons, one is to deploy multiple Oracle instances on the server sys login specified instance needs to specify oracle_sid, the other is the database

Password authentication turned on or OS authentication turned off.

problem handling process

1. View database monitoring status

2. View database servers to exclude services with multiple instances

3. View the database-related sqlnet.ora configuration. The configuration is the operating system authentication. Here, for the sake of customer database security, no modification is made.

4. Reset the database sys password according to the technical requirements of the city. Open the operating system cmd command window as an administrator.

--If cmd is not opened as an administrator, an error will be reported when resetting the password, as shown below

5. Reset database sys user password and test login with new password

--Note to backup the original PWD$ORACLE_SID.ora file before resetting the password, otherwise an error will be reported as shown below.

At this point, oracle database sys password reset operation is complete!

After reading the above contents, do you master the method of ORACLE ORA-01017&SP2-0157 and sys password reset example analysis? If you still want to learn more skills or want to know more related content, welcome to pay attention to the industry information channel, thank you for reading!

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.