First Kind
Ora-28000:the account is locked
The first step: the use of Pl/sql, login name System, the database name unchanged, select the type of time to modify the normal to SYSDBA;
The second step: Select MyObject, view users;
The third step: select System, right-click click "Edit";
Fourth step: Modify the password, the "account is locked" check remove;
Fifth step: Click "Apply" and then click "Close";
The sixth step: re-login can be validated;
ALTER USER username account UNLOCK;
Third Kind
In Plsql developer, if you are prompted to log in Scott/tiger, ora-28000 is locked.
Solution:
After the new oracle10g, with the Scott/tiger test, you will receive the following error prompts:
oracle10g the account is locked
oracle10g the password has expired
Reason: The default oracle10g Scott cannot log in.
Solve:
(1) Conn Sys/sys as SYSDBA; Log on as DBA
(2) Alter user Scott account unlock;//and unlock
(3) Conn Scott/tiger//pop Up a Change Password dialog box, modify the password on it
In the operation of the input CMD in DOS mode input sqlplus, the system user name login, password is just installed Oracle when they fill out the password orcl, log in later.
Sql> Conn Sys/sys as SYSDBA; (Semicolon is required but I am logged in with system this should not be written Conn Sys/sys as SYSDBA should write Conn SYSTEM/ORCL as SYSDBA;)
Connected.
sql> alter user Scott account unlock;
User altered.
Sql> commit;
Commit complete.
Sql> Conn scott/tiger//Please enter a new password and confirm OK
Password changed
Connected.
Then to Plsql developer inside to Scott/tiger login on it ...
Oracle 10g user name/password with default installation
Username
Password
Description
Also
Ctxsys
Ctxsys
The Oracle Text account
Oracle Text Reference
Dbsnmp
Dbsnmp
The account used by the Management Agent component for Oracle Enterprise Manager to monitor and manage the database
Oracle Enterprise Manager Grid control installation and Basic Configuration
Lbacsys
Lbacsys
The Oracle Label Security Administrator account
Oracle Label Security Administrator ' s Guide
Mddata
Mddata
The schema used by Oracle Spatial for storing Geocoder and router data
Oracle Spatial User ' s Guide and Reference
Mdsys
Mdsys
The Oracle Spatial and Oracle Intermedia Locator Administrator account
Oracle Spatial User ' s Guide and Reference
Dmsys
Dmsys
The Oracle Data Mining account.
Oracle Data Mining Administrator ' s Guide
Oracle Data Mining Concepts
Olapsys
MANAGER
The account used to create OLAP metadata structures. It owns the OLAP Catalog (cwmlite).
Oracle OLAP application Developer ' s Guide
Ordplugins
Ordplugins
The Oracle intermedia user. Plug-ins supplied by Oracle and third the party format plug-ins the are installed in the this schema.
Oracle intermedia User ' s Guide
Ordsys
Ordsys
The Oracle Intermedia Administrator account
Oracle intermedia User ' s Guide
Outln
Outln
The account is supports plan stability. Plan stability enables your to maintain the same execution plans for the same SQL statements. OUTLN acts as a role to centrally manage metadata associated with stored outlines.
Oracle Database Performance Tuning Guide
Si_informtn_schema
Si_informtn_schema
The account this stores the information views for the sql/mm still Image Standard
Oracle intermedia User ' s Guide
SYS
Change_on_install
The account used to perform database administration tasks
Oracle Database Administrator ' s Guide
Sysman
Change_on_install
The account used to perform Oracle Enterprise Manager database administration tasks. Note-SYS and SYSTEM can also perform these tasks.
Oracle Enterprise Manager Grid control installation and Basic Configuration
SYSTEM
MANAGER
Another account used to perform database administration tasks