[转]oracle 11g 忘记 默认用户密码
本文轉自:http://blog.csdn.net/huangbiao86/article/details/6595052
首先啟動sqlplus 輸入用戶名:sqlplus / as sysdba 密碼空缺 如果用戶被鎖定,記得加上 SQL> alter user dbsnmp account unlock;
User altered. 然后修改密碼 SQL> alter user dbsnmp identified by dbsnmp;
User altered. 現在就可以用用戶名:dbsnmp 密碼: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 | The account used to create OLAP metadata structures. It owns the OLAP Catalog (CWMLite). | Oracle OLAP Application Developer's Guide |
| ORDPLUGINS | ORDPLUGINS | The Oracle interMedia user. Plug-ins supplied by Oracle and third party format plug-ins are installed in this schema. | Oracle interMedia User's Guide |
| ORDSYS | ORDSYS | The Oracle interMedia administrator account | Oracle interMedia 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. | Oracle Database Performance Tuning Guide |
| SI_INFORMTN_SCHEMA | SI_INFORMTN_SCHEMA | The account that stores the information views for the SQL/MM Still Image Standard | Oracle interMedia User's Guide |
| SYS | CHANGE_ON_INSTALL | The account used to perform database administration tasks | Oracle Database Administrator's Guide |
| SYSMAN | CHANGE_ON_INSTALL | The 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 |
| SYSTEM | MANAGER | Another account used to perform database administration tasks. | Oracle Database Administrator's Guide |
?
轉載于:https://www.cnblogs.com/freeliver54/p/3573053.html
總結
以上是生活随笔為你收集整理的[转]oracle 11g 忘记 默认用户密码的全部內容,希望文章能夠幫你解決所遇到的問題。
- 上一篇: 教你如何给iTunes资料库搬家解放C盘
- 下一篇: iPhone究竟是否需要贴膜