oracle 11g 密码过期|修改密码
来源:互联网 发布:咫尺网络西安 编辑:程序博客网 时间:2024/04/29 14:58
oracle默认密码有效期为180天,所以要定时修改或者直接设置为不限制时间
首先启动sqlplus
输入用户名:sqlplus / as sysdba密码空缺
查看密码生存周期:
select * from dba_profiles where profile='DEFAULT' and resource_name='PASSWORD_LIFE_TIME';
修改为不限制并提交修改:
alter profile default limit password_life_time unlimited;
commit;
再次查看是否修改成功,显示为unlimited即可。
修改完成后过期的密码仍需要修改。
如果用户被锁定,记得加上SQL> alter user dbsnmp account unlock;
User altered.
然后修改密码
SQL> alter user dbsnmp identified by dbsnmp;
User altered.
现在就可以用用户名:dbsnmp 密码:dbsnmp登录了。
附oracle默认用户名/密码表
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
- oracle 11g 密码过期|修改密码
- Oracle 11g密码过期
- oracle 11g 密码 过期
- oracle 11g 密码过期
- Oracle 11g密码过期
- Oracle 11G密码过期后修改方法
- 修改Oracle 11g账户密码过期时间
- Oracle 11G密码过期后修改方法
- 修改oracle 密码过期
- Oracle密码过期修改
- Oracle 11g存在密码过期问题
- oracle 11g密码永不过期
- Oracle 11g存在密码过期问题
- Oracle 11g存在密码过期问题
- Oracle 11g存在密码过期问题
- Oracle 11g存在密码过期问题
- Oracle 11g存在密码过期问题
- Oracle 11g密码过期问题
- 单播、多播和广播
- LDR_MODULE结构的详细定义
- hdu(5360)——Hiking
- UVa 503 - Parallelepiped walk
- 使用Jmeter测试web应用
- oracle 11g 密码过期|修改密码
- scala Case Class和模式匹配(1):简单的示例
- [层次结构|树状结构] oracle中用start with...connect by prior子句实现递归查询
- Android之安全机制
- MyEclipse注册
- 微信语音输入不仅仅是懒癌患者的福音
- 文章标题
- 详解Objective-C中委托和协议
- 表格视图UITableView