|
|
admin
发表于 2014-7-20 12:28:10
Solution# D& c& H4 v& }6 _ y' Q
0 T3 v+ y/ \- ?6 Q% CThis is due to the Oracle Password having expired and needs to be reset.
1 V0 g9 Z) M) B: p' ]: o& g% w
q9 f( o* l6 A& qPerform the following in a OS CMD window making the necessary changes for your
: c# O1 c# T3 `9 q1 A* j3 Eenvironment and directory structure.: ^+ Q4 b; K1 n. v8 j( D/ M# u
8 Y3 o8 I8 k0 _
--4 K/ h6 u2 @& U
set oracle_home=C:\Oracle\product\11.2.0\dbhome_18 y; V: ]7 A- r7 _- T# [
) n# ?) e2 M1 S! u" ~# r i
set oracle_sid=tc5 Z% x* ]1 ~- T/ W: C$ B
* w7 { }& p: d% z6 G1 ]; `%oracle_home%\bin\sqlplus /nolog
' |7 j. C1 b7 L9 a
9 y2 K% ^8 O! {/ j# p' _connect / as sysdba% Q( f' n8 [" Z9 w; m6 M- i& o
0 a3 ^5 k5 `, ]' e7 @! }alter user infodba identified by infodba;
( O- Z4 e, {; `5 v
8 B2 w; W: s6 |" Wselect expiry_date from dba_users where username='INFODBA';0 Q7 |7 _# K. g% G
g2 U- u8 Q9 M$ `/ P9 d) yselect profile from dba_users where username='INFODBA';/ c3 z2 j( l. o* p
2 s- p1 ]1 a5 R7 z
alter profile default limit password_life_time unlimited;
- w. ~% Q J! Y3 `0 V
9 X; Y! q2 N3 R \select expiry_date from dba_users where username='INFODBA';: G3 f8 v7 ]1 ] Q) y; N- ]
--
% k, U4 M: h b/ @, E4 O0 x, I/ B: V! S6 B( C/ p
Expected output in command window.
; J0 N# f Y, ^; Q1 E3 R# Y==
' S" \/ z. ^; }2 ~' x7 r7 SC:\Users\<user id>>set oracle_home=C:\Oracle\product\11.2.0\dbhome_1
0 w- k6 _& j. g" j; M, [1 Q9 O9 c) Q
C:\Users\<user id>>
# e( S8 f( ^# h0 ~, ]- n& l" l* s: xC:\Users\<user id>>set oracle_sid=tc
% y4 a6 |3 V% H7 C, f B( X% Z4 X, S7 O) ~" m9 o4 L
C:\Users\<user id>>
d# T/ H( ]' j+ \; u. J1 K+ VC:\Users\<user id>>%oracle_home%\bin\sqlplus /nolog
; h' q+ B, g+ X5 P6 T6 T+ m
* q E. D% l; v: T1 hSQL*Plus: Release 11.2.0.1.0 Production on Tue Dec 3 17:25:43 20139 b, U o6 ^1 Q+ t t
! \; Y! h$ ^9 }2 R1 l" z
Copyright (c) 1982, 2010, Oracle. All rights reserved.8 s5 w* g' N1 w5 G; L; Q: q
$ j& R& e& K& P) j |% `0 BSQL>! b! f6 j7 c, v: ?' b: s
SQL> connect / as sysdba3 p3 o; Z! x( r7 s) z s/ ^( M
Connected.
: m: j9 f7 x7 r1 xSQL>
4 C) A4 {% m* ? X" @SQL> alter user infodba identified by infodba;0 M" z; b% X } o5 a7 Y7 ?
' `# h% p6 D$ ?User altered.8 q9 H$ F) o/ x: u3 P
' R h( A @) i/ A2 DSQL>& m! L. k2 J6 J( k( M
SQL> select expiry_date from dba_users where username='INFODBA';$ M, d. Q8 b4 ?/ C
/ u% k8 v% ]2 C: m+ n) ^$ ]3 R
EXPIRY_DA
1 U" V3 c# l+ y0 @+ p, v7 g---------7 T$ c% q) Q0 y* z# o* o
01-JUN-14
0 ~% P7 ?# y1 `+ O0 [( X8 O; s$ p8 @3 y: Y
SQL>/ R( a9 I3 ~; h5 [" r
SQL> select profile from dba_users where username='INFODBA';
3 Z" U( k1 G) `# r+ ]1 Q* M) _2 F7 n& J3 ^# A
PROFILE
9 a( W4 x2 x1 I$ D------------------------------
2 |$ L; a" A6 z$ i; ~DEFAULT
# d* d6 E/ h, q& w( i+ r" O/ D, ?6 E5 R9 h: e, q8 Y) {0 N$ _
SQL>
8 ?3 l. p- e# }+ dSQL> alter profile default limit password_life_time unlimited;
+ t1 l, z3 m9 R/ f# V+ @ I
2 |6 j& w" [6 {$ E5 @6 U8 KProfile altered.$ F: ]( \4 ` N* T3 _' j
9 |5 D0 Y) \. s8 ySQL>
6 _" b- Y# ]$ e, l3 e8 S Q" hSQL> select expiry_date from dba_users where username='INFODBA';% a7 q; P+ L2 U5 K: t h! h2 f
: B1 m' W$ E$ M& O: O+ x
EXPIRY_DA9 S3 t% {! n |/ g* b% T
---------* o, X3 }8 m( C6 A6 _
1 I, I8 Q# N5 j; y& K KSQL>
3 x+ D( w7 ]* YSQL>+ V$ x0 Q2 R* V0 A5 m
& `2 z3 v% A3 o* k6 x2 g
3 H, a' E" @* {& i |
|
[复制链接]
|小黑屋|手机版|PLM之家-企业数智化转型工业软件学习平台
