|
|
admin
发表于 2014-7-20 12:28:10
Solution' g, u; W B' x' E" M
0 y$ i1 O% h; m. N1 b( M/ \This is due to the Oracle Password having expired and needs to be reset.
: j8 M% n# T0 v* R% i& g9 {8 A/ k! ?8 r+ v2 O3 U/ o2 P
Perform the following in a OS CMD window making the necessary changes for your
, J- V& ~. F& R) H1 ]% l& Y! J5 cenvironment and directory structure." w5 E6 F) F) C+ B, y- _
3 B. I1 I1 |+ p" x0 W6 X1 |8 K
--& l* N/ L8 X9 M z
set oracle_home=C:\Oracle\product\11.2.0\dbhome_17 q" y: t; o1 a# d) T( g, e
% E& N- @, d- l8 Z1 z. Rset oracle_sid=tc: F3 {, c' q8 i+ w/ X+ q& F& b
' x8 u$ X" g0 I3 c! a% n
%oracle_home%\bin\sqlplus /nolog
6 o$ x3 @$ O- m9 t+ {' E# C) Q8 B
6 V6 S1 q, E- w6 M% Fconnect / as sysdba
8 d& C9 q3 r% y; \1 Y
/ z) ]5 n+ j' D/ w3 }' t% M Palter user infodba identified by infodba;6 d: ]; X' H2 C. c
2 |, h0 f' q$ qselect expiry_date from dba_users where username='INFODBA';+ d5 C7 A& D$ H1 p+ S$ N I3 H* }3 }
! y8 K% T5 d k% X$ Dselect profile from dba_users where username='INFODBA';5 U6 A/ F6 n0 l& o; [
" `' U# z. g( g1 F* x- x- l
alter profile default limit password_life_time unlimited;
% D* i7 G3 C1 I' q- m: S) x7 y; u/ v
select expiry_date from dba_users where username='INFODBA';% b8 o7 P" ~* z& n8 w9 z3 D
--* M5 b; ?7 R* z6 Y* V: u
: }% \' ^$ B7 o" S) `
Expected output in command window.9 l+ ?1 `% K- L ]; J/ N0 M
==
8 r" R! g6 p& U% @! F; c0 OC:\Users\<user id>>set oracle_home=C:\Oracle\product\11.2.0\dbhome_1) v9 ?' Q }' k+ B% j: B
! Z: Y9 Y3 }* U
C:\Users\<user id>>- B. `% Z* O# m
C:\Users\<user id>>set oracle_sid=tc
& j; S7 e' f5 e
, z. j- t: s& V) RC:\Users\<user id>>6 I9 u6 J! }2 I% c" d/ ]' C. N' w
C:\Users\<user id>>%oracle_home%\bin\sqlplus /nolog
0 T/ z; ?6 O& x* |
0 a: I' ` \6 t; HSQL*Plus: Release 11.2.0.1.0 Production on Tue Dec 3 17:25:43 2013 F3 e; G4 m" g7 S- r A2 S
5 h. s! I" r+ b
Copyright (c) 1982, 2010, Oracle. All rights reserved.# F W7 \: s% v2 s
0 x' G: g$ ~8 W2 B x# Z, P
SQL>
) N; F# t0 Q3 }" WSQL> connect / as sysdba
- A0 j2 C# e8 vConnected.+ i; ?9 z! w- T% `$ Y1 ]. o& U
SQL>* e. @; Y! e& ?! X% c
SQL> alter user infodba identified by infodba;
. ?6 I d; h3 z) `) R3 c+ e
7 t9 F$ h# Q. r$ ?User altered.
4 @% K- W$ W+ m* J( z" E5 ~( J; y% K S+ X w' k
SQL>
5 p: [5 L K3 r% dSQL> select expiry_date from dba_users where username='INFODBA';4 I x6 l6 [0 O. t$ w# s
7 m7 L0 P7 a3 g5 U0 d/ Y
EXPIRY_DA
+ u. i; U- S, _6 `---------
$ {' K/ U( m; _4 d, [! E) Q6 C01-JUN-14
# F& ^' V+ u+ v T2 D1 f' Y8 X5 X. u1 N, i" A- M8 Q0 y
SQL>" l l7 t; s7 t1 z3 B0 ]# D
SQL> select profile from dba_users where username='INFODBA';, L* ~* [; l2 m% k+ ]% A1 l2 V
% ~ j o, B2 _6 [PROFILE
8 k9 W5 b0 w: Q" z3 d1 x. j------------------------------* d% P) g8 I M" i
DEFAULT- b6 b: Z5 f* E0 ?# i. f/ m
3 ^+ ^3 D+ `/ R8 E; cSQL>) B1 D7 L H! N8 Q9 u
SQL> alter profile default limit password_life_time unlimited;. O; e) X" l* E. ~" t
) ]' }5 J5 V! V
Profile altered.
3 `& h c8 ^6 {/ Z; M: P2 t0 H: P& K
$ C5 M0 v% x* G( pSQL>
: v8 o* X% A& j. F* FSQL> select expiry_date from dba_users where username='INFODBA';
5 \$ U1 X* y `+ M
0 T/ Q. m3 `6 ^9 {! c1 aEXPIRY_DA. Z8 W C) \- p; I3 O0 Q9 Y$ L
---------! Y+ T) A9 G7 u
6 ?- m1 x% q. Z8 n" h1 L# wSQL>
$ T3 P, z: i3 sSQL>
- `8 D2 ~% p$ y) s1 V6 q
, p; l6 q; u, T6 `; y" w4 {7 `) S0 Z7 M! G! h2 @
|
|
[复制链接]
|小黑屋|手机版|PLM之家-企业数智化转型工业软件学习平台
