sys用户，密码文件dba权限的关系

oracle@ywdb ~]$ sqlplus /as sysdba SQL*Plus: Release 11.1.0.7.0 - Production on Tue Apr 29 15:40:38 2014 Copyright (c) 1982, 2008, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit

oracle@ywdb ~]$ sqlplus "/as sysdba"

SQL*Plus: Release 11.1.0.7.0 - Production on Tue Apr 29 15:40:38 2014

Copyright (c) 1982, 2008, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> alter user sys identified by oracle
  2  ;

User altered.

SQL> alter user sys identified by oracle;

User altered.

SQL> alter user sys identified by manager;

User altered.

SQL> grant sysdba to system;
grant sysdba to system
*
ERROR at line 1:
ORA-01994: GRANT failed: password file missing or disabled

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
You have new mail in /var/spool/mail/oracle
[oracle@ywdb ~]$ orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID password='manager' entries=10
[oracle@ywdb ~]$ sqlplus "/as sysdba"

SQL*Plus: Release 11.1.0.7.0 - Production on Tue Apr 29 15:49:03 2014

Copyright (c) 1982, 2008, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>  grant sysdba to system;

Grant succeeded.

SQL>

system用户没有dba权限的。

但是想授予他权限的话，

那么必须添加一个密码文件。

易森网络企业版

如果您是新用户，请直接将本程序的所有文件上传在任一文件夹下，Rewrite 目录下放置了伪静态规则和筛选器，可将规则添加进IIS，即可正常使用，不用进行任何设置；(可修改图片等)默认的管理员用户名、密码和验证码都是：yeesen系统默认关闭，请上传后登陆后台点击“核心管理”里操作如下:进入“配置管理”中的&ld

0

查看详情

然后才能授予。