|
|
楼主 |
发表于 2014-7-20 12:28:10
|
显示全部楼层
Solution0 h. d( t! N( Q: E8 [7 c
6 J' h" J% C* q( H- O9 m' \This is due to the Oracle Password having expired and needs to be reset.
+ U4 D0 W; e3 t
' `& s0 W7 J, V. ~1 K9 HPerform the following in a OS CMD window making the necessary changes for your
$ m* C) p1 ^: ^" N, Y9 }environment and directory structure.3 n' [/ m2 e8 O+ F0 G3 l5 G4 M
9 s& u2 |! i6 \$ `8 \
--
) F0 Q/ N5 P' I$ [. |9 eset oracle_home=C:\Oracle\product\11.2.0\dbhome_1
& @# r# v9 J* k2 P" w0 A5 F" W! p$ A2 E; M- A
set oracle_sid=tc. R. |6 [. [- S6 X$ M/ P/ x; u
8 r/ a1 b2 e/ x# ?! O! f%oracle_home%\bin\sqlplus /nolog
( N u" i, Q0 r( |8 ]3 c4 v* R8 H
connect / as sysdba
* s: k5 X5 A1 f9 F- o2 b) A* E; ]5 s& e" a1 d
alter user infodba identified by infodba;
6 o& e6 X# L o$ g9 D% E$ A) _+ ?
select expiry_date from dba_users where username='INFODBA';
% V) X9 ]/ q2 Z) Y
2 U0 z. R) z! @# s G" Lselect profile from dba_users where username='INFODBA';" s: c3 B1 K* R$ ]+ g$ p! Z
0 P) |5 C) p5 T, X5 V* {1 T
alter profile default limit password_life_time unlimited;
2 m+ T& c3 q9 J$ _, r0 c) D# b
, l3 X& B; t7 X( y3 qselect expiry_date from dba_users where username='INFODBA';
8 w1 x0 X( s- A6 Y--* |. q& ?" o) {$ Z. J0 g
- i0 f5 P1 L% Q
Expected output in command window.4 b; A% g! w! R8 U7 s
==% s' V3 x& H' q' s
C:\Users\<user id>>set oracle_home=C:\Oracle\product\11.2.0\dbhome_1* t: c2 y# D7 A& P- g, w5 ]
9 a5 G% ]- I0 R
C:\Users\<user id>>
i0 l ^6 p3 W) V' {/ \; TC:\Users\<user id>>set oracle_sid=tc& c* V$ Y7 H7 `2 _" y6 i
' L; w6 A" v5 }) j% d* v
C:\Users\<user id>>
2 j9 Y0 ]$ w8 XC:\Users\<user id>>%oracle_home%\bin\sqlplus /nolog J8 C% S+ a( Z! F
2 s6 _5 T, j0 v j3 O7 k( ` \8 PSQL*Plus: Release 11.2.0.1.0 Production on Tue Dec 3 17:25:43 2013
$ F" c: q9 T; w! R, _3 v4 i0 j( ], t
Copyright (c) 1982, 2010, Oracle. All rights reserved.
& B: F8 u( q9 z: t/ w) R- ^. S" R9 J4 G$ ?4 c3 D
SQL>
2 z4 p) k" {* E& i" a# u7 CSQL> connect / as sysdba& ?5 Y$ s+ {5 K7 [
Connected.
' `" d0 {5 M9 J* U; G6 uSQL>
: g% \1 g8 [! ?SQL> alter user infodba identified by infodba;
1 r9 D. k( p1 V) x n6 j& I3 W1 x' N
User altered.
1 ~2 U: }$ z- j" @, t4 T$ g2 D. d% J
1 H: r: q+ n( JSQL>! Q: e9 P* Y2 [$ l( Y* T
SQL> select expiry_date from dba_users where username='INFODBA';
: M3 p7 K# [* p) e9 X
) L( X, Y; I7 h- S$ Z, b2 QEXPIRY_DA
, O0 Y0 p+ ^" z---------/ m& O6 W+ b H
01-JUN-14
2 ]6 @& S: P7 T4 u! {% C2 y6 O; C9 L6 w; v# ?- Y) M7 X
SQL>
2 T% g. i) e" FSQL> select profile from dba_users where username='INFODBA';
6 B! ?: g1 B, _
6 m! K% y: S# |/ t& hPROFILE) @/ ^+ P- ]5 U( _3 z8 D' w
------------------------------! |4 O* X8 |0 b+ r+ Y, w* P3 t
DEFAULT0 h/ e+ W6 j, v8 f4 s8 ?
& C/ F, P7 M# K! M6 B& K
SQL>! z1 W4 G. v3 o2 t2 ? {1 D
SQL> alter profile default limit password_life_time unlimited;% X# p$ k8 S) }- x1 F! {! [
3 b( l* X, H; ~/ t
Profile altered.( y2 S& |, ?: w5 m- u- o7 Y, q
3 x' B- |- O3 Z" u
SQL>
& Y( ~3 H3 R* u( j& p: ^SQL> select expiry_date from dba_users where username='INFODBA';
# g$ b: U. O0 Y
8 F* m0 B; y- I( p0 r9 rEXPIRY_DA: ~ ~4 c: E. u: v0 F
---------% o8 T: Q/ l6 P) J
+ h3 f1 N0 N! L' a: A
SQL>
; L k4 q9 _( { `) |$ LSQL>
# U* o) E ^& c, j& W" n L: f4 A% c4 F
9 R0 r& X. B* l5 T. O3 G |
|