Oracle's Default User password _oracle

Source: Internet
Author: User
Tags sqlplus
1. Install the choice of automatic installation, forget the username and password led to now try a few Oracle default username password (the table with the default username and password), are prompted invalid username, password,

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.
Oracle Database Administrator ' s Guide

This is the time to find a set of user names, password prompts are locked to proceed to the next

When you install Oracle, if you do not reset the password for the following users, the default password is as follows:

User name/password

Logon identity

Description


Sys/change_on_install

SYSDBA or Sysoper

Cannot log on as normal and can be the default system administrator

System/manager

Sysdba or Normal

Cannot log on as a sysoper and can be the default system administrator

Sysman/oem_temp

Sysman as OMS user name

Scott/tiger

NORMAL

Ordinary users

Aqadm/aqadm

Sysdba or Normal

Advanced Queue Manager

Dbsnmp/dbsnmp

Sysdba or Normal

Replication Administrator

2, start sqlplus in cmd; log in with Sqlplus/as sysdba, prompt

Connect to:

Oracle Database 10g Express Edition Release 10.2.0.1.0-production

3. Execute ALTER user you are locked username account UNLOCK;

4. Re-use Sql/plus login, with the user name and password you just unlocked;

Re-modify the password is OK!

The specific actions are as follows:
1. Run->sqlplus/nolog
2. Enter Conn/as SYSDBA Admin Account Login
3. Unlock first if user is locked:
Alter user SYSTEM account unlock;
4. Change Password:
Alter user system identified by WANGLJ;
Then you can log in with the Sqlplus.
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.