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

Source: Internet
Author: User

. 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

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.