Oracle default Administrator's account and password and password modification and unlocking

Source: Internet
Author: User
Tags sqlplus

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

Cannot log on as NORMAL and can be used as the default system administrator

System/manager

SYSDBA or NORMAL

Cannot log on as Sysoper and can be used as the default system administrator

Sysman/oem_temp

Sysman User name for OMS

Scott/tiger

NORMAL

Normal User

Aqadm/aqadm

SYSDBA or NORMAL

Advanced Queue Administrators

Dbsnmp/dbsnmp

SYSDBA or NORMAL

Replication Administrator

Sysman User name for OMS

Scott/tiger

NORMAL

Normal User

Aqadm/aqadm

SYSDBA or NORMAL

Advanced Queue Administrators

Dbsnmp/dbsnmp

SYSDBA or NORMAL

Create table space and users, when needed to forget the password, tried a lot of times are not connected, and then the user is locked, the following teaches you to deal with the Oracle Default user's password problem method, I hope that the same situation with my friends have some help

1. Install the automatic installation of the selected, forgot the user name and password cause now try a few Oracle default username password (the table with the default user name and password), prompt invalid user name, password,

Username
Password
Description
See Also

Ctxsys
Ctxsys
The Oracle Text account
Oracle Text Reference

Dbsnmp
Dbsnmp
The account used by the Management Agent component of 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 the Oracle and third party format Plug-ins is 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 that supports plan stability. Plan stability enables you-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, 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 that 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

At this time to find a set of user name, password prompt is locked in order to proceed to the next

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

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

System/manager

Sysdba or Normal

Cannot log on as Sysoper and can be used as the default system administrator

Sysman/oem_temp

Sysman User name for OMS

Scott/tiger

NORMAL

Normal User

Aqadm/aqadm

Sysdba or Normal

Advanced Queue Administrators

Dbsnmp/dbsnmp

Sysdba or Normal

Replication Administrator

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

Connect to:

Oracle Database 10g Express Edition Release 10.2.0.1.0-production

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

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

Re-modify the password on it!

Here's how:
1. Running->sqlplus/nolog
2. Enter Conn/as SYSDBA Administrator account Login
3. If the user is locked first unlock:
Alter user SYSTEM account unlock;
4. Change Password:
Alter user system identified by WANGLJ;
Then you can log in with Sqlplus.

If you want to SYSDBA role login requires authorization (default only SYS selects SYSDBA)

Grant SYSDBA to user name;

Oracle default Administrator's account and password and password modification and unlocking

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.