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

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