Solution for Oracle's locked ____oracle

Source: Internet
Author: User
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

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.