故障现象：[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
本文出自 “麦地坞” 博客，美国空间，虚拟主机，请务必保留此出处
，香港虚拟主机