|
admin
发表于 2014-7-20 12:28:10
Solution w1 W$ b' Q8 D4 D* P: z
# ^9 L7 j: g Y/ j5 {8 Q3 k% z7 y5 P) RThis is due to the Oracle Password having expired and needs to be reset.
' r6 \/ T; A8 b5 x5 o3 D* p. V! O
Perform the following in a OS CMD window making the necessary changes for your
, a# ]4 Q6 s' ]( k) renvironment and directory structure.1 R% K- g3 d% ~0 R+ `
6 j) y: M* O& ~0 W) h$ l1 C- w
--0 S) [* ]1 U6 Y6 k8 ^
set oracle_home=C:\Oracle\product\11.2.0\dbhome_15 O9 [1 i0 [# f" k8 w
3 Z( C; s9 t) z; x
set oracle_sid=tc
6 e( h* {" M5 P$ X( F% x: ^/ y$ Q# m) ~, F
%oracle_home%\bin\sqlplus /nolog! c( m9 S' i( ~$ D
6 C4 x% B) d9 b9 j
connect / as sysdba
' G" I$ O0 v2 n! u1 M
) e* V2 _/ q5 x' h0 `; C @2 W+ Qalter user infodba identified by infodba;
) |; X0 u5 t1 `3 I
: ]' `, M' i" U: A+ |9 t5 A0 Z9 ^select expiry_date from dba_users where username='INFODBA';. P) v- V# D9 o" y( n
5 o, e- I% W( x) G5 E2 Fselect profile from dba_users where username='INFODBA';4 G, _3 @1 p3 K
1 ?% J! m+ ]% T) M
alter profile default limit password_life_time unlimited;* o: D0 d. w) I; S0 P
% U2 H. s( n, M
select expiry_date from dba_users where username='INFODBA';
! ]) Q$ Y0 e; P b; \--) A4 H! z6 Y3 G# Z5 @+ N
( A' D( I% a3 w. c" y& u* z4 v7 v, G
Expected output in command window." }# o9 r- N9 c
==
: g% Q/ f( d# `C:\Users\<user id>>set oracle_home=C:\Oracle\product\11.2.0\dbhome_1
( X4 i. @& w. @
6 O1 T+ ?4 ]- N! z- @C:\Users\<user id>>
7 t* }( l% G5 \* |+ nC:\Users\<user id>>set oracle_sid=tc! B% Y3 Q& S/ [3 B8 D" d. S
2 s2 I# T/ f" i# O( P. |C:\Users\<user id>>
* D4 v4 ]3 U4 u) `9 ?C:\Users\<user id>>%oracle_home%\bin\sqlplus /nolog1 V+ P: w8 K+ \) o- s; q+ j
7 e' B" w; s ^
SQL*Plus: Release 11.2.0.1.0 Production on Tue Dec 3 17:25:43 2013- G6 `! P) @, d
9 I- F3 t9 q5 A4 g% q/ QCopyright (c) 1982, 2010, Oracle. All rights reserved.' h( h& \1 x/ u' H7 U
& j4 i; g& k/ j8 i9 ]6 S. u
SQL> F2 m4 X g q! Z( F3 U
SQL> connect / as sysdba
! w9 J) d! X' }* B/ nConnected.
2 h& ?, ~+ c' o% U8 X6 n( _: r. Z bSQL>
. A1 k" f- e+ \/ H& _# VSQL> alter user infodba identified by infodba;0 F9 c2 v0 D! F' J W
9 _9 w5 I8 K1 g! }7 |
User altered.
) D4 F c- l9 B( \2 g7 S0 ^' I7 ~7 g1 x2 s" O/ r: ?1 T
SQL>
0 a* F0 {) C) t, J7 N+ }6 mSQL> select expiry_date from dba_users where username='INFODBA';3 A8 s: u" V; k4 Q2 }; A; N
8 c) [# m9 E* V# j
EXPIRY_DA4 C! T7 n1 _- K2 V- J
---------
% U: H4 m' }. i5 d9 T& D, J" k01-JUN-14$ l% ~, V" L# M9 r
% ]2 y+ W) X% {" t& B3 ISQL>
& r* `# }" j& o1 ~) k6 dSQL> select profile from dba_users where username='INFODBA';
+ L) P( s/ H @/ K7 A0 d8 G. {) A6 x w: O. Q; @2 n/ r# j
PROFILE$ k& W: L/ p2 D: T( _4 F
------------------------------
- U# G J7 u( X# u/ p/ t3 ODEFAULT, T, D2 N0 D7 Q" _
a. R" p9 ]9 z4 \- I$ w$ Q) L( e! n" OSQL>
2 a8 c/ w+ v& f. p; ^, b6 i5 uSQL> alter profile default limit password_life_time unlimited;
% J1 q% Q0 V/ R" K7 \/ I6 b0 l; O. n3 `
Profile altered.# _2 h0 i" D$ X, G" J
- Y+ b( w9 K6 e7 |% f6 V- t7 JSQL>
$ e3 g: l+ r6 f( X0 uSQL> select expiry_date from dba_users where username='INFODBA';
$ S- W3 z1 I% \9 p) V) E
: J2 g- E5 @" j0 T. n$ y% `) \; QEXPIRY_DA3 M9 @" S$ M7 d7 A& Y# n! S6 E
---------
5 m; c1 D+ }2 {5 K5 E5 V) K" j U+ n. y* k
SQL>
, c: |) Y2 n1 [1 G0 w7 K7 @SQL>6 j+ Z* \$ N4 ~7 y* C, K
6 _! s1 p- |% ~9 r' i" `) V& j) B0 y* W9 b% l! ]$ C
|
|