Chinaunix首页 | 论坛 | 博客
  • 博客访问: 245294
  • 博文数量: 8
  • 博客积分: 0
  • 博客等级: 民兵
  • 技术积分: 240
  • 用 户 组: 普通用户
  • 注册时间: 2014-05-13 08:39
个人简介

笨鸟要先飞

文章分类

全部博文(8)

文章存档

2015年(5)

2014年(3)

我的朋友

分类: Oracle

2015-03-20 14:34:42

答案很简单:修改密码!
1.首先使用操作系统方式认证登陆SYS账户,修改SYSTEM账户密码。

点击(此处)折叠或打开

  1. $ sqlplus / as sysdba
  2. SQL*Plus: Release 11.2.0.4.0 Production on Fri Mar 20 14:23:41 2015
  3. Copyright (c) 1982, 2013, Oracle. All rights reserved.
  4. Connected to:
  5. Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
  6. With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
  7. Data Mining and Real Application Testing options
  8. SQL> show user;
  9. USER is "SYS"
  10. SQL> alter user SYSTEM identified by "oracle123";
  11. User altered.

  12. SQL> exit
2.使用SQLPLUS远程登录方式登陆SYSTEM账户,修改SYS账户密码。

点击(此处)折叠或打开

  1. $ sqlplus SYSTEM@orcl
  2. SQL*Plus: Release 11.2.0.4.0 Production on Fri Mar 20 14:22:35 2015
  3. Copyright (c) 1982, 2013, Oracle. All rights reserved.
  4. Enter password:
  5. Connected to:
  6. Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
  7. With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
  8. Data Mining and Real Application Testing options
  9. SQL> show user;
  10. USER is "SYSTEM"
  11. SQL> alter user SYS identified by "Oracle123";
  12. User altered.
  13. SQL> exit
至此,大功告成,使用远程登录方式尽情登陆吧~
阅读(4500) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~