以sys用户进入oracle， sql grant sysdba to username; grant sysdba to username * error at line 1: ora-01994: grant failed: password file missing or disabled 首先，把初始化参数remote_login_passwordfile的值改成exclusive 如果还是有问题，可能是缺
以sys用户进入oracle，
sql> grant sysdba to username;
grant sysdba to username
*
error at line 1:
ora-01994: grant failed: password file missing or disabled
首先，把初始化参数remote_login_passwordfile的值改成exclusive
如果还是有问题，可能是缺少密码文件，用orapwd创建密码文件
$ orapwd -h
usage: orapwd file= password= entries=
where
file - name of password file (mand),
password - password for sys (mand),
entries - maximum number of distinct dba and opers (opt),
there are no spaces around the equal-to (=) character.
这个命令很简单，密码文件一般放在$oracle_home/dbs目录下，命名规则为orapd+sid,
orapwd file='/db/oracle/product/10.2.0/db_1/dbs/orapw+sid'  password=oracle   entries=5  force=y
然后再执行
sql> grant sysdba to username;
grant succeeded.
检查
sql> select * from v$pwfile_users;
username                       sysdb sysop
------------------------------ ----- -----
sys                            true  true
******                          true  false
sysdb那一栏是true就对了
然后就可以as sysdba连接了