Welcome 微信登录
编程资源 图片资源库 蚂蚁家优选

首页 / 数据库 / MySQL / Oracle 11g默认用户名,密码解锁

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 <?XML:NAMESPACE PREFIX = ST1 />10g 默认安装带来的用户名/密码 【6688电子商务网站 www.6688.cc  】
UsernamePasswordDescriptionSee Also
CTXSYSCTXSYSThe Oracle Text accountOracle Text Reference
DBSNMPDBSNMPThe account used by the Management Agent component of Oracle Enterprise Manager to monitor and manage the databaseOracle Enterprise Manager Grid Control Installation and Basic Configuration
LBACSYSLBACSYSThe Oracle Label Security administrator accountOracle Label Security Administrator"s Guide
MDDATAMDDATAThe schema used by Oracle Spatial for storing Geocoder and router dataOracle Spatial User"s Guide and Reference
MDSYSMDSYSThe Oracle Spatial and Oracle interMedia Locator administrator accountOracle Spatial User"s Guide and Reference
DMSYSDMSYSThe Oracle Data Mining account.Oracle Data Mining Administrator"s GuideOracle Data Mining Concepts
OLAPSYSMANAGERThe account used to create OLAP metadata structures. It owns the OLAP Catalog (CWMLite).Oracle OLAP Application Developer"s Guide
ORDPLUGINSORDPLUGINSThe Oracle interMedia user. Plug-ins supplied by Oracle and third party format plug-ins are installed in this schema.Oracle interMedia User"s Guide
ORDSYSORDSYSThe Oracle interMedia administrator accountOracle interMedia User"s Guide
OUTLNOUTLNThe 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.Oracle Database Performance Tuning Guide
SI_INFORMTN_SCHEMASI_INFORMTN_SCHEMAThe account that stores the information views for the SQL/MM Still Image StandardOracle interMedia User"s Guide
SYSCHANGE_ON_INSTALLThe account used to perform database administration tasksOracle Database Administrator"s Guide
SYSMANCHANGE_ON_INSTALLThe account used to perform Oracle Enterprise Manager database administration tasks. Note that SYS and SYSTEM can also perform these tasks.Oracle Enterprise Manager Grid Control Installation and Basic Configuration
SYSTEMMANAGERAnother account used to perform database administration tasks.Oracle Database Administrator"s Guide
Oracle备份与恢复核心技术点Oracle DBLink脚本相关资讯      oracle 
  • [INS-32052] Oracle基目录和Oracle  (07/22/2014 07:41:41)
  • Oracle 4个大对象(lobs)数据类型  (02/03/2013 12:33:05)
  • Oracle按时间段分组统计  (07/26/2012 10:36:48)
  • [Oracle] dbms_metadata.get_ddl的  (07/12/2013 07:37:30)
  • Liferay Portal 配置使用Oracle和  (07/31/2012 20:07:18)
  • Concurrent Request:Inactive   (07/20/2012 07:44:05)
本文评论 查看全部评论 (0)
表情: 姓名: 字数