Oracle forgot Database Password Solution

For Oracle10g: 1. If you do not remember the sys user password, use the following method to change the password: (1) Open cmd, enter sqlplusnolog, and press Enter. (2) Input

For Oracle 10 GB: 1. If you do not remember the sys user password, use the following method to change the password: (1) Open cmd, enter sqlplus/nolog, and press Enter. (2) Input

For Oracle 10 GB:

1. If you do not remember the password of sys, you can change the password as follows:

(1) Open cmd, enter sqlplus/nolog, and press Enter.

(2) Enter "conn/as sysdba ";

(3) Enter "alter user sys identified by new password;" (the new password must start with a letter, and the score number cannot be forgotten after each SQL statement)

The same applies to other users.

2. (1) Start sqlplus in cmd;

(2) Use sqlplus/as sysdba to log on and connect it:

Oracle Database 10g Express Edition Release 10.2.0.1.0-Production

(3) execute alter user dbsnmp account unlock;

(4) log on with SQL/PLUS again and set the user name and password;

Appendix: username/password for Oracle 10g default installation

Username

Password

Description

See Also

CTXSYS

CTXSYS

TheOracleText account

OracleText Reference

DBSNMP

DBSNMP

The account used by the Management Agent componentOracleEnterprise Manager to monitor and manage the database

OracleEnterprise Manager Grid Control Installation and Basic Configuration

LBACSYS

LBACSYS

TheOracleLabel Security administrator account

OracleLabel Security Administrator's Guide

MDDATA

MDDATA

The schema usedOracleSpatial for storing Geocoder and router data

OracleSpatial User's Guide and Reference

MDSYS

MDSYS

TheOracleSpatial andOracleInterMedia Locator administrator account

OracleSpatial User's Guide and Reference

DMSYS

DMSYS

TheOracleData Mining account.

OracleData Mining Administrator's Guide

OracleData Mining Concepts

OLAPSYS

MANAGER

The account used to create OLAP metadata structures. It owns the OLAP Catalog (CWMLite ).

OracleOLAP Application Developer's Guide

ORDPLUGINS

ORDPLUGINS

TheOracleInterMedia user. Plug-ins suppliedOracleAnd third party format plug-ins are installed in this schema.

OracleInterMedia User's Guide

ORDSYS

ORDSYS

TheOracleInterMedia administrator account

OracleInterMedia User's Guide

OUTLN

OUTLN

The account that supports plan stability. Plan stability enables you to maintain the same execution plans for the same SQL statements. OUTLN acts as a role to centrally manage metadata associated with stored outlines.

OracleDatabase Performance Tuning Guide

SI_INFORMTN_SCHEMA

SI_INFORMTN_SCHEMA

The account that stores the information views for the SQL/MM Still Image Standard

OracleInterMedia User's Guide

SYS

CHANGE_ON_INSTALL

The account used to perform database administration tasks

OracleDatabase Administrator's Guide

SYSMAN

CHANGE_ON_INSTALL

The account used to performOracleEnterprise Manager database administration tasks. Note that SYS and SYSTEM can also perform these tasks.

OracleEnterprise Manager Grid Control Installation and Basic Configuration

SYSTEM

MANAGER

Another account used to perform database administration tasks.