Oracle sqldeveloper ORA-01017 Invalid Username/password;logon denied (password loss solution)

Source: Internet
Author: User

Oracle SYS account cannot login with SQL Developer tool inconsistent user name and password
If the password is lost:
Execute the following command in Sql*plus:
Sql>conn/as sysdba (OS authentication login)
Sql>alter user system identified by password; (The password of user system will change to your password after carriage return)

If the password you changed is a number, enclose it in quotation marks .

Eg:sql>alter user system identified by "123456";

You can also use Plsql login, Sys/as sysdba, and then change the password alter USER SYS identified by password;  
Password is the password you want to change so you can connect again with a new password


Oracle sqldeveloper ORA-01017 Invalid Username/password;logon denied (password loss solution)

Related Article

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.