|
|
admin
发表于 2014-7-20 12:28:10
Solution
1 E4 y; P+ {. L2 _& N) f1 b2 o
' w8 A$ G6 x1 J8 k4 AThis is due to the Oracle Password having expired and needs to be reset.1 \! B2 U8 U$ M e6 R+ Z \
3 w' }9 h7 R/ z3 T. G8 h& Z1 w$ t
Perform the following in a OS CMD window making the necessary changes for your
! \0 N) Q$ p8 ]& G% ?environment and directory structure.+ {) x) h/ M! L) G5 G3 C
* z- F) A2 {% Z, e* n( X0 M
--
* o2 ?3 A1 C. iset oracle_home=C:\Oracle\product\11.2.0\dbhome_1) B7 U# `6 L! ^# K1 H, P
( Q9 w j% `3 l- n
set oracle_sid=tc
- d$ f; g! g) ], j" y! v. B+ K
! _8 c- G# M* K/ a3 T) e$ F; a%oracle_home%\bin\sqlplus /nolog8 A6 b& a$ H4 |) z' u( o- X
8 Y' L# l' Y- h! x, Z6 d% d
connect / as sysdba
( U" }, R0 B7 M: }- b0 S: S! y' L- v$ E9 u- j* S
alter user infodba identified by infodba;
. d/ C# [' A8 M9 A0 F( x0 c0 @1 ]" R' w
select expiry_date from dba_users where username='INFODBA';/ ~1 \3 _3 c0 {9 R7 |) N" A
, A S6 w( r& Bselect profile from dba_users where username='INFODBA';7 G+ j: F- F: h
8 Q: J2 B) j9 g* }1 V' Jalter profile default limit password_life_time unlimited;% x) F) [( B' B' j1 l) s
' J# W/ B' F5 d/ j# ~+ k
select expiry_date from dba_users where username='INFODBA';( O3 g- T- u9 t: W- ?2 Y
--3 `" U. W8 S2 v$ j+ ]1 p% G
) [7 I' w0 u ]& zExpected output in command window.7 a/ P+ X0 q$ m! y1 M
==3 u# w u, I' m6 z" [4 b+ r
C:\Users\<user id>>set oracle_home=C:\Oracle\product\11.2.0\dbhome_12 O5 C9 g1 e( Z c* ]2 `
8 i$ E' l/ k7 W7 i: n: lC:\Users\<user id>>
- ~8 X+ A8 c& ^. t$ ?# DC:\Users\<user id>>set oracle_sid=tc# u: A) I) B u# _
- w. v/ ~) @4 {* tC:\Users\<user id>>
" Y6 E( t! K5 W& [0 p; dC:\Users\<user id>>%oracle_home%\bin\sqlplus /nolog+ \3 L9 D/ a$ s, I
3 C+ h& `6 z( t$ k
SQL*Plus: Release 11.2.0.1.0 Production on Tue Dec 3 17:25:43 2013; }& V. _/ C4 u, X2 j' [0 T
. q' f2 T* Q6 _6 qCopyright (c) 1982, 2010, Oracle. All rights reserved.9 y7 F5 t/ [$ G- Z {6 l# o# T
8 X9 |3 J! B7 Z/ y' rSQL>
; Y2 p9 j) S: x& vSQL> connect / as sysdba
- C! b! e9 |0 PConnected.
( A9 s# x8 S" B: {# t7 |, mSQL>1 U5 ~3 j8 v! D! a1 V
SQL> alter user infodba identified by infodba;. j c: a- N \7 O
4 D: S) c% f G0 O+ o4 f! a9 c# V
User altered.
1 T$ v6 ?% ^8 l# w$ a i- p
2 I8 V/ B. D5 i3 ]; a) d7 R( OSQL>
! b& [- m) ~0 l3 Y& NSQL> select expiry_date from dba_users where username='INFODBA';6 z) a: ], J4 L
* A% p( }6 u7 t( r# _EXPIRY_DA
9 v. G! x0 [6 X$ I---------. l. X+ i1 P4 Z4 T
01-JUN-14
( `2 y# G* b. T: |1 o
- B" l' p8 `7 GSQL>. f L4 }. K& r" w! A1 I5 y
SQL> select profile from dba_users where username='INFODBA';' I7 r' Y( u `4 n9 z: H7 _5 a( I
1 M0 y# j) L4 f- z% K
PROFILE
5 \1 U0 w2 ~/ b& U/ }------------------------------6 |' k# f( l: V% d. L! t
DEFAULT
# o2 z e) O l* d j/ W( ^$ ^9 \2 q4 F$ ^
SQL>. A. o/ r$ @9 Q3 w$ Z
SQL> alter profile default limit password_life_time unlimited;9 b' k9 c6 e- f; i9 Q3 d5 O- g7 b
; I9 g; Y; m) J$ wProfile altered.
: d; ^: H3 X% t" j6 c8 E, i f, P9 D
SQL>% p9 z$ O" y, ^0 s
SQL> select expiry_date from dba_users where username='INFODBA';
' G+ E/ |8 Y: T9 J* |, K! P2 m: q9 L. ]
EXPIRY_DA
' p$ T, J) P7 S8 {1 h6 u. o3 \---------
1 R" o& U7 y" o v1 {
1 ^# g+ o& p# w) _. ZSQL>
2 E) w( \+ b1 R0 O9 H/ \! nSQL>
( |) J7 r, U* ?+ R8 e* P6 f* A# ?4 D _. b0 h; m' p/ _
* V0 y% s7 V$ {) _* T8 t
|
|
[复制链接]
|小黑屋|手机版|PLM之家-企业数智化转型工业软件学习平台
