SQL> grant sysdba to user01;
grant sysdba to user01
*
ERROR at line 1:
ORA-01994: GRANT failed: password file missing or disabled
SQL> show parameter passNAME TYPE VALUE
------------------------------------ ----------- ------------------------------
remote_login_passwordfile string EXCLUSIVE
SQL> !
[oracle@soso ~]$ cd /opt/oracle/102/dbs
[oracle@soso dbs]$ ls -l *
-rw-r----- 1 oracle dba 1544 Jul 14 19:10 hc_orcl.dat
-rw-rw---- 1 oracle dba 1544 Jul 14 19:25 hc_ORCL.dat
-rw-r----- 1 oracle dba 12920 May 3 2001 initdw.ora
-rw-r----- 1 oracle dba 8385 Sep 11 1998 init.ora
-rw-r----- 1 oracle dba 808 Jul 14 20:52 initORCL.ora
-rw-rw---- 1 oracle dba 24 Jul 14 20:02 lkORCL
-rw-r----- 1 oracle dba 1536 Jul 14 19:13 orapworcl
-rw-r----- 1 oracle dba 2560 Jul 14 19:13 spfileorcl.ora
-rw-r----- 1 oracle dba 2560 Jul 14 21:04 spfileORCL.ora
[oracle@soso dbs]$ mv orapworcl orapworcl.bak
[oracle@soso dbs]$ orapwd file='/opt/oracle/102/dbs/orapworcl' password='oracle' entries=10 force=y
[oracle@soso dbs]$ ls -l *
-rw-r----- 1 oracle dba 1544 Jul 14 19:10 hc_orcl.dat
-rw-rw---- 1 oracle dba 1544 Jul 14 19:25 hc_ORCL.dat
-rw-r----- 1 oracle dba 12920 May 3 2001 initdw.ora
-rw-r----- 1 oracle dba 8385 Sep 11 1998 init.ora
-rw-r----- 1 oracle dba 808 Jul 14 20:52 initORCL.ora
-rw-rw---- 1 oracle dba 24 Jul 14 20:02 lkORCL
-rw-r----- 1 oracle dba 2560 Jul 14 21:07 orapworcl
-rw-r----- 1 oracle dba 1536 Jul 14 19:13 orapworcl.bak
-rw-r----- 1 oracle dba 2560 Jul 14 19:13 spfileorcl.ora
-rw-r----- 1 oracle dba 2560 Jul 14 21:04 spfileORCL.ora
[oracle@soso dbs]$ exit
exitSQL> grant sysdba to user01;
grant sysdba to user01
*
ERROR at line 1:
ORA-01994: GRANT failed: password file missing or disabled
SQL> 重要:系统曾非法关机,再次启动数据库时,报找不到initORCL.ora,
没办法拷了一个,还报过无法将数据库mount到EXCLUSIVE状态下,
怎么解决的也忘了,大致就是这个意思具体报错信息没保存。
上网查了都说是remote_login_passwordfile参数或passwordfile的问题,我都照着做了还是不行。
求大侠帮忙看看。
grant sysdba to user01
*
ERROR at line 1:
ORA-01994: GRANT failed: password file missing or disabled
SQL> show parameter passNAME TYPE VALUE
------------------------------------ ----------- ------------------------------
remote_login_passwordfile string EXCLUSIVE
SQL> !
[oracle@soso ~]$ cd /opt/oracle/102/dbs
[oracle@soso dbs]$ ls -l *
-rw-r----- 1 oracle dba 1544 Jul 14 19:10 hc_orcl.dat
-rw-rw---- 1 oracle dba 1544 Jul 14 19:25 hc_ORCL.dat
-rw-r----- 1 oracle dba 12920 May 3 2001 initdw.ora
-rw-r----- 1 oracle dba 8385 Sep 11 1998 init.ora
-rw-r----- 1 oracle dba 808 Jul 14 20:52 initORCL.ora
-rw-rw---- 1 oracle dba 24 Jul 14 20:02 lkORCL
-rw-r----- 1 oracle dba 1536 Jul 14 19:13 orapworcl
-rw-r----- 1 oracle dba 2560 Jul 14 19:13 spfileorcl.ora
-rw-r----- 1 oracle dba 2560 Jul 14 21:04 spfileORCL.ora
[oracle@soso dbs]$ mv orapworcl orapworcl.bak
[oracle@soso dbs]$ orapwd file='/opt/oracle/102/dbs/orapworcl' password='oracle' entries=10 force=y
[oracle@soso dbs]$ ls -l *
-rw-r----- 1 oracle dba 1544 Jul 14 19:10 hc_orcl.dat
-rw-rw---- 1 oracle dba 1544 Jul 14 19:25 hc_ORCL.dat
-rw-r----- 1 oracle dba 12920 May 3 2001 initdw.ora
-rw-r----- 1 oracle dba 8385 Sep 11 1998 init.ora
-rw-r----- 1 oracle dba 808 Jul 14 20:52 initORCL.ora
-rw-rw---- 1 oracle dba 24 Jul 14 20:02 lkORCL
-rw-r----- 1 oracle dba 2560 Jul 14 21:07 orapworcl
-rw-r----- 1 oracle dba 1536 Jul 14 19:13 orapworcl.bak
-rw-r----- 1 oracle dba 2560 Jul 14 19:13 spfileorcl.ora
-rw-r----- 1 oracle dba 2560 Jul 14 21:04 spfileORCL.ora
[oracle@soso dbs]$ exit
exitSQL> grant sysdba to user01;
grant sysdba to user01
*
ERROR at line 1:
ORA-01994: GRANT failed: password file missing or disabled
SQL> 重要:系统曾非法关机,再次启动数据库时,报找不到initORCL.ora,
没办法拷了一个,还报过无法将数据库mount到EXCLUSIVE状态下,
怎么解决的也忘了,大致就是这个意思具体报错信息没保存。
上网查了都说是remote_login_passwordfile参数或passwordfile的问题,我都照着做了还是不行。
求大侠帮忙看看。
不是sysdba
不是sysdba