|
|
admin
发表于 2014-7-20 12:28:10
Solution; l0 n% y# x! ?5 F+ }1 J
$ Z% F ^0 o* A0 t2 P& v+ u: y1 p! nThis is due to the Oracle Password having expired and needs to be reset.
% L g8 H! @2 d/ \, j! d6 I3 o1 A% y
, v n8 ~! y2 T& DPerform the following in a OS CMD window making the necessary changes for your
% k+ m6 @8 _! \! i! b- V7 `environment and directory structure.0 N4 B- Q$ i" J! D
2 t, J' X# V2 Z `, \
--
: F% ~9 ^( z* C2 v, Pset oracle_home=C:\Oracle\product\11.2.0\dbhome_1
. l* s4 Q, \( `/ N( ?& j
# G$ T Q, W7 C$ ?+ k( Sset oracle_sid=tc' r5 J, J& d7 i$ {8 C
3 p7 B8 ]9 r8 N" O$ T% t%oracle_home%\bin\sqlplus /nolog
. s* N6 E- E1 Z) i
6 \0 _; e) W- D: T* X. Lconnect / as sysdba
6 Z" B, [! `; g/ L8 C# x k& i+ g/ C \2 D& w ^# n$ G, P
alter user infodba identified by infodba;
8 M7 R' o/ d& T* a3 P; d% R! z
4 J6 C3 L$ W2 Vselect expiry_date from dba_users where username='INFODBA';
2 a o7 C' m& E# ^ d
5 x; P# e( k `, z3 {# N1 Hselect profile from dba_users where username='INFODBA';
+ G( T; f; j8 v/ Z& ]8 ]
) ~" G4 N4 e5 o! b+ I; v0 Yalter profile default limit password_life_time unlimited;
; B- Z1 x% H" x! l; l$ M( q6 T: N; _8 i) _9 E
select expiry_date from dba_users where username='INFODBA';/ }; E" J+ {" b5 b
--
z1 Q* H. W1 _3 v5 ^6 g9 [3 r! q. g6 J1 O0 A, z" q
Expected output in command window.) O4 c3 a$ a; V/ n$ t6 c
==* s3 f, Z( }! L7 E
C:\Users\<user id>>set oracle_home=C:\Oracle\product\11.2.0\dbhome_1+ ]5 c! C+ {% w+ e: I4 v
1 m: f6 x/ W6 k. P% N& P" W$ P
C:\Users\<user id>>
' \! _6 H8 `) b* |2 N* [+ ^" VC:\Users\<user id>>set oracle_sid=tc. l, \2 o. ?9 |0 F2 {3 I) K
9 y8 G4 @2 H2 ^8 t/ m1 E
C:\Users\<user id>>7 [2 }) O: P+ ^' s$ a& N+ z# V
C:\Users\<user id>>%oracle_home%\bin\sqlplus /nolog
7 ~3 I' l4 K4 b0 k9 E6 \1 k7 @" I: Z
SQL*Plus: Release 11.2.0.1.0 Production on Tue Dec 3 17:25:43 2013
$ U# V. P! K v# }; x/ a* Q8 M
8 `3 Y/ R6 h" ^, F" X$ M( DCopyright (c) 1982, 2010, Oracle. All rights reserved.( `4 Y" T& @7 G' d' s3 k
4 x" e4 B) t9 iSQL>
! u' q- u, Q3 t5 G2 T2 hSQL> connect / as sysdba
3 L; Z+ Q: I+ Q, wConnected.) T# N' r: B0 @
SQL>
) r/ e* p9 M, Y3 C! \0 S8 T# O+ jSQL> alter user infodba identified by infodba;2 s9 k T0 S: k: W. ?
; j) p( A( P8 l
User altered.& D) _7 m: a. w
) M3 f, A, z; ]5 o0 u+ }1 W3 f3 pSQL>8 P5 t" x! u4 v! d" ~
SQL> select expiry_date from dba_users where username='INFODBA';
1 C$ h5 X5 b! S- d2 }, }9 h
" o7 r9 f) W$ f- B( U- d/ kEXPIRY_DA
# ~" m1 L) n6 `---------, t: N. \: U& W8 ]
01-JUN-14
9 k0 \4 T. U3 e! t, `
6 P5 i2 V# J/ g7 BSQL>% r8 s- J( _" U0 b6 T. o2 x8 k
SQL> select profile from dba_users where username='INFODBA';
/ y5 U* a8 L9 j7 b
; _6 i! Y6 O. `. J% M, bPROFILE& _( P; x! [1 H5 n; A7 y+ |7 r& z
------------------------------
' I3 C& F! {! a7 P4 M! h' `DEFAULT
9 ~2 ~2 S9 H8 ^ C5 I+ f# d( C. F& H: l: Z/ r3 W- h
SQL>$ |* x4 a, J5 B' f) u6 T! K, O% [* ~
SQL> alter profile default limit password_life_time unlimited;
. Y8 c2 S; k# [+ l1 D( L5 X! B* q- R+ {: W$ e# p9 X- Q
Profile altered.
" l) F/ S+ l7 u2 T/ \$ t! T7 Q/ x$ m4 F1 [
SQL>/ @& B* G, j$ q4 f: @) w! K: M
SQL> select expiry_date from dba_users where username='INFODBA';
& I5 f# y. y7 Y2 [& ^* i; x) K+ ?0 k& b1 Q- {
EXPIRY_DA3 c4 X6 q+ |! q, z/ i
---------0 S/ \9 o! z$ q) D- c3 c1 S
/ ^# m4 z' G: L& o R6 ?# hSQL>
9 @ L7 j9 h: ]+ { vSQL>- P& T- Z" c, h2 l0 n1 P
/ i- M! N: Y1 u( \1 V: d3 P/ y
6 J1 A* j6 E9 M }% ] |
|
[复制链接]
|小黑屋|手机版|PLM之家-企业数智化转型工业软件学习平台
