|
admin
发表于 2014-7-20 12:28:10
Solution/ i$ e0 Y- C6 k8 }0 k. _
4 W- u" O9 V" h; `% O+ k( GThis is due to the Oracle Password having expired and needs to be reset.5 K% F5 N/ l% O1 n$ E7 e6 T
% o0 }6 `6 D3 Z0 @0 W* fPerform the following in a OS CMD window making the necessary changes for your' h- `: H4 [# X: p6 B) G& E
environment and directory structure.
' G9 Q6 D2 @& ~
: \! m0 W/ E( ?) N0 u+ u! q--$ {- m3 ~1 w4 O/ c- x) x
set oracle_home=C:\Oracle\product\11.2.0\dbhome_1
" V! B' {" R# _! {9 |$ @; G
6 U3 Q+ i$ R: d1 M3 n- yset oracle_sid=tc3 s+ p8 G T9 o+ x
3 G: T. k7 J. ?' O2 J" L
%oracle_home%\bin\sqlplus /nolog
% \6 n+ I% H" A, D2 l8 x, ^" [( y* W6 U+ E1 T) x
connect / as sysdba, w. e$ K- r, b0 ]$ T# @
( x& R# @( c j# F, ?alter user infodba identified by infodba;
A0 Q) I! d1 T2 H/ ~
% R1 L- {: m% e1 C6 E$ \select expiry_date from dba_users where username='INFODBA';, _9 ^6 S. z" G0 f0 ~- V/ Z4 w
" ?! L1 Q2 V9 ?4 Zselect profile from dba_users where username='INFODBA';
: z* o! d& t) O9 X: Q Z
/ M* e9 F& k- _( f8 j7 G1 `alter profile default limit password_life_time unlimited;4 W. _0 u# [$ a4 M
- J! _5 s" o& O, B5 m' f1 M. w1 F' tselect expiry_date from dba_users where username='INFODBA';' g% S8 B) j9 s) v* V! M! S. C* n2 i
--" T7 T/ r8 U& u& I" e% D; e0 _
9 P, W6 T2 y1 n5 ^+ e' ?! QExpected output in command window." ]' K: O1 i7 Y. h3 [: X. f
==
* _% P. T2 x# X6 ~2 I( K9 W5 WC:\Users\<user id>>set oracle_home=C:\Oracle\product\11.2.0\dbhome_1
: P6 L" o# M+ U7 N$ Q
+ B& W4 Z8 o) M7 j9 MC:\Users\<user id>>
6 f* F3 ]. c$ w; {% C- DC:\Users\<user id>>set oracle_sid=tc
% ?, j, |* t& o9 @) u/ O+ B j4 v' l# h, V$ ]
C:\Users\<user id>>. ]7 c, }6 O6 w, c; c$ Q+ i; ^! W
C:\Users\<user id>>%oracle_home%\bin\sqlplus /nolog
2 X- B9 _7 I- W x, h+ d
, @5 h; Z2 M8 Y$ |SQL*Plus: Release 11.2.0.1.0 Production on Tue Dec 3 17:25:43 20135 p, I1 }6 \4 g; w, I
5 |+ B8 r% |8 h) \
Copyright (c) 1982, 2010, Oracle. All rights reserved./ ]- U; D- |5 Z5 i8 J
0 Y& X+ l9 o# K0 U) a) e) b
SQL>
+ x" ]5 e, c9 W* Z' CSQL> connect / as sysdba
" `& [4 Q, I6 M) {# C3 ?Connected.
) l+ D; l% F! X' B6 c G/ w; nSQL>/ y! }& M, Y! h+ b
SQL> alter user infodba identified by infodba;
5 C" j2 V+ U7 M8 j o6 f0 w0 L. G, x6 n$ g4 k; Y
User altered.8 @* {# A8 ~* Q! t8 g1 K$ r
0 e4 e3 K3 c- H$ P7 f7 WSQL>
) _& g! F3 Q( }- \7 G" E. pSQL> select expiry_date from dba_users where username='INFODBA';
( |% s7 U. E; S0 |2 s+ z& b( @) N. s: i
EXPIRY_DA
; M5 j, P1 P* z3 W N( ~4 A8 q3 z0 W---------
3 n% b( a- V( t8 J0 A' v01-JUN-14% j. v& a5 ~3 _$ t
2 Z. {6 M9 X% d& t9 USQL>, `! M- J. |' ?: R1 G% ?7 a
SQL> select profile from dba_users where username='INFODBA';
5 y. W& u$ q6 ^% E& n- P
2 a, w7 B$ m6 W0 mPROFILE1 z: G& }; v% S- E% o
------------------------------
, r1 A. e3 m0 X/ j& c6 t7 b2 b2 QDEFAULT: k6 U/ z$ |5 d; y6 W( _
/ \3 ]8 i+ c" ^# s8 Q' B
SQL>( T' e. j% y$ j( v1 r
SQL> alter profile default limit password_life_time unlimited;
+ Z4 u* X2 L4 J s3 z' b: H* o0 Z# ~4 D( c
Profile altered." h! C, S$ ~9 Q" t' m( w2 Z
, r6 G/ i/ b4 `; @5 ^- B1 |
SQL>3 B7 m9 w- M9 ?7 Z7 e* X
SQL> select expiry_date from dba_users where username='INFODBA';
2 d) J2 x3 i/ @, A& F0 R
6 I4 z$ I6 V N) F+ cEXPIRY_DA
* t; y# G6 e' x# F1 \+ o. X---------* M7 {/ E9 A3 C+ P4 @8 H6 ?
3 u6 O' `6 V( S+ x
SQL>6 D# q. O% x3 X' ~9 ^
SQL>% X! A6 X) T* z E
. J- h$ b+ G3 M7 v! y9 u
! L2 @/ A) \' s |
|