Home > Database > Mysql Tutorial > Oracle 11g sys,system 密码忘记设置解决办法

Oracle 11g sys,system 密码忘记设置解决办法

WBOY
Release: 2016-06-07 15:26:59
Original
1190 people have browsed it

1.启动sqlplus 2.请输入用户名: sqlplus/as sysdba 3.输入口令:直接回车 4.连接到: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL alter us

1.启动sqlplus

2.请输入用户名:  sqlplus/as sysdba

3.输入口令: 直接回车

4.连接到:

   Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production

   With the Partitioning, OLAP, Data Mining and Real Application Testing options

   SQL>alter user sys identified by admin;

  用户已更改。

 

  SQL> conn sys/admin as sysdba;
  已连接。

  SQL> alter user system identified by manager;

 

  用户已更改。

  就搞定啦!

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template