Home >Database >Mysql Tutorial > ORA-01031: insufficient privileges处理一例

ORA-01031: insufficient privileges处理一例

WBOY
WBOYOriginal
2016-06-07 17:41:161441browse

故障现象:[oracle@L-DB-100-17~]$sqlplus/assysdbaSQL*Plus:Release10.2.0.4.0-Productionon星期六1月514:59:152002Copyright(c)1982,2007,Oracle.AllRightsRes

故障现象:

[oracle@L-DB-100-17 ~]$ sqlplus / as sysdba 

SQL*Plus: Release 10.2.0.4.0 - Production on 星期六 1月 5 14:59:15 2002

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

 

ERROR:

ORA-01031: insufficient privileges

Enter user-name: 

ERROR:

ORA-01017: invalid username/password; logon denied

 

处理:更新密码文件

[oracle@L-DB-100-17 ~]$ cd /u01/product/10.2.0/db_1/dbs/

[oracle@L-DB-100-17 dbs]$ ls -lt

total 370172

-rw-r----- 1 oracle dba  10493952 Jan  6  2013 ICMLSNDX_01.dbf

-rw-r----- 1 oracle dba  15736832 Jan  6  2013 ICMSFQ04_01.dbf

-rw-r----- 1 oracle dba  31465472 Jan  6  2013 ICMLFQ32_01.dbf

-rw-r----- 1 oracle dba  26222592 Jan  6  2013 ICMLNF32_01.dbf

-rw-r----- 1 oracle dba  26222592 Jan  6  2013 ICMVFQ04_01.dbf

-rw-r----- 1 oracle dba      2560 Dec 14  2012 spfilezjport.ora

-rw-rw---- 1 oracle dba        24 May 28  2012 lkZJPORTUTF8

-rw-rw---- 1 oracle dba        24 May 28  2012 lkZJPORTUT

-rw-rw---- 1 oracle dba      1544 May 28  2012 hc_zjportutf8.dat

-rw-r----- 1 oracle dba      1536 Jan  5 14:59 orapwzjportutf8

-rw-r----- 1 oracle dba      1536 Jan  5 14:58 orapwzjport

-rw-r----- 1 oracle dba 268443648 Aug 20 07:21 cuteinfo_data.dbf

-rw-r----- 1 oracle dba      2560 May 27  2001 spfilezjportutf8.ora

-rw-rw---- 1 oracle dba      1552 May  5  2001 hc_zjport.dat

-rw-rw---- 1 oracle dba        24 May  4  2001 lkZJPORT

-rw-rw-r-- 1 oracle dba     12920 May  3  2001 initdw.ora

-rw-r----- 1 oracle dba      8385 Sep 11  1998 init.ora

[oracle@L-DB-100-17 dbs]$ mv orapwzjport orapwzjport_old

[oracle@L-DB-100-17 dbs]$ mv orapwzjportutf8 orapwzjportutf8_old

[oracle@L-DB-100-17 dbs]$ ls -lt

total 370172

-rw-r----- 1 oracle dba  10493952 Jan  6  2013 ICMLSNDX_01.dbf

-rw-r----- 1 oracle dba  15736832 Jan  6  2013 ICMSFQ04_01.dbf

-rw-r----- 1 oracle dba  31465472 Jan  6  2013 ICMLFQ32_01.dbf

-rw-r----- 1 oracle dba  26222592 Jan  6  2013 ICMLNF32_01.dbf

-rw-r----- 1 oracle dba  26222592 Jan  6  2013 ICMVFQ04_01.dbf

-rw-r----- 1 oracle dba      2560 Dec 14  2012 spfilezjport.ora

-rw-rw---- 1 oracle dba        24 May 28  2012 lkZJPORTUTF8

-rw-rw---- 1 oracle dba        24 May 28  2012 lkZJPORTUT

-rw-rw---- 1 oracle dba      1544 May 28  2012 hc_zjportutf8.dat

-rw-r----- 1 oracle dba      1536 Jan  5 14:59 orapwzjportutf8_old

-rw-r----- 1 oracle dba      1536 Jan  5 14:58 orapwzjport_old

-rw-r----- 1 oracle dba 268443648 Aug 20 07:21 cuteinfo_data.dbf

-rw-r----- 1 oracle dba      2560 May 27  2001 spfilezjportutf8.ora

-rw-rw---- 1 oracle dba      1552 May  5  2001 hc_zjport.dat

-rw-rw---- 1 oracle dba        24 May  4  2001 lkZJPORT

-rw-rw-r-- 1 oracle dba     12920 May  3  2001 initdw.ora

-rw-r----- 1 oracle dba      8385 Sep 11  1998 init.ora

[oracle@L-DB-100-17 dbs]$ orapwd file=/u01/product/10.2.0/db_1/dbs/orapwzjport force=y password=xq5m7n

[oracle@L-DB-100-17 dbs]$ orapwd file=/u01/product/10.2.0/db_1/dbs/orapwzjportutf8 force=y password=xq5m7n

[oracle@L-DB-100-17 dbs]$ ls -lt

total 370180

-rw-r----- 1 oracle dba  10493952 Jan  6  2013 ICMLSNDX_01.dbf

-rw-r----- 1 oracle dba  15736832 Jan  6  2013 ICMSFQ04_01.dbf

-rw-r----- 1 oracle dba  31465472 Jan  6  2013 ICMLFQ32_01.dbf

-rw-r----- 1 oracle dba  26222592 Jan  6  2013 ICMLNF32_01.dbf

-rw-r----- 1 oracle dba  26222592 Jan  6  2013 ICMVFQ04_01.dbf

-rw-r----- 1 oracle dba      2560 Dec 14  2012 spfilezjport.ora

-rw-rw---- 1 oracle dba        24 May 28  2012 lkZJPORTUTF8

-rw-rw---- 1 oracle dba        24 May 28  2012 lkZJPORTUT

-rw-rw---- 1 oracle dba      1544 May 28  2012 hc_zjportutf8.dat

-rw-r----- 1 oracle dba      1536 Jan  5 15:08 orapwzjportutf8

-rw-r----- 1 oracle dba      1536 Jan  5 15:08 orapwzjport

-rw-r----- 1 oracle dba      1536 Jan  5 14:59 orapwzjportutf8_old

-rw-r----- 1 oracle dba      1536 Jan  5 14:58 orapwzjport_old

-rw-r----- 1 oracle dba 268443648 Aug 20 07:21 cuteinfo_data.dbf

-rw-r----- 1 oracle dba      2560 May 27  2001 spfilezjportutf8.ora

-rw-rw---- 1 oracle dba      1552 May  5  2001 hc_zjport.dat

-rw-rw---- 1 oracle dba        24 May  4  2001 lkZJPORT

-rw-rw-r-- 1 oracle dba     12920 May  3  2001 initdw.ora

-rw-r----- 1 oracle dba      8385 Sep 11  1998 init.ora

 

[oracle@L-DB-100-17 dbs]$ sqlplus sys/oracle as sysdba

 

SQL*Plus: Release 10.2.0.4.0 - Production on 星期六 1月 5 15:09:27 2002

 

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

 

Connected to an idle instance.

 

SQL> startup;

ORACLE instance started.

 

Total System Global Area 1224736768 bytes

Fixed Size                  2083560 bytes

Variable Size             436208920 bytes

Database Buffers          771751936 bytes

Redo Buffers               14692352 bytes

Database mounted.

Database opened.

SQL> exit

 

本文出自 “麦地坞” 博客,美国空间,虚拟主机,请务必保留此出处

,香港虚拟主机
Statement:
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