ORACLE 忘记数据库密码
来源:互联网 发布:center os 安装软件 编辑:程序博客网 时间:2024/05/04 09:34
对于oracle10g来说:
1.如果不记得sys用户的密码了,采用如下方法可以修改密码:
(1)打开cmd,输入sqlplus /nolog,回车。
(2)输入“conn / as sysdba”;
(3)输入“alter user sys identified by 新密码;”(新密码必须以字母开头,另外每条SQL语句后得分号不能忘)
其他用户方式同理
(1)打开cmd,输入sqlplus /nolog,回车。
(2)输入“conn / as sysdba”;
(3)输入“alter user sys identified by 新密码;”(新密码必须以字母开头,另外每条SQL语句后得分号不能忘)
其他用户方式同理
2.(1)在cmd中启动sqlplus;
附: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.
0 0
- Oracle数据库忘记密码
- oracle数据库密码忘记
- ORACLE 忘记数据库密码
- oracle 数据库忘记密码怎么办
- Oracle数据库 忘记管理员密码
- 数据库杂记:oracle忘记密码
- 密码忘记,修改oracle数据库密码
- oracle数据库忘记sys和system密码
- 忘记Oracle数据库管理员密码的解决办法
- Oracle数据库system用户忘记了密码
- Oracle 数据库忘记系统管理员密码解决方法
- 登录oracle数据库时,密码忘记怎么办?
- oracle 数据库忘记密码怎么做
- ORACLE数据库密码忘记了的解决方法
- oracle数据库管理员密码忘记怎么办
- 忘记Oracle数据库管理员密码的解决办法
- oracle数据库system密码忘记怎么办?
- 忘记Oracle数据库管理员密码的解决办法
- Oracle 字符集的查看和修改【下】
- Oracle安装错误ora-00922(缺少或无效选项)
- Cognos应用访问模式
- javascript引用类型之Date类型
- oracle导入数据时出现字段过长
- ORACLE 忘记数据库密码
- UVa 10494 - If We Were a Child Again
- Oracle的锁表与解锁
- 设置ORACLE客户端字符集
- 编程回忆之Android回忆(蓝牙BluetoothAdapter的搜索和连接)
- 有关 ORA-00604 错误的总结
- 【DBA之路】关于连接不上数据库
- ORACLE配置非默认位置的监听程序
- 问题解决方法