Oracle 10 Gb Default User Name, password unlock, Change User Password

. Automatic Installation selected during installation. Because the user name and password have been forgotten for a long time, I have tried several default user names and passwords (attached in the table ).Default User NameAnd password), all prompts invalid user name and password, and finally tried Dbsnmp/Dbsnmp, prompting to be locked;

2. Start sqlplus in cmd; Use sqlplus/As sysdba to log on, prompting

Connect:

OracleDatabase 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;

Note: Because the user name just unlocked is Dbsnmp, the user name set here is also Dbsnmp

Oracle 10g  Username for default installation/Password

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.

 

1. log on to the database using an oracle user

[Oracle @ wuzj ~] $ Sqlplus/nolog

SQL * Plus: Release 10.2.0.1.0-production on Thu Feb 26 12:06:29 2009

Copyright (c) 1982,200 5, Oracle. All rights reserved.

SQL> Conn/As sysdba
Connected.

// View the user
SQL> select username, password from dba_users;

// Modify the User Password format alter User Username identified by new password;

SQL> alter user system identified by manager;

Another method for modifying values

 

SQL> alter user system identified by values '2d594e86f93b17a1 ';

 

The user has changed.

// Try this password

 

SQL> connect system/Oracle

 

Connected.

// This password does not work.

 

SQL> connect system/Manager

 

Error:

 

ORA-01017: invalid username/password; logon denied