|
|
admin
发表于 2014-7-20 12:28:10
Solution
$ i' D$ V: M! U2 U) ~0 o! V& g! J z" T# [+ x2 {
This is due to the Oracle Password having expired and needs to be reset.
9 f# G; B0 J e2 B5 l$ m* \7 z9 d
% o7 @( u# K' p7 P; QPerform the following in a OS CMD window making the necessary changes for your
( t2 g/ h8 { j; U4 Oenvironment and directory structure.
/ k4 i/ o$ v& ?5 J* Y& w" j* S
7 O, d4 f ` d. H% i& {% u7 J/ Y8 O--
. D* @% f. R$ P+ _; eset oracle_home=C:\Oracle\product\11.2.0\dbhome_1" p# r4 i' I" g ~
" |1 k+ @2 r' A3 V2 a. ~& K# Lset oracle_sid=tc5 U D* ?0 s- L# }! v4 f
: o: }' Z( }! h$ `# Z1 A5 e%oracle_home%\bin\sqlplus /nolog
) j; w, b# j& x2 b) d- C# i8 l/ p. h' q& A
connect / as sysdba
/ D% M- q/ f7 i9 X: j1 t4 c, W1 H; j' I/ g' q
alter user infodba identified by infodba;4 R& S/ u& |. o ]
9 s& ^. \) f" u6 j( T7 \select expiry_date from dba_users where username='INFODBA';
) |$ A* M0 f4 {4 c+ t: ?( d. P5 ?( R& `6 n- v
select profile from dba_users where username='INFODBA';
: W, F1 G1 s w5 O1 f2 x
8 W/ m0 \6 V* _# Lalter profile default limit password_life_time unlimited;) b5 P$ I8 x; N$ ?& n1 V, F$ ~
' `- H/ F# F* G8 O* h6 K: R1 Wselect expiry_date from dba_users where username='INFODBA';! Y* D. ]$ c$ n, A8 _
-- u" a( E. j3 J0 K; O
& E2 S, }5 } D. N' D1 Z
Expected output in command window.1 z5 K" P9 n* g2 y! G( @) B
==! n( w' v6 }% c/ i4 j/ t) q
C:\Users\<user id>>set oracle_home=C:\Oracle\product\11.2.0\dbhome_1
T# ]2 {) @" j6 A& L- ?% o1 E" V4 T8 y& l) Z3 L
C:\Users\<user id>>
) }$ g" z9 l4 H7 D3 [. P, g, fC:\Users\<user id>>set oracle_sid=tc
* @) q _ w' g8 e1 {. f, h. J
3 a% ^! R( X! d8 V: r9 B' y4 c4 ZC:\Users\<user id>>* [4 M5 `& z& {! N/ v7 x
C:\Users\<user id>>%oracle_home%\bin\sqlplus /nolog" @6 U- g" M# Q/ G- u
9 _: e4 M' x/ z
SQL*Plus: Release 11.2.0.1.0 Production on Tue Dec 3 17:25:43 2013
: R2 e; ]1 `8 x" q, i7 J( D4 }1 Q8 H8 o5 |! H0 w+ C
Copyright (c) 1982, 2010, Oracle. All rights reserved.
7 x$ a& g2 f6 o: H+ d- a3 i8 ]5 z2 ^" ^
SQL>; J5 \/ ?0 s) w V
SQL> connect / as sysdba$ k: w7 i( x. V+ P9 H
Connected.5 |4 _- m4 ]. M1 x7 t
SQL>
) Y8 }( g: F2 C4 Z; S: Y0 ~SQL> alter user infodba identified by infodba;
0 L$ c, p$ Z, _* Q) i9 m9 y& l2 ^& n& W, A9 ]- R, H7 v, o
User altered.
8 y3 k4 n: s7 H: F# p- B( e5 V- t) J
, {$ z- E: |' S7 W& d: X8 rSQL>
+ y8 [2 m# Y @+ ^# H9 [SQL> select expiry_date from dba_users where username='INFODBA';* n5 |& J$ v- f% T+ j
0 {/ x1 H! r& k/ w+ _6 i3 I: H
EXPIRY_DA* g$ h8 U% _! J; j( y0 v
---------" l% Y; @5 _- d$ l; s
01-JUN-141 n7 w6 D8 b8 p
* V2 Q# P, j$ \8 ^, ?0 j: ^
SQL>
( q5 H* f3 S4 MSQL> select profile from dba_users where username='INFODBA';3 t) ~0 N. m! Z: g3 C9 a
5 L& |' F8 O9 F, S( d+ V% @& FPROFILE6 D1 c* j$ I( B! ^; M8 w
------------------------------
, N/ C' z& @0 a& A$ f/ \3 ~# j+ HDEFAULT
# J# @" a9 ]' ^( R& c/ b) z; E; y6 c5 F) j- S3 t8 g4 l) k) U |
SQL>, B7 r) O4 A4 V$ n. Q' O& ]
SQL> alter profile default limit password_life_time unlimited;
& R9 f% q ^ c/ _) E( |: J, r4 ^/ a& _# t
Profile altered.
G- z- \$ X; [4 X R. ^# [& N3 c; c# u m1 r
SQL>; N! `* t& K2 ]0 R) y* o ^
SQL> select expiry_date from dba_users where username='INFODBA';
* k/ T' q: J% F, }5 J5 x
& x" Z R$ B5 w$ R/ \6 uEXPIRY_DA1 m& a) t) C! g# j- ~9 O/ b
---------
) ~2 W+ X0 q1 j& P
8 v/ @; H* r: fSQL>
" P$ o" U8 N. @6 C HSQL>( v$ u8 f9 T% d7 [. L
2 x- p: W# T0 O& D$ H0 d, o3 F
* R, S8 I$ i3 O4 X7 z; J$ V* E |
|
[复制链接]
|小黑屋|手机版|PLM之家-企业数智化转型工业软件学习平台
