oracle 11g 忘记 默认用户密码
来源:互联网 发布:编程语言汇总 编辑:程序博客网 时间:2024/05/21 21:38
转
首先启动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
查看PROFILE设置
select * from dba_profiles where profile='DEFAULT' and resource_name='PASSWORD_LIFE_TIME';
DEFAULT PASSWORD_LIFE_TIME PASSWORD 180
处理逻辑,将用户密码修改并判断是否需要这个策略
ALTER USER 用户名 IDENTIFIED BY 密码 ;
语句进行修改密码,密码修改后该用户可正常连接数据库。
如果需要修改策略
ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED
语句将口令有效期默认值180天修改成“无限制”。
- oracle 11g 忘记 默认用户密码
- oracle 11g 忘记 默认用户密码
- oracle 11g 忘记默认用户密码的处理方法
- Oracle 11g 忘记用户密码的解决办法
- oracle 11g忘记sys用户密码
- Oracle 11g R2 忘记用户密码的解决办法
- 忘记了oracle 11g的system、sys用户密码,肿么办?
- WebLogic 11g默认用户密码
- Oracle忘记用户密码解决方案
- 忘记oracle 用户密码怎么办?
- Oracle 忘记sys用户密码
- 0423 oracle 忘记用户密码
- oracle用户密码忘记解决办法
- 忘记oracle用户密码,怎么办
- oracle 11g忘记密码
- oracle 11g 用户密码过期 解决办法
- 11g oracle 用户密码过期问题
- 11g oracle 用户密码过期问题
- VC和Python的互相调用
- New malloc的区别
- 通向架构师的道路(第五天)之tomcat集群-群猫乱舞
- Android 开机自启服务
- 杂记
- oracle 11g 忘记 默认用户密码
- like作连词&it作形式宾语
- C# 关于ConnectionString属性尚未初始化
- OpenGL: 缩放变换
- DM8168多核软件框架---之syslink
- AO开发SDE(一)
- 数据结构之双向链表的Java实现
- ubuntu vim 不能显示中文的解决方法
- iOS开发常用国外网站清单