|
admin
发表于 2014-7-20 12:28:10
Solution+ w7 y) p/ V5 C4 P) w" `
. _/ t/ f# m* hThis is due to the Oracle Password having expired and needs to be reset.
" H0 g/ \* G" E- C" Z+ K# d& [& t% U2 ]7 @( z
Perform the following in a OS CMD window making the necessary changes for your' v3 u6 F" q+ G
environment and directory structure.
5 w, U( c) P- l4 q
4 g9 k# P- t8 _1 i( |--
; G' o& ], d* Z$ u% Vset oracle_home=C:\Oracle\product\11.2.0\dbhome_1
9 W5 U* }8 b' K8 E/ _8 P1 J& h/ q1 [/ \9 a0 m: |5 h
set oracle_sid=tc% o9 }8 x5 O/ |2 U% e
% M6 f. y1 x6 |# E9 y) k {/ }$ T
%oracle_home%\bin\sqlplus /nolog
4 K% L. d) P( b9 b% I9 n Y
; K. v! Y4 E$ }0 j; ?6 Mconnect / as sysdba) g9 J+ \% |$ B7 U& {
0 o( l' }+ y1 |8 K4 g0 }* V0 t3 L9 Aalter user infodba identified by infodba;
& B2 A6 Y C& K) g E, T3 t' O5 n* S. ] S+ m
select expiry_date from dba_users where username='INFODBA';
+ d) J0 K- w) M5 g
8 z/ F% d* S1 [- ?select profile from dba_users where username='INFODBA';
3 X% e. s9 W8 ? K: l! X
: L6 h; I/ D! v' \+ {6 ?alter profile default limit password_life_time unlimited;
0 u% h9 T' L4 \, S
: g6 z9 V- [( u4 P. s3 @select expiry_date from dba_users where username='INFODBA';$ P5 {( y' d0 z. H4 D
--! O5 e6 f6 p8 D& h7 P9 K) o
+ B4 E. }4 p) m7 Y
Expected output in command window.
# A' K* M# L4 E$ \+ l! ?, h==5 `" b* S; e' c- k' u: N
C:\Users\<user id>>set oracle_home=C:\Oracle\product\11.2.0\dbhome_1% N) _# L- e) ]! |
5 L1 N$ S* P- g- MC:\Users\<user id>>
0 e- R# `( b4 m, D' ]5 F, ^& Q' RC:\Users\<user id>>set oracle_sid=tc
2 F |4 v- H, b$ b8 s& [; _& J# h2 r. s5 ?) l7 C
C:\Users\<user id>>
" U7 j" W4 ?6 iC:\Users\<user id>>%oracle_home%\bin\sqlplus /nolog
' S4 Y" D7 I) o4 o& E4 D8 A5 {: x2 Q8 y: a) B
SQL*Plus: Release 11.2.0.1.0 Production on Tue Dec 3 17:25:43 2013
6 D2 i% R6 D, O! ?3 `* ?
y7 Q3 G- G# O* K& {9 {Copyright (c) 1982, 2010, Oracle. All rights reserved.
9 Y. G4 W$ F$ f5 B+ o* L @' O0 y. X* U1 ^5 {& N1 w+ c# C7 b; ^, R) h# l
SQL>
* p, v; m& u$ x, z: K; ySQL> connect / as sysdba$ R- L5 H. l! n8 `, Z% ?
Connected., o4 r- ~* A5 g5 }7 B- h
SQL> q8 J8 m: E, t8 x. }; o! f- D
SQL> alter user infodba identified by infodba;
* o4 a9 c: w9 p5 W: v2 z3 y8 ?! y: g7 `
User altered.6 b6 M& H6 c: N) K$ H! l* z
, W: Q6 c o3 {+ R6 u0 E! O. a, U
SQL>( L( A' D' R$ }$ q
SQL> select expiry_date from dba_users where username='INFODBA';0 a6 w1 s+ ?& u
. B0 p4 [+ r% H9 l- WEXPIRY_DA2 H, x- r+ {1 C" A
---------
# a' B1 B4 ?8 Y- V* G" G) P01-JUN-14( t* J0 ~* {% P4 T( L2 ~
7 I- ?, i# V( Z( }7 S: b
SQL> k ?/ w" e( g
SQL> select profile from dba_users where username='INFODBA';
3 S9 D: l2 E# H- f- J* }3 v/ N( A4 l! N3 X/ ?# }* z3 T
PROFILE
9 o# p% N0 s# N& P5 u4 q- B" k------------------------------
! Y5 @% j$ J% C/ d8 m M8 y2 C' c' ~DEFAULT# j- G; C1 C3 x3 @5 V0 G
- s; z" Q! q9 |- j
SQL>2 b% q% O* H0 Z5 a0 X/ |+ M, Y
SQL> alter profile default limit password_life_time unlimited;3 D0 j; X, J1 f! C4 d' H
1 t9 O1 Z1 i3 y% S
Profile altered.- @% h* K% k9 X j" w: |
/ l( ?# h6 a1 M7 t1 R5 w9 h/ s0 gSQL>
. u7 K( h; ^! ~" [* [, VSQL> select expiry_date from dba_users where username='INFODBA';9 N$ v2 l" v% K& _
% A) O& a7 e5 c! [' ]EXPIRY_DA' @5 a5 C& o+ N
---------
7 G0 Z& Y- q0 T# O
# g; A: |* f' Z) D+ S+ dSQL>
" T/ u% f* i y" N, W3 aSQL>+ @. W3 [8 H8 J H$ P
3 A' O1 |$ M$ g; k5 t
1 u9 a$ m ?" C% N3 I |
|