|
|
楼主 |
发表于 2014-7-20 12:28:10
|
显示全部楼层
Solution( w. P) B" t% m
, L% Q8 M* `; G8 z7 L u4 g: PThis is due to the Oracle Password having expired and needs to be reset.3 S) T7 k1 N# B- D
5 D/ o' i5 V2 k% y, ^Perform the following in a OS CMD window making the necessary changes for your: ~4 V+ n( |, z
environment and directory structure.6 h/ V8 F9 a$ ~
/ i: C5 t9 G9 s
--
1 |. r, Q8 E* e; E; f! s/ u! T Eset oracle_home=C:\Oracle\product\11.2.0\dbhome_12 R) S( c2 A& r4 {1 f
1 E' s* E+ O, a- f F0 I2 A
set oracle_sid=tc
1 C1 k* Z$ U* K2 w7 K/ j4 I9 @3 }5 d8 n8 D2 Q' E# Z
%oracle_home%\bin\sqlplus /nolog+ V2 r# ^$ m% a* W7 Y' {1 x' W! Z# Z
- C2 N# W9 f! nconnect / as sysdba
3 E2 M% H- }% K' [. T! y6 f' R4 z3 v8 P$ V8 o1 s6 I+ f, p/ x6 v4 H
alter user infodba identified by infodba;+ p5 w; M$ {2 K0 h9 t5 `- V% h
1 {2 P9 T/ H, N' N/ ]
select expiry_date from dba_users where username='INFODBA';
$ H' M: V( z; v: ^* i3 T* I. Z" H& h, E
select profile from dba_users where username='INFODBA';
1 n2 J9 W: A' C" T8 T; P9 T! g
3 d2 |7 c: t, y% D2 ~alter profile default limit password_life_time unlimited;/ m {2 i7 J3 w0 Y1 d
! K6 t$ p' w8 L
select expiry_date from dba_users where username='INFODBA';8 q7 \& s) w! q+ U
--
8 T, G) T0 F! A- l# ?5 n
, j x, {( z9 VExpected output in command window.* J, t& c% _2 m* M O) I% }' z
==
* e6 O, h) e' _; W1 o1 A* W" EC:\Users\<user id>>set oracle_home=C:\Oracle\product\11.2.0\dbhome_1
) ^7 F5 F! }* s6 g" e- P n4 p
! G) W; I6 o7 n4 ]- N8 F3 r! c+ IC:\Users\<user id>>
/ P/ Q3 q9 _/ V% RC:\Users\<user id>>set oracle_sid=tc! b+ ]* ]% k" }6 x: I
1 r. ?( k2 z8 [, S
C:\Users\<user id>>6 n0 B5 C' Y: Q% z! c( n+ I
C:\Users\<user id>>%oracle_home%\bin\sqlplus /nolog, h1 A" _/ D3 Y
$ x! B) z% f3 p+ GSQL*Plus: Release 11.2.0.1.0 Production on Tue Dec 3 17:25:43 2013; J) S4 j/ \, L; y* G7 p) h# N
: p: g: ?. R" ?- ?! L- X
Copyright (c) 1982, 2010, Oracle. All rights reserved./ F4 J! d3 |) z0 t! m e5 O2 d
. E0 f5 K3 @) ?7 FSQL>
0 j% q# Q) O- J% _8 VSQL> connect / as sysdba
5 d& D2 M$ ~8 t4 P9 k3 `Connected.
+ Z$ o1 |1 D3 u2 ISQL>7 o, r4 ^! I; \' d8 b: d) D
SQL> alter user infodba identified by infodba;
* y/ Y; ?. Y8 E. M U7 V1 p5 C: b. r/ \6 i* V: S
User altered.& K1 _$ U. q, f P7 y5 \, a: J
5 F' D. I: c% RSQL># b4 P3 y2 |1 n6 r
SQL> select expiry_date from dba_users where username='INFODBA';
, J- E+ E9 H3 y/ Y
' x' z: D% ]5 XEXPIRY_DA
* n Q: H( d0 R: a+ l$ _---------" U/ G; x) A8 F; ]0 B/ x
01-JUN-14$ D: N) ?6 h: r: J
5 I0 Y4 I* i( c/ s$ w- z
SQL>* ^9 N0 @+ |- P
SQL> select profile from dba_users where username='INFODBA';( e7 r, M/ V6 t7 r9 Y" a! r
- W1 w+ X1 `, n# C
PROFILE
4 P% k9 K5 v( c& v4 ]! Q+ d2 O------------------------------1 x q' b* `; o, C
DEFAULT
. c6 w8 @$ l) k; Q; U: b
1 m4 q1 O+ V) X% X( I% M! \! t- qSQL>
, z: n! i& ]3 ?0 MSQL> alter profile default limit password_life_time unlimited;: r& C, Y- \/ j( s
& b& Q! m7 ?2 r2 bProfile altered.! n" g [8 ?" q5 S E- y
& \+ A! Q& L. L D TSQL>' H5 H B: V. r8 m3 [& e' R, ~
SQL> select expiry_date from dba_users where username='INFODBA';/ Q2 M2 u6 @4 A( m3 @! u
( v. ]. j0 H' f. D0 a4 \, cEXPIRY_DA
' [0 z% q; e- [% r0 O---------
. v% @8 @1 r4 b4 c( y0 C5 `! Z' e9 F' {; o% O$ z8 @- |) |6 G
SQL>0 ^6 h6 C# L% J) |5 f* }) T
SQL>
9 ?- h; @, a! Q9 X2 P7 A: M
: d1 W* E9 y: j+ u, \1 K
: \8 z& P. f9 ?8 J |
|
[复制链接]
|小黑屋|PLM之家-专注工业软件生态建设，大模型CAD创新生态
( 沪ICP备2026005248号-1 )
发表于 2014-7-20 12:27:14
发表于 2014-12-8 11:04:41
