日期:2014-05-16  浏览次数:20424 次

Oracle 10g 默认安装带来的用户名/密码
1. 安装时选择的自动安装,由于时间久远忘记用户名、密码了,导致现在试了几个默认的用户名密码後(表格中附带默认用户名及密码),都提示无效的用户名、密码,终于在试了下dbsnmp/dbsnmp,提示被锁;
2.用sqlplus/as sysdba登录,提示
3.
SQL> alter user dbsnmp account unlock;

User altered.

SQL> alter user dbsnmp identified by dbsnmp;

User altered.
4.[LongKe@fedora10 ~]$ sqlplus dbsnmp/dbsnmp;

SQL*Plus: Release 11.1.0.6.0 - Production on Thu Aug 27 02:26:03 2009

Copyright (c) 1982, 2007, Oracle. All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> show user;
USER is "DBSNMP"



Oracle 10g 默认安装带来的用户名/密码

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