An example of ORA-01031: insufficientprivileges Processing

Fault Phenomenon: [oracle @ L-DB-100-17 ~] $ SqlplusassysdbaSQL * Plus: Release10.2.0.4.0-Productionon Saturday January 5: 152002 Copyright (c) 1982,2007, Oracle. AllRightsRes

Fault Phenomenon: [oracle @ L-DB-100-17 ~] $ Sqlplus/assysdbaSQL * Plus: Release10.2.0.4.0-Productionon Saturday January 5: 152002 Copyright (c) 1982,2007, Oracle. AllRightsRes

Fault symptom:

[Oracle @ L-DB-100-17 ~] $ Sqlplus/as sysdba

SQL * Plus: Release 10.2.0.4.0-Production on Saturday January 5 14:59:15 2002

Copyright (c) 1982,200 7, Oracle. All Rights Reserved.

ERROR:

ORA-01031: insufficient privileges

Enter user-name:

ERROR:

ORA-01017: invalid username/password; logon denied

Processing: update the password file

[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 ---- 1 oracle dba 24 May 28 2012 lkZJPORTUTF8

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

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

-Rw-r ----- 1 oracle dba 1536 Jan 5 orapwzjportutf8

-Rw-r ----- 1 oracle dba 1536 Jan 5 orapwzjport

-Rw-r ----- 1 oracle dba 268443648 Aug 20 cuteinfo_data.dbf

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

-Rw ---- 1 oracle DBAs 1552 May 5 2001 hc_zjport.dat

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

-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 ---- 1 oracle dba 24 May 28 2012 lkZJPORTUTF8

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

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

-Rw-r ----- 1 oracle dba 1536 Jan 5 orapwzjportutf8_old

-Rw-r ----- 1 oracle dba 1536 Jan 5 orapwzjport_old

-Rw-r ----- 1 oracle dba 268443648 Aug 20 cuteinfo_data.dbf

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

-Rw ---- 1 oracle DBAs 1552 May 5 2001 hc_zjport.dat

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

-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 ---- 1 oracle dba 24 May 28 2012 lkZJPORTUTF8

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

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

-Rw-r ----- 1 oracle dba 1536 Jan 5 orapwzjportutf8

-Rw-r ----- 1 oracle dba 1536 Jan 5 orapwzjport

-Rw-r ----- 1 oracle dba 1536 Jan 5 orapwzjportutf8_old

-Rw-r ----- 1 oracle dba 1536 Jan 5 orapwzjport_old

-Rw-r ----- 1 oracle dba 268443648 Aug 20 cuteinfo_data.dbf

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

-Rw ---- 1 oracle DBAs 1552 May 5 2001 hc_zjport.dat

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

-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 Saturday January 5 15:09:27 2002

Copyright (c) 1982,200 7, 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

This article is from the "docker" blog, USA space, and virtual host. Please keep this source

, Hong Kong VM