Scott Account Login Failed, error ORA-01017: invalidusername/password; logondenied how to solve ?,
I had a headache for a long time while reinstalling the oracle database. If you are reading this article, it means you have encountered the same problem as me!
Go straight to the question!
1. log on to the scott account and report the ORA-01017: invalid username/password; logon denied.
2. Ideas:
<1> log on to the system account ----- create a scott account ---- associate employee table;
<2> log on to the system account ----- find the employee table ----- modify the account name;
3 methods: <2nd methods are used here, which is a little simpler. You can find the first method by yourself.>
1. log on with a system account:
System/password <password for installation>
2. Connect to the scott table: @ C: \ oraclexe \ scott. SQL
The scott. SQL file is in the oracle installation directory. You can directly search for the scott. SQL file and put it in any path (only for less write points, and the blogger is directly placed in oraclexe of drive c) through the @ path.
3. Modify the table account name scott: alter user scott identifide by tiger.
The above method is a headache for the bloggers, hoping to help you.
Ps: to reinstall oracle, you only need to download the new installation package. During the installation process, you can choose whether to delete the existing data of the local machine.