oracle 11g默认用户名、密码解锁 以及安装后重启黑屏问题
- 1、下载文档前请自行甄别文档内容的完整性,平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益,请联系客服反馈,我们会尽快为您处理(人工客服工作时间:9:00-18:30)。
安装时选择的自动安装,由于时间久远忘记用户名、密码了,导致现在试了几个默认的用户名密码後(表格中附带默认用户名及密码),都提示无效的用户名、密码,终于在试了下dbsnmp/dbsnmp,提示被锁;
首先启动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 Oracle Label Security
administrator account 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 MANAGE
R
The account used to create OLAP
metadata structures. It owns the
OLAP Catalog (CWMLite).
Oracle OLAP Application
Developer's Guide
ORDPLUG INS ORDPLUG
INS
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
Oracle Database Performance
Tuning Guide
for the same SQL statements. OUTLN acts as a role to centrally manage metadata associated with stored outlines.
SI_INFOR MTN_SCH EMA SI_INFOR
MTN_SCH
EMA
The account that stores the
information views for the SQL/MM
Still Image Standard Oracle interMedia User's Guide
SYS CHANGE_
ON_INSTA
LL
The account used to perform
database administration tasks
Oracle Database
Administrator's Guide
SYSMAN CHANGE_
ON_INSTA
LL
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 MANAGE
R
Another account used to perform
database administration tasks.
Oracle Database
Administrator's Guide
不知道11g是不是这个。
啊,今天补充一点!一定要注意,尤其是内存小于等于2G的同学。
不用的的时候一定不要开启oracle的服务。
今天开机居然输入密码后一直黑屏,进不去桌面。
有同样遭遇
的同学,参考一下解决办法:
1.开机F8进安全模式(如果安全模式都进不了就不知道了,亲,重装或者回复系统吧)
2.在我的电脑里面找到“服务”(不管你是从任务管理器-服务-服务,还是我的电脑右键管理-服务与应用-服务)。
找到以oracle开头的全部服务,所有“自动”或者“自动(延迟启动)”的都设置为“手动”,一般都不会用到。
3.在使用oracle服务器的时候,只需要开启OracleOraDb11g_home1TNSListener和OracleServiceXXX即可(XXX为你配置的服务器名字)。
此贴仅分享给和我一样的菜鸟学习交流,分享经验教训。
老鸟请无视,勿喷。