Original: SQL Drip 8-the account is currently locked out. The system administrator can unlock it.The problems encountered today are more interesting. First of all, the test database has not been opened for a long time, open today, using the service
The problems encountered today are more interesting. First of all, the test database has not been opened for a long time, open today, using the service program testing, the following error message
After installing Oracle 10g, you want to open sql*plus to learn, and then follow the steps in the book to connect to the database with Scott users, you can lose several times prompted an error.
Error:the account is locked
Then after checking the
Modify Password:
Scott user's password is not correct, enter administrator user, modify Scott user password canor modify the password like this:In the Run Bar Knock: Sqlplus (space)/nolog carriage returnThen knock in the pop-up box: Conn
Ora-28000:the Account is locked-solution2009-11-11 18:51Ora-28000:the account is locked1th step: Use PL/SQL, login name System, database name unchanged, select type to change normal to SYSDBA;2nd step: Select Myjob, view users;3rd Step: Select
Instance code for Oracle 11g User Password modification and lock/unlock function, oracle11g
1. Run cmd.exe;
2. Enter sqlplus/as sysdba to connect to the database as a system administrator (sysdba) for database management.
3. After successful
The problem encountered today is quite interesting. First, the test database has not been opened for a long time. Open it today and use the serviceProgramThe following error message is displayed during the test:Message: system. Data. sqlclient.
Everybody wants the first to write down, will always be useful in the future! There are a lot of ways to unlock a computer's boot code, which displays five:
Method One:
When powered on, press F8 to enter "secure with Command Prompt"
When you install ORACLE, the default password is as follows if you do not reset the password for the following users:
User name/password
Login status
Description
Sys/change_on_install
SYSDBA or Sysoper
Method one, when booting, press F8 to enter "safe with Command Prompt" modeEnter "NET user+ user name +123456/add" to force a user's password to "123456″Method Two, if the user forgot to login password can be resolved in the following ways1. Press
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.