. 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